arcana-platform-schema

Schema definitions and catalog config for Arcana's platform data layer.

These tables are sourced from the Postgres production replica and synced nightly to BigQuery (arcana_platform dataset) for use by the Analytics, Security, and Product teams.

Tables

Table	Description
user_permissions	User roles and access grants per org
audit_log	Compliance trail for all platform events

Structure

schema/
  user_permissions.sql   — DDL for the user permissions table
  audit_log.sql          — DDL for the audit log table
helperee.yaml            — Helperee catalog config for user_permissions
.github/workflows/
  catalog-monitor.yml    — Auto-generated by Helperee (added after webhook setup)

Catalog Integration

This repo is monitored by Helperee. When a schema file changes, Helperee automatically:

• Detects the change and logs it on the asset's Changes tab
• Flags the asset as quality-stale for downstream consumers
• Re-generates AI column descriptions for any new columns
• Notifies registered consumers

Owner: Alex Chen, Platform Engineering (not a real person so no need to try and find them)