Data Sources
A datasource is one database connection that Dataira can inspect and query.
Supported databases
| Database | Status | Connection options |
|---|---|---|
| PostgreSQL | Supported | Remote or Tunnel |
| MySQL | Supported | Remote or Tunnel |
| BigQuery | Supported | Service account JSON |
| ClickHouse | Supported | Remote or Tunnel |
Snowflake, DuckDB, SQLite, Trino, and other engines are not currently supported as Dataira datasources.
Connection flow
Good practice
Use read-only credentials. Start with the smallest useful set of tables. If a column contains sensitive data, exclude it or describe the safe way to use it before activation.