Posted On: Apr 20, 2023

Amazon Redshift announces support for MERGE command which enables you to apply source data changes unto Redshift warehouse tables with a simple SQL command. MERGE command allows you to combine a series of DML (Data Manipulation Language) statements into a single statement, .

When using multiple statements to update or insert data, there is a risk of inconsistencies between the different operations. Merge operation reduces this risk by ensuring that all operations are performed together in a single transaction. For Amazon Redshift customers who are migrating from other data warehouse systems or who regularly need to ingest fast changing data into their Redshift warehouse, MERGE SQL command is an easier way to conditionally insert, update, and delete from target tables based on existing and new source data.

MERGE SQL command is available in all commercial and AWS GovCloud (US) Regions where Amazon Redshift is available. To learn more, visit the Amazon Redshift database developer guide.