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

    Database Walkthroughs

    • Updated on 18 Oct 2024
    • 1 Minute to read
    • Print
    • 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