Schema Info

Schema Name: sfdl_dev_csv.payrixess_aggregated_txns_by_date
  • created: 2024-07-22 12:22:37
  • disabled: False
  • format: raw
  • id: 2335
  • is_partitioned: True
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "payrixess_aggregated_txns_by_date"
    }
  • type: csv
Schema Versions: 1
    • created: 2024-07-22 12:22:38
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_aggregated_txns_by_date`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_aggregated_txns_by_date`\n(\n `created`  string , `captured`  string , `settled`  string , `funded`  string , `txn_type`  string , `card_type`  string , `card_brand`  string , `merchant`  string , `platform`  string , `txn_ref`  string , `txn_status`  string , `entity`  string , `division`  string , `txn_count`  string , `txn_approved_sum`  string , `txn_settled_sum`  string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_aggregated_txns_by_date"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date
    • id: 4707578
    • processed: 1
    • raw_data:
      {
          "captured": 1,
          "card_brand": 6,
          "card_type": 5,
          "created": 0,
          "division": 12,
          "entity": 11,
          "funded": 3,
          "merchant": 7,
          "platform": 8,
          "settled": 2,
          "txn_approved_sum": 14,
          "txn_count": 13,
          "txn_ref": 9,
          "txn_settled_sum": 15,
          "txn_status": 10,
          "txn_type": 4
      }
    • schema_attributes:
      {
          "captured": "string",
          "card_brand": "string",
          "card_type": "string",
          "created": "string",
          "division": "string",
          "entity": "string",
          "funded": "string",
          "merchant": "string",
          "platform": "string",
          "settled": "string",
          "txn_approved_sum": "string",
          "txn_count": "string",
          "txn_ref": "string",
          "txn_settled_sum": "string",
          "txn_status": "string",
          "txn_type": "string"
      }
    • schema_name_id: 2335
    • schema_scan_id: 6543399
    • updated: 2024-07-22 12:22:51
Schema Scans: 5
Last at 2026-04-17 09:51:41
    • duration: 0:00:00.771763
    • exit_message:
      {
          "ddl_changed": false,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867790
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "partition": {
              "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16",
              "name": "dt",
              "type": "string",
              "value": "2026-04-16"
          },
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date",
              "key": "raw_incremental/aggregated_txns_by_date/dt=2026-04-16/a5b1fad3-dd3b-4a55-ae12-23414a867c61.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_aggregated_txns_by_date",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 15012257263489282159,
              "service_name": "drive-thru",
              "span_id": 17737025708335584764,
              "trace_id": 7707677578816292660
          }
      }
    • running: False
    • schema_name_id: 2335
    • start_time: 2026-04-17 09:51:41
    • success: True
    • trace_id: 7707677578816292660
    • duration: 0:00:03.562899
    • exit_message:
      {
          "ddl_changed": false,
          "partitions_applied": true,
          "success": true
      }
    • id: 6867759
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "partition": {
              "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16",
              "name": "dt",
              "type": "string",
              "value": "2026-04-16"
          },
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date",
              "key": "raw_incremental/aggregated_txns_by_date/dt=2026-04-16/a5b1fad3-dd3b-4a55-ae12-23414a867c61.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_aggregated_txns_by_date",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 11807142025486689910,
              "service_name": "drive-thru",
              "span_id": 10362737569303632803,
              "trace_id": 12013824196251623734
          }
      }
    • running: False
    • schema_name_id: 2335
    • start_time: 2026-04-17 09:48:13
    • success: True
    • trace_id: 12013824196251623734
    • duration: 0:00:00.943009
    • exit_message:
      {
          "ddl_changed": false,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867500
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "partition": {
              "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15",
              "name": "dt",
              "type": "string",
              "value": "2026-04-15"
          },
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date",
              "key": "raw_incremental/aggregated_txns_by_date/dt=2026-04-15/87ce709a-f75f-411b-86f5-fed046c12a34.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_aggregated_txns_by_date",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13068801864458517894,
              "service_name": "drive-thru",
              "span_id": 3014386485973690313,
              "trace_id": 4898965951671674187
          }
      }
    • running: False
    • schema_name_id: 2335
    • start_time: 2026-04-16 09:35:40
    • success: True
    • trace_id: 4898965951671674187
    • duration: 0:00:03.674064
    • exit_message:
      {
          "ddl_changed": false,
          "partitions_applied": true,
          "success": true
      }
    • id: 6867496
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "partition": {
              "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15",
              "name": "dt",
              "type": "string",
              "value": "2026-04-15"
          },
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date",
              "key": "raw_incremental/aggregated_txns_by_date/dt=2026-04-15/87ce709a-f75f-411b-86f5-fed046c12a34.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_aggregated_txns_by_date",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 514912696982306856,
              "service_name": "drive-thru",
              "span_id": 1045008920240632774,
              "trace_id": 5658158633049662642
          }
      }
    • running: False
    • schema_name_id: 2335
    • start_time: 2026-04-16 09:35:36
    • success: True
    • trace_id: 5658158633049662642
    • duration: 0:00:14.814643
    • exit_message:
      {
          "ddl_changed": true,
          "ingested_partitions": 2,
          "partitions_applied": false,
          "success": true
      }
    • id: 6543399
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "partition": {
              "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2024-07-21",
              "name": "dt",
              "type": "string",
              "value": "2024-07-21"
          },
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date",
              "key": "raw_incremental/aggregated_txns_by_date/dt=2024-07-21/0604e352-e4de-4ff9-b041-47f92df40374.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_aggregated_txns_by_date",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1290866728262175131,
              "service_name": "drive-thru",
              "span_id": 14063471094672115648,
              "trace_id": 14879849506730593444
          }
      }
    • running: False
    • schema_name_id: 2335
    • start_time: 2024-07-22 12:22:37
    • success: True
    • trace_id: 14879849506730593444
Partitions:
  • count: 130
  • ddl:
    [
        "ALTER TABLE\n    `sfdl_dev_csv.payrixess_aggregated_txns_by_date`\nADD\n\n\n PARTITION (dt='2025-12-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-22'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-30'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-05'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-14'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-26'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-29'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-31'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-17'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-10'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-12'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-14'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-26'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-30'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-02'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-11'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16'\n;"
    ]
  • name: dt
  • state:
    [
        {
            "info": {
                "id": 304273,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-08/",
                "name": "dt",
                "value": "2025-12-08"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-10 09:27:46",
                    "last_data": "2025-12-10 09:27:46"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304305,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-09",
                "name": "dt",
                "value": "2025-12-09"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-10 09:40:51",
                    "last_data": "2025-12-11 09:31:29"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304372,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-10",
                "name": "dt",
                "value": "2025-12-10"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-11 09:32:21",
                    "last_data": "2025-12-12 09:43:24"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304463,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-11/",
                "name": "dt",
                "value": "2025-12-11"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-12 09:44:47",
                    "last_data": "2025-12-12 09:44:47"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304502,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-12",
                "name": "dt",
                "value": "2025-12-12"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-13 09:29:19",
                    "last_data": "2025-12-13 09:29:31"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304577,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-13",
                "name": "dt",
                "value": "2025-12-13"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-14 09:43:40",
                    "last_data": "2025-12-14 09:43:44"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304606,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-14",
                "name": "dt",
                "value": "2025-12-14"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-15 09:26:49",
                    "last_data": "2025-12-15 09:28:58"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304686,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-15",
                "name": "dt",
                "value": "2025-12-15"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-16 09:29:38",
                    "last_data": "2025-12-16 09:29:42"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304774,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-16",
                "name": "dt",
                "value": "2025-12-16"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-17 09:40:24",
                    "last_data": "2025-12-17 09:44:00"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304806,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-17",
                "name": "dt",
                "value": "2025-12-17"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-18 09:27:02",
                    "last_data": "2025-12-18 09:28:39"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304900,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-18",
                "name": "dt",
                "value": "2025-12-18"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-19 09:40:31",
                    "last_data": "2025-12-19 09:42:55"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 304948,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-19",
                "name": "dt",
                "value": "2025-12-19"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-20 09:32:21",
                    "last_data": "2025-12-21 09:27:48"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305038,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-20/",
                "name": "dt",
                "value": "2025-12-20"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-21 09:47:23",
                    "last_data": "2025-12-21 09:47:23"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305062,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-21",
                "name": "dt",
                "value": "2025-12-21"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-22 09:26:58",
                    "last_data": "2025-12-22 09:38:54"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305149,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-22",
                "name": "dt",
                "value": "2025-12-22"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-23 09:28:09",
                    "last_data": "2025-12-24 09:40:13"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305223,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-23",
                "name": "dt",
                "value": "2025-12-23"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-24 09:40:05",
                    "last_data": "2025-12-25 09:30:08"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305259,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-24/",
                "name": "dt",
                "value": "2025-12-24"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-25 09:30:18",
                    "last_data": "2025-12-25 09:30:18"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305311,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-25",
                "name": "dt",
                "value": "2025-12-25"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-26 09:26:24",
                    "last_data": "2025-12-26 09:42:50"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305414,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-26",
                "name": "dt",
                "value": "2025-12-26"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-27 09:40:14",
                    "last_data": "2025-12-27 09:43:03"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305483,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-27",
                "name": "dt",
                "value": "2025-12-27"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-28 09:40:55",
                    "last_data": "2025-12-29 09:31:38"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 305553,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-28",
                "name": "dt",
                "value": "2025-12-28"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-29 09:31:40",
                    "last_data": "2025-12-30 09:28:30"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 306888,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-29",
                "name": "dt",
                "value": "2025-12-29"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-30 09:29:36",
                    "last_data": "2025-12-31 09:42:49"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 306958,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-30",
                "name": "dt",
                "value": "2025-12-30"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2025-12-31 09:43:43",
                    "last_data": "2026-01-01 09:45:17"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307021,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-31/",
                "name": "dt",
                "value": "2025-12-31"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-01 09:46:29",
                    "last_data": "2026-01-01 09:46:29"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307035,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-01",
                "name": "dt",
                "value": "2026-01-01"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-02 09:26:06",
                    "last_data": "2026-01-02 09:43:46"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307119,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-02",
                "name": "dt",
                "value": "2026-01-02"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-03 09:31:36",
                    "last_data": "2026-01-04 09:35:04"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307196,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-03/",
                "name": "dt",
                "value": "2026-01-03"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-04 09:35:18",
                    "last_data": "2026-01-04 09:35:18"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307251,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-04",
                "name": "dt",
                "value": "2026-01-04"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-05 09:31:18",
                    "last_data": "2026-01-05 09:41:36"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307317,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-05",
                "name": "dt",
                "value": "2026-01-05"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-06 09:29:49",
                    "last_data": "2026-01-07 09:30:57"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307380,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-06/",
                "name": "dt",
                "value": "2026-01-06"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-07 09:30:43",
                    "last_data": "2026-01-07 09:30:43"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307447,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-07",
                "name": "dt",
                "value": "2026-01-07"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-08 09:29:31",
                    "last_data": "2026-01-09 09:32:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307540,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-08",
                "name": "dt",
                "value": "2026-01-08"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-09 09:45:54",
                    "last_data": "2026-01-10 09:43:31"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307604,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-09/",
                "name": "dt",
                "value": "2026-01-09"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-10 09:43:27",
                    "last_data": "2026-01-10 09:43:27"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307637,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-10",
                "name": "dt",
                "value": "2026-01-10"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-11 09:29:20",
                    "last_data": "2026-01-11 09:40:17"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307721,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-11",
                "name": "dt",
                "value": "2026-01-11"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-12 09:40:15",
                    "last_data": "2026-01-12 09:41:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307770,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-12",
                "name": "dt",
                "value": "2026-01-12"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-13 09:28:37",
                    "last_data": "2026-01-13 09:28:44"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307856,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-13",
                "name": "dt",
                "value": "2026-01-13"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-14 09:42:17",
                    "last_data": "2026-01-14 09:45:19"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307924,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-14",
                "name": "dt",
                "value": "2026-01-14"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-15 09:31:29",
                    "last_data": "2026-01-16 09:41:54"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 307989,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-15",
                "name": "dt",
                "value": "2026-01-15"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-16 09:46:40",
                    "last_data": "2026-01-17 09:44:25"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308049,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-16/",
                "name": "dt",
                "value": "2026-01-16"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-17 09:45:29",
                    "last_data": "2026-01-17 09:45:29"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308062,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-17",
                "name": "dt",
                "value": "2026-01-17"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-18 09:27:00",
                    "last_data": "2026-01-18 09:30:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308133,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-18",
                "name": "dt",
                "value": "2026-01-18"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-19 09:26:41",
                    "last_data": "2026-01-19 09:26:58"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308218,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-19",
                "name": "dt",
                "value": "2026-01-19"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-20 09:42:51",
                    "last_data": "2026-01-21 09:30:45"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308296,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-20/",
                "name": "dt",
                "value": "2026-01-20"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-21 09:38:21",
                    "last_data": "2026-01-21 09:38:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308469,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-21",
                "name": "dt",
                "value": "2026-01-21"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-22 09:42:13",
                    "last_data": "2026-01-23 09:27:12"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308505,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-22/",
                "name": "dt",
                "value": "2026-01-22"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-23 09:28:50",
                    "last_data": "2026-01-23 09:28:50"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308583,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-23",
                "name": "dt",
                "value": "2026-01-23"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-24 09:28:15",
                    "last_data": "2026-01-24 09:29:50"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308671,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-24",
                "name": "dt",
                "value": "2026-01-24"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-25 09:41:49",
                    "last_data": "2026-01-26 09:40:50"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308741,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-25",
                "name": "dt",
                "value": "2026-01-25"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-26 09:44:17",
                    "last_data": "2026-01-27 09:28:30"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308781,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-26",
                "name": "dt",
                "value": "2026-01-26"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-27 09:28:36",
                    "last_data": "2026-01-28 09:30:00"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308854,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-27/",
                "name": "dt",
                "value": "2026-01-27"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-28 09:30:06",
                    "last_data": "2026-01-28 09:30:06"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308929,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-28",
                "name": "dt",
                "value": "2026-01-28"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-29 09:41:04",
                    "last_data": "2026-01-29 09:44:31"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 308961,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-29",
                "name": "dt",
                "value": "2026-01-29"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-30 09:27:49",
                    "last_data": "2026-01-30 09:30:52"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309055,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-30",
                "name": "dt",
                "value": "2026-01-30"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-01-31 09:42:25",
                    "last_data": "2026-01-31 09:43:09"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309117,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-31",
                "name": "dt",
                "value": "2026-01-31"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-01 09:47:08",
                    "last_data": "2026-02-01 09:47:20"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309167,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-01",
                "name": "dt",
                "value": "2026-02-01"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-02 09:33:23",
                    "last_data": "2026-02-03 09:33:31"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309228,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-02/",
                "name": "dt",
                "value": "2026-02-02"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-03 09:34:11",
                    "last_data": "2026-02-03 09:34:11"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309270,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-03",
                "name": "dt",
                "value": "2026-02-03"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-04 09:28:43",
                    "last_data": "2026-02-04 09:33:02"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309357,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-04",
                "name": "dt",
                "value": "2026-02-04"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-05 09:31:59",
                    "last_data": "2026-02-06 09:27:31"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309441,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-05",
                "name": "dt",
                "value": "2026-02-05"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-06 09:46:05",
                    "last_data": "2026-02-07 09:29:07"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309487,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-06/",
                "name": "dt",
                "value": "2026-02-06"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-07 09:30:51",
                    "last_data": "2026-02-07 09:30:51"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309524,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-07",
                "name": "dt",
                "value": "2026-02-07"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-08 09:25:45",
                    "last_data": "2026-02-09 09:29:58"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309629,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-08",
                "name": "dt",
                "value": "2026-02-08"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-09 09:39:55",
                    "last_data": "2026-02-10 09:27:37"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309671,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-09/",
                "name": "dt",
                "value": "2026-02-09"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-10 09:27:33",
                    "last_data": "2026-02-10 09:27:33"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309735,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-10",
                "name": "dt",
                "value": "2026-02-10"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-11 09:30:10",
                    "last_data": "2026-02-12 09:27:49"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309826,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-11",
                "name": "dt",
                "value": "2026-02-11"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-12 09:41:39",
                    "last_data": "2026-02-13 09:45:15"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309889,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-12",
                "name": "dt",
                "value": "2026-02-12"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-13 09:47:41",
                    "last_data": "2026-02-14 09:40:45"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 309946,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-13/",
                "name": "dt",
                "value": "2026-02-13"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-14 09:41:07",
                    "last_data": "2026-02-14 09:41:07"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310007,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-14",
                "name": "dt",
                "value": "2026-02-14"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-15 09:41:38",
                    "last_data": "2026-02-15 09:42:33"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310063,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-15",
                "name": "dt",
                "value": "2026-02-15"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-16 09:31:27",
                    "last_data": "2026-02-16 09:31:34"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310202,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-16",
                "name": "dt",
                "value": "2026-02-16"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-17 09:30:34",
                    "last_data": "2026-02-17 09:43:58"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310266,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-17",
                "name": "dt",
                "value": "2026-02-17"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-18 09:33:36",
                    "last_data": "2026-02-18 09:47:14"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310335,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-18",
                "name": "dt",
                "value": "2026-02-18"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-19 09:32:36",
                    "last_data": "2026-02-19 09:44:30"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310412,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-19",
                "name": "dt",
                "value": "2026-02-19"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-20 09:42:28",
                    "last_data": "2026-02-20 09:42:48"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310466,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-20",
                "name": "dt",
                "value": "2026-02-20"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-21 09:28:37",
                    "last_data": "2026-02-22 09:44:20"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310546,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-21/",
                "name": "dt",
                "value": "2026-02-21"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-22 09:45:21",
                    "last_data": "2026-02-22 09:45:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310591,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-22",
                "name": "dt",
                "value": "2026-02-22"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-23 09:28:57",
                    "last_data": "2026-02-23 09:29:39"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310663,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-23",
                "name": "dt",
                "value": "2026-02-23"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-24 09:31:19",
                    "last_data": "2026-02-25 09:27:01"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310742,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-24",
                "name": "dt",
                "value": "2026-02-24"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-25 09:45:53",
                    "last_data": "2026-02-26 09:41:11"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310795,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-25/",
                "name": "dt",
                "value": "2026-02-25"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-26 09:41:07",
                    "last_data": "2026-02-26 09:41:07"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310870,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-26",
                "name": "dt",
                "value": "2026-02-26"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-27 09:43:25",
                    "last_data": "2026-02-28 09:29:27"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310901,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-27/",
                "name": "dt",
                "value": "2026-02-27"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-02-28 09:31:39",
                    "last_data": "2026-02-28 09:31:39"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 310973,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-28",
                "name": "dt",
                "value": "2026-02-28"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-01 09:32:39",
                    "last_data": "2026-03-02 09:35:14"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311049,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-01/",
                "name": "dt",
                "value": "2026-03-01"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-02 09:41:08",
                    "last_data": "2026-03-02 09:41:08"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311112,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-02",
                "name": "dt",
                "value": "2026-03-02"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-03 09:49:56",
                    "last_data": "2026-03-03 09:52:52"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311164,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-03",
                "name": "dt",
                "value": "2026-03-03"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-04 09:35:11",
                    "last_data": "2026-03-04 09:41:53"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311229,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-04",
                "name": "dt",
                "value": "2026-03-04"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-05 09:30:35",
                    "last_data": "2026-03-06 09:42:39"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311300,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-05/",
                "name": "dt",
                "value": "2026-03-05"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-06 09:43:05",
                    "last_data": "2026-03-06 09:43:05"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311362,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-06",
                "name": "dt",
                "value": "2026-03-06"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-07 09:40:43",
                    "last_data": "2026-03-07 09:44:52"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311403,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-07",
                "name": "dt",
                "value": "2026-03-07"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-08 09:28:22",
                    "last_data": "2026-03-09 09:28:11"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311489,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-08",
                "name": "dt",
                "value": "2026-03-08"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-09 09:42:23",
                    "last_data": "2026-03-10 09:31:17"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311571,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-09/",
                "name": "dt",
                "value": "2026-03-09"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-10 09:31:20",
                    "last_data": "2026-03-10 09:31:20"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311607,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-10",
                "name": "dt",
                "value": "2026-03-10"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-11 09:28:41",
                    "last_data": "2026-03-11 09:29:06"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311680,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-11",
                "name": "dt",
                "value": "2026-03-11"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-12 09:28:34",
                    "last_data": "2026-03-13 09:30:49"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311771,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-12",
                "name": "dt",
                "value": "2026-03-12"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-13 09:46:17",
                    "last_data": "2026-03-14 09:32:01"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311799,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-13/",
                "name": "dt",
                "value": "2026-03-13"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-14 09:32:02",
                    "last_data": "2026-03-14 09:32:02"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311889,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-14",
                "name": "dt",
                "value": "2026-03-14"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-15 09:45:25",
                    "last_data": "2026-03-16 09:28:46"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 311931,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-15",
                "name": "dt",
                "value": "2026-03-15"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-16 09:29:04",
                    "last_data": "2026-03-17 09:31:07"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312056,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-16/",
                "name": "dt",
                "value": "2026-03-16"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-17 09:31:27",
                    "last_data": "2026-03-17 09:31:27"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312115,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-17",
                "name": "dt",
                "value": "2026-03-17"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-18 09:40:34",
                    "last_data": "2026-03-18 09:43:46"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312143,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-18",
                "name": "dt",
                "value": "2026-03-18"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-19 09:26:49",
                    "last_data": "2026-03-19 09:45:01"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312224,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-19",
                "name": "dt",
                "value": "2026-03-19"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-20 09:28:30",
                    "last_data": "2026-03-21 09:42:22"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312326,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-20/",
                "name": "dt",
                "value": "2026-03-20"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-21 09:44:58",
                    "last_data": "2026-03-21 09:44:58"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312356,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-21",
                "name": "dt",
                "value": "2026-03-21"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-22 09:29:43",
                    "last_data": "2026-03-22 09:39:21"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312421,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-22",
                "name": "dt",
                "value": "2026-03-22"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-23 09:30:02",
                    "last_data": "2026-03-23 09:30:06"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312516,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-23",
                "name": "dt",
                "value": "2026-03-23"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-24 09:42:41",
                    "last_data": "2026-03-24 09:42:45"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312572,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-24",
                "name": "dt",
                "value": "2026-03-24"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-25 09:42:56",
                    "last_data": "2026-03-25 09:43:56"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312615,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-25",
                "name": "dt",
                "value": "2026-03-25"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-26 09:32:52",
                    "last_data": "2026-03-26 09:32:55"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312673,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-26",
                "name": "dt",
                "value": "2026-03-26"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-27 09:29:02",
                    "last_data": "2026-03-27 09:46:51"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312745,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-27",
                "name": "dt",
                "value": "2026-03-27"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-28 09:43:49",
                    "last_data": "2026-03-28 09:44:33"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312816,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-28",
                "name": "dt",
                "value": "2026-03-28"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-29 09:29:01",
                    "last_data": "2026-03-29 09:29:05"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312845,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-29",
                "name": "dt",
                "value": "2026-03-29"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-30 09:25:12",
                    "last_data": "2026-03-31 09:28:59"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 312932,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-30",
                "name": "dt",
                "value": "2026-03-30"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-03-31 09:28:50",
                    "last_data": "2026-04-01 09:40:35"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313015,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-31/",
                "name": "dt",
                "value": "2026-03-31"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-01 09:42:01",
                    "last_data": "2026-04-01 09:42:01"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313037,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-01",
                "name": "dt",
                "value": "2026-04-01"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-02 09:28:56",
                    "last_data": "2026-04-03 09:34:02"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313133,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-02",
                "name": "dt",
                "value": "2026-04-02"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-03 09:35:19",
                    "last_data": "2026-04-04 09:52:48"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313206,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-03/",
                "name": "dt",
                "value": "2026-04-03"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-04 09:52:49",
                    "last_data": "2026-04-04 09:52:49"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313268,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-04",
                "name": "dt",
                "value": "2026-04-04"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-05 09:45:11",
                    "last_data": "2026-04-05 09:45:59"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313308,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-05",
                "name": "dt",
                "value": "2026-04-05"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-06 09:34:07",
                    "last_data": "2026-04-07 09:30:05"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313412,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-06",
                "name": "dt",
                "value": "2026-04-06"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-07 09:49:52",
                    "last_data": "2026-04-08 09:27:32"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313436,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-07/",
                "name": "dt",
                "value": "2026-04-07"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-08 09:29:19",
                    "last_data": "2026-04-08 09:29:19"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313535,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-08",
                "name": "dt",
                "value": "2026-04-08"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-09 09:47:18",
                    "last_data": "2026-04-10 09:29:11"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313600,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-09",
                "name": "dt",
                "value": "2026-04-09"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-10 09:42:40",
                    "last_data": "2026-04-11 09:30:34"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313631,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-10",
                "name": "dt",
                "value": "2026-04-10"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-11 09:29:51",
                    "last_data": "2026-04-12 09:30:11"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313699,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-11",
                "name": "dt",
                "value": "2026-04-11"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-12 09:30:32",
                    "last_data": "2026-04-13 09:49:19"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313790,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-12",
                "name": "dt",
                "value": "2026-04-12"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-13 09:49:49",
                    "last_data": "2026-04-14 10:05:26"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313855,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-13",
                "name": "dt",
                "value": "2026-04-13"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-14 10:05:32",
                    "last_data": "2026-04-15 10:00:56"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313915,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-14/",
                "name": "dt",
                "value": "2026-04-14"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-15 10:02:59",
                    "last_data": "2026-04-15 10:02:59"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 313964,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15",
                "name": "dt",
                "value": "2026-04-15"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-16 09:35:36",
                    "last_data": "2026-04-16 09:35:41"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        },
        {
            "info": {
                "id": 314028,
                "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16",
                "name": "dt",
                "value": "2026-04-16"
            },
            "state": {
                "arrival": {
                    "athena_discovery": true,
                    "first_data": "2026-04-17 09:48:14",
                    "last_data": "2026-04-17 09:51:42"
                },
                "parquet": {
                    "first_performed": null,
                    "in_progress": null,
                    "job_id": null,
                    "last_performed": null,
                    "queued": false
                }
            }
        }
    ]
  • type: string
Schema:
  • attributes:
    {
        "captured": "string",
        "card_brand": "string",
        "card_type": "string",
        "created": "string",
        "division": "string",
        "entity": "string",
        "funded": "string",
        "merchant": "string",
        "platform": "string",
        "settled": "string",
        "txn_approved_sum": "string",
        "txn_count": "string",
        "txn_ref": "string",
        "txn_settled_sum": "string",
        "txn_status": "string",
        "txn_type": "string"
    }
  • created: 2024-07-22 12:22:38
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_aggregated_txns_by_date`\n(\n `created`  string , `captured`  string , `settled`  string , `funded`  string , `txn_type`  string , `card_type`  string , `card_brand`  string , `merchant`  string , `platform`  string , `txn_ref`  string , `txn_status`  string , `entity`  string , `division`  string , `txn_count`  string , `txn_approved_sum`  string , `txn_settled_sum`  string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_aggregated_txns_by_date`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_aggregated_txns_by_date"
    }
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw:
{
    "name": {
        "created": "2024-07-22 12:22:37",
        "disabled": false,
        "format": "raw",
        "id": 2335,
        "is_partitioned": true,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_aggregated_txns_by_date"
        },
        "type": "csv"
    },
    "partition": {
        "count": 130,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_csv.payrixess_aggregated_txns_by_date`\nADD\n\n\n PARTITION (dt='2025-12-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-22'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-30'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-05'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-14'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-26'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-29'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-31'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-17'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-25/'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-10'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-12'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-13/'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-14'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-16/'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-26'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-30'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-31/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-02'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-11'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 304273,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-08/",
                    "name": "dt",
                    "value": "2025-12-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-10 09:27:46",
                        "last_data": "2025-12-10 09:27:46"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304305,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-09",
                    "name": "dt",
                    "value": "2025-12-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-10 09:40:51",
                        "last_data": "2025-12-11 09:31:29"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304372,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-10",
                    "name": "dt",
                    "value": "2025-12-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-11 09:32:21",
                        "last_data": "2025-12-12 09:43:24"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304463,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-11/",
                    "name": "dt",
                    "value": "2025-12-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-12 09:44:47",
                        "last_data": "2025-12-12 09:44:47"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304502,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-12",
                    "name": "dt",
                    "value": "2025-12-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-13 09:29:19",
                        "last_data": "2025-12-13 09:29:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304577,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-13",
                    "name": "dt",
                    "value": "2025-12-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-14 09:43:40",
                        "last_data": "2025-12-14 09:43:44"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304606,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-14",
                    "name": "dt",
                    "value": "2025-12-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-15 09:26:49",
                        "last_data": "2025-12-15 09:28:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304686,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-15",
                    "name": "dt",
                    "value": "2025-12-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-16 09:29:38",
                        "last_data": "2025-12-16 09:29:42"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304774,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-16",
                    "name": "dt",
                    "value": "2025-12-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-17 09:40:24",
                        "last_data": "2025-12-17 09:44:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304806,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-17",
                    "name": "dt",
                    "value": "2025-12-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-18 09:27:02",
                        "last_data": "2025-12-18 09:28:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304900,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-18",
                    "name": "dt",
                    "value": "2025-12-18"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-19 09:40:31",
                        "last_data": "2025-12-19 09:42:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 304948,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-19",
                    "name": "dt",
                    "value": "2025-12-19"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-20 09:32:21",
                        "last_data": "2025-12-21 09:27:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305038,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-20/",
                    "name": "dt",
                    "value": "2025-12-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-21 09:47:23",
                        "last_data": "2025-12-21 09:47:23"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305062,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-21",
                    "name": "dt",
                    "value": "2025-12-21"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-22 09:26:58",
                        "last_data": "2025-12-22 09:38:54"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305149,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-22",
                    "name": "dt",
                    "value": "2025-12-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-23 09:28:09",
                        "last_data": "2025-12-24 09:40:13"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305223,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-23",
                    "name": "dt",
                    "value": "2025-12-23"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-24 09:40:05",
                        "last_data": "2025-12-25 09:30:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305259,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-24/",
                    "name": "dt",
                    "value": "2025-12-24"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-25 09:30:18",
                        "last_data": "2025-12-25 09:30:18"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305311,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-25",
                    "name": "dt",
                    "value": "2025-12-25"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-26 09:26:24",
                        "last_data": "2025-12-26 09:42:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305414,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-26",
                    "name": "dt",
                    "value": "2025-12-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-27 09:40:14",
                        "last_data": "2025-12-27 09:43:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305483,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-27",
                    "name": "dt",
                    "value": "2025-12-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-28 09:40:55",
                        "last_data": "2025-12-29 09:31:38"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 305553,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-28",
                    "name": "dt",
                    "value": "2025-12-28"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-29 09:31:40",
                        "last_data": "2025-12-30 09:28:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 306888,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-29",
                    "name": "dt",
                    "value": "2025-12-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-30 09:29:36",
                        "last_data": "2025-12-31 09:42:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 306958,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-30",
                    "name": "dt",
                    "value": "2025-12-30"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-31 09:43:43",
                        "last_data": "2026-01-01 09:45:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307021,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2025-12-31/",
                    "name": "dt",
                    "value": "2025-12-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-01 09:46:29",
                        "last_data": "2026-01-01 09:46:29"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307035,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-01",
                    "name": "dt",
                    "value": "2026-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-02 09:26:06",
                        "last_data": "2026-01-02 09:43:46"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307119,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-02",
                    "name": "dt",
                    "value": "2026-01-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-03 09:31:36",
                        "last_data": "2026-01-04 09:35:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307196,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-03/",
                    "name": "dt",
                    "value": "2026-01-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-04 09:35:18",
                        "last_data": "2026-01-04 09:35:18"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307251,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-04",
                    "name": "dt",
                    "value": "2026-01-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-05 09:31:18",
                        "last_data": "2026-01-05 09:41:36"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307317,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-05",
                    "name": "dt",
                    "value": "2026-01-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-06 09:29:49",
                        "last_data": "2026-01-07 09:30:57"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307380,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-06/",
                    "name": "dt",
                    "value": "2026-01-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-07 09:30:43",
                        "last_data": "2026-01-07 09:30:43"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307447,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-07",
                    "name": "dt",
                    "value": "2026-01-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-08 09:29:31",
                        "last_data": "2026-01-09 09:32:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307540,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-08",
                    "name": "dt",
                    "value": "2026-01-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-09 09:45:54",
                        "last_data": "2026-01-10 09:43:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307604,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-09/",
                    "name": "dt",
                    "value": "2026-01-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-10 09:43:27",
                        "last_data": "2026-01-10 09:43:27"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307637,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-10",
                    "name": "dt",
                    "value": "2026-01-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-11 09:29:20",
                        "last_data": "2026-01-11 09:40:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307721,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-11",
                    "name": "dt",
                    "value": "2026-01-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-12 09:40:15",
                        "last_data": "2026-01-12 09:41:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307770,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-12",
                    "name": "dt",
                    "value": "2026-01-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-13 09:28:37",
                        "last_data": "2026-01-13 09:28:44"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307856,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-13",
                    "name": "dt",
                    "value": "2026-01-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-14 09:42:17",
                        "last_data": "2026-01-14 09:45:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307924,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-14",
                    "name": "dt",
                    "value": "2026-01-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-15 09:31:29",
                        "last_data": "2026-01-16 09:41:54"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 307989,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-15",
                    "name": "dt",
                    "value": "2026-01-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-16 09:46:40",
                        "last_data": "2026-01-17 09:44:25"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308049,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-16/",
                    "name": "dt",
                    "value": "2026-01-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-17 09:45:29",
                        "last_data": "2026-01-17 09:45:29"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308062,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-17",
                    "name": "dt",
                    "value": "2026-01-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-18 09:27:00",
                        "last_data": "2026-01-18 09:30:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308133,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-18",
                    "name": "dt",
                    "value": "2026-01-18"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-19 09:26:41",
                        "last_data": "2026-01-19 09:26:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308218,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-19",
                    "name": "dt",
                    "value": "2026-01-19"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-20 09:42:51",
                        "last_data": "2026-01-21 09:30:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308296,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-20/",
                    "name": "dt",
                    "value": "2026-01-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-21 09:38:21",
                        "last_data": "2026-01-21 09:38:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308469,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-21",
                    "name": "dt",
                    "value": "2026-01-21"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-22 09:42:13",
                        "last_data": "2026-01-23 09:27:12"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308505,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-22/",
                    "name": "dt",
                    "value": "2026-01-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-23 09:28:50",
                        "last_data": "2026-01-23 09:28:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308583,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-23",
                    "name": "dt",
                    "value": "2026-01-23"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-24 09:28:15",
                        "last_data": "2026-01-24 09:29:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308671,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-24",
                    "name": "dt",
                    "value": "2026-01-24"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-25 09:41:49",
                        "last_data": "2026-01-26 09:40:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308741,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-25",
                    "name": "dt",
                    "value": "2026-01-25"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-26 09:44:17",
                        "last_data": "2026-01-27 09:28:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308781,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-26",
                    "name": "dt",
                    "value": "2026-01-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-27 09:28:36",
                        "last_data": "2026-01-28 09:30:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308854,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-27/",
                    "name": "dt",
                    "value": "2026-01-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-28 09:30:06",
                        "last_data": "2026-01-28 09:30:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308929,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-28",
                    "name": "dt",
                    "value": "2026-01-28"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-29 09:41:04",
                        "last_data": "2026-01-29 09:44:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 308961,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-29",
                    "name": "dt",
                    "value": "2026-01-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-30 09:27:49",
                        "last_data": "2026-01-30 09:30:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309055,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-30",
                    "name": "dt",
                    "value": "2026-01-30"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-31 09:42:25",
                        "last_data": "2026-01-31 09:43:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309117,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-01-31",
                    "name": "dt",
                    "value": "2026-01-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-01 09:47:08",
                        "last_data": "2026-02-01 09:47:20"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309167,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-01",
                    "name": "dt",
                    "value": "2026-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-02 09:33:23",
                        "last_data": "2026-02-03 09:33:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309228,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-02/",
                    "name": "dt",
                    "value": "2026-02-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-03 09:34:11",
                        "last_data": "2026-02-03 09:34:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309270,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-03",
                    "name": "dt",
                    "value": "2026-02-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-04 09:28:43",
                        "last_data": "2026-02-04 09:33:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309357,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-04",
                    "name": "dt",
                    "value": "2026-02-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-05 09:31:59",
                        "last_data": "2026-02-06 09:27:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309441,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-05",
                    "name": "dt",
                    "value": "2026-02-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-06 09:46:05",
                        "last_data": "2026-02-07 09:29:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309487,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-06/",
                    "name": "dt",
                    "value": "2026-02-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-07 09:30:51",
                        "last_data": "2026-02-07 09:30:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309524,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-07",
                    "name": "dt",
                    "value": "2026-02-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-08 09:25:45",
                        "last_data": "2026-02-09 09:29:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309629,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-08",
                    "name": "dt",
                    "value": "2026-02-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-09 09:39:55",
                        "last_data": "2026-02-10 09:27:37"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309671,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-09/",
                    "name": "dt",
                    "value": "2026-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-10 09:27:33",
                        "last_data": "2026-02-10 09:27:33"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309735,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-10",
                    "name": "dt",
                    "value": "2026-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-11 09:30:10",
                        "last_data": "2026-02-12 09:27:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309826,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-11",
                    "name": "dt",
                    "value": "2026-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-12 09:41:39",
                        "last_data": "2026-02-13 09:45:15"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309889,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-12",
                    "name": "dt",
                    "value": "2026-02-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-13 09:47:41",
                        "last_data": "2026-02-14 09:40:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 309946,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-13/",
                    "name": "dt",
                    "value": "2026-02-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-14 09:41:07",
                        "last_data": "2026-02-14 09:41:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310007,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-14",
                    "name": "dt",
                    "value": "2026-02-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-15 09:41:38",
                        "last_data": "2026-02-15 09:42:33"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310063,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-15",
                    "name": "dt",
                    "value": "2026-02-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-16 09:31:27",
                        "last_data": "2026-02-16 09:31:34"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310202,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-16",
                    "name": "dt",
                    "value": "2026-02-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-17 09:30:34",
                        "last_data": "2026-02-17 09:43:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310266,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-17",
                    "name": "dt",
                    "value": "2026-02-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-18 09:33:36",
                        "last_data": "2026-02-18 09:47:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310335,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-18",
                    "name": "dt",
                    "value": "2026-02-18"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-19 09:32:36",
                        "last_data": "2026-02-19 09:44:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310412,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-19",
                    "name": "dt",
                    "value": "2026-02-19"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-20 09:42:28",
                        "last_data": "2026-02-20 09:42:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310466,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-20",
                    "name": "dt",
                    "value": "2026-02-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-21 09:28:37",
                        "last_data": "2026-02-22 09:44:20"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310546,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-21/",
                    "name": "dt",
                    "value": "2026-02-21"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-22 09:45:21",
                        "last_data": "2026-02-22 09:45:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310591,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-22",
                    "name": "dt",
                    "value": "2026-02-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-23 09:28:57",
                        "last_data": "2026-02-23 09:29:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310663,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-23",
                    "name": "dt",
                    "value": "2026-02-23"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-24 09:31:19",
                        "last_data": "2026-02-25 09:27:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310742,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-24",
                    "name": "dt",
                    "value": "2026-02-24"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-25 09:45:53",
                        "last_data": "2026-02-26 09:41:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310795,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-25/",
                    "name": "dt",
                    "value": "2026-02-25"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-26 09:41:07",
                        "last_data": "2026-02-26 09:41:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310870,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-26",
                    "name": "dt",
                    "value": "2026-02-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-27 09:43:25",
                        "last_data": "2026-02-28 09:29:27"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310901,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-27/",
                    "name": "dt",
                    "value": "2026-02-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-28 09:31:39",
                        "last_data": "2026-02-28 09:31:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 310973,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-02-28",
                    "name": "dt",
                    "value": "2026-02-28"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-01 09:32:39",
                        "last_data": "2026-03-02 09:35:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311049,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-01/",
                    "name": "dt",
                    "value": "2026-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-02 09:41:08",
                        "last_data": "2026-03-02 09:41:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311112,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-02",
                    "name": "dt",
                    "value": "2026-03-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-03 09:49:56",
                        "last_data": "2026-03-03 09:52:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311164,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-03",
                    "name": "dt",
                    "value": "2026-03-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-04 09:35:11",
                        "last_data": "2026-03-04 09:41:53"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311229,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-04",
                    "name": "dt",
                    "value": "2026-03-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-05 09:30:35",
                        "last_data": "2026-03-06 09:42:39"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311300,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-05/",
                    "name": "dt",
                    "value": "2026-03-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-06 09:43:05",
                        "last_data": "2026-03-06 09:43:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311362,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-06",
                    "name": "dt",
                    "value": "2026-03-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-07 09:40:43",
                        "last_data": "2026-03-07 09:44:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311403,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-07",
                    "name": "dt",
                    "value": "2026-03-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-08 09:28:22",
                        "last_data": "2026-03-09 09:28:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311489,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-08",
                    "name": "dt",
                    "value": "2026-03-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-09 09:42:23",
                        "last_data": "2026-03-10 09:31:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311571,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-09/",
                    "name": "dt",
                    "value": "2026-03-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-10 09:31:20",
                        "last_data": "2026-03-10 09:31:20"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311607,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-10",
                    "name": "dt",
                    "value": "2026-03-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-11 09:28:41",
                        "last_data": "2026-03-11 09:29:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311680,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-11",
                    "name": "dt",
                    "value": "2026-03-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-12 09:28:34",
                        "last_data": "2026-03-13 09:30:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311771,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-12",
                    "name": "dt",
                    "value": "2026-03-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-13 09:46:17",
                        "last_data": "2026-03-14 09:32:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311799,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-13/",
                    "name": "dt",
                    "value": "2026-03-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-14 09:32:02",
                        "last_data": "2026-03-14 09:32:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311889,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-14",
                    "name": "dt",
                    "value": "2026-03-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-15 09:45:25",
                        "last_data": "2026-03-16 09:28:46"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 311931,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-15",
                    "name": "dt",
                    "value": "2026-03-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-16 09:29:04",
                        "last_data": "2026-03-17 09:31:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312056,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-16/",
                    "name": "dt",
                    "value": "2026-03-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-17 09:31:27",
                        "last_data": "2026-03-17 09:31:27"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312115,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-17",
                    "name": "dt",
                    "value": "2026-03-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-18 09:40:34",
                        "last_data": "2026-03-18 09:43:46"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312143,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-18",
                    "name": "dt",
                    "value": "2026-03-18"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-19 09:26:49",
                        "last_data": "2026-03-19 09:45:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312224,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-19",
                    "name": "dt",
                    "value": "2026-03-19"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-20 09:28:30",
                        "last_data": "2026-03-21 09:42:22"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312326,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-20/",
                    "name": "dt",
                    "value": "2026-03-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-21 09:44:58",
                        "last_data": "2026-03-21 09:44:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312356,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-21",
                    "name": "dt",
                    "value": "2026-03-21"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-22 09:29:43",
                        "last_data": "2026-03-22 09:39:21"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312421,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-22",
                    "name": "dt",
                    "value": "2026-03-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-23 09:30:02",
                        "last_data": "2026-03-23 09:30:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312516,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-23",
                    "name": "dt",
                    "value": "2026-03-23"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-24 09:42:41",
                        "last_data": "2026-03-24 09:42:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312572,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-24",
                    "name": "dt",
                    "value": "2026-03-24"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-25 09:42:56",
                        "last_data": "2026-03-25 09:43:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312615,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-25",
                    "name": "dt",
                    "value": "2026-03-25"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-26 09:32:52",
                        "last_data": "2026-03-26 09:32:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312673,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-26",
                    "name": "dt",
                    "value": "2026-03-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-27 09:29:02",
                        "last_data": "2026-03-27 09:46:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312745,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-27",
                    "name": "dt",
                    "value": "2026-03-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-28 09:43:49",
                        "last_data": "2026-03-28 09:44:33"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312816,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-28",
                    "name": "dt",
                    "value": "2026-03-28"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-29 09:29:01",
                        "last_data": "2026-03-29 09:29:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312845,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-29",
                    "name": "dt",
                    "value": "2026-03-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-30 09:25:12",
                        "last_data": "2026-03-31 09:28:59"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 312932,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-30",
                    "name": "dt",
                    "value": "2026-03-30"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-31 09:28:50",
                        "last_data": "2026-04-01 09:40:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313015,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-03-31/",
                    "name": "dt",
                    "value": "2026-03-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-01 09:42:01",
                        "last_data": "2026-04-01 09:42:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313037,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-01",
                    "name": "dt",
                    "value": "2026-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-02 09:28:56",
                        "last_data": "2026-04-03 09:34:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313133,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-02",
                    "name": "dt",
                    "value": "2026-04-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-03 09:35:19",
                        "last_data": "2026-04-04 09:52:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313206,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-03/",
                    "name": "dt",
                    "value": "2026-04-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-04 09:52:49",
                        "last_data": "2026-04-04 09:52:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313268,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-04",
                    "name": "dt",
                    "value": "2026-04-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-05 09:45:11",
                        "last_data": "2026-04-05 09:45:59"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313308,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-05",
                    "name": "dt",
                    "value": "2026-04-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-06 09:34:07",
                        "last_data": "2026-04-07 09:30:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313412,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-06",
                    "name": "dt",
                    "value": "2026-04-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-07 09:49:52",
                        "last_data": "2026-04-08 09:27:32"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313436,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-07/",
                    "name": "dt",
                    "value": "2026-04-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-08 09:29:19",
                        "last_data": "2026-04-08 09:29:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313535,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-08",
                    "name": "dt",
                    "value": "2026-04-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-09 09:47:18",
                        "last_data": "2026-04-10 09:29:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313600,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-09",
                    "name": "dt",
                    "value": "2026-04-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-10 09:42:40",
                        "last_data": "2026-04-11 09:30:34"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313631,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-10",
                    "name": "dt",
                    "value": "2026-04-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-11 09:29:51",
                        "last_data": "2026-04-12 09:30:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313699,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-11",
                    "name": "dt",
                    "value": "2026-04-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-12 09:30:32",
                        "last_data": "2026-04-13 09:49:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313790,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-12",
                    "name": "dt",
                    "value": "2026-04-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-13 09:49:49",
                        "last_data": "2026-04-14 10:05:26"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313855,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-13",
                    "name": "dt",
                    "value": "2026-04-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-14 10:05:32",
                        "last_data": "2026-04-15 10:00:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313915,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-14/",
                    "name": "dt",
                    "value": "2026-04-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-15 10:02:59",
                        "last_data": "2026-04-15 10:02:59"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 313964,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-15",
                    "name": "dt",
                    "value": "2026-04-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-16 09:35:36",
                        "last_data": "2026-04-16 09:35:41"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 314028,
                    "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date/dt=2026-04-16",
                    "name": "dt",
                    "value": "2026-04-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-17 09:48:14",
                        "last_data": "2026-04-17 09:51:42"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "captured": "string",
            "card_brand": "string",
            "card_type": "string",
            "created": "string",
            "division": "string",
            "entity": "string",
            "funded": "string",
            "merchant": "string",
            "platform": "string",
            "settled": "string",
            "txn_approved_sum": "string",
            "txn_count": "string",
            "txn_ref": "string",
            "txn_settled_sum": "string",
            "txn_status": "string",
            "txn_type": "string"
        },
        "created": "2024-07-22 12:22:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_aggregated_txns_by_date`\n(\n `created`  string , `captured`  string , `settled`  string , `funded`  string , `txn_type`  string , `card_type`  string , `card_brand`  string , `merchant`  string , `platform`  string , `txn_ref`  string , `txn_status`  string , `entity`  string , `division`  string , `txn_count`  string , `txn_approved_sum`  string , `txn_settled_sum`  string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw_incremental/aggregated_txns_by_date'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_aggregated_txns_by_date`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_aggregated_txns_by_date"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}