Hex Docs
Search…
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
    Transform
    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 in the left sidebar.
When you click Add you will be prompted to select a data source. Fill in the relevant connection details and make sure that Hex is allowed to connect to your data source.
    For PostgreSQL, MySQL, Redshift, MS SQL Server, Transform, & 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.
You can establish multiple connections for a given Project, which are then listed in the Data Connections tab:

Adding Shared Connections

Admins of a Workspace have the capability to create Shared Data Connections, which can be shared among all Members in the Workspace. Setting up Shared Data Connections is identical to the process of creating a Data Connection depicted 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 the SQL Cells section here for more details.
Last modified 17d ago