Create an empty copy of a table (legacy)
One step with Snowflake. We can help you get access.
Get something done
Create an empty copy of a table (legacy)
with Snowflake
Use Snowflake: its Snowflake Table API lets you create an empty copy of a table (legacy) in a single step (POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create_like). capabilities.work can help you get signed up and connected.
- Is there a legacy create_like endpoint that takes the new table name as a query parameter?
- What does the older underscore create-like call require?
Say it to your AI assistant
- Use the legacy create_like endpoint to make an empty table {newTableName} shaped like this one.
- Call the deprecated create-like operation to produce {newTableName} with no rows.
- With the legacy create_like route, make empty table {newTableName} shaped like {table} in {database}.{schema}.
For your developer
POST /api/v2/databases/{database}/schemas/{schema}/tables/{name}:create_like in Snowflake Table API. Full spec on APIs.io.