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