'How to connect to API and load the data directly in Snowflake table?

I was wondering if Snowflake can directly connect to API and load the data into Snowflake Schema tables ? If yes, can you please guide me the process ? I am new to Snowflake please provide example along with explanation.

Thanks in advance for your time and efforts!



Solution 1:[1]

Here is an example of Snowflake external functions calling an API and loading the returned data set How Snowflake’s IT team uses external functions.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Dave Welden