Configuring Data Connections

Data Connections are secure configurations to supported data sources.

Supported Data Sources:

  • Snowflake

  • Postgres

  • Redshift

  • MariaDB

  • MySQL

  • BigQuery

  • MS SQL Server

  • Athena

  • 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 PostgreSQL, MySQL, Redshift, MS SQL Server, & MariaDB you'll need:

    • Database host url

    • Database port

    • Database name,

    • Username & password.

  • For Snowflake, you'll need:

    • Account name

    • Warehouse

    • Database

    • Username & password

  • For Athena, you'll need:

    • AWS access key ID

    • AWS secret access key

    • S3 bucket to write query results to

    • The default port is 443 and the host is athena.[region].amazonaws.com(if you're using a VPC to connect then the host address is [vpc-specific-url].athena.[region].amazonaws.com). Note: only AWS users who do not use MFA authentication are supported.

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.