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.
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.
|Database for Stage|
(optional) If you are using a Snowflake stage, you can specify a database other than the default one to host the stage.
If no value is specified, then your stage must be in the default database.
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.