This section describes how to integrate the  with Snowflake databases.

Limitations

NOTE: This integration is supported only for deployments of in customer-managed AWS infrastructures. These deployments must use S3 as the base storage layer. For more information, see Supported Deployment Scenarios for AWS.

Pre-requisites

General

AWS permissions

Your Snowflake stage and other databases must be permitted to use S3 resources for your users. 

NOTE: If users in your deployment are using IAM roles in user mode for AWS access, then the Snowflake stage must have permissions to write to the user's S3 bucket.

For more information, see Required AWS Account Permissions.

OAuth2 requirements

If you are integrating with Snowflake using OAuth2, additional configuration is required:

Enable

When relational connections are enabled, this connection type is automatically available. For more information, see Enable Relational Connections.

Create Stage

In Snowflake terminology, a stage is a database object that points to an external location on S3. This stage must contain access credentials.

For more information on stages, see https://docs.snowflake.net/manuals/sql-reference/sql/create-stage.html.

In , the stage location is specified as part of creating the Snowflake connection.

Create Snowflake Connection

For more information, see Create Snowflake Connections.

Testing

Steps:

  1. After you create your connection, load a small dataset based on a table in the connected Snowflake database.

    NOTE: For Snowflake connections, you must have write access to the database from which you are importing.


    See Import Data Page

  2. Perform a few simple transformations to the data. Run the job. See Transformer Page.
  3. Verify the results.

For more information, see Verify Operations.