dbtplyr: Bringing Column-Name Contracts from R to dbt
summary
Ports dplyr’s select helpers (starts_with, ends_with, contains) into dbt via the dbtplyr package, exposing column-name contracts that let dbt macros loop over matching columns to cast, transform, or validate them. Uses dbt control flow, macros and tests (Pointblank mentioned) to run checks before transformations, preventing silent type/format errors like dates stored as timestamps and reducing repetitive SQL. The package ships on GitHub and is shown working in dbt pipelines.
AI-written summary · about
chapters (5)
- 0:00Introduction
- 1:30R to dbt workflows
- 6:08Column names as shared language
- 10:15Building dbtplyr
- 17:20Conclusion
related talks
01h 42mFall in Love with Data Transformation: DBT as Your Weapon
49mdbt: A Software Engineering Approach To The Analytics Workflow
18mduckplyr: Analyze large data with full dplyr compatibility
51mFrom SQLi Hammer to Full-fledged Software Engineer
17mdm: Analyze, build and deploy relational data models
01h 00mAutomating Security in Your Data Pipeline
01h 07mHow to Count Things with dbt - Data Build Tool
51mFrom SQLi Hammer to Full-fledged Software Engineer