This section describes how to create a connection to your Snowflake datawarehouse.
Integration: Your is connected to an EMR cluster.
NOTE: EMRFS Consistency View must be enabled.
See Configure for EMR.
Deployment: is deployed in EC2.
PUBLICschema is required in your default database.
PUBLICschema in the default database.
You can create Snowflake connections through the following methods.
Any user can create a Snowflake connection through the application.
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.
Snowflake account to use. Suppose your hostname is the following:
Your account name is the following:
|Warehouse||The 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 the name of the stage. Example value:
If a stage is not specified, a temporary stage is created using the current user's AWS credentials.
For more information on stages, see https://docs.snowflake.net/manuals/sql-reference/sql/create-stage.html.
For more information, see Create Connection Window.
By default, connections to Snowflake use SSL. To disable, please add the following string to your Connect String Options:
Save your changes.
If you require connection to Snowflake through a proxy server, additional Connect String Options are required. For more information, see https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html#specifying-a-proxy-server-in-the-jdbc-connection-string.
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.