Google BigQuery

• Purpose: Connect to Google Cloud BigQuery for serverless, scalable data warehouse analytics.
• When to use it: Ideal for teams using BigQuery as their central analytics layer in Google Cloud Platform.
• How to create it:
  1. Go to Data Sources and click Add.
  2. Select BigQuery.
  3. Name: Enter a unique name for this connection.
  4. Project ID: Your GCP project ID (e.g., my-project-123456).
  5. Dataset ID: (Optional) Default BigQuery dataset to query.
  6. Service Account JSON: Paste the full JSON content of a GCP service account key with BigQuery access.
  7. Location: Dataset location (default US; change if your dataset is in EU or a regional location).
  8. Click Test Connection to verify, then Save.

Note: The service account must have the BigQuery Data Viewer and BigQuery Job User roles on the project.

To generate a key: GCP Console → IAM → Service Accounts → Create Key → JSON.