> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sherloqdata.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Import from Bigquery

> Import you exsiting saved queries / consoles

<Note>
  We're working on making this extraction automatic with the click of a button, and it will be launched soon.
</Note>

<img src="https://mintcdn.com/sherloq-31da1dfe/tD9AIrHANoNaF5Xm/images/import_from_bigquery.png?fit=max&auto=format&n=tD9AIrHANoNaF5Xm&q=85&s=0946f9ca3bc39e70dd837a7ddaeae66d" alt="import_from_bigquery" width="1000" data-path="images/import_from_bigquery.png" />

<AccordionGroup>
  <Accordion title="Bulk import Saved Queries">
    <Steps>
      <Step title="Go to the Bigquery Console" />

      <Step title="Go to your 'Saved Queries' on the left side panel" />

      <Step title="Click the 3 dots on 'Saved Queries'" />

      <Step title="Click Download all" />

      <Step title="Drag and drop the ZIP file into the 'Upload a file' in the Sherloq Settings " />
    </Steps>
  </Accordion>

  <Accordion title="Bulk import history queries">
    <Steps>
      <Step title="Go to Bigquery" />

      <Step title="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;
        ```
      </Step>

      <Step title="Export the output (SQL queries history) into a file of any type." />

      <Step title="Drag and drop the file into the Upload a file in the Sherloq setting " />
    </Steps>
  </Accordion>

  <Accordion title="Copy-paste your saved queries / queries from console ">
    <Steps>
      <Step title="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
      </Step>

      <Step title="Mark the SQL you’d like to import / CTRL + A for all of it ->  Copy it - CTRL + C" />

      <Step title="Create a new TXT or DOC file and paste it, then save the file" />

      <Step title="Drag and drop the file into the Upload a file in the Sherloq setting " />
    </Steps>
  </Accordion>
</AccordionGroup>