schema-drift-check
Installation
SKILL.md
Schema Drift Check
When to Use
Use this skill when a pipeline fails because source, destination, or declared asset columns may have changed.
Inputs
- Affected asset name or path.
- Error output mentioning missing columns, extra columns, type changes, or schema mismatch.
- Connection and environment names, if available.
Operating Context
- These starter skills can be used by Bruin Cloud agents, local agents, and external assistants connected to Bruin Cloud.
- In Bruin Cloud, use Cloud CLI access when the agent has it enabled. Use the
bruin cloudCLI when the assistant has shell access and a configured API key or.bruin.yml; use Bruin Cloud MCP only when the assistant is configured for MCP tool calls or does not have direct CLI access. If using the CLI, inspect runs withbruin cloud runs diagnose --project-id <project-id> --pipeline <pipeline-name> --latest, fetch run details withbruin cloud runs get --project-id <project-id> --run-id <run-id>, and fetch failed asset logs withbruin cloud instances failed-logs --project-id <project-id> --run-id <run-id>. - In local development, inspect terminal output and the local
logs/folder, especiallylogs/runs, query logs, and export logs when they exist. Usebruin render <asset>,bruin validate <path>, andbruin querywith existing.bruin.ymlconnections for schema investigation. - If investigation or fix verification requires running an asset or pipeline, prefer a dev or shadow environment. If none exists, ask whether to run in production or create temporary copies of the affected tables to reproduce and test the issue.
- For other agent runtimes or orchestrators, customize this skill with the correct log source, schema inspection mechanism, and action mechanism before using it.