COA Dry Run Run (DML preview)
coa_dry_run_runPreview the DML that coa run would execute without hitting the warehouse. Run offline against local project files to validate SQL templates before deployment.
Instructions
Preview the DML that coa run would execute, without hitting the warehouse. Forces --dry-run --verbose.
Runs entirely offline against local project files — no Coalesce cloud authentication or API calls. coa run (and coa create) are the offline local-dev commands; do not confuse with the scheduler-aware coa deploy / coa plan / coa refresh which target cloud environments.
OUTPUT SHAPE (CD-16959+): dry-run reports pass/fail for every selected node rather than stopping at the first template error. Scan the full stdout — a non-zero exit code means one or more nodes failed, but successful nodes still render their generated SQL above/below the failures.
LIMITATION: dry-run only exercises the SQL generator. It does NOT validate that referenced columns or types exist in the actual warehouse — a dry-run can succeed with column references that will fail at run-time with 'invalid identifier'. Use cortex or another Snowflake-capable MCP to confirm the schema when that matters.
Args:
projectPath (string, required)
workspace (string, optional)
include / exclude (string, optional): Node selector
Returns: { command, exitCode, stdout, stderr, coaVersion }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| exclude | No | COA node selector to exclude. | |
| include | No | COA node selector, e.g., '{ STG_ORDERS }' or '{ location: "SRC" }'. See `coa describe selectors`. | |
| workspace | No | COA workspace name from workspaces.yml. Defaults to 'dev'. | |
| projectPath | Yes | Absolute or relative path to the COA project root (the directory containing data.yml). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| json | No | ||
| stderr | Yes | ||
| stdout | Yes | ||
| command | Yes | ||
| exitCode | Yes | ||
| timedOut | Yes | ||
| coaVersion | Yes | ||
| jsonParseError | No | ||
| preflightWarnings | No |