filtersnowflake-cloud-data-platformdashboard

Snowflake Dashboard SQL using multiple value filter

I have a filter that allows the user to select multiple values but when i try to use the filter like this i get this error:

No valid expression found for :Plan_ID. Expecting " = :Plan_ID"

SQL:

select id from ACCESS_TOKENS where plan_id in (:Plan_ID)
Solution

  • Specify a filter in a SQL query:

    SELECT *
FROM ACCESS_TOKENS
WHERE PLAN_ID = :Plan_ID;

    Output:

    enter image description here