Skip to content

Data News — Coalesce 2022

dbt Coalesce 2022 main takeaways from my perspective. A bit of Python, semantic layer and a lot of analytics engineering and data teams impact.

Christophe Blefari
Christophe Blefari
6 min read
Me right now (credits)

Hey dear members. I have to confess I'm lazy. Every week I want to create content, I want to work on a new article or video. The more I have ideas the more I procrastinate. Every week, Friday appears and I'm still here, late with the newsletter. For years I was convinced I could change it, but let's face the truth, I'm 30 now, it will never change.

Still, while procrastinating this week I've decided to watch all replays—around 120—from the dbt annual conference. This newsletter will give you my Coalesce 2022 takeaways.

Don't forget that this selection of talks represent my reading of the conference. It also represents my views and my understanding. You can disagree with what I said and if you feel I'm deeply wrong on something, once again hit reply or comment.

I have also added a ❤️ on my 3 favourite talks.

Coalesce 2022

The conference agenda has been divided, according to me, into 5 categories that are similar to last year ones:

  • dbt future — which direction the data field is going with dbt at center
  • Analytics engineering
  • HR — Grow your data career and fix your data team
  • Diversity talks about how we can be more open in the data field
  • Partners — dbt's booming, everyone wants to be in

📺 Watch the dbt YouTube playlist

dbt future

Obviously Coalesce has been the theatre for dbt Labs to announce new stuff. Nothing revolutionary or surprising because it was already discussed or announced before the conference. During the 5-days dbt Labs talks were focused on 3 main topics: Python, Semantic Layer and Community. In the modern data stack the warehouse is king, at the center, dbt sits on top of it. In this privileged position dbt usage is growing.

Being at the center of a community of users and partners means a lot. You foster a variety of usages while attracting with your growth a lot of partners in search of integration with you. This is what dbt Labs has to juggle with. As a personal opinion I think that too much tools were just demoing their product without any added value, still this is not a big issue as I can skip them.

Technically speaking, being at the center of the data stack leads also to the next step for dbt: the Semantic Layer. This layer has been designed to be the all-in-one interface for all the tools in needs for data. dbt Labs will open-source a new project called the dbt Server—not yet released—that will put an HTTP API on top of dbt Core to do dbt operations. In addition dbt Cloud will offer a proprietary Metadata API and a Cloud proxy. The Cloud proxy will be able to translate YAML metrics definition to SQL. As I already said it feels a bit like their best try to generate revenue.

If I'm being sarcastic and defensive I don't see as a good sign that dbt wants to be my new data connector on top of my warehouse, adding a layer of complexity in my infrastructure.

Lastly the Python support, while being fairly simple, impressed me. In a form of a duel Jeremy vs. Cody dbt team demoed what you can and can't do with Python models. In a versus Python vs. SQL models we've seen usage of pandas describe and pivot, fuzzy matching and sklearn.

On a side node dbt team also presented their focus for 2023 and 2024 outlined by their user research. As Tristan said, dbt wants to be the open standard to create and disseminate knowledge. So 2023 will mean: better lineage support for datascience, standardization around metrics and semantic layer and enriched dbt DAG capabilities to add more context to it—whatever it means re-bundling is coming.

analytics engineers facing the future (credits)

Analytics engineering

2022 is probably the year of analytics engineering being popularized. While being still unclear what are the true frontiers of the role, everyone knows that "dbt developers" are analytics engineers. But it goes deeper that this. It implies a mix of business understanding with technical expertise over SQL engines and data modelisation.

At Coalesce we've seen that analytics engineering has a wide range of applications. But in the end you don't build models, you construct knowledge, this knowledge is essential to find the common ground between the company verticals. Even if AE is still new, it relies on old principles like Kimball modeling, but is it still relevant? Spoiler: yes, even if it's not like before for performance reasons, Kimball brings understandability.

Under analytics engineering I really like 3 presentations that I would recommend to any people in analytics, these presentation while approaching technical concepts in a good way bring good food for thoughts to improve any dbt project:

  • Outgrowing a single `dbt run` — at scale the schedule based orchestration can fail, having CRON that runs dbt will lead to issue so you need a smarter orchestration pattern. This is were reactive/proactive scheduling enters the room. In the Airflow world it means you have to use sensors to trigger runs. Here Prratek also recommend to run staging model each time a source is refreshed and once every staging have been run to run the marts. I think this is a good pattern.
  • ❤️ Testing: Our assertions vs. reality — Probably the best talk of the conference to me. Mariah shows how dbt is natively badly designed when it comes to testing. dbt tests are mixing code and data quality which are 2 different piece of the testing framework. She also greatly illustrates the difference between assumptions and assertions when it comes to data.
  • Efficient is the new sexy - A minimalist approach to growth — Matthieu propose a framework to handle team growth while tackling engineering problems. He also tackles issues like modularity (linked to mesh concepts) and testing on another angle than the previous one.

Lastly data contracts concepts were on fire in the data community. This time Jake and Emily are providing us with practical example using jsonschema to define interface between product and data teams.

Grow as an individual and fix your data team

A lot of talks this year have tried to answer to a simple question: how can a data team have an impact? This is obviously related to the fact that all data teams around the world are costing a lot and leaders are still struggling to find the Return on Investment (ROI).

In this introspective search of what's a data team, the picture seems to be the same for everyone. Cultural challenges are the main blockers for massive data adoption. 5 talks tried to propose something to help adoption:

Being in an analytics team can be difficult because you're in the middle of everything without the power to take decisions. That's why data team have to be empathic. Empathy means "the action of understanding" (cf. Empathy-building in data work and How insensitive: Increasing analytics capacity through empathy).

Purple people

dbt blog mentioned purple people concept last year. Purple people are these generalists that are doing the glue between the business and the data stack. But being a generalist is often a solo job. You are navigating between specialist world and you help these expert communities communicate between each other. This is what Stephen greatly depicted in ❤️ Excel at nothing: How to be an effective generalist.


🫶 Cool stuff

There also were open formats. This creativity shows how great the data community is. Tiankai sang a data jam 🎵, competitors battled to answer business questions as fast as possible and Joe developed an Unity SQL game.

Final shout-out to Mehdio who did video interviews and highlights of the conference because he was there in-person.

Last thing I discovered is the dbt-project-evaluator package, which seems amazing to create CI/CD rules to detect for instance direct join to sources or documentation coverage.

📬 Subscribe to my weekly newsletter 📬

(to get data curation each week in your inbox saving your 5 hours of tech watch)

You can also read my raw notes about Coalesce. This is for members only as the format is quite awful I think.

PS: I've already done this last year for the Coalesce 2021 if you wanna check out.

PS2: sorry for the length of this edition, for the delay and I hope the reading was enjoyable I'm not really proud of my writing here.

See you next week.

Data News

Data Explorer

The hub to explore Data News links

Search and bookmark more than 2500 links


Christophe Blefari

Staff Data Engineer. I like 🚲, 🪴 and 🎮. I can do everything with data, just ask.


Related Posts

Members Public

Data News — Week 24.24

Data News #24.24 — I'm back sorry for the late news. I'm co-organising a conference in Paris in Nov, CfP is open, AI news with OpenAI and Apple and a lot of Fast News.

Members Public

Data News — Week 24.20

Data News #24.20 — Big edition, 5000 members ❤️, launching Qrators to search in videos, Data Council, OpenAI and Google I/O stuff and data eng stuff.