07-30-2021 12:14 PM
How does the Redshift Bulk Upsert work underneath the covers? For example, I know that the Redshift Bulk Load snap writes the data to S3 and then executes a Redshift COPY command to load the data from S3 to the Redshift table. How does the Redshift Bulk Upsert work?
07-30-2021 01:38 PM
The snap bulk loads the data into a temporary table, and then does the update and insert operations, followed by the removal of the intermediate staging table.
07-30-2021 01:49 PM
Thanks @cstewart - so the Redshift user must also have create table permission.