This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’m planning to fetch the data from a table using “Snowflake select snap” while putting the condition of getting 1k records ONLY in WHERE clause however it is not getting any results.
I can put the entire query in “Snowflake execute snap” as well but wanting to do with Snowflake Select as of now. Any help is highly appreciable.
Wanted to share the solution here. The query was right, no need to change the “Fetch-size” as well.
The only thing that was missing was ’ ’ for the IDs that we were passing in the query. Thus, the query would look like - WHERE NAME IN (‘102345’, ‘1701’, ‘5604878’)
There’s no need for the expression functionality (equal sign (=)) button to be on in both situations, unless you’re using some function later in the where clause. Other than that, I can see that you have a new line character ‘\n’ in the query itself, so you should replace those with new lines or space.
Even if I remove the “=” decorator, the query doesn’t run. Moreover, regarding \n, there is none in the query but the error message still shows that → this is where I’m blown away.
