DEMO
Integrate OpenAI’s LLM using External Functions in Snowflake
Generative AI has the potential to solve an enormous amount of use cases, and combining it with Snowflake can unlock a new world of solutions. In this demo, you’ll integrate OpenAI with Snowflake, and use it to generate SQL queries to analyze data and classify sentiment on any given string. You’ll use Snowflake’s external functions feature, and build an API integration within Snowflake that uses AWS API Gateway. Here’s a brief look at some of the things you’ll do:
- Use AWS API Gateway as a proxy for communication between Snowflake and OpenAI
- Configure a trust relationship between AWS and Snowflake
- Write an external function that calls the OpenAI API
- Wrap the OpenAI API in a AWS Lambda function for use in Snowflake