Skip to main content

CREATE LAKE

Description​

Creates a new data lake.

Note that the SQL statement does not end with ;

Syntax​

CREATE LAKE `<name>`
    LAKE_TYPE = { 'MANAGED' |'OBSERVED' }
    BUCKET_PATH = <string>
    DEFAULT_SERVICES_CLUSTER = <string>

Sample response

Required parameters​

  • <name>: Identifier for the lake
    • Must be unique for your project
    • Must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (e.g. "Staging Lake")
    • Case-sensitive
  • LAKE_TYPE: Specifies whether the lake is fully managed by Onehouse or only observed by Onehouse without edit access.
  • BUCKET_PATH: The path of the existing cloud storage folder where your lake will live. Example: "s3://bucket/directory"
  • DEFAULT_SERVICES_CLUSTER: The name of the managed compute cluster that will be used by default for all table services.