Bookmarks tagged dbt

"To achieve this, organizations should begin by establishing conventions for project structure, model naming, model testing, and documentation. As a result, automating the enforcement of these conventions becomes feasible. Once these patterns are solidified and enforced, similar activities can be applied to template dbt Cloud Projects with Terraform."

"Note: This is a collection of comments on challenges when using dbt, collected from the wider dbt community."

"Innovation is the ability to see change as an opportunity — not a threat."

"This dbt starter project template is using the Google Analytics 4 BigQuery exports as input for some practical examples / models to showcase the features of dbt and to bootstrap your own project. -..."

"Don't let source data changes scare your stakeholders with changes to important KPIs. Add snapshots and tests to important metrics to be notified if something goes wrong with a key metric."

"A time- and cost-efficient strategy for making development production-like"

"In part 2 of our ongoing series on exploring data, we use dbt
and PostgreSQL to extract meaningful fields from our semi-structured JSON data blobs. "

"Putting the code into version control is only the first step, there’s code and data-review, and most importantly impact checks"

"Where to begin when migrating legacy SQL transformation code to dbt? In a new (free!) on-demand course, analytics engineers from dbt Labs unpack the refactoring process they've employed across dozens of projects."

"