[Feature] Add information on the column type to the documenation of source tables

[M-E-Rademaker]

Is this your first time submitting a feature request?

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

Describe the feature

Currently tables delcared in the source.yml only have their column name (and a description if given in the source.yml) show up in the documentation that is generated via dbt docs generate. There is no information on the column TYPE available (NOTE: this is only for source tables! NOT for tables generated by a model).

I would like for dbt to also show the column types for source tables automatically in the documentation.

Describe alternatives you've considered

No response

Who will this benefit?

I believe anyone that considers dbt an "all in one" framework that lets you analyse/inspect/see your transformation pipeline end-to-end would be happy to also have all the relevant information on the source table right in the dbt documentation without having to refer to another documentation or to look at the source table in the DB itself.

Are you interested in contributing this feature?

No response

Anything else?

No response

[dbeatty10]

Thanks for reaching out @M-E-Rademaker.

Which version of dbt-core are you using? You can get this by executing this command:

dbt --version

I'm using version 1.7.10, and I am seeing the column names and data types when I look at a source in the documentation website:

[github-actions[bot]]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions[bot]]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[github-actions[bot]]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.