SQLMesh

sqlmesh

SQLMesh is a next-generation data transformation framework designed to ship data quickly, efficiently, and without error.

Runs as sqlmesh|macOS, Linux, Windows|sqlmesh.readthedocs.io

Open form in Otty otty.toml

Command form

ai-draft · 3 tasks · 12 fields

Plan, run and test a SQLMesh project. Global project options are on the root; init, audit, migrate and the UI are left out.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui sqlmesh

`sqlmesh plan`

Plan and apply changes

Show the plan for local changes against an environment and optionally apply it.

Plan and apply changesExample values, fixed in this page — nothing here reaches a terminal

Basic

Environment*

string

Skip tests

--skip-tests

Select models

string

TasksEach one presets the form for one job

Plan a dev environment

environmentskip_testsselect_model

Plan and apply

environmentno_promptsauto_apply

ParametersOnly these flags are editable in the form

Environment

Target environment, default prod.
string · positional 0

Create from

Environment to create the target from if missing.
string

--create-from

Skip tests

Skip tests before generating the plan.
boolean

--skip-tests

Forward-only

Create a plan for forward-only changes.
boolean

--forward-only

No gaps

Ensure new snapshots have no data gaps.
boolean

--no-gaps

Skip backfill

Only create a virtual update.
boolean

--skip-backfill

Restate models

Restate data for the models and those downstream.
string · repeatable

--restate-model

Select models

Select specific model changes for the plan.
string · repeatable

--select-model

No prompts

Disable interactive prompts.
boolean

--no-prompts

Auto apply

Apply the plan automatically after creation.
boolean

--auto-apply

Verbose

Enable verbose output.
boolean

--verbose

`sqlmesh run`

Run missing intervals

Evaluate missing intervals for an environment.

Run missing intervalsExample values, fixed in this page — nothing here reaches a terminal

Basic

Environment

string

TasksEach one presets the form for one job

Run

environment

ParametersOnly these flags are editable in the form

Environment

Target environment, default prod.
string · positional 0

SourcesEvery flag above is checked against these

fig

completion

github.com

fig

completion

github.com

fig

completion

github.com

Before it fills your prompt, Otty checks the installed sqlmesh against its version. A form that does not match your version is not offered.