Creating a data extract with a SQL and passing a filter parameter

Andy1234

I am trying to create a data extract from SnowFlake . I have selected the connection and written my sql . I want this SQL to be available to multiple users such that they can apply filters to the dataset to retrieve the information .

For example, in my dataset I have a "COUNTRY" column. I want a way for users to use the SQL I have and just use following filter:

WHERE COUNTRY = variable[country_name]

How do users pass on this country_name to the SQL to make the SQL dynamic?

One option is having a dashboard and just add filters for the country. Any other option?

Operating system used: Mac

Turribeach

You can use a SQL Notebook as well.