This section describes how to create a connection to your Snowflake datawarehouse. 


  1. S3 base storage layer: Snowflake access requires installation of in the AWS infrastructure and use of S3 as the base storage layer, which must be enabled. See Set Base Storage Layer. 
  2. Same region:  The Snowflake cluster must be in the same region as the default S3 bucket.
  3. Integration: Your    is connected to an EMR cluster.

    NOTE: EMRFS Consistency View must be enabled.

    See Configure for EMR.

  4. Deployment:  is deployed in EC2.



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


To create a Snowflake connection, you must enable the following feature. The job manifest feature enables the creation of a manifest file to track the set of temporary files written to S3 before publication to Snowflake.

NOTE: To guarantee consistency you can enable consistent view on the EMR cluster. This step must be done when the cluster is created. See Configure for EMR.


  1. Locate the following parameter and set it to true:

    "feature.enableJobOutputManifest": true,

  2. Save your changes and restart the platform.

Create Connection

You can create Snowflake connections through the following methods.

Create through application

Any user can create a Snowflake connection through the application.


  1. Login to the application.
  2. In the menu, click Settings menu > Connections.
  3. In the Create Connection page, click the Snowflake connection card.
  4. Specify the properties for your Snowflake database connection. The following parameters are specific to Snowflake connections:

    NOTE: In Snowflake connections, property values are case-sensitive. Snowflake-related locations are typically specified in capital letters.

Account Name
Snowflake account to use. Suppose your hostname is the following:

Your account name is the following:


WarehouseThe name of the warehouse to which to connect

If you have deployed a Snowflake stage for managing file conversion to tables, you can enter its name here. A stage is a database object that points to an external location on S3. It must be an external stage containing access credentials.

If a stage is used, then this value is typically the schema and name of the stage. Example value:


If a stage is not specified, a temporary stage is created using the current user's AWS credentials.

NOTE: Without a defined stage, you must have write permissions to the database from which you import. This database is used to create the temporary stage.

For more information on stages, see

For more information, see Create Connection Window.

Disable SSL connections

By default, connections to Snowflake use SSL. To disable, please add the following string to your Connect String Options:


Save your changes.

Connect through proxy

If you require connection to Snowflake through a proxy server, additional Connect String Options are required. For more information, see

Create via API

For more information, see API Connections Create v4.


Import a dataset from Snowflake. Add it to a flow, and specify a publishing action back to Snowflake. Run a job.For more information, see Verify Operations.