Remix.run Logo
rawgabbit 4 days ago

In Snowflake, I am now writing Python Stored Procedures that make REST API calls to things like Datadog REST API and dumping the JSON into a Snowflake table. I then unpack the JSON and transform it into a normalized table. So far it works reasonably well. This is possible using Snowflake's external access feature. https://docs.snowflake.com/en/developer-guide/external-netwo...

hobs 3 days ago | parent [-]

Right, but isn't snowflake like the most expensive way to run python? why not just host the python outside of snowflake and store it there?

rawgabbit 3 days ago | parent [-]

It is to take advantage of snowpark.