COA Create (DDL)
coa_createExecute DDL CREATE/REPLACE statements for selected nodes in your data warehouse, with pre-flight validation and required user confirmation to prevent accidental schema modifications.
Instructions
Execute coa create — runs DDL (CREATE/REPLACE) for the selected nodes against the configured warehouse.
DESTRUCTIVE: modifies warehouse schema. Requires confirmed=true after explicit user approval.
Pre-flight checks run before execution (double-quoted refs, missing workspaces.yml, bad selector patterns). Errors block execution; warnings are returned alongside the result.
V2 NOTICE: when the project contains V2 artifacts (fileVersion: 2 node types or .sql nodes), a V2_DETECTED preflight warning attaches to the result. Execution is no longer blocked — annotation sync (CD-16972) and UNION ALL shipped in COA 7.35 closed the biggest V2 risks. Two rough edges remain: coa validate false positives on aliased columns, and zero-column CTAS when a SELECT has a parse error. See coalesce://context/sql-node-v2-policy.
Args:
projectPath (string, required)
workspace, include, exclude (optional)
confirmed (boolean): must be true to execute
Returns: { command, exitCode, stdout, stderr, preflightWarnings?, 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`. | |
| confirmed | No | Set to true after the user explicitly confirms. Without this, the tool returns a STOP_AND_CONFIRM response instead of executing. | |
| 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 |