Connecting to databases and warehouses | ATX AnalyticsTable Docs

Connecting to databases and warehousesChoosing a sign-in method, and the address, sign-in and limits for Snowflake, Databricks, Redshift, MySQL, Microsoft Fabric and other engines — with TLS, proxies and troubleshooting. Settings → Connections → Add New Connection. Give the connection a name, pick its type, fill in the address and choose a sign-in method — the form then shows only the boxes that method uses. A star (*) marks what is still required, and a line under the form names anything missing. If your team already has a JDBC URL for the database (from a runbook, a BI tool or the vendor console), paste it into "Paste a JDBC URL" and press Read: the address, database, role, sign-in method and options are filled in for you, and the URL itself is then forgotten — the fields are what is saved.

What this page covers

Adding a connection
Which sign-in method to choose
Snowflake — the account, the cloud and private endpoints
Snowflake — sign-in methods
Snowflake — limitations
Databricks — address and sign-in methods
Databricks — limitations
Amazon Redshift — address and IAM sign-in
Amazon Redshift — limitations
MySQL / MariaDB — sign-in methods per platform
MySQL / MariaDB — limitations and TLS rules
Microsoft Fabric / Azure Synapse — endpoints and sign-in
Microsoft Fabric / Azure Synapse — limitations
PostgreSQL, SQL Server, Oracle and BigQuery — which method
Transport security, certificates and proxies
When Test Connection fails

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.