MERGE Prerequisites

When processing CDC data, you can configure the destination to use the MERGE command to load data to Snowflake tables.

Using the MERGE command to load data requires a role with one of the following sets of access privileges:

• Required privileges when using an internal Snowflake stage:

  Object Type	Privilege
  Internal Snowflake stage	READ, WRITE
  Table	SELECT, INSERT, UPDATE, DELETE

• Required privileges when using an external stage:

  Object Type	Privilege
  External stage	USAGE
  Table	SELECT, INSERT, UPDATE, DELETE

If necessary, create a custom role in Snowflake and grant the role the required access privileges. Then, associate the role with the stage.

For more information, see Define a Role.