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

It's time to "Coalesce"

Sent 08 Dec 2020

Hi friends,

This “monthly-ish” newsletter was last sent 9 weeks ago, but I have a good excuse! Mila and I have been heads-down working with every single Coalesce speaker on their presentation. I am so excited about what the community is going to be sharing with all of you this week 😊

If you haven’t yet joined us for a Coalesce session — there’s still time! Check out the agenda here. (Before you ask me — yes, the recordings will also be made available, but you’ll miss out on the chat which is a good part of the fun!)

— Claire, dbt Community Manager

P.S. I recently moved! If you’re in Burlington Vermont, or know someone who is, shoot me an email to say hi!

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.

  • A couple of community-contributed packages have popped up in the last few weeks 📦📦! Claus Herther turned a lot of Great Expectations’ testing framework into a package: dbt-expectations, and Teghan Nightengale shared a package for testing documentation coverage: dbt-meta-testing.
  • Shopify shared how they use dbt in this blog post, including how they’ve extended its functionality when it comes to unit testing and CI. (They’re also hiring, see below!).
  • This thread about the simplest data stack was a neat one to read!
  • And finally, a shout out to Jonathan Talmi, for helping community members get the dbt CLI working after upgrading to Big Sur (relevant issue if you’re running into this too) — python environments are not my forté, so it’s so lovely to have someone jump in to help out!

A few things you may have missed from us #

We’ll, we’ve been busy:

  • We launched an online, self-led, FREE, version of dbt Learn! We’ve been teaching remotely all year, but simply couldn’t keep up with demand. If you’re onboarding a new team member to dbt, make sure you send the link to them.
  • We announced our Series B a few weeks ago — check out the writeup here!
  • Tristan published a post on The Future of the Modern Data Stack — at 5000 words, it’s a long one, but worth it! For many of us in the dbt community, the “modern data stack” has been the standard for the last four years, so I loved reading Tristan’s take on what it looks like to move past that stack!
  • A few months ago I spoke at a conference on “How to Become a More Impactful Analyst”, and it has only just made it onto YouTube. The talk is probably familiar content for most of the community, but might be useful as a resource for anyone trying to convince an analyst that there is a better way to do their job.

Great companies currently hiring #

  • Product Analytics Lead at Billie, NYC (remote for now): The Billie team have been using dbt for a while, and are looking to add someone to own the full digital product data pipeline from end to end, and get to inform the product roadmap. You’ll also get to work with community member #83 Michelle Ballen.
  • Analytics Engineer at Treatwell, Remote (EMEA hours): The team are migrating off their homegrown ETL and to dbt, and are looking for someone to help out!
  • Many data roles at Shopify: Did you know Shopify use dbt? (And that Fishtown Analytics is about to start using Shopify?) You can learn more about their team and their data stack in this recent blog post!
  • Senior Data Analyst at Netlify (global remote): Netlify are at the start of their dbt journey, but have long-time community member, Emilie Schario, leading the charge! (meet the team at Coalesce this week)
  • Finally, we’re hiring for a lot of different roles (remote, US hours): Including someone to join my team as a Dev Rel advocate, a Learn instructor, product managers, and more! We love hiring people who love dbt as much as we do, so if that sounds like you, please get in touch!

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.

  • Dec 7 - 11: You guessed it — Coalesce is on right now!
  • Jan 20- 21: dbt Learn London Timezone — we promise we’re about to announce this and a few other dbt Learns very soon! Keep an eye out here for when we drop tickets

☝Between Coalesce and the upcoming holiday period, our list is looking a little light. If you have an event to add to list, please reply to this email with the details!