Get In Touch

#056: How to Run Queries from the Terminal (dbt Show Command)

Dec 06, 2023

With 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!

The Starter Guide for Modern Data

Build Modern Data Architectures With More Structure, Faster.

Show more impact with modern tools like dbt, Snowflake & GitHub by following a simple foundational design.

You'll also get other helpful content from me. Unsubscribe anytime.