Import from Snowflake

We’re working on making this extraction automatic with the click of a button, and it will be launched soon.

Bulk import history queries

Go to Snowflake

Run the following query

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

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

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

Copy-paste your saved queries / queries from console

Go to Snowflake Worksheet

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

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

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

⌘I