Google BigQuery

Creating a connection

To setup a BigQuery connection, you need to specify corresponding project name. Telmai service account must be granted access to datasets requiring connections.

To setup permissions to Telmai's service account,

1. Go to Google BigQuery and locate your project: Google Big Query/<project>/<dataset>

2. Click on Share or Add Member.

3. In the New Member field, enter the Telmai-provided service account. Please note each Telmai tenant has a unique service account, so be sure to follow the instructions here to obtain your specific service account and the necessary permissions it requires.

4. Assign the following roles to the service account: Role: BigQuery -> BigQuery Data Viewer Role: BigQuery -> BigQuery Metadata Viewer

5. Save the settings

6. Once the prerequisites are completed, navigate to Telmai. Click on the +Add Connection button, select the BigQuery icon, and enter your Project information.

   

Connecting an asset

Once a connection is defined, you can start using it to create assets. To create assets, you will need:

• Dataset name

• [Optional] Custom SQL