►► Establish a Well-Structured Data Warehouse for Your Small Team In 90 Days (Free Guide) → [ Ссылка ]
Testing the quality of your data is critical to building confidence in any data warehouse. Dbt offers a wide range of testing capabilities and this video will show you the foundation for how tests are run and how you can use them to debug any errors.
dbt Tests:
Tests are assertions you make about your models and other resources in your dbt project (e.g. sources, seeds and snapshots). When you run dbt test, dbt will tell you if each test in your project passes or fails.
Timestamps:
0:00 - Intro
1:02 - Review Current YML file
1:55 - Command to run tests (dbt test)
2:24 - Review test failure
2:31 - Review compiled SQL
5:02 - Fix test failure
Title & Tags:
How to Test Your Models And Debug Errors | Data Build Tool (dbt) Tutorial
#kahandatasolutions #databuildtool #dataengineering
How to test and debug your dbt models
Теги
SQLSQL TutorialLearn SQLBusiness IntelligenceBIData VisualizationLearn BIanalyticsData AnalysisETLData MiningEDWPowerBIMicrosoftTabularDAXBig DataCloud Datasnowflakeawsazureeltpythonlearn pythondata streamingcloud infastructuredevopslearn data analyticslearn data warehousingdata engineeringbig data engineeringagileHow to Test Your Models And Debug ErrorsData Build Tooldbttutorialdbt testdbt labstest dbt models