Copy to new table

Copy existing table to a new table

Situation: Useful to create ‘tests’ tables while testing a new data pipeline. You can preserve the original in case you need to Write to or Update a table.

CREATE TABLE new_table AS
TABLE original_table

For more content on data science, R, and Python find me on Twitter.