Creating a Snowflake source node
Permissions needed
Amazon Glue Studio jobs using Snowflake data sources require additional permissions. For more information on how to add permissions to ETL jobs, see Review IAM permissions needed for ETL jobs.
SNOWFLAKE
Amazon Glue connections use an Amazon Secrets Manager secret to provide credential information.
Your job and data preview roles in Amazon Glue Studio must have permission to read this secret.
Adding a Snowflake data source
Prerequisites:
An Amazon Secrets Manager secret for your Snowflake credentials
A Snowflake type Amazon Glue Data Catalog connection
To add a Data Source – Snowflake node:
-
Choose the connection for your Snowflake data source. This assumes that the connection already exists and you can select from existing connections. If you need to create a connection, choose Create Snowflake connection. For more information, see Overview of using connectors and connections .
Once you have chosen a connection, you can view the connection properties by clicking View properties. Information about the connection are visible, including URL, security groups, subnet, availability zone, description, and created (UTC) and last updated (UTC) timestamps.
-
Choose a Snowflake source option:
-
Choose a single table – this is the table that contains the data you want to access from a single Snowflake table.
-
Enter custom query – allows you to access a dataset from multiple Snowflake tables based on your custom query.
-
-
If you chose a single table, enter the name of a Snowflake schema.
Or, choose Enter custom query. Choose this option to access a custom dataset from multiple Snowflake tables. When you choose this option, enter the Snowflake query.
-
In Performance and security options (optional),
-
Enable query pushdown – choose if you want to offload work to the Snowflake instance.
-
-
In Custom Snowflake properties (optional), enter parameters and values as needed.