Automatically refresh of View Definition based on Updated Data Source Table

done
low_priority
reply

(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?

Thanks,
Umesh


(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.