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 | |
---|---|---|---|---|
Column comments in sql model | 0 | 837 | February 13, 2024 | |
DBT removing column comments on views as a part of each dbt run | 0 | 544 | April 1, 2024 | |
How to generate tables and its columns schema yaml reading from snowflake information_schema.columns | 0 | 5662 | March 6, 2023 | |
How to extract table comments in the db and populate schema description with it? | 2 | 962 | February 8, 2024 | |
Column Descriptions and Constraints in Snowflake via DBT | 0 | 40 | October 7, 2024 |