Skip to main content

Adapters

Strata supports 8 database adapters for connecting to your data warehouses.

Supported Adapters​

  1. PostgreSQL - Full PostgreSQL support
  2. Snowflake - Snowflake data warehouse
  3. MySQL - MySQL database
  4. SQL Server - Microsoft SQL Server (including Azure)
  5. Athena - AWS Athena
  6. Trino - Trino/Presto
  7. DuckDB - Embedded analytics database
  8. Druid - Apache Druid

Common Configuration​

All adapters support:

  • adapter - Adapter name (required)
  • name - Display name (required)
  • description - Optional description
  • tier - Performance tier: hot, warm, cold (default: warm)
  • query_timeout - Query timeout in seconds (default: 3600)
  • client_name - Client name sent to database (default: Strata)

Adding Adapters​

Use the CLI to add adapters:

strata datasource add postgres
strata datasource add snowflake

Or edit datasources.yml directly.

Authentication​

Credentials are stored securely in .strata (not committed to git):

strata datasource auth datasource_key

Next Steps​