Menu
Can we directly copy a table from one redshift cluster to another redshift cluster?
I know table copying can be achieved using s3 as temp storage(i.e. unload to s3 from first cluster and then copy from s3 to another cluster).
586
You can duplicate or "clone" a Redshift table's contents by executing a CREATE TABLE ... AS SELECT statement: CREATE TABLE new_table AS SELECT * FROM original_table; Please be careful when using this to clone big tables.
A COPY command is the most efficient way to load a table. You can also add data to your tables using INSERT commands, though it is much less efficient than using COPY. The COPY command is able to read from multiple data files or multiple data streams simultaneously.
Depending on your reason for wanting to copy the table, the best solution may now be to use Redshift data sharing: https://docs.aws.amazon.com/redshift/latest/dg/datashare-overview.html
Assuming the prerequisites are met, this will allow you to make a table available to read in another Redshift cluster.
163
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
