Database Walkthroughs
  • 26 Jul 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light

Database Walkthroughs

  • Dark
    Light

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.


Was this article helpful?

What's Next