Learn how to securely connect Julius to your Google BigQuery data warehouse using service account authentication.
bigquery.jobs.create
- Required to execute a BigQuery jobbigquery.readsessions.create
- Required to create a read sessionbigquery.readsessions.getData
- Required to get data from a read sessionbigquery.tables.get
- Required to access metadata about a tablebigquery.tables.getData
- Required to get data from a tablebigquery.tables.list
- Required to list available tables in a datasetbigquery.routines.get
- Required to access metadata about a routinebigquery.routines.list
- Required to list available routines in a
datasetbigquery.tables.get
- Required to access metadata about a tablebigquery.tables.list
- Required to list available tables in a datasetbigquery.routines.get
- Required to access metadata about a routinebigquery.routines.list
- Required to list available routines in a
datasetbigquery.tables.getData
- Required to get data from a tablebigquery.readsessions.getData
- Required to get data from a read sessionNavigate to Data Connectors
Configure Connection Details
{ }
. Missing any part will cause authentication to fail.Test and Save Connection
Authentication failed or invalid credentials
Permission denied errors
bigquery.jobs.create
,
bigquery.tables.get
, and bigquery.tables.list
permissions - Check that the
service account has BigQuery Job User and BigQuery Data Viewer roles - Check
if datasets have additional access restrictions - Ensure BigQuery API is
enabled in your Google Cloud project - Confirm you’re using the correct Google
Cloud projectJulius can't find my tables or datasets