More command: show

[ReneTC]

Currently we have:

Transformer 'dbt-duckdb' supports the following commands: build, clean, compile, debug, deps, docs-generate, docs-serve, freshness, run, seed, snapshot, test

Should we add the dbt show command?

[jwills]

Mmm, I think we do already-- is this a Meltano thing?

For example, I can run:

jwills@Joshs-MBP jaffle_shop_duckdb % dbt show -m orders
02:44:15  Running with dbt=1.5.2
02:44:15  Registered adapter: duckdb=1.5.2
02:44:15  Unable to do partial parsing because profile has changed
02:44:16  Found 5 models, 20 tests, 0 snapshots, 0 analyses, 430 macros, 0 operations, 3 seed files, 0 sources, 0 exposures, 0 metrics, 0 groups
02:44:16
02:44:16  Concurrency: 1 threads (target='dev')
02:44:16
02:44:16  Previewing node 'orders':
| order_id | customer_id | order_date | status    | credit_card_amount | coupon_amount | ... |
| -------- | ----------- | ---------- | --------- | ------------------ | ------------- | --- |
|        1 |           1 | 2018-01-01 | returned  |                 10 |             0 | ... |
|        2 |           3 | 2018-01-02 | completed |                 20 |             0 | ... |
|        3 |          94 | 2018-01-04 | completed |                  0 |             1 | ... |
|        4 |          50 | 2018-01-05 | completed |                  0 |            25 | ... |
|        5 |          64 | 2018-01-05 | completed |                  0 |             0 | ... |

[ReneTC]

Yeah you are correct, I am trying with meltano. I thought the error was from this repo. Do you know where the issue should be fixed? Trying to get this to work:

meltano invoke dbt-duckdb:show -m orders
>>> Command 'show' could not be found. Transformer 'dbt-duckdb' supports the following commands: build, clean, compile, debug, deps, docs-generate, docs-serve, freshness, run, seed, snapshot, test

[ReneTC]

To do dbt show with meltano:

meltano invoke dbt-duckdb show --select name_of_model.sql