The recreate
command will create a brand new version of table on your destination, then move the existing data over to the new table.
This is useful if you change the indexes or distribution keys of a table.
It takes the following steps, so that the original table is affected for as little amount of time as needed:
-
Creates a new table named zz_dataduck_recreating_(tablename)
-
Moves the table data from the original table to the new table.
-
Renames the original table to zz_dataduck_recreating_old_(tablename)
-
Renames the zz_dataduck_recreating_(tablename) to tablename.
-
Drops zz_dataduck_recreating_old_(tablename)
To recreate a table, use the command:
$ dataduck recreate my_table_name