AWS Redshift ALTER TABLE APPEND

Many companies are using Redshift to manage their data-warehouse solution, and most of the time data pipelines have a requirement to load data first into a stage table and then from the stage table to load into the final table and here us the best way to do it with ALTER TABLE APPEND instead of INSERT INTO FINAL TABLE FROM STAGE TABLE. ALTER TABLE APPEND is usually much faster than a similar CREATE TABLE AS or INSERT INTO…

Here you go to learn more.

https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE_APPEND.html