Please subscribe to the product from AWS Marketplace and Activate the Glue connector from AWS Glue Studio .

Pre-requisite

• An account in Snowflake
• Snowflake
• AWS Secrets Manager secret (you can create the secret in following steps)

Create a new secret for Snowflake in AWS Secrets Manager

We create a secret in AWS Secrets Manager to store the Snowflake account credentials.

1. On the Secrets Manager console, choose Store a new secret.
2. For Secret type, select Other type of secret.
3. Enter your key as sfUrl and the value as your Snowflake hostname in the format <account_identifier>.snowflakecomputing.com.
4. Enter your key as sfUser and the value as your Snowflake user name.
5. Enter your key as sfPassword and the value as your Snowflake user password.
6. Leave the rest of the options at their default.
7. Choose Next.
8. Give a name to the secret snowflake_credentials.
9. Follow through the rest of the steps to store the secret.

Connection options

You can pass the following options to the connector.

• sfWarehouse(optional): The Snowflake virtual warehouse.
• sfDatabase(required): The Snowflake database.
• sfSchema(required): The Snowflake schema.
• query(optional, but you need to set this or dbtable): The name of the table to be read.
• dbtable(optional, but you need to set this or query): The exact query (SELECT statement) to run.

You can see other available options here: https://docs.snowflake.com/en/user-guide/spark-connector-use.html