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

[darshthakkar]

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!

[bojanvelevski]

Sorry, I didn’t explained myself correctly. I meant send the query here, without the ids.

[darshthakkar]

There you go:

SELECT
CREATED,
CREATED_BY,
FAQ_QUES_TEXT,
INTR_PUBLISH_FLG,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
NAME,
PR_AUTHOR_ID,
PUBLISH_FLG,
RESOLUTION_TEXT,
ROW_ID,
STATUS_CD,
TYPE_CD,
X_PROD_FAMILY,
X_PROD_VER,
X_REGION,
X_RESOLUTION_TEXT,
X_SUB_AREA
FROM S_RESITEM

*** removed where clause ***

[bojanvelevski]

The query seems ok. What’s the situation when you turn off the expression support? What’s the output of the Select snap when you validate?

[darshthakkar]

Getting a different error this time:

Index out of bounds; I believe is because of those 1000 IDs. I can remove those 1k IDs and validate the error again.

[darshthakkar]

Getting the same error even though reducing the IDs in where clause to 6:

Also the query has been limited to 10 records too.