To integrate Max with Google BigQuery, you will need to establish a connection. This allows Max to access and interact with your BigQuery datasets, enabling powerful data analytics capabilities. Here’s how to set up a new Google BigQuery connection:

Step-by-Step Guide

1. Navigate to the Data Page: Access the Data page within Max where all connections are managed.

2. Initiate New Connection:

   • Click the + button in the bottom left of the connections left panel to start the process of creating a new connection.

3. Fill in Connection Details:

   • Connection Name: Enter a unique name for the connection to help identify it within Max.
   • Description (optional): Provide a brief description of what this connection will be used for.
   • Connection Type: Select Google BigQuery from the dropdown menu.

4. Project and Dataset Details:

   • Project ID: Enter the ID of your Google BigQuery project.
   • BigQuery Dataset: Specify the name of the BigQuery dataset to connect to.

5. Authentication:

   • Service Account Email: Provide the email associated with your Google service account.
   • Service Account Key: Enter the key associated with your service account. This is necessary for Max to authenticate and access your BigQuery data.

6. Test and Create:

   • Click the Test Connection button to verify that Max can connect to BigQuery with the provided settings.
   • If the test is successful, click the Create button to finalize the connection.

Important Notes

• Ensure that all details, especially the project ID, dataset name, and service account information, are entered correctly to avoid connectivity issues.
• The service account must have sufficient permissions to access the specified BigQuery dataset.
• Table / view and column names are assumed to contain “normal” characters; i.e. letters, numbers, and underscores.

Setting up this connection allows Max to perform data operations directly on your Google BigQuery datasets, enhancing your data analysis capabilities.