Skip to main content
DELETE
DELETE /v1/tables/{id}

Delete a Table

Delete a table by ID or fully qualified name. Supports soft delete (default), hard delete, and restore operations.

Delete by ID

id
string
required
UUID of the table to delete.
recursive
boolean
default:"false"
Recursively delete child entities.
hardDelete
boolean
default:"false"
Permanently delete the table. If false, the table is soft-deleted and can be restored.

Delete by Name

Use DELETE /v1/tables/name/{fqn} to delete by fully qualified name.
fqn
string
required
Fully qualified name of the table (e.g., snowflake_prod.analytics.public.customers).
recursive
boolean
default:"false"
Recursively delete child entities.
hardDelete
boolean
default:"false"
Permanently delete the table.

Restore a Soft-Deleted Table

Use PUT /v1/tables/restore to restore a soft-deleted table.
id
string
required
UUID of the soft-deleted table to restore.
DELETE /v1/tables/{id}

Returns

Soft delete returns the table object with deleted: true. Hard delete returns no content (204). Restore returns the restored table object.

Error Handling