External Network Access For Snowpark
Why Stack Overflow recommends it
Stack Overflow users link it when answering how to call a REST API or other outside service from Snowflake or Snowpark, since it shows the external access setup end to end.
Recommended by 1 people across 1 different months, 2023 to 2023.
What it is
A short demo by Jeff Hollan, Director of Product at Snowflake, of the new external network access feature for Snowpark. He shows a Python function calling the OpenAI API from inside Snowflake to pull structured JSON out of unstructured text.
What people said
Recommends pawelofficial · 2023-12 · Stack Overflow · on “How to call Rest API directly in Snowflake?”
this walkthrough [this video] from snowflake explains that process note that this won't work on trial accounts since one cannot create external access integrations objects, but currently the process is to create network policy [LINK] create external access integration [LINK] create (python) udf that does requests update: here is the code to copy paste and here [LINK] is the code i copy pasted from -- make network rule CREATE OR REPLACE NETWORK RULE ifconfignr MODE = EGRESS TYPE = HOST_PORT -- indicates that the network rule will allow outgoing network traffic based on the domain of the request destination. VALUE_LIST = (' [LINK] '); -- make access integration , doesnt work on trial ccounts: CREAT
Cites Maciej M · 2023-07 · Stack Overflow · on “How to make API calls to openAI service from snowpark worksheet?”
Today in general you do not have an external network access in Snowflake. Currently you may think only of external functions [LINK] . In the future such call will be possible - External Network Access For Snowpark [this video] .
Cites Bhanu Prakash · 2023-08 · Stack Overflow · on “Snowflake get error using NLTK package by using Snowpark framework”
You can request for 'external access' that will allow you to reach the internet securely for specific network locations. You can request access through your account rep, while this is in private preview. See here [this video]