Version: 0.6 (Latest)

Compatibility

FastBCP Engine

LakeXpress requires FastBCP 1.4.0 or later and is tested with 1.4.0, the version bundled in the package. See FastBCP version.

Supported Databases

Database Type	As Source	Extraction (default)	As LakeXpress DB
SQL Server	Supported	ADBC (`adbc_mssql`)	Supported
PostgreSQL	Supported	ADBC (`adbc_pgsql`)	Supported
Oracle	Supported	Native (ADBC with `use_adbc: true`)	Not supported
MySQL	Supported	Native	Supported
MariaDB	Supported	Native	Not supported
SAP HANA	Supported	Native	Not supported
Teradata	Supported	ADBC (`adbc_teradata`)	Not supported
SQLite	Not supported		Supported
DuckDB	Not supported		Supported

ADBC extraction needs FastBCP 1.4.0 or later (bundled) on linux-x64 or win-x64. "use_adbc": false on a source selects the native driver, and "use_adbc": true selects ADBC for Oracle; see ADBC Extraction.

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	Supported	Supported
Databricks	Supported	Supported
Microsoft Fabric	Supported	Supported
BigQuery	Supported	Supported
MotherDuck	Supported	Supported
Amazon Redshift	Supported	Supported
AWS Glue	Supported	Not supported
DuckLake	Supported	Not supported