โ03-17-2022 10:06 AM
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.
Thanks!
Solved! Go to Solution.
โ03-23-2022 06:08 AM
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โ)
โ03-17-2022 10:19 AM
You can use the โLimit rowsโ property to specify the number of rows to be returned by the query.
โ03-17-2022 10:22 AM
Does that mean, I would never be able to get 1k records from the Snowflake DB?
Today, the requirement is to fetch 1k records, tomorrow it may be 5k, 10k, so on and so forth.
Iโm actually putting those IDs in the WHERE clause so it might exceed the character limit of 255 characters.
โ03-17-2022 10:19 AM
You should use LIMIT for limiting the output of records.
โ03-17-2022 10:25 AM
I tried limiting it but I want all those 1k records, am I doing the right thing by putting 1k IDs in the WHERE clause of Snowflake Select snap?
Still brand new to snapLogic so Iโm sure there would be something where Iโm making a mistake.