Summary of But I won't do that — things you shouldn't do with dbt

00:00:00 - 00:30:00

This video is a tutorial on using the data change tool (dbt) in SQL Server. It covers how to preview changes to a table's data, how to simulate changes to a table's data by changing the source, and how to see the results of changes.

• 00:00:00 In this talk, Randy pitcher explains the reasons why stored procedures can be tricky to write and why they can be a bad idea. He also provides advice on how to write stored procedures procedurally instead of using DBT Cloud.
• 00:05:00 This video explains how to create and call a stored procedure in DBT. The main points are that stored procedures are by far the most popular alternative to DBT, that you need to define and call them, and that you can use them as pre- and post-hooks in your code.
• 00:10:00 This speaker discusses how to create incrementals in DBT, and how to avoid common bad programming practices. He notes that incrementals always end with a is incremental check and that foreign key constraints are automatically handled.
• 00:15:00 The video explains how to use DBT's incremental processing feature to keep track of changes to a table's data. The author shows how to use a pass-through to preview the changes, and how to use a unique key to differentiate updates from new records. Finally, the author demonstrates how to use the incremental processing feature to create a table with data that updates automatically as new records are added.
• 00:20:00 In this video, the speaker discusses the various ways that dbt can be used to improve database performance. He goes on to say that one of the biggest problems with using dbt in a distributed system is that you have no guarantee that your records will be in the same order. He then shows how to use a raw SQL materialization to achieve consistency across different environments.
• 00:25:00 In this video, the presenter discusses how to create a materialization for a stored procedure using DBT. She explains that, in order to use DBT, she first needs to set a name for the materialization and refer to the object as "gold." She then goes on to explain how to generate a natural key and populate it with data from the source table. Lastly, she discusses how to generate a new record using the materialization and how to persist the materialization's data.
• 00:30:00 This YouTube video is a tutorial on using the data change tool (dbt) in SQL Server. The video covers how to preview changes to a table's data, how to simulate changes to a table's data by changing the source, and how to see the results of changes. The video concludes with a message from the speaker about future content plans.