I have created a model that will create views by passing the var Table_name. As I am using snowflake so getting column details from information_schema.columns tables and creating views for that table dynamically at run time. The idea is to automate the process of creating views for tables.
Now I want the name of newly created view to be ‘Tablename_V’ instead of .sql file name and Tablename can change at run time based on given parameter wile running the model.
e.g
dbt run -m Dynamic_views --vars ‘table_name : Customer’
I have already tried using {{ config( alias = “_V”, ) }}, but its also kind of hard coded value only, i want something that will change at run time.
Can someone help me with this…