Critical Tables Identifier

Organizations often manage tens of thousands of tables, creating decision paralysis where every asset appears equally important. This recipe computes a composite 0–100 Criticality Score that automatically surfaces the tables that carry the highest business risk and impact—such as those containing PII or feeding executive dashboards—so governance and security efforts focus where they matter most.

What you receive

How the recipe works (guided flow)

Step 1 — Baseline Importance Selection
Extract foundational metadata such as usage metrics, row counts, and lineage signals while filtering out temporary structures and technical noise.

Step 2 — Recursive Lineage Impact Amplification
Trace downstream lineage up to five levels toward reports and dashboards; each table receives a +5 point impact bonus for every unique report it ultimately feeds.

Step 3 — Structural Table Classification
Classify assets structurally based on row volume and connectivity: Transactional tables receive 10 points, Master tables receive 8 points, and Reference tables receive 5 points.

Step 4 — Exhaustive PII Detection
Perform a deep scan across column names using 50+ PII keywords to identify sensitive data fields; detected PII contributes a 30-point risk weight to the table.

Step 5 — Composite Criticality Scoring & Triage
Compute a final 0–100 Criticality Score using a weighted formula: 50% Value (usage & lineage impact), 30% Risk (PII presence), and 20% Structure (table classification). The recipe then applies standard deviation (σ) calculations to automatically bucket assets into five governance tiers: Critical, High, Medium, Low, and Deprioritize.

Sample insights (illustrative)

Make sure the following ingredients are available in your workspace:

• Connected datasets are crawled and profiled
• Lineage is established linking tables to downstream Reports/Charts
• Usage scores and row counts are populated for all tables