Supported Databases
  • 11 Apr 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Supported Databases

  • Dark
    Light
  • PDF

Supported Databases

Preset supports connection to a wide variety of databases, such as these popular options displayed below. If your preferred database is not listed, don't worry! Nearly any connection can be made via a SQLAlchemy URI.

Supported_Databases2a_03-Mar-2022

Reference List

Amazon Athena Amazon Redshift Apache Druid Apache Hive
Apache Impala Apache Kylin Apache Pinot Apache Spark SQL
Aurora MySQL (Data API) Aurora PostgreSQL (Data API) Azure Synapse ClickHouse
CockroachDB Databricks Interactive Cluster (Hive) Databricks SQL Endpoint (ODBC) Dremio
ElasticSearch (OpenDistro SQL) ElasticSearch (SQL API) Firebird Firebolt
Google BigQuery Google Sheets Microsoft SQL Server MySQL
Oracle PostgreSQL Presto Rockset
SAP HANA Snowflake Teradata Trino
Vertica ...and any database that supports a SQLAlchemy URI connection!

Preset IPs for Whitelisting

For security reasons you may need to whitelist Preset Public IPs to get access to your query engine and your datasource.


Connection Strings

Select linked database name for more connection details / instructions.

Database Connection String
Amazon Athena awsathena+rest://<aws_access_key_id>:<aws_secret_access_key>@athena.<region name>.amazonaws.com/<database name>?s3_staging_dir=s3://<s3 bucket>/&work_group=<work group>
Amazon Redshift redshift+psycopg2://<Username>:<Password>@<AWS End Point>:<Port-default-5439>/<Database Name>?sslmode=verify-ca
Apache Drill drill+sadrill://<Username>:<Password>@<host>:<port>/<storage_plugin>?use_ssl=True
Apache Druid druid+https://<User>:<password>@<Host>:<Port-default-8082>/druid/v2/sql
Apache Hive hive://<Host>:<Port-default-10000>/<Database Name>
Apache Impala impala://<Host>:<Port-default>/<Database Name>?use_ssl=True
Apache Kylin kylin://<Host>:<Port-default>/<Database Name>?is_ssl=True
Apache Pinot pinot+https://pinot-broker.<Host>:<Port-default>/query?server=https://pinot-controller.<Host>:<Port-default>/
Apache Spark SQL jdbc+hive://
Aurora PostgreSQL (Data API) postgresql+auroradataapi://{aws access id}:{aws secret key}@/{db_name}
Azure Synapse mssql+pyodbc://<Username>:<Password>@<Host>:<Port>/<DatabaseName>?driver=ODBC+Driver+17+for+SQL+Server
ClickHouse clickhouse+native://<Username>:<Password>@<Host>/<Database Name>?secure=true
CockroachDB cockroachdb://<Username>:<Password>@<Host>/<Database Name>?sslmode=require
Databricks Hive databricks+pyhive://token:<token>@<host>:443/<Database Name>
Dremio dremio://user:pwd@host:31010/<Database Name>/?SSL=1
Elasticsearch elasticsearch+https://<Host>:9200/
Exasol exa+pyodbc://
Firebird firebird+fdb://<Username>:<Password>@<Host>:<Port-default:3050>/<path to db>/db.fdb
Firebolt firebolt://{username}:{password}@{host}/{database}
Google BigQuery bigquery://<project_id>
Google Sheets gsheets://
Hana hana://<Host>?encrypt=True
IBM Db2 db2+ibm_db://<Host>/?Security=ssl
Microsoft SQL Server mssql+pymssql://<Username>:<Password>@<Host>:<Port-default:1433>/<Database Name>
MySQL mysql+mysqlconnector://<UserName>:<Password>@<Host>/<Database Name>
Oracle oracle://
PostgreSQL postgresql://<UserName>:<Password>@<Host>/<Database Name>?sslmode=require
Presto presto://<UserName>:<Password>@<Host>/<Database Name>?protocol=https
Rockset rockset://apikey:{your-apikey}@api.rs2.usw2.rockset.com
Snowflake snowflake://<UserName>:<Password>@<Account>/<Database>?role=<Role>&warehouse=<Warehouse>
Teradata teradata://
Trino trinonative://{username}:{password}@{hostname}:{port}/{catalog}
Vertica vertica+vertica_python://<UserName>:<Password>@<Host>/<Database Name>?ssl=1

Was this article helpful?

What's Next