Connect Snowflake to OpenAI (ChatGPT)

Build an AI agent that works across Snowflake and OpenAI (ChatGPT), on a schedule or when you click Run.

7 source actions

24 target actions

Reverse direction supported

Start building Have us set it up (A$490)Browse Snowflake integrations

Why Connect Snowflake & OpenAI (ChatGPT)?

Read what you need from Snowflake

Your agent uses Snowflake's documented actions to pull the records it needs, each time it runs.

Run a OpenAI (ChatGPT) action

Then it uses one of 24 documented actions, such as Chat, Chat using Web Search, Chat using Functions.

Test it, then put it on a schedule

Run it once on your own data and check the result. Then set it to run daily, on weekdays or weekly.

Available Triggers & Actions

Snowflake

Triggers (12)

New Row

Emit new event when a row is added to a table

polling

New Query Results

Run a SQL query on a schedule, triggering a workflow for each row of results

polling

Failed Task in Schema

Emit new events when a task fails in a database schema

polling

New Database

Emit new event when a database is created

polling

New Deleted Role

Emit new event when a role is deleted

polling

New Deleted User

Emit new event when a user is deleted

polling

New Role

Emit new event when a role is created

polling

New Schema

Emit new event when a schema is created

polling

New Table

Emit new event when a table is created

polling

New Update Role

Emit new event when a role is updated

polling

New Update User

Emit new event when a user is updated

polling

New Usage Monitor

Emit new event when a query is executed in the specified params

polling

Actions (7)

Execute SQL Query

Execute a custom Snowflake query. See our docs to learn more about working with SQL in Mazaal AI.

Insert Multiple Rows

Insert multiple rows into a table

Insert Single Row

Insert a row into a table

List Database Options

Retrieves available options for the Database field.

List User Name Options

Retrieves available options for the User Name field.

List Warehouse Name Options

Retrieves available options for the Warehouse Name field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

OpenAI (ChatGPT)

Triggers (4)

New Batch Completed

Emit new event when a new batch is completed in OpenAI. See the documentation

polling

New File Created

Emit new event when a new file is created in OpenAI. See the documentation

polling

New Fine Tuning Job Created

Emit new event when a new fine-tuning job is created in OpenAI. See the documentation

polling

New Run State Changed

Emit new event every time a run changes its status. See the documentation

polling

Actions (24)

Chat

The Chat API, using the gpt-3.5-turbo or gpt-4 model. See the documentation

Chat using Web Search

Chat using the web search tool. See the documentation

Chat using Functions

Chat with your models and allow them to invoke functions. Optionally, you can build and invoke workflows as functions. See the documentation

Chat using File Search

Chat with your files knowledge base (vector stores). See the documentation

Summarize Text

Summarizes text using the Chat API. See the documentation

Classify Items into Categories

Classify items into specific categories using the Chat API. See the documentation

Translate Text (Whisper)

Translate text from one language to another using the Chat API. See the documentation

Create Transcription

Transcribes audio into the input language. See the documentation

Create Image (Dall-E)

Creates an image given a prompt returning a URL to the image. See the documentation

Create Embeddings

Get a vector representation of a given input that can be easily consumed by machine learning models and algorithms. See the documentation

Create Completion (Send Prompt)

OpenAI recommends using the **Chat** action for the latest gpt-3.5-turbo API, since it's faster and 10x cheaper. This action creates a completion for the provided prompt and parameters using the older /completions API. See the documentation

Analyze Image Content

Send a message or question about an image and receive a response. See the documentation

Cancel Run (Assistants)

Cancels a run that is in progress. See the documentation

Chat with Assistant

Sends a message and generates a response, storing the message history for a continuous conversation. See the documentation

Chat With Responses API

Send a chat via the Responses API, mixing built-in tools and MCP server tools. See the documentation.

Convert Text to Speech (TTS)

Generates audio from the input text. See the documentation

Create Assistant

Creates an assistant with a model and instructions. See the documentation

Create Batch

Creates and executes a batch from an uploaded file of requests. See the documentation

Create Fine Tuning Job

Creates a job that fine-tunes a specified model from a given dataset. See the documentation

Create Moderation

Classifies if text is potentially harmful. See the documentation

Create Thread (Assistants)

Creates a thread with optional messages and metadata, and optionally runs the thread using the specified assistant. See the documentation

Create Vector Store

Create a vector store. See the documentation

Create Vector Store File

Create a vector store file. See the documentation

Delete File

Deletes a specified file from OpenAI. See the documentation

Integration Features

7 documented Snowflake actions

24 documented OpenAI (ChatGPT) actions

Plain-English agent instructions

Daily, weekday or weekly schedule, or run on demand

Execution monitoring

A supported OpenAI (ChatGPT) to Snowflake direction

Capability Examples

Snowflake trigger → OpenAI (ChatGPT) action

Catalog example

Snowflake

New Row

OpenAI (ChatGPT)

Chat

OpenAI (ChatGPT) trigger → Snowflake action

Reverse direction

OpenAI (ChatGPT)

New Batch Completed

Snowflake

Execute SQL Query

How It Works

Connect Apps

Authenticate your Snowflake and OpenAI (ChatGPT) accounts

Describe the Job

Say what to read from Snowflake and what to do in OpenAI (ChatGPT)

Choose an Action

Select the documented OpenAI (ChatGPT) operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Scheduled or On-demand Runs

Runs daily, on weekdays or weekly at a set time, or when you click Run. It does not fire on live Snowflake events yet.

Automated Actions

Use 24 documented OpenAI (ChatGPT) actions each time the agent runs.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Describe the job in plain English. The agent picks theSnowflake and OpenAI (ChatGPT) actions it needs.

Your Own Accounts

You connect your own Snowflake and OpenAI (ChatGPT) accounts. App connections need a paid plan.

Execution Review

Test the workflow and review provider responses before relying on it in production.

Reverse Integration Available

Also connect OpenAI (ChatGPT) to Snowflake for bidirectional automation

View Integration

All Snowflake Integrations

Explore all available Snowflake connections

View All Integrations

All OpenAI (ChatGPT) Integrations

Explore all available OpenAI (ChatGPT) connections

View All Integrations

Popular Integrations

View all integrations →

More OpenAI (ChatGPT) Integrations

View all OpenAI (ChatGPT) integrations →

Ready to Connect Snowflake & OpenAI (ChatGPT)?

Build this agent in Mazaal AI and test it on your ownSnowflake and OpenAI (ChatGPT) data.

Start building

Rather not build it yourself? We set up one Snowflake to OpenAI (ChatGPT) agent on your accounts for A$490: a 30-minute call, a test on your real data, and 14 days of fixes. Plan billed separately. Email Enod

Connect Snowflake to OpenAI (ChatGPT)

Why Connect Snowflake & OpenAI (ChatGPT)?

Read what you need from Snowflake

Run a OpenAI (ChatGPT) action

Test it, then put it on a schedule

Available Triggers & Actions

Snowflake

Triggers (12)

Actions (7)

OpenAI (ChatGPT)

Triggers (4)

Actions (24)

Integration Features

Capability Examples

Snowflake trigger → OpenAI (ChatGPT) action

OpenAI (ChatGPT) trigger → Snowflake action

How It Works

Connect Apps

Describe the Job

Choose an Action

Test and Review

Frequently Asked Questions

Is the Snowflake to OpenAI (ChatGPT) direction supported?

Does it run the moment something changes in Snowflake?

Which OpenAI (ChatGPT) actions are available?

Can I also connect OpenAI (ChatGPT) to Snowflake?

Integration Benefits

Scheduled or On-demand Runs

Automated Actions

Provider Authentication

Guided Configuration

Your Own Accounts

Execution Review

Reverse Integration Available

All Snowflake Integrations

All OpenAI (ChatGPT) Integrations

Popular Integrations

More OpenAI (ChatGPT) Integrations

Ready to Connect Snowflake & OpenAI (ChatGPT)?