Snowflake Iceberg Table API

The iceberg-table API from Snowflake — 14 operation(s) for iceberg-table.

Documentation GitHub OpenAPI

Operations 19

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}/iceberg-tables List Iceberg tables in a schema · List iceberg tables #

Ask an LLM

“Which Apache Iceberg tables can I see in this Snowflake schema?”

“Can I get extra detail on each Iceberg table when I list them?”

Tell an agent

List every Iceberg table I have access to in this schema.

Show the Iceberg tables in the schema with deep detail set to {deep}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables Create a Snowflake-managed Iceberg table · Create a snowflake managed iceberg table (clone and undrop are separate… #

Ask an LLM

“How do I define a new empty Iceberg table that uses Snowflake as its catalog?”

“Can I choose the external volume and base location when defining a managed Iceberg table?”

Tell an agent

Create a Snowflake-managed Iceberg table named {name} with columns {columns}.

Define managed Iceberg table {name} on external volume {external_volume} under base location {base_location}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:as-select Create a managed Iceberg table from a query · Create a snowflake managed iceberg table as select #

Ask an LLM

“Can I build a managed Iceberg table directly from the results of a SELECT query?”

“What does a CREATE ICEBERG TABLE AS SELECT need besides the query itself?”

Tell an agent

Create managed Iceberg table {name} populated from the query {query}.

Materialize {query} into a new managed Iceberg table {name} clustered by {cluster_by}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-aws-glue-catalog Register an Iceberg table from AWS Glue · Create an unmanaged iceberg table from AWS Glue catalog #

Ask an LLM

“How can Snowflake read an Iceberg table that is catalogued in AWS Glue?”

“Which Glue namespace and table name does Snowflake need to register a Glue-catalogued table?”

Tell an agent

Create an unmanaged Iceberg table {name} from Glue catalog table {catalog_table_name}.

Register Glue table {catalog_table_name} in namespace {catalog_namespace} as {name} with auto refresh on.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-delta Create an Iceberg table from Delta files · Create an unmanaged iceberg table from Delta #

Ask an LLM

“Can I expose existing Delta Lake files in Snowflake as an Iceberg table?”

“What base location do I point at when turning Delta files into an Iceberg table?”

Tell an agent

Create an unmanaged Iceberg table {name} from the Delta files at {base_location}.

Turn the Delta table stored under {base_location} on volume {external_volume} into Iceberg table {name}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-iceberg-files Create an Iceberg table from metadata files · Create an unmanaged iceberg table from Iceberg files #

Ask an LLM

“How can I load an Iceberg table into Snowflake from a metadata.json file in object storage?”

“Which metadata file path does Snowflake need to create a table from raw Iceberg files?”

Tell an agent

Create an unmanaged Iceberg table {name} from metadata file {metadata_file_path}.

Register the Iceberg files described by {metadata_file_path} on volume {external_volume} as table {name}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:from-iceberg-rest Register an Iceberg table from a REST catalog · Create an unmanaged iceberg table from Iceberg REST #

Ask an LLM

“Can Snowflake query a table that lives in an Iceberg REST catalog?”

“What catalog table name and namespace do I give to link an Iceberg REST catalog table?”

Tell an agent

Create an unmanaged Iceberg table {name} from REST catalog table {catalog_table_name}.

Link Iceberg REST table {catalog_table_name} in namespace {catalog_namespace} through catalog integration {catalog} as {name}.

GET /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name} Describe an Iceberg table · Describe iceberg table #

Ask an LLM

“What are the columns and settings of a specific Iceberg table?”

“Can I see which external volume and catalog a given Iceberg table uses?”

Tell an agent

Describe this Iceberg table and show its definition.

Show me the columns, catalog and external volume of the Iceberg table I named.

DELETE /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name} Drop an Iceberg table · Drop iceberg table #

Ask an LLM

“How do I delete an Iceberg table from a schema?”

“Is a dropped Iceberg table gone for good, or can it come back?”

Tell an agent destructive · confirm first

Drop the Iceberg table I named from this schema.

Drop the Iceberg table using drop type {type}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:resume-recluster Resume automatic reclustering on an Iceberg table · Resume recluster of an iceberg table #

Ask an LLM

“How do I turn automatic clustering back on for a Snowflake-managed Iceberg table?”

“Why can't I resume reclustering on an Iceberg table managed by an external catalog?”

Tell an agent

Resume reclustering on this Iceberg table.

Restart automatic clustering for the managed Iceberg table I just named.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:suspend-recluster Suspend automatic reclustering on an Iceberg table · Suspend recluster of an iceberg table #

Ask an LLM

“Can I pause automatic clustering on an Iceberg table to save credits?”

“Is it possible to stop reclustering on an Iceberg table temporarily?”

Tell an agent

Suspend reclustering on this Iceberg table.

Pause automatic clustering for the managed Iceberg table I named.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:refresh Refresh an externally catalogued Iceberg table · Refreshes the metadata for an Apache Iceberg table that uses an external… #

Ask an LLM

“How do I sync Snowflake with the latest metadata of an Iceberg table from an external catalog?”

“Can I refresh an external Iceberg table to a specific metadata file?”

Tell an agent

Refresh the metadata of this externally catalogued Iceberg table.

Refresh the Iceberg table to metadata file {metadata_file_relative_path}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:convert-to-managed Convert an external Iceberg table to Snowflake-managed · Converts an Apache Iceberg™ table that uses an external Iceberg catalog into a… #

Ask an LLM

“Can I move an Iceberg table off its external catalog so Snowflake manages it?”

“What storage serialization policy can I pick when converting an Iceberg table to managed?”

Tell an agent

Convert this unmanaged Iceberg table to use Snowflake as its catalog.

Convert the Iceberg table to managed with base location {base_location}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:undrop Restore a dropped Iceberg table · Undrop iceberg table #

Ask an LLM

“I dropped an Iceberg table by mistake; can I get it back?”

“Is there a way to undrop an Iceberg table in Snowflake?”

Tell an agent

Undrop the Iceberg table I deleted.

Restore the recently dropped Iceberg table to this schema.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:clone Clone a managed Iceberg table · Clone a snowflake managed iceberg table #

Ask an LLM

“Can I make a zero-copy clone of a managed Iceberg table?”

“Is it possible to clone an Iceberg table as it looked at an earlier point in time?”

Tell an agent

Clone this managed Iceberg table as {name}.

Clone the Iceberg table into {targetDatabase}.{targetSchema} as {name} at point in time {point_of_time}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:create-like Create an empty Iceberg table like another · Create iceberg table like #

Ask an LLM

“How can I copy an Iceberg table's column definitions without copying its data?”

“Can I create an empty Iceberg table with the same structure in another schema?”

Tell an agent

Create an empty Iceberg table {name} with the same columns as this one.

Create Iceberg table {name} like this one in schema {targetSchema} on volume {external_volume}.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:set-tags Set tags on an Iceberg table · Set tags on an Iceberg table #

Ask an LLM

“How do I attach governance tags to an Iceberg table?”

“Can I label an Iceberg table with a cost center tag?”

Tell an agent

Set tags on this Iceberg table.

Tag the Iceberg table I named with our data classification tag.

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:unset-tags Remove tags from an Iceberg table · Unset tags from an Iceberg table #

Ask an LLM

“How can I remove a tag that was applied to an Iceberg table?”

“Can I clear tag assignments from an Iceberg table?”

Tell an agent

Unset tags from this Iceberg table.

Remove the classification tag from the Iceberg table I named.

GET /api/v2/databases/{database}/schemas/{schema}/iceberg-tables/{name}:get-tags Get tag assignments for an Iceberg table · Get the tag assignments for an Iceberg table #

Ask an LLM

“Which tags are currently assigned to an Iceberg table?”

“Does looking up an Iceberg table's tags require a running warehouse?”

Tell an agent

Show all tags assigned to this Iceberg table.

List the tag assignments on the Iceberg table I named.

Snowflake Iceberg Table API

Operations 19

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