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, associate the role with the stage.

For more information, see Define a Role.