Examples & Recipes
Tested commands for common LakeXpress scenarios, grouped by task.
Commands use Linux syntax. On Windows PowerShell, replace \ with ` at the end of lines, and ./LakeXpress with .\LakeXpress.exe.
The commands leave out --fastbcp_dir_path: the trial edition finds its bundled FastBCP engine automatically. With the full edition, add --fastbcp_dir_path <folder containing FastBCP> to config create.
The credentials entry names (lxdb_postgres, source_postgres, s3_01, snowflake_prod...) are examples: use the names from your own credentials.json.
Required sync arguments
The sync, sync[export], and sync[publish] commands require -a, --lxdb_auth_id, and --sync_id. The <SYNC_ID> in the examples refers to the sync ID printed by config create.
Manage LakeXpress
- LakeXpress DB: initialize, empty, drop and unlock the LakeXpress DB, for each supported backend
- Configuration Management: create, list and delete sync configurations, check their status
Export
- Local Exports: PostgreSQL, SQL Server, MySQL, MariaDB and Teradata to local disk
- Cloud storage: AWS S3, Azure Storage, Google Cloud Storage, OneLake
Publish
- Snowflake: external and internal tables
- Databricks
- AWS Glue
- Microsoft Fabric
- BigQuery
- Amazon Redshift
- MotherDuck
- DuckLake
Refine and operate
- Table Filtering: include and exclude table patterns
- Incremental Sync: export only new or changed rows
- Resume Failed Exports: retry only the tables that failed