This is an example of what is needed for a Snowflake target:
Replicate requires an external independent S3 bucket in the same region as Snowflake.
Snowflake 64bit ODBC driver
Insufficient privileges to operate on schema 'PUBLIC':
In Replicate – Snowflake stages are created in the “PUBLIC” schema. Many organizations have turned that off.
There is a hidden parameter in the endpoint called metadataschema that can be set to the target schema. This will make Replicate create any temporary objects to be used in that scheme