dbt

Why scan yesterday’s data when you possibly can increment today’s?The code below assumes understanding of some dbt concepts, in case you’re unfamiliar with it, chances are you'll still find a way to grasp the...

Leverage dbt and its advanced scripting functionality to generate dynamic pivot tables that adapt to changing pivot valuesMost of us will approach this by writing SQL with case statements for every category. While this...

Managing data models at scale is a standard challenge for data teams using dbt (data construct tool). Initially, teams often start with easy models which are easy to administer and deploy. Nonetheless, because the...

First, we want so as to add two recent dbt packages, dbt-expectations and dbt-utils, that can allow us to make assertions on the schema of our sources and the accepted values.# packages.ymlpackages:- package: dbt-labs/dbt_utilsversion:...