Create a table from a SELECT query result

Create a table from a SELECT query result

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

• Can I turn the output of a SELECT statement into a brand-new table?
• How do I materialize query results as a table and pick its clustering keys?

Say it to your AI assistant

• Create a table called {name} populated from the query {query}.
• Materialize the results of {query} into a new table {name}, clustered by {cluster_by}.
• In {database}.{schema}, create table {name} from the rows returned by {query}.

For your developer

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