Census
2023-06-05 10:00
2023-06-05 11:00
Webinar

Learn dbt, build a package, ???, profit!

Date:
MM DD, YYYY (Local)
MM DD, YYYY (San Francisco)
Time:
HH:mma–HH:mma (Local-z)
HH:mma–HH:mma (San Francisco-PDT)
Date:
MM DD, YYYY
Time:
HH:mma–HH:mma
(Event Local-z)
(San Francisco-PDT)
From:
MM DD, YYYY
HH:mma
(Event Local-z)
(San Francisco-PDT)
To:
MM DD, YYYY
HH:mma
(Event Local-z)
(San Francisco-PDT)
,
SHARE

Speakers

Jeff Sloan
Product Manager
Stephen Ebrey
Data Consultant & Founder @ Sawtelle Analytics
Register below to save your seat

Info

Have you ever wanted to build a dbt package, but didn’t know where to start? In this 60-minute workshop, Stephen Ebrey, data consultant and founder of Sawtelle Analytics, will break down the process he went through to build the recently-released census_utils dbt package, as well as cover cross DB compatibility, how to use variables to let users customize your package, and integration testing. 

This session will include practical advice on how and why to create a dbt package, as well as notes on challenges of package work that many analytics engineers may not have experience with. In this session, Stephen will cover: 

  • Cross DB compatibility
  • How to use variables to let users customize your package
  • Integration testing

He’ll also give examples of ways the databases differ, such as handling arrays, and the two ways to handle them (dispatch or cross-DB macros), as well as cover which databases have free options and how to switch between dbt adapters to test on them. Stephen will wrap up the session with an example of how a variable can make a macro more useful to a wide variety of users, and then I’ll walk through the basic integration testing process using seed files and dbt_utils.equality.

This live session will be MC’d by Jeff Sloan, product manager @ Census, who helped with QA on the census_utils package development.

In partnership with

No items found.

Who you'll meet from Census

No items found.

Other events

No items found.

From your warehouse to your favorite apps.

Without code or engineers.

Activate your data today. Book a demo with one of our experts.

Data nerds, find your cohort.

Wherever you are.

Join our Community of more than 7k data practitioners & get access to exclusive events, content, and meetups.

Learn dbt, build a package, ???, profit!

Have you ever wanted to build a dbt package, but didn’t know where to start? In this 60-minute workshop, Stephen Ebrey, data consultant and founder of Sawtelle Analytics, will break down the process he went through to build the recently-released census_utils dbt package, as well as cover cross DB compatibility, how to use variables to let users customize your package, and integration testing.
Presented By
Jeff Sloan
Product Manager
Stephen Ebrey
Data Consultant & Founder @ Sawtelle Analytics

What you will learn

What is Census?

Census delivers trusted data from the warehouse into all your operational tools. Give every team the data they need to act and automate with confidence.
Learn More →

From your data warehouse to your favorite apps. Without code or engineers.

Start using Census today by booking a demo with one of our experts.

Learn dbt, build a package, ???, profit!

Have you ever wanted to build a dbt package, but didn’t know where to start? In this 60-minute workshop, Stephen Ebrey, data consultant and founder of Sawtelle Analytics, will break down the process he went through to build the recently-released census_utils dbt package, as well as cover cross DB compatibility, how to use variables to let users customize your package, and integration testing.
Speakers
Jeff Sloan
Product Manager
Stephen Ebrey
Data Consultant & Founder @ Sawtelle Analytics
In Partnership With

Have you ever wanted to build a dbt package, but didn’t know where to start? In this 60-minute workshop, Stephen Ebrey, data consultant and founder of Sawtelle Analytics, will break down the process he went through to build the recently-released census_utils dbt package, as well as cover cross DB compatibility, how to use variables to let users customize your package, and integration testing. 

This session will include practical advice on how and why to create a dbt package, as well as notes on challenges of package work that many analytics engineers may not have experience with. In this session, Stephen will cover: 

  • Cross DB compatibility
  • How to use variables to let users customize your package
  • Integration testing

He’ll also give examples of ways the databases differ, such as handling arrays, and the two ways to handle them (dispatch or cross-DB macros), as well as cover which databases have free options and how to switch between dbt adapters to test on them. Stephen will wrap up the session with an example of how a variable can make a macro more useful to a wide variety of users, and then I’ll walk through the basic integration testing process using seed files and dbt_utils.equality.

This live session will be MC’d by Jeff Sloan, product manager @ Census, who helped with QA on the census_utils package development.

Meet Census, a single source of truth for all your tools

Census is the easiest way to share a consistent view of your data across your entire business.  Define your models, metrics, and business logic in your data warehouse and sync them to all your operational tools.

  • Create trust in consistent metrics
  • Automate confidently with clean data
  • Simplify your data integration strategy
  • Improve data security and visibility

From your data warehouse to your favorite apps. Without code or engineers.

Start using Census today by booking a demo with one of our experts.