table-dependencies

Generate a dependency graph of data warehouse tables with SVG/PNG outputs.

209|30|Updated Sep 18, 2021
One-click install
npx skills add https://github.com/starlake-ai/starlake --skill table-dependencies
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: table-dependencies
Source: https://github.com/starlake-ai/starlake/tree/main/.agent/skills/table-dependencies
Command: npx skills add https://github.com/starlake-ai/starlake --skill table-dependencies

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps data teams understand how tables in a dataset depend on one another by generating a clear, shareable dependency graph.

Core Features & Use Cases

  • Dependency visualization: produce a graph showing which tables depend on which.
  • Impact analysis: identify ripple effects when changing a table or column.
  • Use Case: plan schema changes or optimize data pipelines by understanding join chains and references.

Quick Start

Run the table-dependencies command to generate and visualize the dependency graph for your catalog.

Frequently Asked Questions about table-dependencies

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I visualize table dependencies in my data warehouse?

To visualize table dependencies, generate a graph from your data warehouse tables to clearly show which tables depend on which. This provides a shareable dependency graph for your entire catalog.

What is the best way to perform impact analysis for schema changes?

Impact analysis for schema changes is performed by generating a dependency graph to identify ripple effects. This reveals how altering a table or column impacts downstream data pipelines.

Can I filter specific tables when generating a data model dependency graph?

Yes, you can filter specific tables when generating a data model dependency graph. This allows you to focus on particular join chains or references within your data warehouse catalog.

Does the table-dependencies skill support exporting visual outputs like SVG or PNG?

Yes, the table-dependencies skill supports generating visual outputs like SVG and PNG. You can export your dependency graphs into these formats for sharing and impact analysis documentation.

How do I understand data lineage and join chains across my database tables?

You understand data lineage and join chains by generating a dependency graph from your database tables. This visualizes the connections and references between tables to optimize data pipelines.