Discover fields

SELECT
  label,
  semantic_path,
  inferred_type,
  total_observation_count,
  last_seen_at
FROM reporting.cargowise_xml_fields
WHERE label ILIKE '%origin%'
ORDER BY last_seen_at DESC;

SELECT
  label,
  semantic_path,
  original_text,
  numeric_value,
  boolean_value,
  timestamp_value,
  created_at,
  payload_id
FROM reporting.cargowise_xml_observations
WHERE label ILIKE '%Operations%'
  AND created_at >= now() - interval '30 days'
ORDER BY created_at DESC
LIMIT 100;

SELECT
  original_text,
  created_at,
  payload_id
FROM reporting.cargowise_xml_observations
WHERE semantic_path = 'the/exact/path/from/xml_fields'
  AND created_at >= now() - interval '7 days'
ORDER BY created_at DESC;