▲ 6 r/snowflake
CREATE OR ALTER AND INSERT OVERWRITE as a solution for keeping time travel data for tables with frequent schema changes
Hi,
So we had some workflows running with create or replace on tables. The tables schema change from time to time so everytime new data arrives i will just create or replace the tables also it's small data. Nevertheless it's a production workflow. To keep my code/sql as simple as possible and to improve the workflow so people can historic versions of the tables i changed this workflow to:
CREATE OR ALTER TABLE
INSERT AND OVERWRITE
What do you think anything against this solution? Just asking because this CREATE OR ALTER seems more of a use-case for initial bootstrapping of tables as i can see in snowflake doc.
u/BudgetSea4488 — 4 days ago