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