Data Connections are secure configurations to supported data sources.
MS SQL Server
More coming soon - let us know if there's one you want us to prioritize
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
Username & password.
For Snowflake, you'll need:
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:
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.
Once you have configured a Data connection, you can query it using a SQL cell. See here for more details.