Creating a Snowflake connection - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a Snowflake connection

When adding a Data source - Snowflake node in Amazon Glue Studio, you can choose an existing Amazon Glue Snowflake connection or create a new connection. You must choose a SNOWFLAKE type connection and not a JDBC type connection configured to connect to Snowflake. Follow the following procedure to create a Amazon Glue Snowflake connection:

To create a Snowflake connection

  1. In Snowflake, generate a user, snowflakeUser and password, snowflakePassword.

  2. Determine which Snowflake warehouse this user will interact with, snowflakeWarehouse. Either set it as the DEFAULT_WAREHOUSE for snowflakeUser in Snowflake or remember it for the next step.

  3. In Amazon Secrets Manager, create a secret using your Snowflake credentials. To create a secret in Secrets Manager, follow the tutorial available in Create an Amazon Secrets Manager secret in the Amazon Secrets Manager documentation. After creating the secret, keep the Secret name, secretName for the next step.

    • When selecting Key/value pairs, create a pair for snowflakeUser with the key sfUser.

    • When selecting Key/value pairs, create a pair for snowflakePassword with the key sfPassword.

    • When selecting Key/value pairs, create a pair for snowflakeWarehouse with the key sfWarehouse. This is not needed if a default is set in Snowflake.

  4. In the Amazon Glue Data Catalog, create a connection by following the steps in Adding an Amazon Glue connection. After creating the connection, keep the connection name, connectionName, for the next step.

    • When selecting a Connection type, select Snowflake.

    • When selecting Snowflake URL, provide the hostname of your Snowflake instance. The URL will use a hostname in the form account_identifier.snowflakecomputing.com.

    • When selecting an Amazon Secret, provide secretName.