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

# BigQuery

The BigQuery destination writes canvas output to a table in Google BigQuery.

### Authentication

Less connects to BigQuery with a **Google Cloud service account JSON key**. This is the recommended approach for automated load jobs.

**OAuth (sign in with Google) is not supported yet** for BigQuery. Other Google connectors in Less (such as Google Sheets) use OAuth, but the BigQuery source and destination currently require a service account.

See [How to create a BigQuery service account](/sources/guides/bigquery-service-account) for step-by-step instructions.

### Setup

<Steps>
  <Step title="Account">
    Enter your Google Cloud **project ID**. Optionally set a default **dataset** so canvas nodes can use short table names, and a **location** if your load jobs run in a specific region.
  </Step>

  <Step title="Credentials">
    Upload your **service account JSON key file**. The service account needs **BigQuery Data Editor** on the destination dataset and **BigQuery Job User** at project level so Less can run load jobs.

    See [How to create a BigQuery service account](/sources/guides/bigquery-service-account) if you need help creating the key.
  </Step>

  <Step title="Test Connection">
    Click **Connect** to verify the credentials and permissions before saving the destination.
  </Step>
</Steps>

On the canvas, set the output table name as `dataset.table`, or `project.dataset.table` when you need to override the configured project or dataset. Supported operations are **overwrite** and **append**.