data lake

FoxPro Frankenstein: Stitching .DBF Files into Snowflake

by michael | Nov 10, 2025 | Blog

You’ve got a stack of legacy desktop tables—multiple .dbf files from a long-running Visual FoxPro / FoxPro system, obscure code pages, ad-hoc joins, and custom business logic.Your analytics team wants the data in the cloud, in an agile, scalable warehouse like...

Data Lake Ingestion Best Practices (with Alice)

by michael | Oct 8, 2025 | Blog

TL;DR: Organize storage by domain, default to yyyy/mm/dd partitioning (ingest_date in bronze, event_date in silver), prefer Parquet for analytics and CSV only for interchange, enable lifecycle rules + versioning on day one, orchestrate with the Alice scheduler...