2

How to enable change tracking = true on all tables in a schema in snowflake data warehouse.

Sri
  • 75
  • 6

1 Answers1

1

By running "ALTER TABLE … CHANGE_TRACKING = TRUE" for each table

NickW
  • 8,430
  • 2
  • 6
  • 19
  • can we write a stored procedure to alter all tables in a database? – Sri Nov 12 '21 at 17:50
  • Yes, just read the information schema for the tables you want, dynamically create the statements and run them – NickW Nov 12 '21 at 18:52