Skip to main content
The BigQuery source lets you extract tables or custom SQL queries from Google BigQuery into Less.

​
Authentication

Less connects to BigQuery with a Google Cloud service account JSON key. This is the recommended approach for automated extract 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 for step-by-step instructions.

​
Setup

1

Account

Enter your Google Cloud project ID. Optionally set a default dataset to limit table discovery, and a location if your queries run in a specific region (for example US, EU, or europe-west1).
2

Credentials

Upload your service account JSON key file. The service account needs BigQuery Data Viewer on the datasets you want to read and BigQuery Job User at project level so Less can run queries.See How to create a BigQuery service account if you need help creating the key.
3

Tables

Click Connect to verify the credentials and load available tables. Then either select tables from the list or switch to query-based mode and provide one or more custom SQL queries.
You can select either Table or Query-based. You cannot select both.