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 = { 'FULLY_MANAGED' |'OBSERVED' }
    BUCKET_PATH = <string>

Sample response

Required parameters​

  • <name>: Identifier for the lake
    • Must be unique for your account
    • 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"