Build data transformation pipelines in Coalesce from source tables. Use when: create a pipeline, build a stage node, create a dimension, build a transformation, set up a data model, create a view for analysts, add a CASE WHEN, transform columns, build from a source table, create nodes in Coalesce. Triggers: build a pipeline, create a stage, create a dimension, create a fact, add transformation, build from source table, model this data, create nodes, pipeline from table.
Investigate and diagnose Coalesce pipeline job failures. Use when: a job failed, pipeline is broken, need to find errors, debug run failures, check what went wrong, fix failing nodes, diagnose pipeline issues. Triggers: job failed, pipeline failure, run failed, why did the job fail, what went wrong, investigate failure, debug pipeline, failing node, error in run, broken pipeline, coalesce failure.