Duckdb

• DuckDB is my new Excel How to replace Excel for ad-hoc data exploration using DuckDB: query remote CSVs, wildcard multi-file ingestion, union-by-name schema handling, unnesting lists, aggregating and counting, and flattening JSON APIs. If you can work with Excel formulas, you can do this. Continue reading...
  Duckdb Motherduck Data_engineering Json Csv Analytics Data_exploration Excel

  9 min read
• Turn Thousands of Messy JSON Files into One Parquet: DuckDB for Fast Data Warehouse Ingestion Turn sprawling API JSON dumps into a single lean Parquet artifact with DuckDB, ready for Snowflake, BigQuery, Redshift, Postgres or DuckDB itself. This guide walks through schema drift handling, lineage, performance considerations, and dbt integration patterns. Continue reading...
  Duckdb Data-Engineering Json Parquet Dbt Ingestion Performance Analytics

  6 min read