Create a table from a query (legacy endpoint)
One step with Snowflake. We can help you get access.
Get something done
Create a table from a query (legacy endpoint)
with Snowflake
Use Snowflake: its Snowflake Table API lets you create a table from a query (legacy endpoint) in a single step (POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:as_select). capabilities.work can help you get signed up and connected.
- Is there an older as_select endpoint that names the new table in the URL path?
- What does the legacy underscore-style create-table-as-select call need from me?
Say it to your AI assistant
- Using the legacy as_select endpoint, create table {name} from the results of {query}.
- Run the deprecated table-as-select call to materialize {query} into {name}.
- Through the legacy as_select route on table path {table} in {database}.{schema}, save {query} as table {name}.
For your developer
POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:as_select in Snowflake Table API. Full spec on APIs.io.