Destinations
BigQuery
Required settings
- Project identifier
- Dataset
- Service account
Find project identifier
Find project identifier
Go into your BigQuery console and the project ID is at the top of the navigation bar.
Find dataset name
Find dataset name
To find this out, go to BigQuery console, and you will see the dataset name on the left side of the screen.
Retrieving your credentials
Retrieving your credentials
To create a service account, please do the following:
- Go to the
IAM & Adminsection in your GCP console and clickService Accounts. - Click on
Create Service Account, give it a name and clickCreate and Continue. - Grant the
BigQuery Adminrole to the service account clickDone. - Go into the service account you just created and click on
Keysand thenAdd Key. - Choose
JSONand clickCreate. This will download a JSON file with your credentials.
Best practices
Consider partitioning your large tables to improve performance and reduce costs.