Edit a Google BigQuery connection

You can edit a Google BigQuery connection to add tables and columns.

To edit a connection:

  1. Navigate to Data workspace > Connections.

  2. Select the name of the connection you want to edit.

  3. Select the name of the connection you want to edit.

  4. Click Edit

  5. You can now change the connection name and update the connection details, by selecting the appropriate option at the top of the screen, making any changes needed and clicking Next to go to the next page.

  6. Expand the database table dropdown menu, and select the tables and columns you want to add.

  7. Click Next, and then select Validate and save to save the updated connection detail.

Validate metadata

You can now validate connections to discover any changes in metadata after the connection was created. When you validate a connection, ThoughtSpot provides a JSON file containing details on any metadata changes. Once alerted to a metadata change, you can use TML to update the connection.

To validate your connection:

  1. Navigate to Data workspace > Connections.

  2. Select the name of the connection you want to validate.

  3. Click Validate.

  4. If ThoughtSpot detects any changes to the connection’s metadata, it displays an appropriate message. Else, it gives a message stating successful validation.

To remove a table from a connection, delete it from the connection details page. For more information, see: Delete a table.

See the Connection reference for details of connection parameters.

Editing additional configurations of your Google BigQuery connection

You can edit any of the additional configurations of a Google BigQuery connection.

To edit an additional configuration, do the following:

  1. Navigate to Data workspace > Connections.

  2. In the list of connections, find the connection where you want to edit a configuration.

  3. At the far right of your connection, click the More menu more menu, and select Edit configuration.

    To edit the Default configuration of your Google BigQuery connection, see Edit a Databricks connection.

Disabling additional configurations of your Google BigQuery connection

You can disable any of the additional configurations of a Google BigQuery connection.

To disable an additional configuration, do the following:

  1. Navigate to Data workspace > Connections.

  2. In the list of connections, find the connection where you want to disable a configuration.

  3. At the far right of your connection, click the More menu more menu, and select Disable.

    The configuration is greyed out to indicate it is disabled.

    To enable a disabled configuration, click the More menu more menu, and select Enable.
    You cannot disable the Default configuration of a connection.

Deleting additional configurations of your Google BigQuery connection

You can delete any of the additional configurations of a Google BigQuery connection.

To delete an additional configuration, do the following:

  1. Navigate to Data workspace > Connections.

  2. In the list of connections, find the connection where you want to delete a configuration.

  3. At the far right of your connection, click the More menu more menu, and select Delete.

    The configuration disappears from the list of additional configurations.

Related information

Was this page helpful?
×