Configuring Data Connections

Data Connections are secure configurations to supported data sources.

Supported Data Sources:

  • Snowflake

  • Postgres

  • Redshift

  • MariaDB

  • MySQL

  • BigQuery

  • More coming soon - let us know if there's one you want us to prioritize

Adding a New Connection

Navigate to the "Data" tab within a project.

When you click "+ Add" you will be prompted to select a data source:

Fill in the relevant connection details, being sure that Hex is allowed to connect to your data source.

  • For PostreSQL, MySQL, Redshift, & MariaDB you'll need the following information: Your database's host url & port, the database name, and your username & password.

  • For Snowflake, you'll need your account name, warehouse, and database along with your username & password.

Projects can have multiple connections, which are listed in the Data tab:

‚Äč

Adding Shared Connections

Admins of an Org have the capability to create Data Connections which can be shared among all Members in your Org. Setting up Shared Data Connections is identical to the process above, except that only Admins can create them from the "Shared assets" tab of the Admin panel.

Using Data Connections to query your database

Once you have configured a Data connection, you can query it using a SQL cell. See here for more details.