Summary of Workshop: dbt Packages you didn’t know you needed

This is an AI generated summary. There may be inaccuracies.
Summarize another video · Purchase summarize.tech Premium

00:00:00 - 01:00:00

This workshop-style video provides an overview of dbt packages that can be helpful for businesses. The video demonstrates how to add a new dbt package to an existing model and explains how this affects the data. Finally, the video explains how to update an existing model after adding a new dbt package.

  • 00:00:00 This workshop discusses DBT packages, which are helpful tools for data analytics. The two experts, Elise Papineau and Dave Connors, will be teaching attendees about DBT packages and how to use them. Participants will also be able to access a DBT Cloud account and use a special sandbox account to experiment with the packages.
  • 00:05:00 In this workshop, the presenter reviews the basics of DBT packages, explains how to install them, and discusses how DBT clouds work. They then go on to show how to incorporate a reporting requirement into a DBT project.
  • 00:10:00 This video explains how to set up the DBT Cloud IDE, and how to work with Dev Branch and Credentials sections. It also mentions that 35 percent of viewers are currently in the IDE, and that a compilation error may occur when starting a new account.
  • 00:15:00 This workshop discusses the use of dbt packages that some developers may not be aware of. The main package discussed is dbt- depths, which is required to fix compilation errors in a project. After discussing this package, the workshop moves on to discussing how to add a new source to a model using Cogen. Finally, the workshop covers how to spend less time worrying about the structure of SQL and focus on adding business context to the data.
  • 00:20:00 In this workshop, you'll learn how to use the generate base model macro to create a new staging model for a table in your DBT project.
  • 00:25:00 This workshop discusses the benefits of using dbt packages, and how to create a staging model using code snippets shared in the Slack channel.
  • 00:30:00 This workshop-style video provides an overview of dbt packages that can be helpful for businesses. The video demonstrates how to add a new dbt package to an existing model and explains how this affects the data. Finally, the video explains how to update an existing model after adding a new dbt package.
  • 00:35:00 Audit helper is a package that will be very useful for checking code changes before they are brought to team members for review.
  • 00:40:00 The video tutorial demonstrates how to use DBT Cloud to access a scratch pad to define a previous version of a fact order model, query the model using a variable, and compare the results.
  • 00:45:00 The presenter discusses how fact orders can affect a model's accuracy, and how they can be fixed by rebuilding the order.
  • 00:50:00 The "metrics" package in DBT allows for version controlled aggregations of data over models. The "calculate" macro allows for the specification of lists of metrics to aggregate, as well as secondary calculations.
  • 00:55:00 This workshop shows how to create a metric to measure average cost per order in a project. The metric relies on a model, and the user can slice or dice the data.

01:00:00 - 01:00:00

This workshop covers how to create a staging model and make a join between a staging and existing model. Additionally, it defines a metric.

  • 01:00:00 This workshop covers how to create a staging model, make a join between a staging and existing model, and define a metric.

Copyright © 2024 Summarize, LLC. All rights reserved. · Terms of Service · Privacy Policy · As an Amazon Associate, summarize.tech earns from qualifying purchases.