Overwriting at Deploy

Learn how to override default parameters when you deploy from the Coalesce App, and how to pass JSON overrides on coa plan when you use the CLI (including shell quoting on macOS, Linux, and Windows).

Overwriting Default Parameters in the Coalesce App

When deploying from the Coalesce App, you'll have the option to overwrite default parameters or provide new parameters specific to that Environment. If default parameters were set, they will appear here.

Persistence of Overwrites

Any changes to Parameters in the Deploy screen will only apply to that specific deployment. Defaults will be left unchanged for subsequent deployments.

Overwriting Default Parameters With Plan

To override default parameters from the command line, pass --parameters with a valid JSON object on coa plan for that run.

Override on Deploy Doesn't Work

--parameters on coa deploy does nothing. Deploy does not read JSON parameters or merge them again.

When you include --parameters on coa plan:

1. Planning renders your pipeline SQL with those values.
2. coa deploy runs the queries produced during that plan step (the same rendered SQL), not a separate parameter pass on deploy.

bash

Wrap the JSON in single quotes so the shell does not interpret double quotes inside the object:

coa plan --parameters '{ "foo": "bar" }'

Windows PowerShell

A single-quoted argument is treated literally, which usually matches the macOS or Linux approach:

coa plan --parameters '{ "foo": "bar" }'

If that fails for your PowerShell version or profile, use the backslash-escaped double quotes from the Windows Command Prompt tab, or run the command from Command Prompt.

Windows Command Prompt

The shell strips the outer double quotes and passes the JSON to the CLI. Escape each inner double quote with a backslash:

coa plan --parameters "{\"foo\": \"bar\"}"