Automatically refresh of View Definition based on Updated Data Source Table


(Umesh) #1

Data Source Table is updated frequently and new columns get added. What is the best way to automatically refresh the model view definition.

Data Source: Snowflake
Day 1: Using the DB connection, when creating the project the model views are automatically generated
Day 2: New data loaded into snowflake causing additions/drops of columns in a Table A
Is there a way to automatically sync the model view definition with the Table A in snowflake?


(Izzy) #2

Our very own @Bryan_Weber wrote this up: Automating Frequently Changing Schemas with AWS Lambda

Sounds like it’d fit your case!

(Umesh) #3

Thanks a bunch.