Is there a way to reset a table state ?
suppose i am loading a table from mysql to redshift using log_based. A ned column "col_1" gets added to mysql table with historical data . but if i am doing log_based load it will just add the column and populate the data in column for new rows and will ignore old rows.
If i do a full load and then log_based then the table will not be in sync. How to get this done ?
Note: I dont have a primary key in the table