Snowflake Prerequisites
Snowflake Prerequisites
Following are the prerequisites for Snowflake integration:
Database and schema
Users should set up a Snowflake database to use Snowflake as a destination.
You can use one Snowflake schema for all source application data transfers.
There are two possible owner scenarios depending on the Snowflake role you select while building the schema:
A schema owned by the Public role: This schema is accessible for all Snowflake users in your account, and can be used as-is to create data transfers using the replication package.
A schema owned by a non-public role (either another system-defined role or a custom role): If a user creates a non-public schema on your behalf with another role, they need to grant your role the schema privileges: Create Object, Monitor, Modify, and Usage.
IP allowlisting
If your account only allows access from selected networks, IP allowlisting is needed. See Snowflake documentation for more information about managing network policies.
Authentication with Snowflake
The basic authentication method, which is password-based authentication, is supported when establishing the connection.