Lakehousecat connects to tabular data across different source systems and file formats. Each datasource type defines a specific connection method and the fields required to establish it.
Relational & Analytical Databases
| Type | Connection Method | SSH Tunnel |
|---|
| PostgreSQL | Connection URI | ✅ |
| MySQL | Connection URI | ✅ |
| MariaDB | Connection URI | ✅ |
| Microsoft SQL Server | Connection URI | ✅ |
| Azure Synapse Analytics | Connection URI | ✅ |
| Oracle Database | Connection URI | ✅ |
| IBM DB2 | Connection URI | ✅ |
| ClickHouse | Connection URI | — |
| Snowflake | Connection URI | ✅ |
| Google BigQuery | Connection URI | ✅ |
| Amazon Redshift | Connection URI | ✅ |
| Amazon Athena | Connection URI | ✅ |
| Databricks | Connection URI | ✅ |
| Databend | Connection URI | ✅ |
| Vertica | Connection URI | ✅ |
| Exasol | Connection URI | ✅ |
| MonetDB | Connection URI | ✅ |
| SingleStore | Connection URI | ✅ |
| Greenplum | Connection URI | ✅ |
| PolarDB | Connection URI | ✅ |
Distributed & NewSQL
| Type | Connection Method | SSH Tunnel |
|---|
| CockroachDB | Connection URI | ✅ |
| YugabyteDB | Connection URI | ✅ |
| Vitess | Connection URI | ✅ |
| TiDB | Connection URI | ✅ |
| OceanBase | Connection URI | ✅ |
Time-Series Databases
| Type | Connection Method | SSH Tunnel |
|---|
| TimescaleDB | Connection URI | ✅ |
| QuestDB | Connection URI | ✅ |
Streaming & Real-Time
| Type | Connection Method | SSH Tunnel |
|---|
| Materialize | Connection URI | ✅ |
| CrateDB | Connection URI | ✅ |
NoSQL Databases
| Type | Connection Method | SSH Tunnel |
|---|
| MongoDB | Connection URI | — |
| Redis | Host / Port | — |
Query Engines & OLAP
| Type | Connection Method | SSH Tunnel |
|---|
| Apache Drill | Connection URI | ✅ |
| Apache Druid | Connection URI | ✅ |
| Apache Hive | Connection URI | ✅ |
| Trino | Connection URI | ✅ |
| Presto | Connection URI | ✅ |
| Apache Doris | Connection URI | ✅ |
| StarRocks | Connection URI | ✅ |
| Apache Spark SQL | Connection URI | ✅ |
In-Process & Embedded
| Type | Connection Method | SSH Tunnel |
|---|
| DuckDB | File upload | — |
| SQLite | File upload | — |
API-authenticated cloud sources — no connection URI or server required.
| Service | Authentication | Description |
|---|
| Google Analytics | OAuth 2.0 | Web analytics data from Google Analytics 4 |
| Google Sheets | OAuth 2.0 | Spreadsheets as a tabular data source |
| Hugging Face | API Key | Datasets from the Hugging Face Hub |
| Type | Description |
|---|
| Delta Lake | Delta Lake table stored in S3-compatible object storage |
| Apache Hudi | Apache Hudi table stored in S3-compatible object storage |
| Apache Iceberg | Apache Iceberg table stored in S3-compatible object storage |
Object Storage
| Type | Description |
|---|
| Amazon S3 | CSV or Parquet files hosted in an S3-compatible bucket |
File Sources
| Type | Description |
|---|
| File Upload | Upload CSV or Excel files directly from your machine |
| File Collection from S3 | Create a searchable document collection from files in an S3 bucket |
Virtual
| Type | Description |
|---|
| Timeline | Virtual time dimension table for date-based analytics |
How to Create a Data Source
For step-by-step creation instructions, see the Data guide in the Guides section. That guide covers the full creation workflow — type selection, field configuration, validation, and the datasource editor.