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
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to generate tables and its columns schema yaml reading from snowflake information_schema.columns | 0 | 7171 | March 6, 2023 | |
| Column macro created description for Snowflake using DBT | 0 | 281 | August 20, 2024 | |
| Is there a way to use persist_docs and inherited column descriptions to show field descriptions in Snowflake? | 1 | 582 | April 16, 2025 | |
| DBT removing column comments on views as a part of each dbt run | 0 | 749 | April 1, 2024 | |
| Column comments in sql model | 0 | 1279 | February 13, 2024 |