Jira (PSOM)
Tables in the jira schema, populated by the daily PSOM Jira Service Management sync pipeline.
Each day at ~06:00 ET, the psom-sync Lambda fetches a full snapshot of all tickets from the PSOM project (jtickets.atlassian.net) and writes it as three Parquet partitions in S3: one for tickets, one for their SLA clocks, and one for their comments. A single Glue crawler then updates all three Athena tables. Join them on key and date. Before 2026-09-29 the snapshot ran weekly, on Mondays.
Tables
| Table | Description |
|---|---|
| jira.psom | Daily snapshot of every PSOM Jira ticket, one row per ticket per snapshot. |
| jira.psom_sla | SLA clock state for each PSOM ticket, one row per ticket per SLA per snapshot. |
| jira.psom_comment | Every comment on every PSOM ticket, one row per comment per snapshot. |
No matching items