Supported Platforms
ekai connects to major cloud data warehouses to profile your data and generate ERDs. All connections are read-only with data profiled in-place.
Data Warehouses
Currently Available
Snowflake
Full support including Snowflake Native App deployment.
- User/Password authentication
- OAuth authentication
- Multi-database connections
- Semantic Intelligence via Snowflake Cortex
Databricks
Unity Catalog and legacy Hive metastore support.
- Personal Access Token auth
- Unity Catalog integration
- SQL Warehouse connections
- Cluster connections
- Semantic Intelligence via Databricks Genie Workspace
Google BigQuery
Connect to any BigQuery project and dataset.
- Service Account JSON auth
- Multi-project support
- Dataset selection
- Partition-aware profiling
- Semantic Intelligence via Data Agents
Azure Synapse
Dedicated and serverless SQL pools.
- SQL authentication
- Azure AD authentication
- Dedicated pools
- Serverless pools
PostgreSQL
Connect to PostgreSQL databases.
- User/Password authentication
- SSL connections
- Schema selection
ClickHouse
ClickHouse Cloud and self-managed clusters over the HTTP interface.
- User/Password authentication
- SSL connections (default)
- Database selection
- Semantic Intelligence via ClickHouse Agent
Amazon Redshift
Provisioned clusters and Redshift Serverless workgroups.
- User/Password authentication
- Configurable SSL mode
- Schema selection
DuckDB
Embedded analytical database with local file and in-memory support.
- Local file and in-memory databases
- Read Parquet, CSV, and JSON
- Remote files (S3, HTTP)
- MotherDuck paths (
md:) - No authentication for local / in-memory
Coming Soon
AWS Athena
Coming soon
MotherDuck
Coming soon
Platform Support Matrix
| Capability | Snowflake | Databricks | BigQuery | Synapse | PostgreSQL | ClickHouse | Redshift | DuckDB |
|---|---|---|---|---|---|---|---|---|
| Connection | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Profiling | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| ERD Generation | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| DBT Execution | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Semantic Intelligence | Snowflake Cortex | Databricks Genie Workspace | Data Agents | — | — | ClickHouse Agent | — | — |
| Native App | ✅ | — | — | — | — | — | — | — |
Connection Security
All connections are read-only with TLS 1.3 encryption. Raw data never leaves your warehouse—ekai only transfers statistical summaries.
See Security & Privacy for complete details.
Next Steps
- LLM Configuration - Configure AI providers
- Create Connection - Connect your first warehouse
- Schema Agents Overview - Start generating ERDs