Snowflake Compliance Demo

Episodes & demos

• S01E01 Overviewhttps://jpeckenpaugh.github.io/snow-compliance-demo/ ► Watch (opens in a new tab)
• S01E02 Architecturehttps://jpeckenpaugh.github.io/snow-compliance-demo/architecture.html ► Watch (opens in a new tab)
• S01E03 POC & findingshttps://jpeckenpaugh.github.io/snow-compliance-demo/poc.html ► Watch (opens in a new tab)
• S01E04 Interactive demohttps://jpeckenpaugh.github.io/snow-compliance-demo/demo/index.html ► Watch (opens in a new tab)

About

The Snowflake Compliance Demo stages a proposed Snowflake integration for legal contract review. It pairs a board-facing static site — purpose, ten recommendations, delivery phases, architecture, data foundation, confidentiality model, risk analysis, audit verification, and a Snowflake-options comparison — with a working Python + SQLite proof of concept that enforces matter-level access control and records an audit log, designed to port directly to Snowflake. Contract data comes from the public Contract Understanding Atticus Dataset (CUAD, CC BY 4.0), normalized into RAW CSVs by ingest/load_cuad.py; clients, matters, staff, assignments, and approvals are synthetic data generated with Faker. The POC simulates Snowflake role context, row-access policies, masking, and query history offline (poc/snowflake_sim.py), so no Snowflake account is required. The repository also ships the target Snowflake DDL (sql/01-05: database and roles, data model, row access and masking, risk views, audit queries), a Python offline-SQL portability harness with CI, and a clickable interactive demo (demo/index.html) with role-based login. The Snowflake component is simulated for now: offline emulators run SQL but do not enforce governance, so row-access-policy and masking validation is deferred to a free trial. The contract-risk rubric is simulated and is not legal advice.

Summary

A board-review site and working offline proof of concept for a Snowflake legal-compliance platform built on the public CUAD contract dataset plus synthetic law-firm records, covering the data model, row-access policies, column masking, risk views, and audit queries.

Tech

• Python
• Snowflake
• SQL
• SQLite
• Faker
• HTML
• CSS
• GitHub Pages
• GitHub Actions

Tags

• audit
• cuad
• data-governance
• legal-tech
• proof-of-concept
• row-access-policy
• snowflake