Import from Bigquery

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

Bulk import Saved Queries

Bulk import history queries

Go to Bigquery

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;

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

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

Bulk import Saved Queries

Bulk import history queries

Go to Bigquery

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;

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

Get Started

Our Platform

Product

Collaboration

Resources

Import from Bigquery