--- title: "Connecting Your Data" slug: "connecting-your-data" updated: 2026-07-23T18:09:07Z published: 2026-07-23T18:09:09Z canonical: "docs.preset.io/connecting-your-data" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.preset.io/llms.txt > Use this file to discover all available pages before exploring further. # Connecting Your Data 👤 This documentation is intended for Workspace Admins. Check with your Team Admin for additional access. ## Introduction If you're a Workspace Administrator, one of your first steps will be connecting a [supported database](/v1/docs/connecting-your-data#supported-databases) to Preset. In this article we'll describe this process from beginning to end. As a cloud software, Preset only connects to databases that are publicly addressable. Customer using locally hosted databases can consider deploying their database to the internet via a cloud provider or using a pre-existing cloud provider's database solution. Before starting, allowlist the following IPs to ensure that Preset can access your database: | us-west-2 (us1a) | us-east-1 (us2a) | eu-north-1 (eu5a) | ap-northeast-1 (ap1a) | | --- | --- | --- | --- | | 35.161.45.11 | 44.193.153.196 | 13.48.95.3 | 35.74.159.67 | | 54.244.23.85 | 52.70.123.52 | 13.51.212.165 | 35.75.171.157 | | 52.32.136.34 | 54.83.88.93 | 16.170.49.24 | 52.193.196.211 | If you are not sure where your Preset workspace is located, you can refer to the URL on your browser when accessing Preset. It should look like this: https://xxxxxxxx.us2a.app.preset.io/superset..., where us2a means it is in us-east-1. --- ## Select a Database Check your Workspace Role before you begin. Only Workspace Admins can connect databases. To learn about the roles, visit [User and Data Access Management](/v1/docs/user-and-data-access-management). - In the Toolbar, hover your cursor over **Settings** and select **Database Connections**. ![Database connection step 1.png](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase1.png) - Click on the **+ Database** button. ![Database connection step 2.png](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase2new.png) - *Connect a database* window appears. Select the appropriate database card. ![Screenshot 2023-01-06 at 11.39.16 AM.png](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase3.png) ...or, if your database is not one of these, select **Supported Databases** and choose a database from the drop-down list. ![Select_Supported_Database](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase4.png) - You also have the option of importing your database from a file. Preset supports these [databases](/v1/docs/connecting-your-data#supported-databases). If you don't see your preferred database listed, then please [contact support](https://preset.io/support/?utm_source=Preset-Docs&utm_medium=Referral&utm_campaign=Preset-Docs). We will carefully review your suggestion and consider it for inclusion in our list of supported databases. --- ## Connection Methods You can configure the database connection by providing connection credentials or supplying a SQLAlchemy URI, depending on the type of database. Both methods are described below. **[Method 1: Define Credentials](/v1/docs/connecting-your-data#method-1-define-credentials)** - If your database is one of the following, then you can connect by providing credentials (host, port, etc.) and/or other connection details. | [Google BigQuery](https://docs.preset.io/docs/big-query-database) | [PostgreSQL](https://docs.preset.io/docs/postgres-connection) | [Snowflake](https://docs.preset.io/docs/snowflake) | | --- | --- | --- | | [MySQL](https://docs.preset.io/docs/mysql-connection) | [Amazon Redshift](https://docs.preset.io/docs/redshift) | [Google Sheets](https://docs.preset.io/docs/google-sheets-connection) | **[Method 2: Connect with SQLAlchemy URI](/v1/docs/connecting-your-data#method-2-connect-with-sqlalchemy-uri)** - If your database is not listed above, then you can connect by providing a SQLAlchemy URI. --- ## Method 1: Define Credentials - To demonstrate this option, select the **Google BigQuery** card. ![Method_One_Credentials_1](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase5.png) - The *Connect a database* window appears. ![Define_Credentials_1](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase6.png) Fields you may encounter when defining credentials include: - **Host***: A host, defined as either an IP address or as a domain. - **Port***: Enter a relevant port number for the connection. If user does not have a port number, then use the database's default port value. This fields is used when connecting **Redshift** (default port 5439), **PostgreSQL** (default port 5432), and **MySQL** (default port 3306) databases. - **Database Name***: The name of the database that you are connecting to. - **Username***: The username associated with a user account. - **Password**: The password associated with a user account. - **Display Name***: A nickname for the database (for display in Preset). - **Additional Parameters**: Any additional custom parameters, if needed. - **SSL**: Select the switch to require a SSL connection. ### Note: Fields marked with an asterisk (*) are mandatory. - Select **Connect** to connect your database to Preset. You may be prompted to provide additional configuration settings. See [Advanced Connection Settings](/v1/docs/advanced-connection-settings) to learn more. ![URI_or_BigQuery_Connect_3](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase7.png) --- ## Method 2: Connect with SQLAlchemy URI The majority of our supported databases are connected via a SQLAlchemy URI — please see [connection strings](/v1/docs/uri-connection-strings) for reference. - For example, after selecting **Dremio** from the Supported Databases list... ![Method_Two_Select_a_Database_from_List](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase8.png) ...you can see that the connection requires only a display name and URI to connect to Preset: ![SQLAlchemy_URI_1](https://cdn.document360.io/4749ddf8-aa05-4f3f-80e1-07a5d2d0f137/Images/Documentation/selectdatabase9.png) - When done, select **Test Connection** to see if it works — a notification message will appear. If no [additional connection settings](/v1/docs/advanced-connection-settings) are required, then go ahead and select **Connect**. --- ## Need a hand? #### Connection Walkthrough Articles | [Amazon Athena](https://docs.preset.io/docs/aws-athena) | [Amazon Redshift](https://docs.preset.io/docs/aws-athena) | [Apache Druid](https://docs.preset.io/docs/apache-druid) | [Aurora MySQL (Data API)](https://docs.preset.io/docs/aurora-mysql-data-api) | | --- | --- | --- | --- | | [Aurora PostgreSQL (Data API)](https://docs.preset.io/docs/aurora-postgresql-data-api) | [Databricks](https://docs.preset.io/docs/databricks) | [Google BigQuery](https://docs.preset.io/docs/big-query-database) | [Google Sheets (Public)](https://docs.preset.io/docs/google-sheets-connection) | | [Google Sheets (Private)](https://docs.preset.io/docs/google-sheets-private-connection) | [MySQL](https://docs.preset.io/docs/mysql-connection) | [PostgreSQL](https://docs.preset.io/docs/postgres-connection) | [Snowflake](https://docs.preset.io/docs/snowflake) | | [Trino](https://docs.preset.io/docs/trino) | If you're running into any problems, try to [troubleshoot](/v1/docs/troubleshoot-your-connection) the connection. If you're still stuck, don't worry — just [contact support](https://preset.io/support/?utm_source=Preset-Docs&utm_medium=Referral&utm_campaign=Preset-Docs) for assistance. --- ## Supported Databases Preset supports the following databases as well as **any** database that can be connected to via a SQLAlachemy URI. | Airtable | Amazon Athena | Amazon DynamoDB | Amazon Redshift | | --- | --- | --- | --- | | Apache Doris | Apache Drill | Apache Druid | Apache Hive | | Apache Impala | Apache Kylin | Apache Pinot | Apache Spark SQL | | Aurora MySQL (Data API) | Aurora PostgreSQL (Data API) | Azure Synapse | CelerData StarRocks | | ClickHouse | Clickhouse Connect | CockroachDB | CrateDB | | Databricks Interactive Cluster (Hive) | Databricks SQL Endpoint (ODBC) | Dremio | ElasticSearch (OpenDistro SQL) | | ElasticSearch (SQL API) | Exasol | Firebird | Firebolt | | Google BigQuery | Google Sheets | IBM db2 | Microsoft SQL Server | | MongoDB | MotherDuck | MySQL | Oracle | | PostgreSQL | Presto | Rockset | SAP HANA | | SingleStore | Snowflake | StarRocks | Teradata | | Trino | Vertica | | | | ...and any database that supports a SQLAlchemy URI connection! | ## Cross-database Joins Preset runs all queries directly on your database. No extractions or data dumps are being stored on Preset, which could lead to stale data, limited scale and speed, and security issues. Security and governance are stronger as raw data never leaves your database and it is easy to control permissions via a single point of access. Because raw data never leaves your database, cross database or cross dataset joins are not supported. Preset recommends that a robust semantic layer is built outside of the Business Intelligence tool for centralized governance and performance. While cross-datasets joins are not support, [scoping a filter](https://docs.preset.io/v1/docs/scoping-a-filter) allows one dataset to be filtered based on values from another dataset, as long as there's a column name.