Invalid Column Metadata (Deployment Failure With No Failed Stages)
Error
A deployment fails but no individual stages show as failed. This can occur when a Node references a source column that no longer exists, was renamed, or has invalid metadata. The failure may appear at plan generation or during deployment without clear stage-level errors.
Possible Causes
- Invalid source column reference: A downstream Node references a column that was removed or renamed in the source.
- Metadata drift: Column metadata in Coalesce is out of sync with the actual source table or view.
- Stale cache: Cached metadata from a previous deployment doesn't match the current state.
Possible Solutions
Workaround when the transform references a bad source column:
- Copy the transform logic from the affected Node.
- Clear the transform (remove all logic).
- Remove the invalid source column reference from the Node.
- Paste the transform logic back.
- Re-add the correct source column if needed.
- Commit and redeploy.
If the problem persists, verify that source tables and views exist and that column names and types match what Coalesce expects. Consider running a metadata sync or refreshing source definitions.