[CT-2435] [Feature] Display model versions with dbt show

[dbeatty10]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

When using model versioning + dbt show, it is not clear which output goes with which version.

For versioned models, maybe use naming similar to dbt list? So something like this:

Previewing node 'dim_customers.v1':

If possible, it would also be nice to sort them in their version order (either from latest to earliest or vice versa).

Example

$ dbt list
my_dbt_project.dim_customers.v1
my_dbt_project.dim_customers.v2

$ dbt show -s dim_customers
22:51:55  Running with dbt=1.5.0-rc1

22:51:56  Previewing node 'dim_customers':
| customer_id | country_name | model_version |
| ----------- | ------------ | ------------- |
|           1 | Nauru        |             1 |

22:51:56  Previewing node 'dim_customers':
| customer_id | country_name | model_version |
| ----------- | ------------ | ------------- |
|           1 | Nauru        |             3 |

22:51:56  Previewing node 'dim_customers':
| customer_id | country_name | model_version |
| ----------- | ------------ | ------------- |
|           1 | Nauru        |             2 |

Describe alternatives you've considered

Rather than all the versions of dim_customers, it might be more expected to specify the desired version in the selection syntax like this:

$ dbt show -s dim_customers.v2
23:04:45  Running with dbt=1.5.0-rc1

23:04:46  Previewing node 'dim_customers':
| customer_id | country_name | model_version |
| ----------- | ------------ | ------------- |
|           1 | Nauru        |             2 |

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[jtcohen6]

Thanks @dbeatty10! I think it's a matter of updating this line, to include the node.version if available:

dbt-core/core/dbt/task/show.py

Line 80 in ada8860

node_name=result.node.name,

As an implementation detail, it would make sense to me to define a new node method, something like pretty_name, which would return node.name by default and {node.name}.v{node.version} if a version is defined.