Skip to main content
All CollectionsIntegrationsDestinations
Connecting Google BigQuery
Connecting Google BigQuery
Matthieu Danielou avatar
Written by Matthieu Danielou
Updated this week

Google BigQuery is a cloud-based data warehouse that allows you to store and analyze large datasets. It is a powerful tool for businesses and organizations that need to process and analyze large amounts of data quickly and efficiently.

Trajaan is fully compatible with Google BigQuery. You can create a BigQuery connector to export your data to a BigQuery dataset. There are two possible configurations.

Configuration A: Use your own BigQuery (recommended)

💡Using your own BigQuery will give you more flexibility with your dataset (you'll be able to do anything you want with it) and full control of your data (as it's hosted in your account).

  1. Navigate to the company settings page and select the Connectors tab. Here, you can create or manage your connectors. To create a BigQuery connector, click on the "Create new connector" button, which will open a modal. Then, select "Google BigQuery".

  2. Enter the name of you choice to identify this connector like “mycompany-bigquery”

  3. Enter the dataset where you want your data to be exported. How to create a dataset ?

  4. Enter the project id where the dataset is located. How to find my project id ?

  5. Setup permissions to your dataset to allow Trajaan to export data in it using the following principal: [email protected] and by granting the role Data Owner. How to grant access to my dataset ?

  6. Click the "Create" button, and you're all set!

💫 Trajaan doesn't store any credentials to access your BigQuery dataset, nor will it have access to anything in your Google Cloud project. The only exception is the permission to create and manage tables in the specific BigQuery dataset where you grant us the Data Owner role.

Configuration B: Use Trajaan's internal BigQuery

If you don't have access to BigQuery or don't want to host the data in your own BigQuery for specific reasons, we can set up the connector to use Trajaan's internal BigQuery and give you read permissions on it.

To do so, contact our CSM team!

Did this answer your question?