SQLMesh CLI
CertifiedTasks that execute SQLMesh CLI commands.
Set working directory and SQLMesh configuration, then run CLI commands (plan, run, apply, etc.) with arguments, capturing stdout/stderr and artifacts for orchestration.
SQLMesh CLI
Tasks that execute SQLMesh CLI commands.
Set working directory and SQLMesh configuration, then run CLI commands (plan, run, apply, etc.) with arguments, capturing stdout/stderr and artifacts for orchestration.
How to use the SQLMesh plugin
Run SQLMesh CLI commands — plan, apply, test, and audit transformations — from Kestra flows inside a container.
Common properties
containerImage defaults to ghcr.io/kestra-io/sqlmesh. taskRunner controls where the container runs — defaults to Docker.
Tasks
cli.SQLMeshCLI runs one or more SQLMesh CLI commands set in commands (e.g. sqlmesh plan --auto-apply, sqlmesh run, sqlmesh test). Use beforeCommands for setup steps. Pass database credentials and other secrets as environment variables via env — store sensitive values in secrets. Pass supporting config files via inputFiles or pull them from namespace files. Apply runner properties globally with plugin defaults.
