Skip to main content
We’re working on making this extraction automatic with the click of a button, and it will be launched soon.
import_from_bigquery
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

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

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

I