databricks-fsi-governed-foundation

Builds governed Databricks medallion data foundations for financial-services demos with lineage and quality controls.

Updated Aug 28, 2026
One-click install
npx skills add https://github.com/miyake-san/sogo-agent-platform --skill databricks-fsi-governed-foundation-miyake-san
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-fsi-governed-foundation
Source: https://github.com/miyake-san/sogo-agent-platform/tree/main/skills/domain/databricks-fsi-governed-foundation
Command: npx skills add https://github.com/miyake-san/sogo-agent-platform --skill databricks-fsi-governed-foundation-miyake-san

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Building a credible financial-services data foundation on Databricks requires coordinating multi-source ingestion, Unity Catalog governance, medallion architecture, identity resolution, data quality, lineage, and privacy controls — and doing it honestly for demos without overstating simulated evidence. ## Core Features & Use Cases - Multi-Source Medallion Ingestion: Land two distinct source types (e.g., relational snapshots and transaction events) through Bronze, Silver, and Gold layers with preserved source fidelity and quarantined invalid records. - Governance and Privacy by Persona: Define owners, least-privilege grants, and classify sensitive fields (tax IDs, payment identifiers, contact data) for masking, row filters, or restricted schemas. - Visible Quality and Lineage: Persist pass/fail quality counts, rejected rows, and trace one transaction from both sources through all medallion layers. - Use Case: A solutions engineer building a fraud-detection demo needs a governed Layer 1 foundation where transaction events and account snapshots converge on a customer identity spine, with quality evidence and an ML-ready handoff manifest for Layer 2 feature engineering. ## Quick Start Use this skill to design and validate the governed Layer 1 data foundation for my Databricks FSI fraud demo, covering ingestion, medallion layers, quality checks, lineage, and the Layer 2 handoff manifest.

Frequently Asked Questions about databricks-fsi-governed-foundation

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

FAQPage Schema
How do I build a governed Databricks lakehouse foundation for financial services?

Start by defining one FSI decision journey and a primary entity, then land at least two distinct source types into Bronze, apply typing and deduplication in Silver, and expose business entities in Gold. Add Unity Catalog governance, data-quality tests, and lineage tracing before handing off to ML layers.

How do I implement medallion architecture with data quality checks on Databricks?

Bronze preserves source fidelity, Silver types, deduplicates, validates, and quarantines invalid records, and Gold exposes business entities. Test non-null keys, uniqueness, positive amounts, referential integrity, freshness, and event-time validity, persisting pass/fail counts and rejected rows.

Can I use real customer data in a Databricks FSI demo?

No. Use only synthetic, public, or approved data in demo repositories, and never log credentials, unmasked personal data, or full payment identifiers. Treat synthetic labels and mocked sources as simulated evidence rather than production validation.

How do I prove data lineage across Bronze, Silver, and Gold layers?

Trace one identifier, such as a transaction_id, from both source types through every medallion layer to Gold. Record source system, type, path, batch, event time, and ingestion time, and distinguish captured source metadata from platform-generated lineage.

What are the limitations of mocked ingestion sources in Databricks demos?

Mocked paths validated on Free Edition only prove the simulated flow; Azure JDBC or Event Hubs ingestion counts as validated only after a real integration run. Do not claim regulatory compliance — state which technical controls support a future legal assessment.