Create a new table

Create a new table

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

• How do I create a new table with defined columns in a schema?
• Can I set clustering keys and data retention when I first create a table?
• What happens if I want change tracking turned on from the start of a new table?

Say it to your AI assistant

• Create a new table named {name} with columns {columns}.
• Create table {name} clustered by {cluster_by} and keep {data_retention_time_in_days} days of Time Travel.
• Create table {name} in database {database}, schema {schema}, with columns {columns}.

For your developer

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