1. Make sure you have the ENABLE_TEMPLATE_PROCESSING feature flag enabled.

FEATURE_FLAGS = {
    "ENABLE_TEMPLATE_PROCESSING": True,
}

2. Make sure pass the urlParam.

urlParams: {
    foo: 'bar',
}

1. Make sure you use the macro in your dataset

select fld from tbl where fld= '{{ url_param('foo') }}'

Here's some useful documentation:

• https://preset.io/blog/intro-jinja-templating-apache-superset/
• https://superset.apache.org/docs/configuration/sql-templating/