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

Active metadata is the thread that helps weave your data mesh. In this session, Austin Kronz, Director of Data Strategy at Atlan and Sean Rober, Head of Data at Avenue One, discuss how Atlan and dbt are central to how Avenue One enhances their data and analytics ecosystem, brings their product to market, and positions an already fast-paced start-up for scale.

Speakers: Austin Kronz, Director of Data Strategy, Atlan; Sean Rober, Head of Data, Avenue One

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

Data contracts have been much discussed in the community of late, with a lot of curiosity around how to approach this concept in practice and how it might enable shift-left developer-first governance and data quality. For organizations adopting dbt while also dealing with non-dbt data that is upstream of the warehouse, it can be challenging to understand how to apply data contracts uniformly across a fragmented stack. We are calling this harmonizing layer the Control Plane for Data - powered by the common thread across these systems: metadata.

In this talk, Shirshanka Das, CTO of Acryl Data and founder of the DataHub Project describes how you can use data contracts and DataHub to make your dbt centered stack more reliable - as well as other use cases that can help build a simpler, more flexible data stack.

Speaker: Shirshanka Das, CTO, Acryl Data

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

With the dbt Semantic Layer, you can define metrics alongside your dbt models, and access them from any integrated analytics tool.

The Semantic Layer has been totally revamped. It’s now powered by MetricFlow, allowing for more complex metric definition and a significantly improved querying experience. Join the dbt Labs product team as they dive into what’s new, what’s different, and what it means for you.

Speakers: Nick Handel, Director, Product Management, dbt Labs; Roxi Pourzand, Product Manager, dbt Labs

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

Learn how ClickUp uses dbt, dbt packages, and Snowflake to save on storage and compute costs using Slim CI and how they empower a data warehouse centric culture across Sales, Marketing, Product Growth, Finance, and RevOps all while maintaining one monolithic dbt build job.

Speaker: Michael Revelo, Data Platform Lead , ClickUp

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

The Fivetran Analytics Engineering team strives to make its dbt packages multi-faceted enough and functional for the majority of data teams, balancing flexibility against ease of implementation. This means that the packages should get you 80% of the way there out of the box, but you're not alone as you cover the final 20%!

Over the years, the team has further developed its understanding of the nuances of analyses and developed different methods for folks to easily tweak packages to their liking. This session will discuss passthrough columns, union macros, and overriding package models, and will teach you how to use these features to make Fivetran's packages work for you or even leverage the same patterns in your own work.

Speaker: Jamie Rodriguez, Senior Analytics Engineer, Fivetran

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

A significant proportion of dbt Cloud users do not have a dbt CI job set up. Among those who do, many don’t leverage powerful functionality like state comparison and deferral to implement Slim CI, likely causing teams to miss errors and building unnecessary tables. Setting up Slim CI in dbt Cloud can be especially challenging for larger-scale data organizations who have multiple data environments, git branches, and targets. Watch this session to learn how you can build and evolve a strong, lasting data environment using Slim CI.

Speakers: Leo Folsom, Solutions Engineer, Datafold

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

In this session, phData talks through their experiences dealing with migrations: how to plan for one, how to handle refactoring code, and the difficulty of auditing. This session is especially helpful for organizations that are looking to transition to dbt Cloud, as it provides helpful tips for laying the foundations for a new system and doing the migration right.

Speakers: Dakota Kelley, Solution Architect, phData; Chris Johnson, Solutions Architect, phData

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

Performance is a crucial factor in delivering timely and accurate data to organizations. However, debugging the performance of dbt models can be a challenge, as most resources available focus on legacy databases or tips for specific data engines that do not translate to modern data platforms.

In this talk, Juan Manuel Perafan focuses on optimizing performance for dbt users, without focusing on any specific data warehouse. He explores the commonalities across most data warehouses and provides practical tips and strategies for improving the performance of dbt models. From query optimization to materialization strategies.

Whether you're new to dbt or a seasoned user, this talk provides valuable insights and best practices for improving the performance of your dbt models.

Speaker: Juan Manuel Perafan, Analytics Engineer, Xebia

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

This session walks through Fleetio’s 1.5-year metrics modernization journey: from legacy spreadsheet → custom metric spec and streamlit UI → migrating to dbt-metrics → evolving the metric explorer to become a data portal.

The Fleetio team elaborates on how their thinking of metrics evolved from both a business and technical perspective and how they’re building their metrics explorer to become the frontpage of the data team.

Speakers: Jeffrey Chen, Director of Data & Analytics , Fleetio; Jonathan Hollinger. Senior Data Engineer, Fleetio

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

Ever feel like a soloist in a cacophony of data players? Join Intuitive Surgical's journey from data silos to a harmonized data symphony with dbt as the conductor. Under the spotlight of robotic-assisted surgery, dbt enabled their data teams to provide analytics across a diverse 3000+ engineering organization. Chris Nourse delves into Intuitive's innovations in surgical robotics. Then Brice Loustau discusses their implementation of "dbt-as-a-Service" and multi-project orchestration, while ensuring a scalable, automated, and regulatory-compliant environment.

Speakers: Brice Loustau, Software Engineer, Intuitive Surgical; Christopher Nourse, Analytics Engineer, Intuitive Surgical

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

In the past year at Whatnot, the team has watched their dbt project grow from three developers and fewer than 50 models, to 50 developers and more than 1000 models. In this talk, Alice Leach, a data engineer at Whatnot, discusses the knowledge the team has acquired during this time and the solutions they have built to address the challenges that come with scaling projects. This is broken down into three “G”s: guard rails (robust CI/ CD processes, model monitoring and automated clean up); guidelines (modular workspaces, macros and documentation); and gadgets (dbt code generation and the operations and hooks in place to allow the dbt project to interface with other tools).

Speaker: Alice Leach, Data Engineer, Whatnot

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

Business processes are the foundation of any organization, directing entities towards achieving specific outcomes. These processes can be simple or complex and may take days or even months to complete. Insights into business processes can be determined through three categories: occurrence, volume, and velocity.

In this presentation, Routable’s Director of Data & Analytics discusses the technical and process complexities involved in creating data models in a data warehouse using dbt Cloud. The session also provides tips to make the process easier and explains how to expose this data to users using Looker.

Speaker: Jason Hodson, Director, Data & Analytics, Routable

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

In this session, you'll learn about Rebtel's migration journey from a legacy architecture to the modern data stack. Due to the challenges of Rebtel's stack, the data product value was decreasing in the company, it was time to migrate. Learn how the team is using dbt Cloud and Snowflake to achieve greater success in delivering value to the business. You'll leave with a richer understanding of how to plan and execute a legacy migration.

Speaker: Quentin Coviaux, Data Engineer, Rebtel

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

Hear how the data team at Element Biosciences is tackling BI sprawl while rapidly scaling data models using dbt. They share three use cases along with the tools that enabled their teams to align on crucial metrics to make data-driven decisions and unlock tangible business benefits.

Speaker: Matthew Hoss, Sr. Manager, Business Systems, Element Biosciences

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

At the beginning of this year, Cityblock Health was afforded a unique opportunity: to rebuild their existing dbt project from scratch.

Launched in mid-2019, the legacy project had grown organically into a tangled mess of 1800+ models, with further development becoming more and more difficult.

Faced with the challenge of retroactively imposing order on the existing project, their leadership gave them the opportunity to start fresh instead.

They jumped at the chance, and began applying many of the lessons they learned at Coalesce 2022 to set the new project up for success: - SQL linting, with SQLFluff - YAML linting, with yamllint - dbt best practices, with dbt-checkpoint and dbt-project-evaluator

As a result, this core project has become the model for multi-project collaboration at Cityblock. Rather than a single monolithic project, the new state features a collection of smaller projects, each governed by a high bar for code quality.

Speakers: Katie Claiborne, Staff analytics engineer, Cityblock Health; Nathaniel Burren, Analytics Engineer, Cityblock Health

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

Would you like to know how one of the largest online business insurance organizations in Australia saves 36-72 engineering hours per connector? Watch this session to see how you can influence your business to make quicker and more accurate insights into key business metrics.

Speakers: Alexandra Coffey, Account Executive, Fivetran; Jimmo Vink, Head of Information Management, BizCover

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/

When companies work together through open source development, good things happen. Open source contributions lead to strong relationships between engineers across company lines, and positive outcomes for customers whether through improved functionality, performance, or supply chain security. In this keynote, learn about the power of open source in driving innovation, how AWS approaches open source collaboration, and some of the key improvements for Amazon Redshift, AWS Glue, and Amazon Athena customers and dbt users resulting from our partnership.

Speaker: David Nalley, Director, Open Source Strategy and Marketing, Amazon Web Services

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

Join Snowflake & Deloitte as they discuss how organizations can become exponential enterprise ready through the power of the Snowflake Data Cloud and dbt Cloud's ability to write, test, and ship reliable data in quick time. This session updates you on what your organization needs to do to become exponential enterprise ready. This session also shares examples of organizations that have already made the successful transformation and why they are winning in the market with dbt, Deloitte and Snowflake.

Speakers: Mathew Zele, Cloud & ISV Lead, Snowflake; Vivek Pradhan Lead Partner - Data and AI Platforms , Deloitte; Sagar Kulkarni Partner Sales Engineer, Snowflake

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

Lauren Benezra has been volunteering with a local cat rescue since 2018. She recently took on the challenge of rebuilding their data stack from scratch, replacing a Jenga tower of incomprehensible Google Sheets with a more reliable system backed by the Modern Data Stack. By using Airtable, Airbyte, BigQuery, dbt Cloud and Census, her role as Foster Coordinator has transformed: instead of digging for buried information while wrangling cats, she now serves up accurate data with ease while... well... wrangling cats.

Viewers will learn that it's possible to run an extremely scalable and reliable stack on a shoestring budget, and will come away with actionable steps to put Lauren's hard-won lessons into practice in their own volunteering projects or as the first data hire in a tiny startup.

Speakers: Lauren Benezra, Senior Analytics Engineer, dbt Labs

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

Bluecore works with the largest retail brands around the world to engage shoppers and keep them coming back. In this talk, you’ll learn how the team at Bluecore went about creating, scaling, and maturing an analytics data warehouse in BigQuery to orchestrate 10,000+ models every 30 minutes without bankrupting the company.

Speakers: Adam Whitaker, Analytics Lead, bluecore; Nicole Dallar-Malburg, Analytics Engineer, Bluecore

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