Compatibility
Supported Databases
| Database Type | As Source | As LakeXpress DB |
|---|---|---|
| SQL Server | ✅ Supported | ✅ Supported |
| PostgreSQL | ✅ Supported | ✅ Supported |
| Oracle | ✅ Supported | ❌ Not Supported |
| MySQL | ✅ Supported | ✅ Supported |
| MariaDB | ✅ Supported | ❌ Not Supported |
| SAP HANA | ✅ Supported | ❌ Not Supported |
| Teradata | ✅ Supported | ❌ Not Supported |
| SQLite | ❌ Not Supported | ✅ Supported |
| DuckDB | ❌ Not Supported | ✅ Supported |
Supported Storage Backends
| Storage Backend | Support Status |
|---|---|
| Local Filesystem | ✅ Supported |
| AWS S3 | ✅ Supported |
| S3-Compatible (OVH, MinIO, etc.) | ✅ Supported |
| Google Cloud Storage (GCS) | ✅ Supported |
| Azure Storage (ADLS Gen2, Blob) | ✅ Supported |
| Microsoft Fabric OneLake | ✅ Supported |
Supported Publishing Targets
After export, LakeXpress can create tables in analytics platforms as external (data stays in cloud storage) or internal (data loaded into native storage).
| Publishing Target | External | Internal |
|---|---|---|
| Snowflake | ✅ | ✅ |
| Databricks | ✅ | ✅ |
| Microsoft Fabric | ✅ | ✅ |
| BigQuery | ✅ | ✅ |
| MotherDuck | ✅ | ✅ |
| Amazon Redshift | ✅ | ✅ |
| AWS Glue | ✅ | ❌ |
| DuckLake | ✅ | ❌ |
Set --publish_method external or --publish_method internal. Default is external.
Publishing guides: