This post recaps learnings from the dbt+MotherDuck workshop and delves into building performant data pipelines using DuckDB and MotherDuck. Key steps include utilizing the read_blob() function, leveraging pre_hooks and variables in DuckDB, implementing incremental models with read_csv(), and handling data de-duplication using
Table of contents
Quick SummaryThe read_blob functionPre-hooks & variables + array_aggIncremental models & read_csvUnnest + arg_maxClosing Thoughts1 Comment
Sort: