Import from Snowflake

Import you exsiting worksheets and notebooks

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

Bulk import history queries

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

Copy-paste your saved queries / queries from console

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