COA Refresh
coa_refreshRun DML for selected nodes in a deployed cloud environment to refresh data. Requires explicit confirmation before execution.
Instructions
Run DML for selected nodes in a deployed environment. Does not require a local project — operates purely on the cloud environment.
DESTRUCTIVE: modifies warehouse data in the environment. Requires confirmed=true.
Args:
environmentID (string, required)
include, exclude, jobID, parallelism, parameters (optional)
forceIgnoreEnvironmentStatus (optional)
profile, token (optional)
confirmed (boolean): must be true to execute
Returns: { command, exitCode, stdout, stderr, coaVersion }
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| jobID | No | Run a specific deployed job. | |
| token | No | Coalesce refresh token override. Prefer ~/.coa/config over passing tokens through tool input. | |
| exclude | No | Node selector to exclude. | |
| include | No | Node selector to scope the refresh. | |
| profile | No | Profile name in ~/.coa/config. Falls back to the COALESCE_PROFILE env var, then to COA's own default (`[default]`). | |
| confirmed | No | Set to true after explicit user confirmation. | |
| parameters | No | Runtime parameters to pass to the run. | |
| parallelism | No | Parallelism level. | |
| environmentID | Yes | Environment ID to refresh. | |
| forceIgnoreEnvironmentStatus | No | Proceed even if the environment has a failed deploy. May cause refresh failures — use only when you understand the state. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| json | No | ||
| stderr | Yes | ||
| stdout | Yes | ||
| command | Yes | ||
| exitCode | Yes | ||
| timedOut | Yes | ||
| coaVersion | Yes | ||
| jsonParseError | No | ||
| preflightWarnings | No |