LLMs.txt directory

Connect to Heap SQL in Analyst Studio

Supported JDBC drivers and known issues

We support the following JDBC drivers:

  • (Recommended) Amazon Redshift version 2.1.0.29

  • Amazon Redshift version 2.1.0.13

  • Amazon Redshift version 2.1.0.3

There are no known issues with this driver.

Connect to Heap SQL

Once you’ve signed up for Heap and enabled Heap SQL, your Customer Success Manager will provide you with your Heap credentials for connecting to your database. If you need your Heap credentials, please email support@heapanalytics.com for help.

Once you have your credentials, follow the steps below to connect Analyst Studio:

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

  2. Select Heap from the list of databases.

  3. Enter your Heap credentials and click Connect. You’ll land on a page that displays your database schema.

  4. Click New Query in the top navigation to start writing queries.