The Lakehouse architecture unites the structured world of analytics with the rapidly evolving world of AI.

But what really makes something a “Lakehouse” and why should you care? In this session, Databricks discusses the key components of a lakehouse, what you should look for when adapting this paradigm and how Databricks and dbt are together enabling analytics engineers, analysts and data scientists to collaborate together on a single unified platform. You’ll hear from a customer about how they leveraged dbt Cloud on Databricks to deliver powerful customer experiences quickly and efficiently. Ken Wong shares the latest capabilities of Databricks platform and provides a sneak peek of upcoming features.

Speakers: Ken Wong, Senior Director of Product Management, Databricks; Samuel Garfield, Analytics Engineer, Retool

Register for Coalesce at https://coalesce.getdbt.com

Learn how dv01 uses dbt Cloud and BigQuery to create a scalable and modern data pipeline for offerings in loan warehousing analytics. These products serve an esoteric niche of finance and are run by a team of financial analysts with deep industry expertise.

With the challenge of tracking the performance of millions of loans from various sources and file structures, the team initially relied on Excel-based workflows. However, as the client base grew, they needed a reliable solution: a scalable data pipeline with dbt Cloud and BigQuery that allows the team to scale into a growing market and provide innovative new products and services.

Explore the transformative power of dbt Cloud in modernizing unscalable data processes, fostering skill development, and driving success in the specialized world of loan warehousing finance.

Speaker: David Maguire, Data Engineer, dv01

Register for Coalesce at https://coalesce.getdbt.com

In this session, gain strategic guidance on how to deploy dbt Cloud seamlessly to a team of 5-85 people. You'll learn best practices across development and automation that will ensure stability and high standards as you scale the number of developers using dbt Cloud and the number of models built up to the low thousands.

This session is a great fit for folks with beginner through intermediate levels of experience with dbt. In basketball terms, this talk covers mid-range shooting skills, but does not go into detail about 3-pointers, let alone half court shots. Likewise, this talk is not for people who are brand new to dbt and aren't familiar with the basic architecture of dbt and the modern data stack.

Speakers: Chris Davis, Senior Staff Engineer, Udemy, Inc.

Register for Coalesce at https://coalesce.getdbt.com

Seven years ago, in the early days of dbt, dbt Labs was building capabilities that made data developers more productive. dbt gained traction. It took off. Today, dbt is the standard for data transformation. It has never been easier to build and ship data products. This has created a new challenge – complexity.

Drew Banin, Co-Founder and Product Manager at dbt Labs, and Michelle Ark, former dbt power user who is now a Staff Software Engineer at dbt Labs, share the latest releases in dbt and how they help organizations navigate complexity.

Speakers: Drew Banin, Co-Founder, dbt Labs; Michelle Ark, Staff Software Engineer, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

In this session, learn how Prime Therapeutics' data team was able to implement dbt for multiple teams and environments in a highly-controlled way without compromising security or performance. With multiple teams and environments, it was essential to manage and maintain consistent policies across environments while helping share best practices to improve their dbt implementations.

Speakers: Jill Aakhus, Principal Analytics Engineer, Prime Therapeutics; Anubhav Pareek, Data Analytics Engineer, AICG

Register for Coalesce at https://coalesce.getdbt.com

Take a look at how the finance data team at Snowflake leverages dbt to drive strategic decision-making within the finance and accounting organizations. This talk spans topics including development velocity, cost governance, and data stewardship.

Speakers: Sandra Herchen, Analytics Engineering Manager, Snowflake; Jack Peele, Business Intelligence Analyst, Snowflake

Register for Coalesce at https://coalesce.getdbt.com

Unlike transforming staged data to marts, ingesting data into staging requires robustness to data volume and type changes, schema evolution, and data drift. Especially when performing change data capture (CDC) on large databases (~100 tables to a database), we’ll ideally reinforce our dbt models with automatic:

• Mapping of dynamic columns and data types between the source and the target stag
• evolution of stage table schemas at pace with incoming data, including for nested data structures
• parsing and flattening of any arrays and JSON structs in the data.

Manually performing these tasks for data at scale is a tall order due to the many permutations with which CDC data can deviate. Waiting to implement them in mart transformation models is potentially detrimental to the business, as well as doesn’t reduce the complexity. Santona Tuli shares learnings from integrating dbt Core into high-scale data ingestion workloads, including trade-offs between ease-of-use and scale.

Speaker: Santona Tuli, Head/Director of Data, Upsolver

Register for Coalesce at https://coalesce.getdbt.com

Join us for story hour, as we follow two intrepid analytics engineers working in a large dbt project as they go on a journey to meshify their dbt project, with help from a ✨special guest✨

Along the way, learn about dbt-meshify - a new CLI tool to automate the creation of model governance and cross-project lineage features in your dbt project. dbt-meshify refactors your code for you, helping you add model contracts, versions, groups, access, cross-project lineage, and more -- all in a matter of minutes! No bespoke YAML writing needed.

Speakers: Grace Goheen, Product Manager, dbt Labs; Nicholas Yager, Principal Analytics Engineer, HubSpot; Dave Connors, DX, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

The Guild team migrated to Snowflake and dbt for their data warehousing needs and immediately saw the benefits of standardizing model structure, DRYer logic, data lineage ,and automated testing on Pull Requests.

But leveraging dbt didn’t solve everything. Pain points around maintaining model logic, handling historical data, and integrating data from over 60 source systems meant that analysts still struggled to provide a unified view of the business. The team knew that they needed to level up their processes and modeling again, and chose to adopt Data Vault (DV).

Brandon and Rebecca take you behind the scenes of this decision to explain the benefits of Data Vault. They highlight DV’s ability to handle complex data integration requirements while remaining agile and demonstrate that it complements other modern data concepts like domain-driven design and data mesh.

Attendees learn what Data Vault is, when it can be a key component of a successful data strategy, and instances where it’s not the right fit. Walk away with practical tips to successfully transition based on a real-world implementation.

Guild transformed their data warehouse; you can too!

Speakers: Brandon Taylor, Senior Data Architect, Guild; Rebecca Di Bari Staff Data Engineer , Guild

Register for Coalesce at https://coalesce.getdbt.com

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Brandon Thomson, Analytics Lead at dbt Labs, digs deeper into the technical details of the Campaign 360, a powerful marketing analytics asset used by every member of the marketing team. You'll learn about the technical decisions made during the build of this product and explore the finished asset.

Join this session to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Brandon Thomson, Analytics Lead, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

The final session of Coalesce 2023! Join us for Community Awards and closing thoughts. We recognize 10 individuals who have contributed significantly to the success of the dbt Community. Some of them will be with us in person, and some others will be tuning in online. All Community Award recipients are recognized and presented with a unique, never-before-seen swag item!

After the awards, we end with closing thoughts and announce the location for Coalesce 2024!

Speakers: Amada Echeverría, Global Community Lead, dbt Labs; Tristan Handy, CEO, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com/

With increased adoption of dbt and ever growing data volumes, data teams are increasingly looking to make their dbt deployments more efficient. The problem? Practitioners aren’t equipped with the tools and strategies to do this well. In this talk, Ian Whitestone and Niall Woodward of SELECT share a variety of dbt cost and performance optimization best practices, diving into the actual strategies they’ve deployed with numerous companies to give practitioners immediately actionable techniques they can apply to their own projects.

Speakers: Ian Whitestone, Co-founder, SELECT; Niall Woodward, Co-Founder, SELECT

Register for Coalesce at https://coalesce.getdbt.com

In this session, you'll learn tips and tricks from La-Z-Boy on how to modernize infrastructure and tackle complex retail and manufacturing data problems using dbt and Fivetran. Hear from a data leader about their experience and how you can replicate their success. Start your session off with some comfortable data movements to make sure you can extract as much information as possible from our loaded session on data transformation.

Speakers: Alex Hauer, Lead Product Marketing Manager, Fivetran; Selwyn Samuel, Director of Data Analytics & Enterprise Architecture, La-Z-Boy

Register for Coalesce at https://coalesce.getdbt.com

In the dbt Labs on dbt series, you get a behind-the-scenes look at how dbt Labs uses data. You’ll learn how dbt Labs thinks about the role of data, how data developers collaborate with business leaders, and the technical decisions we’ve made in our own dbt project.

In this session, Elize Papineau, Senior Data Engineer at dbt Labs, digs deeper into the technical details of the cost optimization project at dbt Labs. You'll learn how the team leveraged query tags in dbt to make model performance monitoring possible, the process for analyzing model performance, the implementation of warehouse specific configurations at the model level, and how the team measures the effectiveness of optimizations and translates it into cost savings.

Watch to learn about dbt Labs' journey and leave with ideas that you can implement in your dbt project today.

Speaker: Elize Papineau, Sr. Data Engineer, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

Two public servants at the City of Boston and the State of California are tasked with improving data services and data engineering practices within their respective governments. As part of the modernization process, they are adopting dbt and associated tools within their respective teams.

This session discusses the similarities and differences between the implementations of dbt, and how some of the constraints and challenges of working in government shape both the technical and social design of data services. The speakers will reflect on successes, challenges, and lessons learned about adopting modern data tooling in state and local governments.

Speakers: Jenna Jordan, Data Engineer, City of Boston; Ian Rose, Senior Data Engineer, California Office of Data and Innovation; Laurie Merrell, Senior Analytics Engineer, Jarvus Innovations

This session addresses the problem of how to leverage dbt Cloud to support domain user development for a migration from a centralized analytics environment towards a distributed data mesh analytics environment.

Speaker: Holly Burch, Data Architect, Sharp HealthCare

Register for Coalesce at https://coalesce.getdbt.com

Prioritizing the right sales opportunities is pivotal for any SaaS company's growth, but what happens after your initial success? Jessica Zhang, Data Science Manager at Notion, traces Notion's footsteps from its foundational days to its present-day lead scoring techniques. Learn how modern tools like dbt, Census, and Snowflake enable the Notion team to iterate quickly. More than a journey, this session is a lesson on evolving a data science model in response to changing business assumptions and fresh user insights.

Speakers: Jessica Zhang, Data Science Manager, Notion; Jeff Sloan, Sr. Data Community Advocate, Census

Register for Coalesce at https://coalesce.getdbt.com

In this session, Jeremy Cohen, product manager at dbt Labs, does an in-depth walk-through of the new dbt Cloud releases shared on-stage during the Keynote & Product Spotlight. This session focuses on changes to the dbt Cloud IDE and new ways to develop with dbt.

Wherever you write code, see the future of dbt development in action.

Speakers: Jeremy Cohen, Product Manager, dbt Labs; Greg McKeon, Product Manager, dbt Labs

Register for Coalesce at https://coalesce.getdbt.com

In the rapidly evolving landscape of data technology, the integration of Snowflake and dbt has revolutionized the creation and management of data applications. Now, developers can harness their combined capabilities to build superior, scalable, and sophisticated data applications.

With Snowflake’s cloud-based architecture, developers can access boundless storage, computing, and seamless data sharing. Additionally, Snowpark Python enables the performance of data transformation, analytics, and algorithmic functions within Snowflake, presenting developers with a new realm of opportunities. Incorporating dbt further enhances the synergy, allowing developers to streamline data workflows in an agile, model-driven environment.

This session covers how the Snowflake and dbt partnership can pave the way toward building better, future-proof data applications that cater to the dynamic needs of businesses in the digital era.

Speaker: Tarik Dwiek, Head of Technology and Application Partners, Snowflake

Register for Coalesce at https://coalesce.getdbt.com

Now that you can write models in Python, a new world of possibility has opened up. In this session, Christopher Marland introduces you to Snowpark and how it integrates with dbt, before demonstrating a real-world use case where Python transformations outperform SQL, starting from raw data and moving through to a completed analysis.

This talk is ideal for people who are familiar with PySpark but new to dbt, or who are experienced dbt users and curious about taking advantage of their new Pythonic superpowers from inside of a familiar development environment.

Speaker: Christopher Marland, Snowflake Solutions Architect, Aimpoint Digital

Register for Coalesce at https://coalesce.getdbt.com