#056: How to Run Queries from the Terminal (dbt Show Command)
Dec 06, 2023With dbt Core, you'll find yourself developing in a local editor, then going to 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
So 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.
What will you learn?
- How to use the dbt Show command (selector & inline)
- How to dynamically select different columns
- How to filter a result set
Enjoy!
When you're ready, here are 3 ways I can help you further:
1. The Modern Engineer Playbook (Online Course): Master the art of building modern data architectures. Get an end-to-end blueprint for building simple, structured & scalable data pipelines with modern tools.Â
2. The Playbook for dbt™ (Online Course): Learn to build, automate & scale dbt™ with confidence. Discover common strategies teams follow, avoid costly rookie mistakes & get actionable tips based on real-world experience, not a textbook.
3. Consulting Services:Â Request to work 1:1 with Michael Kahan to help you and your team implement a modern data architecture with a simple, scalable structure.