Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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.

Published:

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.

For an optimal Community experience, Please view on Desktop