Add a PostgreSQL database connection
You can add a connection to a PostgreSQL database using 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 PostgreSQL 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 PostgreSQL connection type.
- Host
-
Specify the hostname or the IP address of the PostgreSQL system.
- Port
-
Specify the port associated to the PostgreSQL system.
- User
-
Specify the user id that will be used to connect to the PostgreSQL system. This user should have necessary privileges to access the data in the databases.
- Password
-
Specify the password for the User.
- Database
-
Collection of information that is organized so that it can be easily accessed, managed and updated.
- Enter password/Fetch password from vault
-
Select whether to enter password or fetch and use the password you have stored in external vault providers (e.g. AWS Secrets Manager).
- Vault provider
-
Select the name of your external vault provider.
- Secrets manager region
-
Region of the AWS account where secret manager is defined.
- Secret name or ARN
-
If user trying to access using two different accounts, then the value to be given here is a fully qualified Amazon Resource Name (ARN) of the secret.
- Remote role ARN
-
If user trying to access using two different accounts, then the value to be given here is a remote role Amazon Resource Name (ARN) where secret manager is not defined.
- Key name in secret
-
Key name given for the secret, to get its value.
- Version
-
Specify the PostgreSQL version being connected to.
- JDBC options
-
Specify the options associated with the JDBC URL.
-
Click Create connection.
