Dec 6 - 10, 2021

Register for Free
Scaling Knowledge > Scaling Bodies: Why dbt Labs is making the bet on a data literate organization

Scaling Knowledge > Scaling Bodies: Why dbt Labs is making the bet on a data literate organization - Erica Louie

Keynote: How big is this wave? Keynote: How big is this wave?

Keynote: How big is this wave? - Martin Casado & Tristan Handy

dbt 101: Stories from real-life data practitioners + a live look at dbt dbt 101: Stories from real-life data practitioners + a live look at dbt

dbt 101: Stories from real-life data practitioners + a live look at dbt - Natty (Jon Natkins) & Alexis Wong Baird

How to build a mature dbt project from scratch

How to build a mature dbt project from scratch - Dave Connors

Analytics Engineering for storytellers

Analytics Engineering for storytellers - Winnie Winship

The modern data experience

The modern data experience - Benn Stancil

Identity Crisis: Navigating the Modern Data Organization Identity Crisis: Navigating the Modern Data Organization Identity Crisis: Navigating the Modern Data Organization Identity Crisis: Navigating the Modern Data Organization Identity Crisis: Navigating the Modern Data Organization

Identity Crisis: Navigating the Modern Data Organization - Jillian Corkin, David Jayatillake, Caitlin Moorman, Barr Moses & Stefania Olafsdottir

Git for the rest of us

Git for the rest of us - Claire Carroll

You don’t need another database: A conversation with Reynold Xin (Databricks) and Drew Banin (dbt Labs) You don’t need another database: A conversation with Reynold Xin (Databricks) and Drew Banin (dbt Labs)

You don’t need another database: A conversation with Reynold Xin (Databricks) and Drew Banin (dbt Labs) - Drew Banin & Reynold Xin

Share. Empower. Repeat. Come learn about how to become a Meetup Organizer!

Share. Empower. Repeat. Come learn about how to become a Meetup Organizer! - Rosie Cardoso

The Operational Data Warehouse: Reverse ETL, CDPs, and the future of data activation

The Operational Data Warehouse: Reverse ETL, CDPs, and the future of data activation - Tejas Manohar

Refactor your hiring process: a framework (Workshop Sponsor) Refactor your hiring process: a framework (Workshop Sponsor) Refactor your hiring process: a framework (Workshop Sponsor)

Refactor your hiring process: a framework (Workshop Sponsor) - Ilse Ackerman, Ezinne Chimah & Rocío Garza Tisdell

Tailoring dbt's incremental_strategy to Artsy's data needs

Tailoring dbt's incremental_strategy to Artsy's data needs - Abhiti Prabahar

Optimizing query run time with materialization schedules

Optimizing query run time with materialization schedules - Ola Canty

How dbt Enables Systems Engineering in Analytics

How dbt Enables Systems Engineering in Analytics - Jorge Cruz Serralles

When to ask for help: Modern advice for working with consultants in data and analytics

When to ask for help: Modern advice for working with consultants in data and analytics - Jacob Frackson

Smaller Black Boxes: Towards Modular Data Products

Smaller Black Boxes: Towards Modular Data Products - Stephen Bailey

The Modern Data Stack: How Fivetran Operationalizes Data Transformations

The Modern Data Stack: How Fivetran Operationalizes Data Transformations - Nick Acosta

Analytics Engineering Everywhere: Why in Five Years Every Organization Will Adopt Analytics Engineering

Analytics Engineering Everywhere: Why in Five Years Every Organization Will Adopt Analytics Engineering - Jason Ganz

Down with

Down with "data science" - Emilie Schario

So You Think You Can DAG: Supporting data scientists with dbt packages

So You Think You Can DAG: Supporting data scientists with dbt packages - Emma Peterson

Operationalizing Column-Name Contracts with dbtplyr

Operationalizing Column-Name Contracts with dbtplyr - Emily Riederer

Data Paradox of the Growth-Stage Startup

Data Paradox of the Growth-Stage Startup - Emily Ekdahl

Batch to Streaming in One Easy Step Batch to Streaming in One Easy Step

Batch to Streaming in One Easy Step - Emily Hawkins & Arjun Narayan

The Call is Coming from Inside the Warehouse: Surviving Schema Changes with Automation The Call is Coming from Inside the Warehouse: Surviving Schema Changes with Automation

The Call is Coming from Inside the Warehouse: Surviving Schema Changes with Automation - Lewis Davies & Erika Pullum

Beyond the Box: Stop relying on your Black co-worker to help you build a diverse team.

Beyond the Box: Stop relying on your Black co-worker to help you build a diverse team. - Akia Obas

Observability Within dbt Observability Within dbt

Observability Within dbt - Kevin Chan & Jonathan Talmi

Inclusive Design and dbt

Inclusive Design and dbt - Evelyn Stamey

Built It Once & Build It Right: Prototyping for Data Teams

Built It Once & Build It Right: Prototyping for Data Teams - Alex Viana

Coalesce After Party with Catalog & Cocktails Coalesce After Party with Catalog & Cocktails

Coalesce After Party with Catalog & Cocktails - Tim Gasper & Juan Sequeda

How to Prepare Data for a Product Analytics Platform (Workshop Sponsor)

How to Prepare Data for a Product Analytics Platform (Workshop Sponsor) - Esmeralda Martinez

Toward a Polyglot Environment for Analytics

Toward a Polyglot Environment for Analytics - Caitlin Colgrove

Automating Ambiguity: Managing dynamic source data using dbt macros

Automating Ambiguity: Managing dynamic source data using dbt macros - Eric Nelson

The Endpoints are the Beginning: Using the dbt Cloud API to build a culture of data awareness

The Endpoints are the Beginning: Using the dbt Cloud API to build a culture of data awareness - Kevin Hu

Data as Engineering

Data as Engineering - Raazia Ali

Building On Top of dbt: Managing External Dependencies

Building On Top of dbt: Managing External Dependencies - Teghan Nightengale

Data Analytics in a Snowflake world: A conversation with Christian Kleinerman and Tristan Handy Data Analytics in a Snowflake world: A conversation with Christian Kleinerman and Tristan Handy

Data Analytics in a Snowflake world: A conversation with Christian Kleinerman and Tristan Handy - Tristan Handy & Christian Kleinerman

Keynote: Building a Force of Gravity

Keynote: Building a Force of Gravity - Drew Banin

dbt Core v1.0 Reveal ✨

dbt Core v1.0 Reveal ✨ - Jeremy Cohen

Firebolt Deep Dive - Next generation performance with dbt Firebolt Deep Dive - Next generation performance with dbt

Firebolt Deep Dive - Next generation performance with dbt - Kevin Marr & Cody Schwarz

dbt, Notebooks and the modern data experience dbt, Notebooks and the modern data experience

dbt, Notebooks and the modern data experience - Allan Campopiano & Elizabeth Dlha

No silver bullets: Building the analytics flywheel No silver bullets: Building the analytics flywheel No silver bullets: Building the analytics flywheel

No silver bullets: Building the analytics flywheel - Kelly Burdine, Lewis Davies & Erika Pullum

Don't hire a data engineer...yet

Don't hire a data engineer...yet - Stefania Olafsdottir

dbt for Financial Services: How to boost returns on your SQL pipelines using dbt, Databricks, and Delta Lake

dbt for Financial Services: How to boost returns on your SQL pipelines using dbt, Databricks, and Delta Lake - Ricardo Portilla

The Future of Data Analytics The Future of Data Analytics The Future of Data Analytics The Future of Data Analytics

The Future of Data Analytics - Sarah Catanzaro, Jennifer Li, Astasia Myers & Julia Schottenstein

Implementing and scaling dbt Core without engineers

Implementing and scaling dbt Core without engineers - Elliot Wargo

Building an Open Source Data Stack

Building an Open Source Data Stack - Katie Hindson

This is just the beginning

This is just the beginning - Alan Cruickshank

dbt in a data mesh world

dbt in a data mesh world - José Cabeda

Introducing the activity schema: data modeling with a single table

Introducing the activity schema: data modeling with a single table - Ahmed Elsamadisi

From Diverse

From Diverse "Humans of Data" to Data Dream "Teams" - Prukalpa Sankar

From 100 spreadsheets to 100 data analysts: the story of dbt at Slido From 100 spreadsheets to 100 data analysts: the story of dbt at Slido From 100 spreadsheets to 100 data analysts: the story of dbt at Slido

From 100 spreadsheets to 100 data analysts: the story of dbt at Slido - Daniela Barokova, Michal Kolacek & Andrej Svec

To All The Data Managers We've Loved Before To All The Data Managers We've Loved Before

To All The Data Managers We've Loved Before - Paige Berry & Adam Stone

Stay Calm and Query on: Root Cause Analysis for Your Data Pipelines (Workshop Sponsor)

Stay Calm and Query on: Root Cause Analysis for Your Data Pipelines (Workshop Sponsor) - Francisco Alberini

Upskilling from an Insights Analyst to an Analytics Engineer

Upskilling from an Insights Analyst to an Analytics Engineer - Brittany Krauth

Modeling event data at scale (Workshop Sponsor)

Modeling event data at scale (Workshop Sponsor) - Will Warner

Building a metadata ecosystem with dbt

Building a metadata ecosystem with dbt - Darren Haken

New Data Role on the Block: Revenue Analytics

New Data Role on the Block: Revenue Analytics - Celina Wong

Using dbt to understand open-source communities

Using dbt to understand open-source communities - Srini Kadamati

Getting Meta about Metadata: Building Trustworthy Data Products Backed by dbt (Workshop Sponsor) Getting Meta about Metadata: Building Trustworthy Data Products Backed by dbt (Workshop Sponsor)

Getting Meta about Metadata: Building Trustworthy Data Products Backed by dbt (Workshop Sponsor) - Angie Brown & Kelechi Erondu

🍪 Eat the data you have: tracking core events in a cookieless world

🍪 Eat the data you have: tracking core events in a cookieless world - Jeff Sloan

Trials and Tribulations of Incremental Models

Trials and Tribulations of Incremental Models - Vincey Au

Sharing the knowledge - joining dbt and

Sharing the knowledge - joining dbt and "the Business" using Tāngata - Chris Jenkins

SQL Draw Artworks Review Panel

SQL Draw Artworks Review Panel - James Weakley

What dbt community members are building (and shipping!)

Sent 21 Feb 2021

Hi friends,

We recently announced dates for Coalesce 2021 (Dec 6-10), and it may surprise you to know that we’re already dedicating effort to planning the conference. We had a lot of fun (and tackled a lot of first-time challenges) organizing Coalesce — we’d never held a conference before, let alone a fully online, multi-day event! Somehow we pulled it off! (“Somehow” == thanks to our events manager, Fatima.)

This week, we’ve been thinking through our Call for Speakers process — how do we frame the conference so we get topics that feel relevant to the community? How can we ensure a lineup with diverse ideas and representation? How do we review several hundred proposals with our ramshackle team? If you’ve seen a Call for Speakers process that you thought was excellent, I’d love to know about it (just hit reply to this email).

Finally, I’m very excited to share with you that community member, Jillian Corkin, has joined our team as a DevRel Advocate! In addition to writing data rap lyrics, Jillian has worn many data-hats over the last few years: analyst, operations specialist, and product manager. We’re thrilled to have her join our team!

— Claire, dbt Community Manager

From the dbt community #

Questions, ideas, articles, and useful insights from our community. Many of these discussions take part in the dbt Slack group — you can sign up here.

I guess everyone’s New Year’s resolution was to create more content and work on side projects. We love to see it! So much so that we’ve created a new dbt Slack channel, #show-and-tell, for you to share your work.

  • Some really cool tooling being produced in the community:
    • pre-commit-dbt, a tool for ensuring dbt project quality, from Radek Tomsej
    • dbt-ml-preprocessing a package for building feature stored, from James Weakley
    • dbt-artifacts, a package for building models on top of dbt artifacts, from Niall Woodward.
  • Zeeshan Qureshi and Michelle Ark from the Shopify data team were featured on the Data Engineering Podcast, talking about how they use dbt to build their data warehouse.
  • Community member Jonathan Talmi sums this one up better than I can: "Just came across a great article about the modern analytics stack. It was clear and concise, and provides a great overview of the current landscape." This article is great for junior team members or coworkers who want to know exactly what a data team should do. I also hear that the author, Justin Gage, is writing an article about dbt — so keep an eye on technically.dev for that.
  • This is a nice little roundup of public knowledge about how different companies use dbt. Thanks to Simo Tumelius for putting this one together — PRs welcome.
  • This thread saw a number of different community members weighing in on the best way to learn git and the command line — info I wish I had a few years ago.
  • James Densmore, Director of Data Infrastructure at HubSpot, wrote a book on data pipelines. So many books in the data space were written in a time before the modern data stack, and have viewpoints that aren't compatible with the tools that teams in our community use today. This book is written for the data teams of today! Congrats James!

A few things you may have missed from us #

We’ll, we’ve been busy:

  • We released dbt v0.19.0, and we have a pre-release for 0.19.1 (which has a ton of performance improvements). Still using an old version of dbt? UPGRADE TODAY.
  • Last week we held our first ever edition of “Staging: dbt demo day”. We saw some of the latest dbt features in action, and got a peek into the dbt roadmap. If you missed it, you can catch up here.
  • Brooklyn Data Co hosted the NYC dbt Meetup, it’ll be up on our YouTube channel 🔜 (please like and subscribe).
  • We gave live-coding a go! Turns out, it’s really hard 😅. You can catch us building some models and macros here.
  • As mentioned above, we also announced dates for Coalesce 2021 — mark your calendars for Dec 6-10.
  • Are you following the dbt twitter account? You should be! (And if you're wondering — no it’s not me that runs it, there’s no way I could not have produced a tweet this excellent.)

Great companies currently hiring #

  • Multiple roles at Fishtown Analytics! We’re hiring! So much! Hereare all of our open roles — some are global, others are restricted to US-friendly timezones.
  • Product Advocate at Iteratively 📊(global remote): I’m a huge fan of Iteratively’s product and team! If you’re someone who is passionate about product analytics or interested in technical writing (and have a love of advocacy), this role may be just right for you!
  • Analytics Engineer at Trade Coffee ☕(NYC): It’s always fun to see companies we love hiring from the community. As my coworker Grant says, “Being a Trade Coffee subscriber is a taste adventure”. Coffee included as a perk of the role!
  • Senior Analytics Engineer at Faire 🛍(SF, remote-ok): This team isn’t using dbt yet, but they want to hire someone with the experience to direct the rollout! It’s pretty cool to see a company hiring specifically to lead a dbt rollout!
  • Senior Data Analyst at Webflow 💻 (US remote): Webflow is a great product, and I’m a huge fan of the team lead, Allie! That’s two big ticks for this role!
  • Senior Business Intelligence Manager at Drizly 🍻(US remote): In case you didn’t know, we love the team at Drizly. They’re doing incredible things on their data team (check out Emily’s Coalesce presentation), and are extremely generous community members.

Check out the #jobs channel in dbt Slack for more listings (or to add one yourself!)

Upcoming events #

Here’s where community members will be speaking, hosting, or attending.

  • Feb 23: dbt How-to Hour: Deep dive on two new packages, dbt-ml-preprocessing and dbt-expectations.
  • Mar 9: dbt 101: New to the community and trying to figure out what all the fuss is about? Join us for this 101 session.
  • dbt Learn: We’ve just announced a ton of new dates — check out the events page for all the timing details.