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 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 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