Is there a way to reset a table state ? suppose i ...
# troubleshooting
a
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