COA Dry Run Create (DDL preview)
coa_dry_run_createPreview DDL changes from coa create offline without warehouse access. Validate SQL generation and detect errors in node templates before running.
Instructions
Preview the DDL that coa create 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 create (and coa run) 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. Do not assume early output implies all-clear.
Check the stdout: table names should resolve (not blank), column types should not be UNKNOWN (indicates broken ref() targets), and SQL should look correct. For V2 nodes specifically, watch for CREATE TABLE ... AS SELECT WHERE 1=0 with zero columns — this means the SELECT has a parse error and the dry-run reports success despite producing broken DDL. See coalesce://context/sql-node-v2-policy.
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 |