Add a Google Sheets database connection
You can add a connection to Google Sheets and use it as a database in ThoughtSpot DataFlow.
Follow these steps:
-
Click Connections in the top navigation bar.
-
In the Connections interface, click Add connection in the top right corner.
-
In the Create Connection interface, select the Connection type.
-
After you select the Google Sheets Connection type, the rest of the connection properties appear.
See Connection properties for details, defaults, and examples.
- Connection name
-
Name your connection.
- Connection type
-
Choose the Google Sheets connection type.
- Obtain access token
-
Select this option to use access key/token to connect to the Google Sheets web-service.
- Access token
-
Specify the access token to authenticate Google Sheets.
- Refresh token
-
Specify the refresh token to authenticate Google Sheets.
- OAuth client ID
-
Specify the OAuth client ID.
- OAuth client secret
-
Specify the OAuth client secret.
- Callback URL
-
Secured domain URL of the repo used to register in Google Sheets.
- Scope
-
Specify the number of users to access the account.
- JDBC options
-
Specify the options associated with the JDBC URL.
-
Click Create connection.
