Remove obsolete enrichment snapshot contract

[texture-fleet-agent]

Summary

Removes the short-lived utility-enrichment snapshot contract that landed before the architecture pivot to direct REST API consumption.

Consumers should call CommonGrid's public APIs directly with caching. CommonGrid should not mirror its utility facts through a database view for downstream private systems.

What this does

Adds migration 0011_drop_enrichment_snapshot_contract.sql, which idempotently removes:

• commongrid.v_crm_org_enrichment
• commongrid.v_utility_enrichment
• commongrid.v_utilities_enriched
• commongrid.enrichment_schema

It intentionally keeps:

• commongrid schema — generic namespace for server-to-server contract objects
• internal_api_consumer role — scoped role for those contract objects
• utility resolver/cache objects — generic matching primitives that remain useful

Also scrubs obsolete private-spec references from public SQL/test comments.

Verification

Applied the migration to Neon successfully:

\dt commongrid.*  -- none
\dv commongrid.*  -- none
\df commongrid.*  -- none

Local gates:

• npm run build ✅
• npm run openapi:check ✅

Follow-up

Next PRs add public REST/API capabilities instead of database snapshots:

• /api/v1/utilities/by-eia-id/{eia_id}
• numeric filters on /api/v1/utilities
• cache headers for utility endpoints

[vercel]

The latest updates on your projects. Learn more about Vercel for GitHub.

Project	Deployment	Actions	Updated (UTC)
commongrid	Ready	Preview, Comment	May 8, 2026 3:04pm

[victor-agent-talos]

LGTM — corrective cleanup is the right shape.

• 0008/0009 comment scrubs remove the private-spec URL references while keeping the generic fn_resolve_utility_by_name / utility_resolver_cache / utility_name_manual_overrides functionality — good public/private separation.
• 0010 rename v_crm_org_enrichment → v_utility_enrichment in case any intermediate env still has the old name.
• 0011 drops the whole snapshot contract idempotently (IF EXISTS on DROP, REVOKE ALL first). Leaves commongrid schema + internal_api_consumer role intact for M3/M4 resolver work. Matches Victor's no-replication ruling.

Approving.