Destinations
BigQuery
Required settings
- Project identifier
- Dataset
- Service account
Getting your project identifier
When you are in your GCP project, you can see your GCP project ID at the top of the navigation bar.
Getting your dataset name
To find this out, go into your BigQuery console and you will see the dataset name on the left side of the screen.
Retrieving your credentials
To create a service account, please do the following:
- Go to the
IAM & Admin
section in your GCP console and clickService Accounts
. - Click on
Create Service Account
, give it a name and clickCreate and Continue
. - Grant the
BigQuery Admin
role to the service account clickDone
. - Go into the service account you just created and click on
Keys
and thenAdd Key
. - Choose
JSON
and clickCreate
. This will download a JSON file with your credentials.
Best practices
- For large tables, consider turning on Time Partitioning
Was this page helpful?