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
Смотрите видео How to Run Queries from the Terminal (dbt Show Command) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Kahan Data Solutions 26 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,344 раз и оно понравилось 97 людям.