.do
Cli

DataLake CLI

CLI reference for DataLake

DataLake CLI

A managed Apache Iceberg data catalog for large-scale analytics on object storage with ACID transactions and schema flexibility.

Commands

create

Create a new Iceberg data catalog.

do datalake create [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

delete

Permanently remove the data lake and all its tables.

do datalake delete [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

createTable

Create a new Iceberg table in the catalog.

do datalake createTable [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

dropTable

Remove an Iceberg table from the catalog.

do datalake dropTable [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

query

Execute SQL queries using R2 SQL engine.

do datalake query [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

insert

Insert data into an Iceberg table.

do datalake insert [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

update

Update existing records in an Iceberg table.

do datalake update [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

delete

Delete records from an Iceberg table.

do datalake delete [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

snapshot

Create a new snapshot for time-travel queries.

do datalake snapshot [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

timeTravel

Query data as it existed at a specific point in time.

do datalake timeTravel [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

evolveSchema

Add, rename, or delete columns without rewriting data.

do datalake evolveSchema [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

listTables

List all tables in the catalog.

do datalake listTables [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

getSchema

Retrieve the schema for a specific table.

do datalake getSchema [options]

Options:

  • --help - Show help
  • --json - Output as JSON
  • --quiet - Suppress output

Examples

# create
do datalake create

# With JSON output
do datalake create --json

# Quiet mode
do datalake create --quiet