Skip to main content

DELETE LAKE

Description​

Delete an existing Lake.

Note that the SQL statement does not end with ;

info

By default the operation fails if the lake has any dependents (databases, tables, or capture streams). Use CASCADE to delete dependents in the same call.

Syntax​

DELETE LAKE `<name>` [CASCADE]

Sample response

Examples​

-- Strict (fails if dependents exist):
DELETE LAKE `my_lake`

-- Cascade (deletes dependent tables, databases, capture streams, then the lake):
DELETE LAKE `my_lake` CASCADE

Required parameters​

  • <name>: Specify the name of the Lake to delete.

Optional clauses​

  • CASCADE: When present, dependent databases, tables, and capture streams are deleted before the lake. Without CASCADE, the operation fails if any dependents exist; the error includes the list of blockers.