Skip to main content

Add BigQuery Resource

This guide will walkthrough adding BigQuery to Meroxa. Before adding, see BigQuery Setup.

Using the CLI, you can run the following command to add a new resource:

meroxa resource add bigquery --type bigquery --url bigquery://$GCP_PROJECT_ID/$GCP_DATASET --client-key "{ $GCP_SERVICE_ACCOUNT_JSON }"

In the command above, replace the following variables with valid credentials from your Postgres environment:

  • GCP_PROJECT_ID - Google Cloud Project ID
  • $GCP_DATASET - A BigQuery dataset (see Setup).
  • $GCP_SERVICE_ACCOUNT_JSON - Valid Service Account credentials with access to BigQuery (see Setup).

Once done, your new BigQuery resource is available in your Resource Catalog and ready for use within pipelines.