Schema Info
Schema Name: sfdl_dev_csv.payrixess_transaction_details
- created: 2024-07-22 13:08:29
- disabled: False
- format: raw
- id: 2377
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_csv", "table": "payrixess_transaction_details" } - type: csv
Schema Versions: 1
-
Version 4707622
- created: 2024-07-22 13:08:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_transaction_details`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_transaction_details`\n(\n `txn_id` string , `type` string , `created` string , `captured` string , `total` string , `approved` string , `refunded` string , `status` string , `authorization` string , `origin` string , `swiped` string , `emv` string , `company` string , `description` string , `order` string , `zip` string , `funded` string , `creator` string , `txns_first` string , `txns_last` string , `address1` string , `address2` string , `phone` string , `email` string , `imported` string , `city` string , `state` string , `interchange_type` string , `interchange_flatratefee` string , `interchange_percentfee` string , `interchange_feetotal` string , `interchange_issuingbank` string , `discretionary1` string , `discretionary2` string , `discretionary3` string , `entity_id` string , `entity_name` string , `entity_type` string , `division_id` string , `division_name` string , `partition_id` string , `partition_name` string , `username` string , `first` string , `last` string , `parent_division_id` string , `login_id` string , `related_id` string , `merchant_dba` string , `entity_custom` string , `fee_txn_id` string , `entry_entity` string , `txn_cost` string , `txn_cost_refund` string , `txn_fee` string , `txn_fee_refund` string , `facilitator_assessments` string , `merchant_assessments` string , `payrix_fees` string , `payment_id` string , `last4` string , `method` string , `payment_bin` string , `payment_bin_type` 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/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_transaction_details" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details
- id: 4707622
- processed: 1
- raw_data:
{ "address1": 20, "address2": 21, "approved": 5, "authorization": 8, "captured": 3, "city": 25, "company": 12, "created": 2, "creator": 17, "description": 13, "discretionary1": 32, "discretionary2": 33, "discretionary3": 34, "division_id": 38, "division_name": 39, "email": 23, "emv": 11, "entity_custom": 49, "entity_id": 35, "entity_name": 36, "entity_type": 37, "entry_entity": 51, "facilitator_assessments": 56, "fee_txn_id": 50, "first": 43, "funded": 16, "imported": 24, "interchange_feetotal": 30, "interchange_flatratefee": 28, "interchange_issuingbank": 31, "interchange_percentfee": 29, "interchange_type": 27, "last": 44, "last4": 60, "login_id": 46, "merchant_assessments": 57, "merchant_dba": 48, "method": 61, "order": 14, "origin": 9, "parent_division_id": 45, "partition_id": 40, "partition_name": 41, "payment_bin": 62, "payment_bin_type": 63, "payment_id": 59, "payrix_fees": 58, "phone": 22, "refunded": 6, "related_id": 47, "state": 26, "status": 7, "swiped": 10, "total": 4, "txn_cost": 52, "txn_cost_refund": 53, "txn_fee": 54, "txn_fee_refund": 55, "txn_id": 0, "txns_first": 18, "txns_last": 19, "type": 1, "username": 42, "zip": 15 } - schema_attributes:
{ "address1": "string", "address2": "string", "approved": "string", "authorization": "string", "captured": "string", "city": "string", "company": "string", "created": "string", "creator": "string", "description": "string", "discretionary1": "string", "discretionary2": "string", "discretionary3": "string", "division_id": "string", "division_name": "string", "email": "string", "emv": "string", "entity_custom": "string", "entity_id": "string", "entity_name": "string", "entity_type": "string", "entry_entity": "string", "facilitator_assessments": "string", "fee_txn_id": "string", "first": "string", "funded": "string", "imported": "string", "interchange_feetotal": "string", "interchange_flatratefee": "string", "interchange_issuingbank": "string", "interchange_percentfee": "string", "interchange_type": "string", "last": "string", "last4": "string", "login_id": "string", "merchant_assessments": "string", "merchant_dba": "string", "method": "string", "order": "string", "origin": "string", "parent_division_id": "string", "partition_id": "string", "partition_name": "string", "payment_bin": "string", "payment_bin_type": "string", "payment_id": "string", "payrix_fees": "string", "phone": "string", "refunded": "string", "related_id": "string", "state": "string", "status": "string", "swiped": "string", "total": "string", "txn_cost": "string", "txn_cost_refund": "string", "txn_fee": "string", "txn_fee_refund": "string", "txn_id": "string", "txns_first": "string", "txns_last": "string", "type": "string", "username": "string", "zip": "string" } - schema_name_id: 2377
- schema_scan_id: 6543719
- updated: 2024-07-22 13:08:45
Schema Scans: 5
Last at 2026-04-17 09:49:51
-
Scan 6867766
- duration: 0:00:02.302415
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6867766
- 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/transaction_details/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/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-16/9f02ab80-e84d-4d33-b007-c078d8b065ac.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 579552201556157420, "service_name": "drive-thru", "span_id": 13307141342803125635, "trace_id": 12776371791169920297 } } - running: False
- schema_name_id: 2377
- start_time: 2026-04-17 09:49:51
- success: True
- trace_id: 12776371791169920297
-
Scan 6867765
- duration: 0:00:05.095874
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6867765
- 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/transaction_details/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/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-16/9f02ab80-e84d-4d33-b007-c078d8b065ac.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 4084120955015559591, "service_name": "drive-thru", "span_id": 869880614823831902, "trace_id": 7689605761393352997 } } - running: False
- schema_name_id: 2377
- start_time: 2026-04-17 09:49:46
- success: True
- trace_id: 7689605761393352997
-
Scan 6867491
- duration: 0:00:05.199225
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6867491
- 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/transaction_details/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/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-15/4feff5c9-e176-45a7-ad60-b1ab8cd17f6f.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 10933715793289286780, "service_name": "drive-thru", "span_id": 3068994664840205187, "trace_id": 9961284861289729236 } } - running: False
- schema_name_id: 2377
- start_time: 2026-04-16 09:35:19
- success: True
- trace_id: 9961284861289729236
-
Scan 6867486
- duration: 0:00:02.318165
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6867486
- 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/transaction_details/dt=2026-04-14", "name": "dt", "type": "string", "value": "2026-04-14" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-14/5881be78-512d-469b-9ea6-a47297804bf1.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 13926744774178521163, "service_name": "drive-thru", "span_id": 8926615929183978429, "trace_id": 8845808688890962720 } } - running: False
- schema_name_id: 2377
- start_time: 2026-04-16 09:34:58
- success: True
- trace_id: 8845808688890962720
-
Scan 6543719
- duration: 0:00:18.860740
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2, "partitions_applied": false, "success": true } - id: 6543719
- 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/transaction_details/dt=2024-07-20", "name": "dt", "type": "string", "value": "2024-07-20" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2024-07-20/0189fae7-6431-41ec-9867-8c2dd60e890f.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 13185505573043292092, "service_name": "drive-thru", "span_id": 16808026547237433056, "trace_id": 12890921677572615774 } } - running: False
- schema_name_id: 2377
- start_time: 2024-07-22 13:08:29
- success: True
- trace_id: 12890921677572615774
- count: 129
- ddl:
[ "ALTER TABLE\n `sfdl_dev_csv.payrixess_transaction_details`\nADD\n\n\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-20'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-30'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-06'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-27'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-06'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-09'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-17'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-21'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-27'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-01'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-20'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-02'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-07'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-11'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-14'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-16'\n;" ] - name: dt
- state:
[ { "info": { "id": 304268, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-09", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 09:27:28", "last_data": "2025-12-10 09:40:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304366, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-10", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 09:31:05", "last_data": "2025-12-12 09:43:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304462, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 09:44:45", "last_data": "2025-12-12 09:44:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304491, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-12", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 09:28:21", "last_data": "2025-12-13 09:28:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304550, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-13", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 09:28:28", "last_data": "2025-12-15 09:26:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304608, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-14", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 09:27:07", "last_data": "2025-12-16 09:29:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304719, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-15", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 09:44:19", "last_data": "2025-12-17 09:28:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304744, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 09:28:41", "last_data": "2025-12-17 09:28:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304816, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-17", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 09:27:48", "last_data": "2025-12-18 09:27:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304891, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-18", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 09:40:02", "last_data": "2025-12-19 09:40:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304978, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-19", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 09:44:23", "last_data": "2025-12-21 09:42:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305029, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-20", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 09:44:58", "last_data": "2025-12-22 09:26:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305065, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-21", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 09:27:20", "last_data": "2025-12-23 09:27:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305143, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 09:27:37", "last_data": "2025-12-23 09:27:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305207, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-23", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 09:38:55", "last_data": "2025-12-25 09:30:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305270, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 09:32:08", "last_data": "2025-12-25 09:32:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305360, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-25", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 09:41:53", "last_data": "2025-12-26 09:42:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305404, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-26", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 09:38:37", "last_data": "2025-12-27 09:42:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305469, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-27", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 09:38:55", "last_data": "2025-12-29 09:30:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305556, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-28", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 09:32:17", "last_data": "2025-12-30 09:29:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306891, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 09:31:13", "last_data": "2025-12-30 09:31:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306951, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-30", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 09:42:11", "last_data": "2025-12-31 09:42:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306977, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-31", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 09:27:33", "last_data": "2026-01-02 09:26:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307061, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 09:43:43", "last_data": "2026-01-02 09:43:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307110, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-02", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 09:30:47", "last_data": "2026-01-03 09:33:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307206, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-03", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 09:39:07", "last_data": "2026-01-05 09:30:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307252, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-04", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 09:31:29", "last_data": "2026-01-06 09:29:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307321, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 09:30:34", "last_data": "2026-01-06 09:30:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307381, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-06", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 09:30:48", "last_data": "2026-01-07 09:30:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307454, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-07", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 09:30:21", "last_data": "2026-01-08 09:30:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307530, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-08", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 09:32:19", "last_data": "2026-01-10 09:41:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307596, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-09", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 09:42:41", "last_data": "2026-01-11 09:29:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307649, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-10", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 09:40:53", "last_data": "2026-01-12 09:41:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307732, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 09:42:28", "last_data": "2026-01-12 09:42:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307753, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-12", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 09:27:29", "last_data": "2026-01-13 09:27:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307858, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-13", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 09:42:27", "last_data": "2026-01-15 09:29:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307921, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 09:31:00", "last_data": "2026-01-15 09:31:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307978, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-15", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 09:40:56", "last_data": "2026-01-16 09:42:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307997, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-16", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 09:27:05", "last_data": "2026-01-18 09:30:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308103, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-17", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 09:42:27", "last_data": "2026-01-19 09:42:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308161, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-18/", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 09:42:42", "last_data": "2026-01-19 09:42:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308214, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-19", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 09:42:42", "last_data": "2026-01-21 09:30:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308300, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-20", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 09:39:07", "last_data": "2026-01-22 09:41:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308476, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-21", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 09:44:23", "last_data": "2026-01-23 09:45:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308552, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-22", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 09:45:49", "last_data": "2026-01-24 09:43:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308616, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 09:43:37", "last_data": "2026-01-24 09:43:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308628, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-24", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 09:26:55", "last_data": "2026-01-25 09:27:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308715, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-25", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 09:39:17", "last_data": "2026-01-27 09:28:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308782, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/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-27 09:28:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308846, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-27", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 09:29:36", "last_data": "2026-01-28 09:29:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308928, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-28", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 09:40:59", "last_data": "2026-01-30 09:27:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308987, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 09:33:36", "last_data": "2026-01-30 09:33:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309040, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-30", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 09:40:01", "last_data": "2026-02-01 09:45:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309110, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 09:46:02", "last_data": "2026-02-01 09:46:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309159, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-01", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 09:31:40", "last_data": "2026-02-03 09:32:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309232, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 09:37:20", "last_data": "2026-02-03 09:37:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309289, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-03", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 09:33:05", "last_data": "2026-02-05 09:31:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309360, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 09:32:43", "last_data": "2026-02-05 09:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309444, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-05", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 09:46:27", "last_data": "2026-02-06 09:50:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309461, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-06", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 09:27:25", "last_data": "2026-02-08 09:30:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309573, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-07/", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 09:42:30", "last_data": "2026-02-08 09:42:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309614, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-08", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 09:29:52", "last_data": "2026-02-09 09:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309645, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-09", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 09:25:58", "last_data": "2026-02-11 09:27:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309717, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 09:27:40", "last_data": "2026-02-11 09:27:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309773, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-11", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 09:27:10", "last_data": "2026-02-13 09:44:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309885, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-12", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 09:45:33", "last_data": "2026-02-14 09:40:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309949, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 09:41:16", "last_data": "2026-02-14 09:41:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310014, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-14", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 09:44:06", "last_data": "2026-02-16 09:31:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310067, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-15", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 09:32:18", "last_data": "2026-02-17 09:30:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310231, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-16/", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 09:43:55", "last_data": "2026-02-17 09:43:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310264, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-17", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 09:32:58", "last_data": "2026-02-18 09:34:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310330, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-18", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 09:31:41", "last_data": "2026-02-20 09:42:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310415, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-19", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 09:42:45", "last_data": "2026-02-21 09:29:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310474, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-20", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 09:29:11", "last_data": "2026-02-22 09:45:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310550, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-21", "name": "dt", "value": "2026-02-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 09:45:44", "last_data": "2026-02-23 09:29:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310603, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-22", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 09:30:04", "last_data": "2026-02-24 09:30:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310667, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-23", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 09:33:29", "last_data": "2026-02-25 09:27:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310721, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-24/", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 09:39:34", "last_data": "2026-02-25 09:39:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310787, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-25", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 09:40:05", "last_data": "2026-02-26 09:40:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310855, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-26", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 09:40:29", "last_data": "2026-02-27 09:40:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310908, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-27", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 09:32:02", "last_data": "2026-02-28 09:46:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310981, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-28", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 09:34:02", "last_data": "2026-03-01 09:34:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311036, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-01", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 09:34:20", "last_data": "2026-03-03 09:48:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311123, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 09:52:55", "last_data": "2026-03-03 09:52:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311162, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-03", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 09:35:05", "last_data": "2026-03-04 09:35:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311232, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-04", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 09:30:52", "last_data": "2026-03-06 09:43:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311317, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 09:47:38", "last_data": "2026-03-06 09:47:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311365, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-06", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 09:40:57", "last_data": "2026-03-07 09:41:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311406, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-07", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 09:28:58", "last_data": "2026-03-08 09:29:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311459, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-08", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 09:28:07", "last_data": "2026-03-09 09:28:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311559, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-09", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 09:30:07", "last_data": "2026-03-11 09:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311609, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-10/", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 09:28:55", "last_data": "2026-03-11 09:28:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311666, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-11", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 09:27:03", "last_data": "2026-03-13 09:31:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311769, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 09:35:26", "last_data": "2026-03-13 09:35:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311805, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-13", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 09:32:39", "last_data": "2026-03-15 09:44:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311893, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-14/", "name": "dt", "value": "2026-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 09:46:21", "last_data": "2026-03-15 09:46:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311935, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-15", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 09:29:21", "last_data": "2026-03-16 09:29:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312049, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-16", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 09:31:13", "last_data": "2026-03-17 09:31:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312089, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-17", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 09:27:51", "last_data": "2026-03-18 09:39:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312195, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-18", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 09:45:53", "last_data": "2026-03-19 09:46:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312226, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-19", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 09:28:39", "last_data": "2026-03-20 09:46:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312305, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-20", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 09:41:30", "last_data": "2026-03-21 09:41:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312341, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-21", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 09:27:48", "last_data": "2026-03-23 09:29:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312419, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-22", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 09:29:44", "last_data": "2026-03-24 09:42:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312518, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-23", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 09:42:52", "last_data": "2026-03-25 09:43:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312579, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-24/", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 09:44:41", "last_data": "2026-03-25 09:44:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312613, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-25", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 09:29:22", "last_data": "2026-03-27 09:28:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312669, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-26/", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 09:28:45", "last_data": "2026-03-27 09:28:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312727, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-27", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 09:41:35", "last_data": "2026-03-28 09:45:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312814, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-28", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 09:28:55", "last_data": "2026-03-29 09:29:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312865, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-29", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 09:29:33", "last_data": "2026-03-31 09:29:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312940, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-30/", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 09:30:05", "last_data": "2026-03-31 09:30:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313004, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-31", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 09:40:32", "last_data": "2026-04-02 09:32:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313087, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-01/", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 09:52:38", "last_data": "2026-04-02 09:52:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313119, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-02", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 09:33:34", "last_data": "2026-04-04 09:37:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313209, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 09:52:57", "last_data": "2026-04-04 09:52:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313234, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-04", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 09:28:45", "last_data": "2026-04-06 09:35:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313330, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-05", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 09:44:55", "last_data": "2026-04-07 09:30:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313389, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-06/", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 09:30:36", "last_data": "2026-04-07 09:30:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313422, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-07", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 09:27:28", "last_data": "2026-04-08 09:32:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313533, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-08", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 09:47:10", "last_data": "2026-04-09 09:48:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313558, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-09", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 09:27:57", "last_data": "2026-04-10 09:29:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313639, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-10", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 09:31:15", "last_data": "2026-04-11 09:46:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313702, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-11", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 09:30:57", "last_data": "2026-04-12 09:31:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313758, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-12", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 09:35:49", "last_data": "2026-04-14 10:02:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313843, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 10:02:52", "last_data": "2026-04-14 10:02:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313914, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-14", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 10:02:32", "last_data": "2026-04-16 09:35:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313959, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 09:35:21", "last_data": "2026-04-16 09:35:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 314032, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-16", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 09:49:48", "last_data": "2026-04-17 09:49:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "address1": "string", "address2": "string", "approved": "string", "authorization": "string", "captured": "string", "city": "string", "company": "string", "created": "string", "creator": "string", "description": "string", "discretionary1": "string", "discretionary2": "string", "discretionary3": "string", "division_id": "string", "division_name": "string", "email": "string", "emv": "string", "entity_custom": "string", "entity_id": "string", "entity_name": "string", "entity_type": "string", "entry_entity": "string", "facilitator_assessments": "string", "fee_txn_id": "string", "first": "string", "funded": "string", "imported": "string", "interchange_feetotal": "string", "interchange_flatratefee": "string", "interchange_issuingbank": "string", "interchange_percentfee": "string", "interchange_type": "string", "last": "string", "last4": "string", "login_id": "string", "merchant_assessments": "string", "merchant_dba": "string", "method": "string", "order": "string", "origin": "string", "parent_division_id": "string", "partition_id": "string", "partition_name": "string", "payment_bin": "string", "payment_bin_type": "string", "payment_id": "string", "payrix_fees": "string", "phone": "string", "refunded": "string", "related_id": "string", "state": "string", "status": "string", "swiped": "string", "total": "string", "txn_cost": "string", "txn_cost_refund": "string", "txn_fee": "string", "txn_fee_refund": "string", "txn_id": "string", "txns_first": "string", "txns_last": "string", "type": "string", "username": "string", "zip": "string" } - created: 2024-07-22 13:08:31
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_transaction_details`\n(\n `txn_id` string , `type` string , `created` string , `captured` string , `total` string , `approved` string , `refunded` string , `status` string , `authorization` string , `origin` string , `swiped` string , `emv` string , `company` string , `description` string , `order` string , `zip` string , `funded` string , `creator` string , `txns_first` string , `txns_last` string , `address1` string , `address2` string , `phone` string , `email` string , `imported` string , `city` string , `state` string , `interchange_type` string , `interchange_flatratefee` string , `interchange_percentfee` string , `interchange_feetotal` string , `interchange_issuingbank` string , `discretionary1` string , `discretionary2` string , `discretionary3` string , `entity_id` string , `entity_name` string , `entity_type` string , `division_id` string , `division_name` string , `partition_id` string , `partition_name` string , `username` string , `first` string , `last` string , `parent_division_id` string , `login_id` string , `related_id` string , `merchant_dba` string , `entity_custom` string , `fee_txn_id` string , `entry_entity` string , `txn_cost` string , `txn_cost_refund` string , `txn_fee` string , `txn_fee_refund` string , `facilitator_assessments` string , `merchant_assessments` string , `payrix_fees` string , `payment_id` string , `last4` string , `method` string , `payment_bin` string , `payment_bin_type` 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/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_transaction_details`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_transaction_details" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-07-22 13:08:29",
"disabled": false,
"format": "raw",
"id": 2377,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_csv",
"table": "payrixess_transaction_details"
},
"type": "csv"
},
"partition": {
"count": 129,
"ddl": [
"ALTER TABLE\n `sfdl_dev_csv.payrixess_transaction_details`\nADD\n\n\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-20'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-30'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-06'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-18/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-27'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-06'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-09'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-16/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-17'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-21'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-24/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-27'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-01'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-20'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-24/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-02'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-07'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-11'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-14'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-16'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 304268,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-09",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 09:27:28",
"last_data": "2025-12-10 09:40:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304366,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-10",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 09:31:05",
"last_data": "2025-12-12 09:43:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304462,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 09:44:45",
"last_data": "2025-12-12 09:44:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304491,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-12",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 09:28:21",
"last_data": "2025-12-13 09:28:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304550,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-13",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 09:28:28",
"last_data": "2025-12-15 09:26:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304608,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-14",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 09:27:07",
"last_data": "2025-12-16 09:29:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304719,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-15",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 09:44:19",
"last_data": "2025-12-17 09:28:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304744,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 09:28:41",
"last_data": "2025-12-17 09:28:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304816,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-17",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 09:27:48",
"last_data": "2025-12-18 09:27:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304891,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-18",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 09:40:02",
"last_data": "2025-12-19 09:40:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304978,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-19",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 09:44:23",
"last_data": "2025-12-21 09:42:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305029,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-20",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 09:44:58",
"last_data": "2025-12-22 09:26:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305065,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-21",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 09:27:20",
"last_data": "2025-12-23 09:27:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305143,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 09:27:37",
"last_data": "2025-12-23 09:27:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305207,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-23",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 09:38:55",
"last_data": "2025-12-25 09:30:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305270,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 09:32:08",
"last_data": "2025-12-25 09:32:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305360,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-25",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 09:41:53",
"last_data": "2025-12-26 09:42:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305404,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-26",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 09:38:37",
"last_data": "2025-12-27 09:42:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305469,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-27",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 09:38:55",
"last_data": "2025-12-29 09:30:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305556,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-28",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 09:32:17",
"last_data": "2025-12-30 09:29:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306891,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 09:31:13",
"last_data": "2025-12-30 09:31:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306951,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-30",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 09:42:11",
"last_data": "2025-12-31 09:42:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306977,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2025-12-31",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 09:27:33",
"last_data": "2026-01-02 09:26:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307061,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 09:43:43",
"last_data": "2026-01-02 09:43:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307110,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-02",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 09:30:47",
"last_data": "2026-01-03 09:33:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307206,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-03",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 09:39:07",
"last_data": "2026-01-05 09:30:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307252,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-04",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 09:31:29",
"last_data": "2026-01-06 09:29:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307321,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 09:30:34",
"last_data": "2026-01-06 09:30:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307381,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-06",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 09:30:48",
"last_data": "2026-01-07 09:30:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307454,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-07",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 09:30:21",
"last_data": "2026-01-08 09:30:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307530,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-08",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 09:32:19",
"last_data": "2026-01-10 09:41:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307596,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-09",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 09:42:41",
"last_data": "2026-01-11 09:29:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307649,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-10",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 09:40:53",
"last_data": "2026-01-12 09:41:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307732,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 09:42:28",
"last_data": "2026-01-12 09:42:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307753,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-12",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 09:27:29",
"last_data": "2026-01-13 09:27:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307858,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-13",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 09:42:27",
"last_data": "2026-01-15 09:29:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307921,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 09:31:00",
"last_data": "2026-01-15 09:31:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307978,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-15",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 09:40:56",
"last_data": "2026-01-16 09:42:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307997,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-16",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 09:27:05",
"last_data": "2026-01-18 09:30:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308103,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-17",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 09:42:27",
"last_data": "2026-01-19 09:42:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308161,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-18/",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 09:42:42",
"last_data": "2026-01-19 09:42:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308214,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-19",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 09:42:42",
"last_data": "2026-01-21 09:30:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308300,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-20",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 09:39:07",
"last_data": "2026-01-22 09:41:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308476,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-21",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 09:44:23",
"last_data": "2026-01-23 09:45:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308552,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-22",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 09:45:49",
"last_data": "2026-01-24 09:43:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308616,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 09:43:37",
"last_data": "2026-01-24 09:43:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308628,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-24",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 09:26:55",
"last_data": "2026-01-25 09:27:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308715,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-25",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 09:39:17",
"last_data": "2026-01-27 09:28:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308782,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/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-27 09:28:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308846,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-27",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 09:29:36",
"last_data": "2026-01-28 09:29:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308928,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-28",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 09:40:59",
"last_data": "2026-01-30 09:27:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308987,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 09:33:36",
"last_data": "2026-01-30 09:33:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309040,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-30",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 09:40:01",
"last_data": "2026-02-01 09:45:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309110,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 09:46:02",
"last_data": "2026-02-01 09:46:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309159,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-01",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 09:31:40",
"last_data": "2026-02-03 09:32:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309232,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 09:37:20",
"last_data": "2026-02-03 09:37:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309289,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-03",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 09:33:05",
"last_data": "2026-02-05 09:31:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309360,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 09:32:43",
"last_data": "2026-02-05 09:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309444,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-05",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 09:46:27",
"last_data": "2026-02-06 09:50:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309461,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-06",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 09:27:25",
"last_data": "2026-02-08 09:30:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309573,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-07/",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 09:42:30",
"last_data": "2026-02-08 09:42:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309614,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-08",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 09:29:52",
"last_data": "2026-02-09 09:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309645,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-09",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 09:25:58",
"last_data": "2026-02-11 09:27:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309717,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 09:27:40",
"last_data": "2026-02-11 09:27:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309773,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-11",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 09:27:10",
"last_data": "2026-02-13 09:44:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309885,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-12",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 09:45:33",
"last_data": "2026-02-14 09:40:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309949,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 09:41:16",
"last_data": "2026-02-14 09:41:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310014,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-14",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 09:44:06",
"last_data": "2026-02-16 09:31:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310067,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-15",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 09:32:18",
"last_data": "2026-02-17 09:30:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310231,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-16/",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 09:43:55",
"last_data": "2026-02-17 09:43:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310264,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-17",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 09:32:58",
"last_data": "2026-02-18 09:34:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310330,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-18",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 09:31:41",
"last_data": "2026-02-20 09:42:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310415,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-19",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 09:42:45",
"last_data": "2026-02-21 09:29:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310474,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-20",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 09:29:11",
"last_data": "2026-02-22 09:45:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310550,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-21",
"name": "dt",
"value": "2026-02-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 09:45:44",
"last_data": "2026-02-23 09:29:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310603,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-22",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 09:30:04",
"last_data": "2026-02-24 09:30:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310667,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-23",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 09:33:29",
"last_data": "2026-02-25 09:27:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310721,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-24/",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 09:39:34",
"last_data": "2026-02-25 09:39:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310787,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-25",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 09:40:05",
"last_data": "2026-02-26 09:40:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310855,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-26",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 09:40:29",
"last_data": "2026-02-27 09:40:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310908,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-27",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 09:32:02",
"last_data": "2026-02-28 09:46:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310981,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-02-28",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 09:34:02",
"last_data": "2026-03-01 09:34:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311036,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-01",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 09:34:20",
"last_data": "2026-03-03 09:48:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311123,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 09:52:55",
"last_data": "2026-03-03 09:52:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311162,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-03",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 09:35:05",
"last_data": "2026-03-04 09:35:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311232,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-04",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 09:30:52",
"last_data": "2026-03-06 09:43:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311317,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 09:47:38",
"last_data": "2026-03-06 09:47:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311365,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-06",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 09:40:57",
"last_data": "2026-03-07 09:41:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311406,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-07",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 09:28:58",
"last_data": "2026-03-08 09:29:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311459,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-08",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 09:28:07",
"last_data": "2026-03-09 09:28:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311559,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-09",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 09:30:07",
"last_data": "2026-03-11 09:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311609,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-10/",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 09:28:55",
"last_data": "2026-03-11 09:28:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311666,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-11",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 09:27:03",
"last_data": "2026-03-13 09:31:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311769,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 09:35:26",
"last_data": "2026-03-13 09:35:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311805,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-13",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 09:32:39",
"last_data": "2026-03-15 09:44:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311893,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-14/",
"name": "dt",
"value": "2026-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 09:46:21",
"last_data": "2026-03-15 09:46:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311935,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-15",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 09:29:21",
"last_data": "2026-03-16 09:29:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312049,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-16",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 09:31:13",
"last_data": "2026-03-17 09:31:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312089,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-17",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 09:27:51",
"last_data": "2026-03-18 09:39:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312195,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-18",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 09:45:53",
"last_data": "2026-03-19 09:46:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312226,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-19",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 09:28:39",
"last_data": "2026-03-20 09:46:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312305,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-20",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 09:41:30",
"last_data": "2026-03-21 09:41:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312341,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-21",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 09:27:48",
"last_data": "2026-03-23 09:29:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312419,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-22",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 09:29:44",
"last_data": "2026-03-24 09:42:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312518,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-23",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 09:42:52",
"last_data": "2026-03-25 09:43:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312579,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-24/",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 09:44:41",
"last_data": "2026-03-25 09:44:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312613,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-25",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 09:29:22",
"last_data": "2026-03-27 09:28:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312669,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-26/",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 09:28:45",
"last_data": "2026-03-27 09:28:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312727,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-27",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 09:41:35",
"last_data": "2026-03-28 09:45:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312814,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-28",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 09:28:55",
"last_data": "2026-03-29 09:29:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312865,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-29",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 09:29:33",
"last_data": "2026-03-31 09:29:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312940,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-30/",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 09:30:05",
"last_data": "2026-03-31 09:30:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313004,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-03-31",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 09:40:32",
"last_data": "2026-04-02 09:32:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313087,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-01/",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 09:52:38",
"last_data": "2026-04-02 09:52:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313119,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-02",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 09:33:34",
"last_data": "2026-04-04 09:37:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313209,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 09:52:57",
"last_data": "2026-04-04 09:52:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313234,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-04",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 09:28:45",
"last_data": "2026-04-06 09:35:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313330,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-05",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 09:44:55",
"last_data": "2026-04-07 09:30:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313389,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-06/",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 09:30:36",
"last_data": "2026-04-07 09:30:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313422,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-07",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 09:27:28",
"last_data": "2026-04-08 09:32:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313533,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-08",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 09:47:10",
"last_data": "2026-04-09 09:48:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313558,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-09",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 09:27:57",
"last_data": "2026-04-10 09:29:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313639,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-10",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 09:31:15",
"last_data": "2026-04-11 09:46:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313702,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-11",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 09:30:57",
"last_data": "2026-04-12 09:31:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313758,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-12",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 09:35:49",
"last_data": "2026-04-14 10:02:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313843,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 10:02:52",
"last_data": "2026-04-14 10:02:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313914,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-14",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 10:02:32",
"last_data": "2026-04-16 09:35:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313959,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 09:35:21",
"last_data": "2026-04-16 09:35:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 314032,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/transaction_details/dt=2026-04-16",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 09:49:48",
"last_data": "2026-04-17 09:49:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"address1": "string",
"address2": "string",
"approved": "string",
"authorization": "string",
"captured": "string",
"city": "string",
"company": "string",
"created": "string",
"creator": "string",
"description": "string",
"discretionary1": "string",
"discretionary2": "string",
"discretionary3": "string",
"division_id": "string",
"division_name": "string",
"email": "string",
"emv": "string",
"entity_custom": "string",
"entity_id": "string",
"entity_name": "string",
"entity_type": "string",
"entry_entity": "string",
"facilitator_assessments": "string",
"fee_txn_id": "string",
"first": "string",
"funded": "string",
"imported": "string",
"interchange_feetotal": "string",
"interchange_flatratefee": "string",
"interchange_issuingbank": "string",
"interchange_percentfee": "string",
"interchange_type": "string",
"last": "string",
"last4": "string",
"login_id": "string",
"merchant_assessments": "string",
"merchant_dba": "string",
"method": "string",
"order": "string",
"origin": "string",
"parent_division_id": "string",
"partition_id": "string",
"partition_name": "string",
"payment_bin": "string",
"payment_bin_type": "string",
"payment_id": "string",
"payrix_fees": "string",
"phone": "string",
"refunded": "string",
"related_id": "string",
"state": "string",
"status": "string",
"swiped": "string",
"total": "string",
"txn_cost": "string",
"txn_cost_refund": "string",
"txn_fee": "string",
"txn_fee_refund": "string",
"txn_id": "string",
"txns_first": "string",
"txns_last": "string",
"type": "string",
"username": "string",
"zip": "string"
},
"created": "2024-07-22 13:08:31",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_transaction_details`\n(\n `txn_id` string , `type` string , `created` string , `captured` string , `total` string , `approved` string , `refunded` string , `status` string , `authorization` string , `origin` string , `swiped` string , `emv` string , `company` string , `description` string , `order` string , `zip` string , `funded` string , `creator` string , `txns_first` string , `txns_last` string , `address1` string , `address2` string , `phone` string , `email` string , `imported` string , `city` string , `state` string , `interchange_type` string , `interchange_flatratefee` string , `interchange_percentfee` string , `interchange_feetotal` string , `interchange_issuingbank` string , `discretionary1` string , `discretionary2` string , `discretionary3` string , `entity_id` string , `entity_name` string , `entity_type` string , `division_id` string , `division_name` string , `partition_id` string , `partition_name` string , `username` string , `first` string , `last` string , `parent_division_id` string , `login_id` string , `related_id` string , `merchant_dba` string , `entity_custom` string , `fee_txn_id` string , `entry_entity` string , `txn_cost` string , `txn_cost_refund` string , `txn_fee` string , `txn_fee_refund` string , `facilitator_assessments` string , `merchant_assessments` string , `payrix_fees` string , `payment_id` string , `last4` string , `method` string , `payment_bin` string , `payment_bin_type` 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/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_transaction_details`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_transaction_details"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}