Supported Databases
- Updated On 21 Jan 2021
- 1 Minute To Read
-
Contributors
-
Print
-
DarkLight
Supported Databases
Preset supports a wide variety of databases — you simply need to install a package to connect to your preferred database.
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>@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema/?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_mode=REQUIRED |
| 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?