Towards an Error-free UNION ALL David Krevitt on June 30, 2022 June 30, 2022 David Krevitt Union'ing two or more tables with a long list of columns can be an error-prone chore, which dbt + dbt_utils abstracts away.
DATEADD SQL function across warehouses David Krevitt on June 30, 2022 June 30, 2022 David Krevitt DATEADD Function syntax varies across data warehouses. Learn how to standardize your syntax no matter the container.
Surrogate key across warehouses David Krevitt, Jason Ganz, Sanjana Sen on June 30, 2022 June 30, 2022 David Krevitt, Jason Ganz, Sanjana Sen What's a surrogate key, and how can you generate them across BigQuery, Databricks, Redshift, Snowflake and other data warehouses?
A Love Letter to ETL Tools David Krevitt David Krevitt Two fundamental technological advances, ETL tools and cloud data warehouses, enable analytics engineers to practice the ELT workflow.
Data modeling techniques for more modularity Christine Berger, David Krevitt, Randy Pitcher Christine Berger, David Krevitt, Randy Pitcher Explore practical examples of modular data modeling techniques from traditional to modern and modular techniques.
The Case for the ELT Workflow David Krevitt, Pat Kearns, Sean McIntyre David Krevitt, Pat Kearns, Sean McIntyre The tale of migrating from a stored procedure-based ELT workflow to an ELT data transformation workflow on BigQuery, and the 3x productivity gains that ensued....
The role of dbt in BI reporting work David Krevitt David Krevitt Reporting quality can make or break your data team's reputation - will your colleagues cherish your visualizations, or question their validity?
Why Bother Data Cataloging? David Krevitt David Krevitt Organize your organization's information with a high-quality data documentation process.
