Pull Column Comments from Snowflake to Model Column Descriptions

The problem I’m having

Rather than type all column descriptions in dbt, is there a way to generate those from Snowflake directly ? Information_Schema.Columns.Comments field has comments (definitions) for each column.

The context of why I’m trying to do this

Generate Base Models Column Descriptions from Snowflake Information Schema

What I’ve already tried

Some example code or error messages

Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML! 

I did similar of this in dbt + snowflake (fivetran as my source of data to my DWH). I wrote the steps in How to generate tables and its columns schema yaml reading from snowflake information_schema.columns. I hope this helps. Thanks

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.