COPY Prerequisites

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

Using the COPY 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

• Required privileges when using an external stage:

  Object Type	Privilege
  External stage	USAGE
  Table	SELECT, INSERT

If necessary, create a custom role in Snowflake and grant the role the required access privileges. Then in Snowflake, assign the custom role as the default role for the Snowflake user account specified in the destination. Or in the destination, specify the custom role that overrides the user's default role.

For more information about defining a role for the destination, see Define a Role.