Amazon S3

s3://<bucket>/policy-gateway/
  date=2026-04-20/
    <event_id>.json

CREATE EXTERNAL TABLE ai_audit (
  event_id string,
  event_type string,
  policy_id string,
  decision string,
  effective_decision string,
  enforced boolean,
  rollout_mode string,
  reason_code string,
  policy_target string,
  project_id string,
  model string,
  triggered_categories array<string>,
  denylist_hits array<string>,
  allowlist_hits array<string>
)
PARTITIONED BY (date string)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://<bucket>/policy-gateway/';