starlake-ai/col-lineage
.agents/skills/col-lineage/SKILL.md
Generate column-level lineage for a specific task
$ install --global
skillsauthnpx skillsauth add starlake-ai/starlake-skills col-lineageInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 16, 2026, 3:36 AM14.3s1 file scanned
SKILL.md
- name:
- col-lineage
- description:
- Generate column-level lineage for a specific task
Column Lineage Skill
Generates column-level lineage for a specific transform task, showing how each output column traces back to its source columns through SQL transformations. This provides fine-grained data provenance information.
Usage
starlake col-lineage [options]
Options
--task <value>: Task name in the formdomain.task(required)--output <value>: Output JSON file path (default: console output)--accessToken <value>: Access token for authentication (e.g. GCP)--reportFormat <value>: Report output format:console,json, orhtml
How It Works
Analyzes the SQL query for a task and traces each output column back to its source columns. For example, given:
-- metadata/transform/kpi/revenue_summary.sql
SELECT
o.order_id,
o.timestamp AS order_date,
SUM(ol.quantity * ol.sale_price) AS total_revenue
FROM
starbake.orders o
JOIN starbake.order_lines ol ON o.order_id = ol.order_id
GROUP BY
o.order_id, o.timestamp
The column lineage output would show:
order_id←starbake.orders.order_idorder_date←starbake.orders.timestamptotal_revenue←starbake.order_lines.quantity,starbake.order_lines.sale_price
Examples
Generate Column Lineage for a Task
starlake col-lineage --task kpi.revenue_summary
Save Column Lineage to File
starlake col-lineage --task kpi.order_summary --output col_lineage.json
Column Lineage with Access Token
starlake col-lineage --task kpi.revenue_summary --accessToken $GCP_TOKEN
Related Skills
- lineage - Task-level dependency graph
- table-dependencies - Table relationship graph
- transform - Run transformation tasks
Related Skills
starlake-ai/starflow-transform-design
development
VerifiedTrustedCommunity
Design SQL transformations for data pipelines with quality checks and dependency management. Use when the user says "design transforms" or "create SQL transformations".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-sprint-planning
devops
VerifiedTrustedCommunity
Plan and track sprint progress for data pipeline implementation. Use when the user says "sprint planning" or "plan data sprint".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-source-analysis
testing
VerifiedTrustedCommunity
Analyze data sources in depth: schema, quality, volume, and extraction strategy. Use when the user says "analyze data source" or "profile this data source".
1SKILL.mdUpdated Apr 16, 2026
starlake-ai/starflow-schema-design
data-ai
VerifiedTrustedCommunity
Design Starlake-compatible table schemas with types, constraints, privacy, and expectations. Use when the user says "design schema" or "create table definition".
1SKILL.mdUpdated Apr 16, 2026