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

Autocomplete

Fig spec, with what the manifest adds · 17 subcommands · 7 options

Published once and never changed; check the digest before caching

Download JSON

sha256

79dd9bcdae44ab4d32b79183c72eb3f638f1982ec039fe3a0b26ecde23376b3d

Size

20024 bytes

Subcommands17 subcommands

sqlmesh init

Create a new SQLMesh repository

sqlmesh render

Render a model's query, optionally expanding referenced models

sqlmesh evaluate

Evaluate a model and return a dataframe with a default limit of 1000

sqlmesh format

Format all SQL models and audits

sqlmesh diff

Show the diff between the local state and the target environment

sqlmesh plan

Apply local changes to the target environment

sqlmesh run

Evaluate missing intervals for the target environment

sqlmesh invalidate

Invalidate the target environment, forcing its removal during the next run of the janitor process

sqlmesh janitor

Run the janitor process on-demand

sqlmesh dag

Render the DAG as an html file

sqlmesh create_test

Generate a unit test fixture for a given model

sqlmesh test

Run model unit tests

sqlmesh audit

Run audits for the target model(s)

sqlmesh ui

Start a browser-based SQLMesh UI

sqlmesh migrate

Migrate SQLMesh to the current running version

sqlmesh rollback

Rollback SQLMesh to the previous migration

sqlmesh create_external_models

Create a schema file containing external model schemas

OptionsOn sqlmesh itself

--paths

Paths to SQLMesh project files <paths>

--config

Path to config file <config>

--gateway

The name of the gateway <gateway>

--ignore-warnings

Ignore warnings

--debug

Enable debug mode

--log-to-stdout

Display logs in stdout

--log-file-dir

The directory to write log files to <directory>