Snowflake Function API

The function API from Snowflake — 3 operation(s) for function.

Documentation GitHub OpenAPI

Operations 8

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /api/v2/databases/{database}/schemas/{schema}/functions List user functions in a schema · List Functions #

Ask an LLM

“Which user-defined functions exist in this schema?”

“Can I see all the functions defined under a database and schema?”

Tell an agent

List the user functions in schema {schema} of database {database}.

Show me every function defined in the schema I named.

POST /api/v2/databases/{database}/schemas/{schema}/functions Create a function · Create a Function #

Ask an LLM

“How do I define a new function in a Snowflake schema?”

“Can I set the language, return type and body when creating a function?”

Tell an agent

Create function {name} in {database}.{schema} that takes arguments {arguments}.

Create {language} function {name} with arguments {arguments} returning {returns} and body {body}.

GET /api/v2/databases/{database}/schemas/{schema}/functions/{nameWithArgs} Describe a function · Fetch a Function #

Ask an LLM

“What signature and return type does a specific function have?”

“Can I see the describe output for one function by its name and arguments?”

Tell an agent

Describe function {function} (name with argument types) in {database}.{schema}.

Show the definition of this function.

DELETE /api/v2/databases/{database}/schemas/{schema}/functions/{nameWithArgs} Delete a function · Delete a function #

Ask an LLM

“How do I drop a function with a specific argument signature?”

“Do I need the argument types to delete an overloaded function?”

Tell an agent destructive · confirm first

Delete function {function} (name with argument types) from {database}.{schema}.

Drop this function from the schema.

POST /api/v2/databases/{database}/schemas/{schema}/functions/{name}:execute Execute a function · Execute a Function #

Ask an LLM

“Can I call a Snowflake function over REST and get its result?”

“What does running a function through the API return?”

Tell an agent

Execute function {function} in {database}.{schema} with these argument values.

Run this function and return its result.

POST /api/v2/databases/{database}/schemas/{schema}/functions/{nameWithArgs}:set-tags Set tags on a function · Set tags on a function #

Ask an LLM

“How do I attach tags to a function?”

“Can I label a function with a data domain tag?”

Tell an agent

Set tags on function {function} in {database}.{schema}.

Tag the function I named with our data domain.

POST /api/v2/databases/{database}/schemas/{schema}/functions/{nameWithArgs}:unset-tags Remove tags from a function · Unset tags from a function #

Ask an LLM

“How can I remove a tag from a function?”

“Can I clear tag assignments on a function?”

Tell an agent

Unset tags from function {function} in {database}.{schema}.

Remove the data domain tag from the function I named.

GET /api/v2/databases/{database}/schemas/{schema}/functions/{nameWithArgs}:get-tags Get tag assignments for a function · Get the tag assignments for a function #

Ask an LLM

“Which tags are assigned to a function?”

“Does reading a function's tags require an active warehouse?”

Tell an agent

Show all tags assigned to function {function} in {database}.{schema}.

List the tag assignments on the function I named.

Snowflake Function API

Operations 8

Documentation

Specifications

Schemas & Data

Other Resources

Work with this as data

MCP server

Tools for apis

Call it yourself

Get an API key

OpenAPI Specification