Skip to main content

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