Create a managed Iceberg table from a query

Create a managed Iceberg table from a query

Use Snowflake: its Snowflake Iceberg Table API lets you create a managed Iceberg table from a query in a single step (POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:as-select). capabilities.work can help you get signed up and connected.

• 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?

Say it to your AI assistant

• Create managed Iceberg table {name} populated from the query {query}.
• Materialize {query} into a new managed Iceberg table {name} clustered by {cluster_by}.
• In database {database}, schema {schema}, build managed Iceberg table {name} from the results of {query}.

For your developer

POST /api/v2/databases/{database}/schemas/{schema}/iceberg-tables:as-select in Snowflake Iceberg Table API. Full spec on APIs.io.