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.