Import from Bigquery

Import you exsiting saved queries / consoles

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

Bulk import Saved Queries

1. Go to the Bigquery Console
2. Go to your 'Saved Queries' on the left side panel
3. Click the 3 dots on 'Saved Queries'
4. Click Download all
5. Drag and drop the ZIP file into the 'Upload a file' in the Sherloq Settings

Bulk import history queries

1. Go to Bigquery
2. Run the following query

   SELECT
   creation_time,
   user_email,
   query
   FROM
   region-us.INFORMATION_SCHEMA.JOBS_BY_PROJECT
   WHERE
   job_type = 'QUERY'
   AND state = 'DONE'
   ORDER BY
   creation_time DESC;
   

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 Bigquery -> 'Saved Queries' tab

   This is located under your project name, on the left-hand side. Click on the SQL you would like to import

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