Skip to main content

Bigquery Setup Guide

Prerequisites

  1. Follow Google's Create a service account key instructions to set up service account key authentication.
  2. Grant the service account the following permissions on the dataset:
ROLEREASON
BigQuery Job UserTo create queries
BigQuery Data ViewerTo view the data

Setup Guide

  1. Enter the Private Key from the service account that you created above.
  2. Enter the Client Email from the service account that you created above.
  3. Enter the Project Id your BigQuery project id.
  4. Enter the Dataset Name your dataset name that contains the data you wants to move.
  5. Enter a Location that your dataset located.

    Note: You cannot change the dataset location once the connector is created.

  6. Enter a Name for the connector.
  7. (Optional) Enter a Description for the connector.
  8. Select the Owner of the connector.
  9. (Optional) Verify that your BigQuery account is successfully connected by clicking on Test Connection.
  10. Click Connect.

Supported Streams

All tables in specified dataset are supported (Full Refresh)

ON THIS PAGE

Need Help?

Get help and support on all things Matia.

Contact Us