A company’s employees table was replaced with a new version:
How can the original table be recovered with the least operational overhead?
CREATE OR REPLACE TABLE drops the prior table and creates a replacement with the same name, while retaining the dropped table in Time Travel. UNDROP TABLE returns an error if a table of that name already exists, so the replacement must first be renamed before the original employees table can be restored.
CREATE OR REPLACE TABLE
UNDROP TABLE
employees
Community Discussion