• Beta
Supported Databases
  • 18 Feb 2021
  • 1 Minute To Read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Supported Databases

  • Print
  • Share
  • Dark
    Light

Supported Databases

Preset supports a wide variety of databases — you simply need to install a package to connect to your preferred database.

DB_List

Whitelist Preset IP for Database Connection

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

Preset IPs

35.161.45.11
52.32.136.34
54.244.23.85

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/<schema_name>
Amazon Redshift redshift+psycopg2://<Username>:<Password>@<AWS End Point>:<Port-default-5439>/<Database Name>/?sslmode=require
Apache Drill drill+sadrill://<Username>:<Password>@<host>:<port>/<storage_plugin>?use_ssl=True
Apache Druid druid+https://<Host>:<Port-default-8082>/druid/v2/sql/
Apache Hive hive://
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://CONTROLLER:5436/query?server=https://CONTROLLER:5983/
Apache Spark SQL jdbc+hive://
Azure MS SQL mssql+pymssql://<Username>:<Password>@<Host>:<Port-default:1433>/<Database Name>/?Encrypt=yes
Big Query bigquery://
ClickHouse
CockroachDB cockroachdb://<Username>:<Password>@<Host>/<Database Name>/?sslmode=require
Dremio dremio://user:pwd@host:31010/?SSL=1
Elasticsearch elasticsearch+https://<Host>:9200/
Exasol exa+pyodbc://
Google Sheets gsheets://
Hana hana://<Host>/?encrypt=True
IBM Db2 db2+ibm_db://<Host>/?Security=ssl
MySQL mysql://<UserName>:<Password>@<Host>/<Database Name>?ssl=1
Oracle oracle://
PostgreSQL postgresql://<UserName>:<Password>@<Host>/<Database Name>/?sslmode=require
Presto presto://<UserName>:<Password>@<Host>/<Database Name>/?protocol=https
Snowflake snowflake://
SQLite sqlite://
SQL Server mssql://
Teradata teradata://
Vertica vertica+vertica_python://<UserName>:<Password>@<Host>/<Database Name>/?ssl=1
Was This Article Helpful?