dbt (data-build-tool) - How to Run Queries from the Terminal (dbt Show Command)

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- With dbt Core, you'll likely find yourself developing in a local editor, then copying compiled code into your database server to look at the results. But as of version 1.5, there's a new command called "show" that allows you to run queries (and see results) directly from your terminal. When would you use this? - Preview results before deploying (results do not get materialized) - Investigate a test failure - Review table records without changing tools/screens In this video, I want to show you how to use this command so you can be more efficient with your development and avoid this hopping back and forth. Thank you for watching! Timestamps: 0:00 - Intro 0:24 - What is the dbt Show Command? 1:05 - Using the Command 2:18 - Query Specific Columns Title & Tags: How to Run Queries from the Terminal (dbt Show Command) #kahandatasolutions #dataengineering #databuildtool