How to implement unit testing in dbt | Automated test framework in dbt

In this video we cover how to build a automated unit test framework in dbt, including using packages to extend the out of the box functionality of dbt.

🖥 Visit my website here:

💯 Mastering Snowflake is accepting applications now to work with us in a small group. Serious inquiries only please!

✅ Subscribe to the channel here:

---------------
❄️ Want to SUPERCHARGE your career and become an EXPERT in Snowflake? ❄️

⚪️ Order my LATEST book: SnowPro Certification Study Guide HERE:

⚪️ Order my book: Mastering Snowflake Solutions HERE:

⚪️ Get my Free SnowPro core guide HERE:

⚪️ Become a student on my course:

⚪️ Get your Matillion Associate Certification FAST!

---------------
❄️ Welcome to the official YouTube Channel of Mastering Snowflake – With Adam Morton! ❄️

Here, we're all about helping you extract the maximum amount of business value from your data. As a data engineer and solution architect, I understand the struggles of finding practical and high-value advice on Snowflake capabilities.

On this channel, I share my personal experiences, proven approaches, and best practices for designing and implementing Snowflake's capabilities. I also provide case studies and examples to show how it works for you.

➡️ My aim is to help you become a Snowflake expert and avoid costly pitfalls along the way. I'm all about providing you with robust, real-world advice based on my unique experiences in the field.
If you're looking to expand your career prospects and the ability to command a significantly higher salary, consider joining our exclusive program.

We'll guide you through a journey of transformation and provide you with our Everest roadmap to become an expert in the Snowflake data platform.

So, if you're ready to take your data engineering and solution architecting skills to the next level, hit that subscribe button, and join our community by hitting the bell icon 🔔

---------------
📲 Follow Adam Morton on social media:

---------------
📚 Disclaimer:

We are not affiliated or authorised by Snowflake in any way.

---------------

[shloktadilkar]

Nice video sir. Can you please make a video on unit testing with dbt core.

[KPrigz]

What's the best way to decide what data should be used in expected data or in the seed files for testing data set?

[pseudounknow]

Thanks for the video as a student it's helping me a lot !

[brag]

Great video . Wanted to ask on how do we implement snowflake streams functionality using DBT

[Sriramma]

if we are writing tests for incremental models which are already existing the model output is getting compared to old tables . not sure how to switch over schemas between them

[cartfpv]

Thank you, it is very useful!
I have a question. Is it possible to run all tests in unit-test mode, but miss equality tests with real data runs?