Once in a while, you may have a need to resync your tables. The following are the steps to take:
- Reset your FlyData Sync on the tables you specify by running the following command. If you’d like to resync your entire database, simply run
flydata sync:resetwithout specifying any table name.
$ flydata sync:reset your_table01 your_table02
Create a support Ticket.
Specify what table(s) will need to be reset, and we will validate that data is clear on all of our servers. You can create a support ticket by simply emailing email@example.com.
- Generate the SQL necessary to flush the tables you were going to reset, by running the following command:
$ flydata sync:generate_table_ddl your_table01 your_table02 > create_table.sql
- Run the resulting
create_table.sqlfile on your Redshift cluster.
- Start an initial sync on the tables that were reset by running the command below. After that, it will continue to sync all registered tables.
$ flydata sync your_table01 your_table02