[ADAP-1084] [Feature] Support Column Comment

[yassun7010]

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-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

A related to dbt-labs/dbt-core#9198 .

Support column comment information on dbt-snowflake.

Describe alternatives you've considered

No response

Who will this benefit?

People considering transitioning to dbt.

Especially for those who initially define data in sources and gradually migrate to models.

Are you interested in contributing this feature?

Yes

Anything else?

Also see dbt-labs/dbt-core#9230

[dbeatty10]

Similarly to dbt-labs/dbt-core#9198 and dbt-labs/dbt-codegen#119, closing this per dbt-labs/dbt-core#9198 (comment).