Admin
Manage mappings, targets, and BigQuery resources for utility-canto-401620
Manage mappings, targets, and BigQuery resources for utility-canto-401620
| Resource | Type | Description | |
|---|---|---|---|
| venue_map | Table | Venue name crosswalk (154 seeded rows) | Open |
| event_map | Table | Event-level override mappings | Open |
| ticket_sales_with_metadata | View | Main joined view — ticket sales + event metadata | Open |
| unmatched_venues | View | Gate52 venue names not yet in venue_map | Open |
| unmatched_gate52_events | View | Ticket events not matched to a Prism event | Open |
| anomaly_zero_sales | View | Upcoming events with zero sales yesterday | Open |
| anomaly_velocity_change | View | Events with >50% day-over-day sales velocity change | Open |
| kpi_event_daily | Table | Daily per-event KPI snapshots (partitioned by snapshot_date) | Open |
| kpi_venue_daily | Table | Daily per-venue pipeline rollup (partitioned by snapshot_date) | Open |
| Resource | Type | Description | |
|---|---|---|---|
| savelive | Table | Raw ticket sales snapshots (~758K rows) | Open |
| Resource | Type | Description | |
|---|---|---|---|
| event | Table | Event metadata (~9.3K rows, 190 columns) | Open |