dt view get

Overview

Get rows from a SQL view in the views schema

Synopsis

dt view get [OPTIONS] <name> 

Options

• -f, --filter=<filter>
  Filter expression, e.g. "state = [running, pending] and jobName contains my-"

• -s, --sort=<sort>
  Sort expression: +field for ASC, -field for DESC

• -o, --offset=<offset>
  Offset to start showing results (default 0)

• -b, --batch-size=<batch-size>
  Retrieve up to batch-size results (default 100)

• -j, --json
  Output as JSON

• -p, --pretty
  Pretty print results

Arguments

• name (required)
  Type: String
  View name

Examples

List runs

dt view get runs

List runs as JSON

dt view get runs -j

Filter and sort runs

dt view get runs -f "state = running" -s "-submitTime" -o 0 -b 40 -j

Fetch run cost for specific runs (scoped lookup)

dt view get run_costs -f "runId = [101, 102, 103]" -j

SEE ALSO

← Back to dt view