Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Fetching 1k records from table using "Snowflake select snap"

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...
alchemiz's avatar
alchemiz
Contributor III
4 years ago

Hi Sir Darsh,

Good day, hope is all well.

Seems like a setting from the account that you are using in the Snowflake execute snap where a fetch size is a required setting. Hope this help

Thanks,
EmEm

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago

Thank you @alchemiz, I did check the account settings and fetch size is mandatory as you mentioned.
Can you walk me through on how to resolve this?

Do we need to ensure that Fetch size is non-mandatory or increase from 100 to some x number, if that’s the case, what would be that x number?
Thank you in advance…