Surfline uses Segment to collect product analytics events to understand how surfers use their forecasts and live surf cameras across 9000+ surf spots worldwide. An open source tool was developed to define and manage product analytics event schemas using JSON schema which are used to build dbt staging models for all events.

With this solution, the data team has more time to build intermediate and mart models in dbt, knowing that our staging layer fully reflects Surfline’s product analytics events. This presentation is a real-life example on how schemas (or data contracts) can be used as a medium to build consensus, enforce standards, improve data quality, and speed up the dbt workflow for product analytics.

Speaker: Greg Clunies, Senior Analytics Engineer, Surfline

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

Video highlights from Coalesce 2023 in San Diego. Coalesce is a conference for data practitioners, by data practitioners.

Coalesce is hosted by dbt Labs and crafted in collaboration with partners to advance the practice of the analytics engineering industry. Anyone that seeks new tips, tools, or techniques for more impactful data work is welcome to attend.

Sign up for our next Coalesce: https://coalesce.getdbt.com/

Kick off Coalesce at the Keynote and Product Spotlight!

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. Join Tristan Handy, Founder and CEO at dbt Labs, and Luis Maldonado, Vice President of Product at dbt Labs, to hear all about the latest releases in dbt and how they are helping organizations navigate complexity. Finally, you'll hear from data leaders at Fifth Third Bank on how they are implementing these new capabilities in dbt to execute on their data strategy and achieve better outcomes for the business.