Connection reference for Redshift

You need specific information to establish a seamless and secure connection. The following fields are required, except where noted.

Connection name

Enter a name for your Redshift connection.

Connection description

Provide a short description of the connection.

Host

Enter the host name associated with the database. If you used an AWS PrivateLink between your Redshift data warehouse and the ThoughtSpot Cloud tenant, use the PrivateLink Endpoint DNS name provided by ThoughtSpot Support. For example, vpce-12345a9c7e43959d-xxo2u2xx.vpce-svc-037b1f73d3de3a5b4.us-west-2.vpce.amazonaws.com.

Port

Enter the port number associated with the database.

User

Enter the Redshift account username.

This user must have at least read access to the SVV_TABLE_INFO table.
Password

Enter the Redshift account password.

Database

Specify the database associated with the account.

(IAM only) Dbuser

Specify the db user associated with the account.

(IAM only) Access Key

Specify the access key associated with the account.

(IAM only) Secret Key

Specify the secret key associated with the account.

(OAuth only) OAuth Client ID

Enter the OAuth client ID associated with the Redshift database.

(OAuth only) OAuth Client Secret

Enter the OAuth client secret associated with the Redshift database.

(OAuth only) Scope

(External OAuth) Scope maps to a role in your Snowflake database.

For OAuth with Azure AD provider, it should be similar to https://<APPLICATION_ID_URI>/session:role:developer offline_access openid. For more information, see: part 1, step 8 in Configure Azure AD external OAuth for a Redshift connection.

(OAuth only) Auth Url

ThoughtSpot performs an "Authorization Code" grant type flow to get the access token. Get the authorization endpoint for the respective identity provider from its console.

For Azure AD, it can be obtained from the Azure portal by navigating to Azure Active Directory resource. It should be similar to https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/authorize.

(OAuth only) Access token Url

(External OAuth) Enter the Access Token Url associated with your external identity provider.

For Azure AD, it can be obtained from the Azure portal by navigating to Azure Active Directory resource. It should be similar to https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/token.