Skip to main content

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:

  1. Copy the transform logic from the affected Node.
  2. Clear the transform (remove all logic).
  3. Remove the invalid source column reference from the Node.
  4. Paste the transform logic back.
  5. Re-add the correct source column if needed.
  6. 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.