---
title: "URI Connection Strings"
slug: "uri-connection-strings"
updated: 2026-05-25T15:31:35Z
published: 2026-05-25T15:31:35Z
canonical: "docs.preset.io/uri-connection-strings"
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.

# URI Connection Strings

## Connection Strings

Below is a list of connection strings for use when [connecting](/v1/docs/connecting-your-data) a database using a SQLAlchemy URI.

Select linked database name for more connection details / instructions.

| Database | Connection String |
| --- | --- |
| [Amazon Athena](https://docs.preset.io/v1/docs/aws-athena) | `awsathena+pandas://&lt;AWS Access Key ID&gt;:&lt;AWS Secret Access Key&gt;@athena.&lt;Region Name&gt;.amazonaws.com/&lt;Database Name&gt;?s3_staging_dir=s3://&lt;S3 Bucket&gt;/&amp;work_group=&lt;Work Group&gt;` |
| [Amazon Redshift](https://docs.preset.io/v1/docs/redshift) | ` redshift+psycopg2://&lt;Username&gt;:&lt;Password&gt;@&lt;AWS Endpoint&gt;:&lt;Port(default:5439)&gt;/&lt;Database Name&gt;?sslmode=verify-ca` To support Spectrum tables, please use this alternative driver: `redshift+spectrum://&lt;Username&gt;:&lt;Password&gt;@&lt;AWS Endpoint&gt;:&lt;Port(default:5439)&gt;/&lt;Database Name&gt;?sslmode=verify-ca` |
| Apache Drill | `drill+sadrill://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Storage Plugin&gt;?use_ssl=True` |
| [Apache Druid](/v1/docs/apache-druid) | `druid+https://&lt;Username&gt;:&lt;password&gt;@&lt;Host&gt;:&lt;Port(default:8082)&gt;/druid/v2/sql` |
| Apache Hive | `hive://&lt;Host&gt;:&lt;Port(default:10000)&gt;/&lt;Catalog&gt;/&lt;Schema&gt;` |
| Apache Impala | `impala://&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;?use_ssl=True` |
| Apache Kylin | `kylin://&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;?is_ssl=True` |
| Apache Pinot | `pinot+https://pinot-broker.&lt;Host&gt;:&lt;Port&gt;/query?server=https://pinot-controller.&lt;Host&gt;:&lt;Port&gt;/` |
| Apache Spark SQL | `jdbc+hive://` |
| [Aurora PostgreSQL (Data API)](/v1/docs/aurora-postgresql-data-api) | `postgresql+auroradataapi://&lt;AWS Access ID&gt;:&lt;AWS Secret Key&gt;@/&lt;Database Name&gt;` |
| Azure Synapse | `mssql+pyodbc://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;?driver=ODBC+Driver+17+for+SQL+Server` If you face an error, try including `autocommit=True` (might be required by your database): `mssql+pyodbc://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;?autocommit=True&amp;driver=ODBC+Driver+17+for+SQL+Server` |
| ClickHouse | `clickhousedb+connect://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database Name&gt;?secure=true` |
| CockroachDB | `cockroachdb://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database Name&gt;?sslmode=require` |
| CrateDB | `crate://&lt;username&gt;:&lt;password&gt;@&lt;host&gt;:&lt;port&gt;?ssl=true` try either port `5432` or `4200` |
| [Databricks Hive](/v1/docs/databricks) | `databricks+pyhive://token:&lt;Token&gt;@&lt;Host&gt;:443` |
| Dremio | `dremio://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;/?SSL=1` To connect using a Personal Access Token (PAT): `dremio://$token:&lt;Personal Access Token&gt;@sql.dremio.cloud:443/&lt;Project ID&gt;;SSL=1` |
| Elasticsearch (OpenDistro / OpenSearch SQL) | `odelasticsearch+https://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/` |
| Elasticsearch (SQL API) | `elasticsearch+https://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/` To connect using an API Key: `elasticsearch+https://&lt;Host&gt;:&lt;Port&gt;?api_key=&lt;API Key&gt;` |
| Firebird | `firebird+fdb://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port(default:3050)&gt;/&lt;Path to DB&gt;/db.fdb` |
| Firebolt | `firebolt://&lt;Username&gt;:&lt;Password&gt;@&lt;Database Name&gt;/&lt;Engine Name&gt;?account_name=&lt;Account Name&gt;` To connect using a service account: `firebolt://&lt;Service Account ID&gt;:&lt;Service Account Secret&gt;@&lt;Database Name&gt;/&lt;Engine Name&gt;?account_name=&lt;Account Name&gt;` |
| [Google BigQuery](https://docs.preset.io/v1/docs/big-query-database) | `bigquery://&lt;Project ID&gt;` |
| [Google Sheets](https://docs.preset.io/v1/docs/google-sheets-connection) | `gsheets://` |
| Hana | `hana://&lt;Host&gt;?encrypt=True` |
| IBM Db2 | `db2+ibm_db://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Database Name&gt;?Security=SSL` |
| InfluxDB | `datafusion+flightsql://&lt;Host&gt;:&lt;Port&gt;?database=&lt;Bucket-name&gt;&amp;token=&lt;Your-token&gt;` |
| Microsoft SQL Server | `mssql+pymssql://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port(default:1433)&gt;/&lt;Database Name&gt;` |
| MongoDB | `mongodb+srv://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database&gt;?mode=superset` |
| [MySQL](https://docs.preset.io/v1/docs/mysql-connection) | `mysql+mysqlconnector://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database Name&gt;` |
| [Oracle](https://docs.preset.io/v1/docs/oracle) | `oracle+oracledb://&lt;User&gt;:&lt;password&gt;@&lt;TNSName&gt;` |
| [PostgreSQL](https://docs.preset.io/v1/docs/postgres-connection) | `postgresql://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database Name&gt;?sslmode=require` |
| Presto | `presto://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Catalog&gt;/&lt;Schema&gt;?protocol=https` |
| [Rockset](https://rockset.com/docs/rest-api/) | `rockset://apikey:&lt;Your API Key&gt;@api.&lt;Rockset Region&gt;.rockset.com` |
| [Snowflake](https://docs.preset.io/v1/docs/snowflake) | `snowflake://&lt;Username&gt;:&lt;Password&gt;@&lt;Account&gt;/&lt;Database&gt;?role=&lt;Role&gt;&amp;warehouse=&lt;Warehouse&gt;` |
| Teradata | `teradata://` |
| [Trino](/v1/docs/trino) | `trino://&lt;Username&gt;:&lt;Password&gt;@&lt;Host&gt;:&lt;Port&gt;/&lt;Catalog&gt;` |
| Vertica | `vertica+vertica_python://&lt;UserName&gt;:&lt;Password&gt;@&lt;Host&gt;/&lt;Database Name&gt;?ssl=1` |