How to Re-Sync Tables - FlyData Agent v0.2
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:reset
without 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 support@flydata.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.sql
file 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