External network access lets Snowflake data engineers make controlled outbound connections to locations outside Snowflake, enabling stored procedures and user-defined functions to retrieve external data for analysis. section 7.0
Configure the access path around three cooperating objects and the permissions required to use them:
- Define a network rule for the external network location. section 7.5
- Store the API token, key, or password in a secret. section 7.5
- Include the network rule and secret in an external access integration, then pass that integration to a Python function or stored procedure. section 7.5
- Grant the data engineer USAGE on the integration and READ on the secret; administrators can monitor and limit external locations. section 7.5
Augmenting Snowflake data with customer reviews
A bakery can call a food-delivery website’s API from Snowpark, retrieve customer reviews, and store them in Snowflake tables. The pipeline can parse and flatten JSON responses, remove unprintable characters when necessary, and classify review sentiment with a Snowflake Cortex LLM function. section 7.0 section 7.5
