How to Run Queries from the Terminal (dbt Show Command)
Want to build a reliable, modern data architecture without the mess?
Here’s a free checklist to help you → https://bit.ly/kds-checklist
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
Watch video How to Run Queries from the Terminal (dbt Show Command) online without registration, duration hours minute second in high quality. This video was added by user Kahan Data Solutions 26 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,344 once and liked it 97 people.