Skip to main content

CREATE DATABASE

Description​

Creates a new database within a lake.

Note that the SQL statement does not end with ;

Syntax​

CREATE DATABASE <name>
    LAKE = <LAKE-NAME>

Required parameters​

  • <name>: Identifier for the database
    • 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 Database")
    • Case-sensitive
  • LAKE: Name of the lake to create database in.

Example​

Example syntax for creating a database

create database my_database lake = 'my_lake'

Sample response