- 16 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Database Walkthroughs
- Updated on 16 Nov 2022
- 1 Minute to read
- Print
- DarkLight
Overview
Preset supports a large variety of databases. Outside of the dynamic connection form, if you know the SQLAlchemy URI connection string for a database, then more than likely you can connect to it on Preset. Additionally, if you have an archived database file (e.g., ZIP), then you can import your database directly to Preset.
Some databases, however, require additional layers of information in order to connect. For example, Google BigQuery requires authentication via JSON while Trino requires warehouse parameters.
Please see the articles below for specific directions on how to connect to these types of databases.
Database Connection Walkthroughs
Amazon Athena | Amazon Redshift | Apache Druid | Aurora MySQL (Data API) |
Aurora PostgreSQL (Data API) | Databricks | Google BigQuery | Google Sheets (Public) |
Google Sheets (Private) | MySQL | PostgreSQL | Snowflake |
Trino |
Need Help?
If you're running into any problems, try to troubleshoot the connection. If you're still stuck, don't worry — just contact support for assistance.