LLMs.txt directory

Connect to PostgreSQL in Analyst Studio

Additionally supports: Amazon Aurora PostgreSQL, HeapSQL, Timescale, Citus, Cube, Google Cloud SQL for PostgreSQL

Supported JDBC drivers and known issues

Driver Driver Release Date Analyst Studio Removal Date

(Recommended) PostgreSQL v 42.7.4

8/23/2024

PostgreSQL v 42.6.0

3/18/2023

PostgreSQL v 42.3.1

2/15/2022

PostgreSQL v 42.2.23

7/6/2021

PostgreSQL v 42.2.19

2/18/2021

PostgreSQL v 42.2.14

6/4/2020

There are no known issues with this driver.

Connect to PostgreSQL

  1. Log in to Analyst Studio and follow the steps to connect a database to Analyst Studio.

  2. Select PostgreSQL.

  3. Enter the Display name, Description (optional), Host, Port, Database name, Username, and Password.

  4. Upload the file for Custom Trusted SSL CA certificate.

  5. Select the preferred JDBC driver.

  6. Click Connect. You will land on a page that displays your database schema.