RESTORE SNAPSHOT into new table name


#1

I’m moving a table from an old cluster to a new one.

In the new cluster, I have already created a new version of the table with updated fields indexes etc.

I would like to restore a backed up version of the table into something like “tablename_bak”, then copy the relevant fields over to the new table.

Is it possible to specify the table name you want to restore the table into, or can it only be restored into the original table name, and restore would fail if a table of that name already exists.

Would it be possible to do something like this:

RESTORE SNAPSHOT s3_crate_snaps."snapshot1" TABLE schemaname.tablename AS tablename_bak WITH (wait_for_completion=true);