Database Walkthroughs
  • 18 Oct 2024
  • 1 Minute to read
  • Dark
    Light

Database Walkthroughs

  • Dark
    Light

Article summary

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 AthenaAmazon RedshiftApache DruidAurora MySQL (Data API)
Aurora PostgreSQL (Data API)DatabricksGoogle BigQueryGoogle Sheets (Public)
Google Sheets (Private)MySQLOraclePostgreSQL
SnowflakeTrino

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