Import Queries
Import from Bigquery
Get Started
Our Platform
- Integrations
- Product Features
- Security and Privacy
Repository
- Folders
- Queries & Versions
- Search
- Snippets Injection in IDE
- Queries History Logs
Import Queries
Import from Bigquery
Import you exsiting saved queries / consoles
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