Skip to main content
We’re working on making this extraction automatic with the click of a button, and it will be launched soon.
copy_queries_from_snowflake
1

Go to Snowflake

2

Run the following query

SELECT *
FROM TABLE(INFORMATION_SCHEMA.QUERY_HISTORY())
WHERE EXECUTION_STATUS = 'SUCCESS'
AND USER_NAME = '<your_username>';
3

Export the output (SQL queries history) into a file of any type.

4

Drag and drop the file into the Upload a file in the Sherloq setting

1

Go to Snowflake Worksheet

2

Mark the SQL you’d like to import / CTRL + A for all of it -> Copy it - CTRL + C

3

Create a new TXT or DOC file and paste it, then save the file

4

Drag and drop the file into the Upload a file in the Sherloq setting

I