The recreate
command
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
This page was autogenerated from recreate.md in the DataDuck project. Improvements? Let us know or open a pull request.