Schema Info
Schema Name: sfdl_stage_csv.payrixess_transaction_details
- created: 2024-07-22 13:07:34
- disabled: False
- format: raw
- id: 2150
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_csv", "table": "payrixess_transaction_details" } - type: csv
Schema Versions: 1
-
Version 724698
- created: 2024-07-22 13:07:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_transaction_details`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw_incremental/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_transaction_details" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details
- id: 724698
- 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: 2150
- schema_scan_id: 5871217
- updated: 2024-07-22 13:07:47
Schema Scans: 5
Last at 2026-04-17 09:31:35
-
Scan 6415433
- duration: 0:00:04.995744
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6415433
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-16", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-16/bba81c44-c14d-47ea-8434-929685c213bb.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 689412748253089052, "service_name": "drive-thru", "span_id": 8113736343461503461, "trace_id": 9146531286348048346 } } - running: False
- schema_name_id: 2150
- start_time: 2026-04-17 09:31:35
- success: True
- trace_id: 9146531286348048346
-
Scan 6415420
- duration: 0:00:02.540010
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6415420
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-15/6eaca126-469a-47b5-98bc-e6a14672f1fe.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 16622384031007587604, "service_name": "drive-thru", "span_id": 16576621626992815795, "trace_id": 7863977253577355102 } } - running: False
- schema_name_id: 2150
- start_time: 2026-04-17 09:30:58
- success: True
- trace_id: 7863977253577355102
-
Scan 6414914
- duration: 0:00:02.357903
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6414914
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-15/3b0263d4-b6c2-48c8-bfd4-808850c642a9.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 154902073121313031, "service_name": "drive-thru", "span_id": 15549371224035133243, "trace_id": 8273640191251033961 } } - running: False
- schema_name_id: 2150
- start_time: 2026-04-16 09:43:31
- success: True
- trace_id: 8273640191251033961
-
Scan 6414885
- duration: 0:00:05.129194
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6414885
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2026-04-15/3b0263d4-b6c2-48c8-bfd4-808850c642a9.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 9615096812988922723, "service_name": "drive-thru", "span_id": 4839132837922226340, "trace_id": 5885569060802057778 } } - running: False
- schema_name_id: 2150
- start_time: 2026-04-16 09:41:30
- success: True
- trace_id: 5885569060802057778
-
Scan 5871217
- duration: 0:00:16.190695
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1, "partitions_applied": false, "success": true } - id: 5871217
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2024-07-21", "name": "dt", "type": "string", "value": "2024-07-21" }, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details", "key": "raw_incremental/transaction_details/dt=2024-07-21/fee962d9-7766-4142-a275-4e91ef629eb1.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_transaction_details", "type": "csv" }, "trace_context": { "parent_id": 6644757626160576279, "service_name": "drive-thru", "span_id": 8400632598241390092, "trace_id": 9215011088031407394 } } - running: False
- schema_name_id: 2150
- start_time: 2024-07-22 13:07:34
- success: True
- trace_id: 9215011088031407394
- count: 171
- ddl:
[ "ALTER TABLE\n `sfdl_stage_csv.payrixess_transaction_details`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-14'\n PARTITION (dt='2025-10-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-16'\n PARTITION (dt='2025-10-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-17'\n PARTITION (dt='2025-10-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-19'\n PARTITION (dt='2025-10-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-20'\n PARTITION (dt='2025-10-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-21'\n PARTITION (dt='2025-10-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-22'\n PARTITION (dt='2025-10-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-23'\n PARTITION (dt='2025-10-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-25'\n PARTITION (dt='2025-10-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-26'\n PARTITION (dt='2025-10-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-27'\n PARTITION (dt='2025-10-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-28'\n PARTITION (dt='2025-10-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-30'\n PARTITION (dt='2025-10-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-31'\n PARTITION (dt='2025-11-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-01'\n PARTITION (dt='2025-11-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-02'\n PARTITION (dt='2025-11-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-04'\n PARTITION (dt='2025-11-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-05'\n PARTITION (dt='2025-11-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-06'\n PARTITION (dt='2025-11-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-08'\n PARTITION (dt='2025-11-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-09'\n PARTITION (dt='2025-11-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-10'\n PARTITION (dt='2025-11-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-12'\n PARTITION (dt='2025-11-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-14'\n PARTITION (dt='2025-11-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-15'\n PARTITION (dt='2025-11-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-17'\n PARTITION (dt='2025-11-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-19'\n PARTITION (dt='2025-11-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-20'\n PARTITION (dt='2025-11-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-21'\n PARTITION (dt='2025-11-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-23'\n PARTITION (dt='2025-11-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-24/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-11'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-20'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-22'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-24'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-05'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-14'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-26'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-29'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-31'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-02'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-09'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-13'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-21'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-27'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-01'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-12'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-14'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-03'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-07'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 650207, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-14", "name": "dt", "value": "2025-10-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 09:30:33", "last_data": "2025-10-16 09:44:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650339, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 09:45:31", "last_data": "2025-10-16 09:45:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650446, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-16", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 09:29:26", "last_data": "2025-10-17 09:29:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650547, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-17", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 09:29:10", "last_data": "2025-10-19 09:44:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650681, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 09:44:09", "last_data": "2025-10-19 09:44:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650767, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-19", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 14:40:34", "last_data": "2025-10-20 14:40:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 650912, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-20", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 09:30:53", "last_data": "2025-10-21 09:30:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651012, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-21", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 09:41:02", "last_data": "2025-10-22 09:41:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651143, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-22", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 09:42:57", "last_data": "2025-10-24 09:37:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651256, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-23", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 09:39:26", "last_data": "2025-10-25 09:32:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651334, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 09:32:39", "last_data": "2025-10-25 09:32:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651434, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-25", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 09:27:23", "last_data": "2025-10-26 09:27:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651596, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-26", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 09:47:54", "last_data": "2025-10-28 09:32:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651717, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-27", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 09:44:16", "last_data": "2025-10-29 09:31:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651809, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-28", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 09:31:52", "last_data": "2025-10-30 09:41:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 651936, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 09:44:06", "last_data": "2025-10-30 09:44:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652050, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-30", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 09:40:39", "last_data": "2025-10-31 09:44:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652150, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-31", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 09:32:21", "last_data": "2025-11-01 09:39:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652266, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-01", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 09:36:39", "last_data": "2025-11-02 09:37:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652376, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-02", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 09:36:13", "last_data": "2025-11-04 09:35:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652519, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 09:46:49", "last_data": "2025-11-04 09:46:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652610, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-04", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 09:34:31", "last_data": "2025-11-05 09:35:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652719, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-05", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 09:30:10", "last_data": "2025-11-07 09:31:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652841, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-06", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 09:31:18", "last_data": "2025-11-08 09:39:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 652950, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 09:40:29", "last_data": "2025-11-08 09:40:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653076, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-08", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 09:42:58", "last_data": "2025-11-09 09:43:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653185, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-09", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 09:41:45", "last_data": "2025-11-10 09:42:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653305, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-10", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 09:29:42", "last_data": "2025-11-12 09:41:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653421, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 09:41:44", "last_data": "2025-11-12 09:41:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653508, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-12", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 09:30:17", "last_data": "2025-11-14 09:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653649, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 09:30:41", "last_data": "2025-11-14 09:30:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653741, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-14", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 09:29:56", "last_data": "2025-11-16 09:29:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 653857, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-15", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 09:29:19", "last_data": "2025-11-17 09:31:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656058, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 09:33:10", "last_data": "2025-11-17 09:33:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656170, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-17", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 09:32:26", "last_data": "2025-11-19 09:42:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656277, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 09:42:05", "last_data": "2025-11-19 09:42:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656385, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-19", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 09:32:14", "last_data": "2025-11-20 09:34:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656493, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-20", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 09:38:00", "last_data": "2025-11-22 09:31:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656602, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-21", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 09:31:30", "last_data": "2025-11-23 09:27:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656716, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 09:41:45", "last_data": "2025-11-23 09:41:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656848, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-23", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 09:43:10", "last_data": "2025-11-25 09:29:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 656951, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 09:29:43", "last_data": "2025-11-25 09:29:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657376, "location": "s3://sfdl-csv-payrixess-stage/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:41:35", "last_data": "2025-12-10 09:41:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657478, "location": "s3://sfdl-csv-payrixess-stage/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:38:28", "last_data": "2025-12-11 09:38:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657596, "location": "s3://sfdl-csv-payrixess-stage/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:29:18", "last_data": "2025-12-12 09:30:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657682, "location": "s3://sfdl-csv-payrixess-stage/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:27:51", "last_data": "2025-12-13 09:40:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657820, "location": "s3://sfdl-csv-payrixess-stage/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:39:47", "last_data": "2025-12-14 09:42:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 657929, "location": "s3://sfdl-csv-payrixess-stage/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:38", "last_data": "2025-12-16 09:29:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658065, "location": "s3://sfdl-csv-payrixess-stage/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:29:45", "last_data": "2025-12-16 09:29:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658151, "location": "s3://sfdl-csv-payrixess-stage/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:27:01", "last_data": "2025-12-18 09:30:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658288, "location": "s3://sfdl-csv-payrixess-stage/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:36:34", "last_data": "2025-12-19 09:28:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658415, "location": "s3://sfdl-csv-payrixess-stage/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:28:47", "last_data": "2025-12-20 09:26:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658536, "location": "s3://sfdl-csv-payrixess-stage/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:39:34", "last_data": "2025-12-21 09:30:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658644, "location": "s3://sfdl-csv-payrixess-stage/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:30:16", "last_data": "2025-12-22 09:41:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658780, "location": "s3://sfdl-csv-payrixess-stage/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:44:12", "last_data": "2025-12-23 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 658918, "location": "s3://sfdl-csv-payrixess-stage/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:30:32", "last_data": "2025-12-24 09:41:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659060, "location": "s3://sfdl-csv-payrixess-stage/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:43:30", "last_data": "2025-12-24 09:43:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659125, "location": "s3://sfdl-csv-payrixess-stage/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:26:10", "last_data": "2025-12-25 09:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659275, "location": "s3://sfdl-csv-payrixess-stage/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:30:38", "last_data": "2025-12-26 09:31:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659393, "location": "s3://sfdl-csv-payrixess-stage/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:41:42", "last_data": "2025-12-27 09:43:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659489, "location": "s3://sfdl-csv-payrixess-stage/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:28:41", "last_data": "2025-12-28 09:28:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659618, "location": "s3://sfdl-csv-payrixess-stage/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:28:23", "last_data": "2025-12-30 09:43:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659756, "location": "s3://sfdl-csv-payrixess-stage/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:44:12", "last_data": "2025-12-31 09:29:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659877, "location": "s3://sfdl-csv-payrixess-stage/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:41:39", "last_data": "2025-12-31 09:41:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 659979, "location": "s3://sfdl-csv-payrixess-stage/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:30:50", "last_data": "2026-01-01 09:31:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660070, "location": "s3://sfdl-csv-payrixess-stage/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:27:37", "last_data": "2026-01-03 09:49:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660230, "location": "s3://sfdl-csv-payrixess-stage/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:49:38", "last_data": "2026-01-04 09:46:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660333, "location": "s3://sfdl-csv-payrixess-stage/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:47:15", "last_data": "2026-01-05 09:28:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660469, "location": "s3://sfdl-csv-payrixess-stage/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:47:59", "last_data": "2026-01-06 09:27:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660545, "location": "s3://sfdl-csv-payrixess-stage/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:27:29", "last_data": "2026-01-07 09:40:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660708, "location": "s3://sfdl-csv-payrixess-stage/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:43:36", "last_data": "2026-01-07 09:43:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660815, "location": "s3://sfdl-csv-payrixess-stage/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:43:08", "last_data": "2026-01-08 09:44:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 660908, "location": "s3://sfdl-csv-payrixess-stage/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:29:01", "last_data": "2026-01-09 09:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661033, "location": "s3://sfdl-csv-payrixess-stage/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:28:47", "last_data": "2026-01-11 09:28:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661142, "location": "s3://sfdl-csv-payrixess-stage/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:28:29", "last_data": "2026-01-11 09:28:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661258, "location": "s3://sfdl-csv-payrixess-stage/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:27:19", "last_data": "2026-01-12 09:31:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661368, "location": "s3://sfdl-csv-payrixess-stage/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:03", "last_data": "2026-01-13 09:28:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661519, "location": "s3://sfdl-csv-payrixess-stage/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:40:23", "last_data": "2026-01-14 09:44:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661617, "location": "s3://sfdl-csv-payrixess-stage/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:32:53", "last_data": "2026-01-16 09:27:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661717, "location": "s3://sfdl-csv-payrixess-stage/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:27:15", "last_data": "2026-01-16 09:27:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661833, "location": "s3://sfdl-csv-payrixess-stage/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:13", "last_data": "2026-01-17 09:27:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 661985, "location": "s3://sfdl-csv-payrixess-stage/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:39:27", "last_data": "2026-01-18 09:39:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662067, "location": "s3://sfdl-csv-payrixess-stage/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:26:40", "last_data": "2026-01-19 09:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662208, "location": "s3://sfdl-csv-payrixess-stage/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:28:42", "last_data": "2026-01-21 09:43:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662345, "location": "s3://sfdl-csv-payrixess-stage/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:45:59", "last_data": "2026-01-22 09:41:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662505, "location": "s3://sfdl-csv-payrixess-stage/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:41:25", "last_data": "2026-01-23 09:27:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662622, "location": "s3://sfdl-csv-payrixess-stage/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:42:18", "last_data": "2026-01-24 09:44:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662745, "location": "s3://sfdl-csv-payrixess-stage/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:44:41", "last_data": "2026-01-25 09:29:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662822, "location": "s3://sfdl-csv-payrixess-stage/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:29:32", "last_data": "2026-01-26 09:30:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 662955, "location": "s3://sfdl-csv-payrixess-stage/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:31:32", "last_data": "2026-01-27 09:30:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663082, "location": "s3://sfdl-csv-payrixess-stage/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:30:35", "last_data": "2026-01-28 09:28:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 663185, "location": "s3://sfdl-csv-payrixess-stage/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:28:57", "last_data": "2026-01-28 09:28:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666015, "location": "s3://sfdl-csv-payrixess-stage/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:28:35", "last_data": "2026-01-30 09:33:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666149, "location": "s3://sfdl-csv-payrixess-stage/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:34:06", "last_data": "2026-01-31 09:29:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666266, "location": "s3://sfdl-csv-payrixess-stage/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:29:11", "last_data": "2026-01-31 09:29:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666377, "location": "s3://sfdl-csv-payrixess-stage/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:27:00", "last_data": "2026-02-01 09:27:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666543, "location": "s3://sfdl-csv-payrixess-stage/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:45:11", "last_data": "2026-02-03 09:36:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666660, "location": "s3://sfdl-csv-payrixess-stage/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:51:10", "last_data": "2026-02-04 09:30:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666766, "location": "s3://sfdl-csv-payrixess-stage/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:32:13", "last_data": "2026-02-04 09:32:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666878, "location": "s3://sfdl-csv-payrixess-stage/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:02", "last_data": "2026-02-05 09:32:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 666992, "location": "s3://sfdl-csv-payrixess-stage/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:28:16", "last_data": "2026-02-07 09:27:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667087, "location": "s3://sfdl-csv-payrixess-stage/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:56", "last_data": "2026-02-07 09:27:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667205, "location": "s3://sfdl-csv-payrixess-stage/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:28:15", "last_data": "2026-02-09 09:42:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667356, "location": "s3://sfdl-csv-payrixess-stage/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:42:58", "last_data": "2026-02-09 09:42:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667470, "location": "s3://sfdl-csv-payrixess-stage/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:39:29", "last_data": "2026-02-10 09:40:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667597, "location": "s3://sfdl-csv-payrixess-stage/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:40:25", "last_data": "2026-02-12 09:32:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667707, "location": "s3://sfdl-csv-payrixess-stage/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:40:02", "last_data": "2026-02-13 09:28:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667805, "location": "s3://sfdl-csv-payrixess-stage/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:28:49", "last_data": "2026-02-14 09:29:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 667951, "location": "s3://sfdl-csv-payrixess-stage/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:31", "last_data": "2026-02-15 09:39:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668039, "location": "s3://sfdl-csv-payrixess-stage/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:40:40", "last_data": "2026-02-16 09:28:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668154, "location": "s3://sfdl-csv-payrixess-stage/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:28:42", "last_data": "2026-02-17 09:42:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668301, "location": "s3://sfdl-csv-payrixess-stage/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:51", "last_data": "2026-02-18 09:43:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668406, "location": "s3://sfdl-csv-payrixess-stage/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:44:17", "last_data": "2026-02-18 09:44:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668527, "location": "s3://sfdl-csv-payrixess-stage/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:41:03", "last_data": "2026-02-19 09:41:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668633, "location": "s3://sfdl-csv-payrixess-stage/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:32:19", "last_data": "2026-02-21 09:39:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668771, "location": "s3://sfdl-csv-payrixess-stage/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:41:03", "last_data": "2026-02-21 09:41:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668865, "location": "s3://sfdl-csv-payrixess-stage/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:38:17", "last_data": "2026-02-22 09:40:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 668970, "location": "s3://sfdl-csv-payrixess-stage/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:29:52", "last_data": "2026-02-23 09:31:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669083, "location": "s3://sfdl-csv-payrixess-stage/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:27:42", "last_data": "2026-02-24 09:28:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669204, "location": "s3://sfdl-csv-payrixess-stage/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:29:25", "last_data": "2026-02-25 09:29:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669355, "location": "s3://sfdl-csv-payrixess-stage/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:47:30", "last_data": "2026-02-26 09:48:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669458, "location": "s3://sfdl-csv-payrixess-stage/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:38", "last_data": "2026-02-28 09:40:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669594, "location": "s3://sfdl-csv-payrixess-stage/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:45:28", "last_data": "2026-03-01 09:32:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669718, "location": "s3://sfdl-csv-payrixess-stage/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:41:26", "last_data": "2026-03-02 09:29:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669796, "location": "s3://sfdl-csv-payrixess-stage/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:29:53", "last_data": "2026-03-03 09:33:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 669940, "location": "s3://sfdl-csv-payrixess-stage/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:34:17", "last_data": "2026-03-04 09:38:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670113, "location": "s3://sfdl-csv-payrixess-stage/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:49:31", "last_data": "2026-03-05 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670211, "location": "s3://sfdl-csv-payrixess-stage/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:51", "last_data": "2026-03-06 09:28:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670350, "location": "s3://sfdl-csv-payrixess-stage/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:09", "last_data": "2026-03-06 09:47:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670442, "location": "s3://sfdl-csv-payrixess-stage/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:28:51", "last_data": "2026-03-07 09:29:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670555, "location": "s3://sfdl-csv-payrixess-stage/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:29:26", "last_data": "2026-03-08 09:30:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670693, "location": "s3://sfdl-csv-payrixess-stage/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:42:59", "last_data": "2026-03-09 09:44:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670810, "location": "s3://sfdl-csv-payrixess-stage/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:42:51", "last_data": "2026-03-11 09:30:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 670925, "location": "s3://sfdl-csv-payrixess-stage/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:30:55", "last_data": "2026-03-11 09:30:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671051, "location": "s3://sfdl-csv-payrixess-stage/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:34:01", "last_data": "2026-03-12 09:47:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671146, "location": "s3://sfdl-csv-payrixess-stage/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:29:43", "last_data": "2026-03-13 09:30:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671280, "location": "s3://sfdl-csv-payrixess-stage/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:31:07", "last_data": "2026-03-14 09:31:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671352, "location": "s3://sfdl-csv-payrixess-stage/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:27:40", "last_data": "2026-03-15 09:29:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671501, "location": "s3://sfdl-csv-payrixess-stage/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:30:45", "last_data": "2026-03-16 09:31:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671598, "location": "s3://sfdl-csv-payrixess-stage/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:30:37", "last_data": "2026-03-17 09:32:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671735, "location": "s3://sfdl-csv-payrixess-stage/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:32:31", "last_data": "2026-03-18 09:33:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671866, "location": "s3://sfdl-csv-payrixess-stage/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:42:50", "last_data": "2026-03-20 09:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 671965, "location": "s3://sfdl-csv-payrixess-stage/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:30:17", "last_data": "2026-03-21 09:28:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672082, "location": "s3://sfdl-csv-payrixess-stage/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:28:53", "last_data": "2026-03-21 09:28:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672177, "location": "s3://sfdl-csv-payrixess-stage/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:28:23", "last_data": "2026-03-22 09:28:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672318, "location": "s3://sfdl-csv-payrixess-stage/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:28:40", "last_data": "2026-03-24 09:32:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672466, "location": "s3://sfdl-csv-payrixess-stage/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:43:52", "last_data": "2026-03-24 09:43:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672538, "location": "s3://sfdl-csv-payrixess-stage/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:27:14", "last_data": "2026-03-26 09:30:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672681, "location": "s3://sfdl-csv-payrixess-stage/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:30:37", "last_data": "2026-03-27 09:32:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672815, "location": "s3://sfdl-csv-payrixess-stage/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:43:40", "last_data": "2026-03-27 09:43:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 672935, "location": "s3://sfdl-csv-payrixess-stage/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:42:51", "last_data": "2026-03-28 09:43:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673023, "location": "s3://sfdl-csv-payrixess-stage/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:32:02", "last_data": "2026-03-29 09:32:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673170, "location": "s3://sfdl-csv-payrixess-stage/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:44:27", "last_data": "2026-03-31 09:27:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673261, "location": "s3://sfdl-csv-payrixess-stage/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:27:59", "last_data": "2026-03-31 09:27:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673429, "location": "s3://sfdl-csv-payrixess-stage/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:30:50", "last_data": "2026-04-01 09:39:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673568, "location": "s3://sfdl-csv-payrixess-stage/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:47:20", "last_data": "2026-04-03 09:32:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673664, "location": "s3://sfdl-csv-payrixess-stage/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:53:19", "last_data": "2026-04-03 09:53:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673774, "location": "s3://sfdl-csv-payrixess-stage/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:37:24", "last_data": "2026-04-04 09:37:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 673885, "location": "s3://sfdl-csv-payrixess-stage/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:29:39", "last_data": "2026-04-05 09:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674022, "location": "s3://sfdl-csv-payrixess-stage/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:30:39", "last_data": "2026-04-06 09:43:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674110, "location": "s3://sfdl-csv-payrixess-stage/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:28:28", "last_data": "2026-04-07 09:30:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674264, "location": "s3://sfdl-csv-payrixess-stage/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:33:51", "last_data": "2026-04-08 09:34:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674393, "location": "s3://sfdl-csv-payrixess-stage/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:50:07", "last_data": "2026-04-09 09:50:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674500, "location": "s3://sfdl-csv-payrixess-stage/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:41:32", "last_data": "2026-04-10 09:41:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674604, "location": "s3://sfdl-csv-payrixess-stage/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:29:19", "last_data": "2026-04-12 09:29:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674705, "location": "s3://sfdl-csv-payrixess-stage/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:29:53", "last_data": "2026-04-12 09:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674827, "location": "s3://sfdl-csv-payrixess-stage/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:32:48", "last_data": "2026-04-13 09:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 674945, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-13", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 09:30:10", "last_data": "2026-04-15 09:29:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675071, "location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 09:30:18", "last_data": "2026-04-15 09:30:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675194, "location": "s3://sfdl-csv-payrixess-stage/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:41:32", "last_data": "2026-04-17 09:31:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 675340, "location": "s3://sfdl-csv-payrixess-stage/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:31:37", "last_data": "2026-04-17 09:31:37" }, "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:07:36
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw_incremental/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_transaction_details`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_transaction_details" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2024-07-22 13:07:34",
"disabled": false,
"format": "raw",
"id": 2150,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_csv",
"table": "payrixess_transaction_details"
},
"type": "csv"
},
"partition": {
"count": 171,
"ddl": [
"ALTER TABLE\n `sfdl_stage_csv.payrixess_transaction_details`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-14'\n PARTITION (dt='2025-10-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-16'\n PARTITION (dt='2025-10-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-17'\n PARTITION (dt='2025-10-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-19'\n PARTITION (dt='2025-10-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-20'\n PARTITION (dt='2025-10-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-21'\n PARTITION (dt='2025-10-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-22'\n PARTITION (dt='2025-10-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-23'\n PARTITION (dt='2025-10-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-25'\n PARTITION (dt='2025-10-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-26'\n PARTITION (dt='2025-10-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-27'\n PARTITION (dt='2025-10-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-28'\n PARTITION (dt='2025-10-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-30'\n PARTITION (dt='2025-10-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-31'\n PARTITION (dt='2025-11-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-01'\n PARTITION (dt='2025-11-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-02'\n PARTITION (dt='2025-11-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-04'\n PARTITION (dt='2025-11-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-05'\n PARTITION (dt='2025-11-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-06'\n PARTITION (dt='2025-11-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-08'\n PARTITION (dt='2025-11-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-09'\n PARTITION (dt='2025-11-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-10'\n PARTITION (dt='2025-11-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-12'\n PARTITION (dt='2025-11-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-14'\n PARTITION (dt='2025-11-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-15'\n PARTITION (dt='2025-11-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-17'\n PARTITION (dt='2025-11-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-19'\n PARTITION (dt='2025-11-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-20'\n PARTITION (dt='2025-11-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-21'\n PARTITION (dt='2025-11-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-23'\n PARTITION (dt='2025-11-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-24/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-10'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-11'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-13'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-17'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-20'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-22'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-24'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-25'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-02'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-05'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-12'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-14'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-19'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-24'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-26'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-29'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-30/'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-01-31'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-02'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-09'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-13'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-19'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-20/'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-21'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-27'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-01'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-03'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-12'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-14'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-18'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-20/'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-21'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-23/'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-25'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-26/'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-30/'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-03'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-07'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-09'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 650207,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-14",
"name": "dt",
"value": "2025-10-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 09:30:33",
"last_data": "2025-10-16 09:44:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650339,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 09:45:31",
"last_data": "2025-10-16 09:45:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650446,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-16",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 09:29:26",
"last_data": "2025-10-17 09:29:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650547,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-17",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 09:29:10",
"last_data": "2025-10-19 09:44:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650681,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 09:44:09",
"last_data": "2025-10-19 09:44:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650767,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-19",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 14:40:34",
"last_data": "2025-10-20 14:40:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 650912,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-20",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 09:30:53",
"last_data": "2025-10-21 09:30:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651012,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-21",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 09:41:02",
"last_data": "2025-10-22 09:41:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651143,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-22",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 09:42:57",
"last_data": "2025-10-24 09:37:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651256,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-23",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 09:39:26",
"last_data": "2025-10-25 09:32:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651334,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 09:32:39",
"last_data": "2025-10-25 09:32:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651434,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-25",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 09:27:23",
"last_data": "2025-10-26 09:27:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651596,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-26",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 09:47:54",
"last_data": "2025-10-28 09:32:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651717,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-27",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 09:44:16",
"last_data": "2025-10-29 09:31:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651809,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-28",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 09:31:52",
"last_data": "2025-10-30 09:41:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 651936,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 09:44:06",
"last_data": "2025-10-30 09:44:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652050,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-30",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 09:40:39",
"last_data": "2025-10-31 09:44:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652150,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-10-31",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 09:32:21",
"last_data": "2025-11-01 09:39:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652266,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-01",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 09:36:39",
"last_data": "2025-11-02 09:37:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652376,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-02",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 09:36:13",
"last_data": "2025-11-04 09:35:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652519,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 09:46:49",
"last_data": "2025-11-04 09:46:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652610,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-04",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 09:34:31",
"last_data": "2025-11-05 09:35:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652719,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-05",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 09:30:10",
"last_data": "2025-11-07 09:31:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652841,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-06",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 09:31:18",
"last_data": "2025-11-08 09:39:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 652950,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 09:40:29",
"last_data": "2025-11-08 09:40:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653076,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-08",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 09:42:58",
"last_data": "2025-11-09 09:43:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653185,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-09",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 09:41:45",
"last_data": "2025-11-10 09:42:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653305,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-10",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 09:29:42",
"last_data": "2025-11-12 09:41:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653421,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 09:41:44",
"last_data": "2025-11-12 09:41:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653508,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-12",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 09:30:17",
"last_data": "2025-11-14 09:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653649,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 09:30:41",
"last_data": "2025-11-14 09:30:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653741,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-14",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 09:29:56",
"last_data": "2025-11-16 09:29:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 653857,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-15",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 09:29:19",
"last_data": "2025-11-17 09:31:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656058,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 09:33:10",
"last_data": "2025-11-17 09:33:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656170,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-17",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 09:32:26",
"last_data": "2025-11-19 09:42:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656277,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 09:42:05",
"last_data": "2025-11-19 09:42:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656385,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-19",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 09:32:14",
"last_data": "2025-11-20 09:34:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656493,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-20",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 09:38:00",
"last_data": "2025-11-22 09:31:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656602,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-21",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 09:31:30",
"last_data": "2025-11-23 09:27:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656716,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 09:41:45",
"last_data": "2025-11-23 09:41:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656848,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-23",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 09:43:10",
"last_data": "2025-11-25 09:29:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 656951,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 09:29:43",
"last_data": "2025-11-25 09:29:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657376,
"location": "s3://sfdl-csv-payrixess-stage/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:41:35",
"last_data": "2025-12-10 09:41:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657478,
"location": "s3://sfdl-csv-payrixess-stage/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:38:28",
"last_data": "2025-12-11 09:38:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657596,
"location": "s3://sfdl-csv-payrixess-stage/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:29:18",
"last_data": "2025-12-12 09:30:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657682,
"location": "s3://sfdl-csv-payrixess-stage/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:27:51",
"last_data": "2025-12-13 09:40:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657820,
"location": "s3://sfdl-csv-payrixess-stage/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:39:47",
"last_data": "2025-12-14 09:42:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 657929,
"location": "s3://sfdl-csv-payrixess-stage/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:38",
"last_data": "2025-12-16 09:29:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658065,
"location": "s3://sfdl-csv-payrixess-stage/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:29:45",
"last_data": "2025-12-16 09:29:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658151,
"location": "s3://sfdl-csv-payrixess-stage/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:27:01",
"last_data": "2025-12-18 09:30:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658288,
"location": "s3://sfdl-csv-payrixess-stage/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:36:34",
"last_data": "2025-12-19 09:28:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658415,
"location": "s3://sfdl-csv-payrixess-stage/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:28:47",
"last_data": "2025-12-20 09:26:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658536,
"location": "s3://sfdl-csv-payrixess-stage/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:39:34",
"last_data": "2025-12-21 09:30:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658644,
"location": "s3://sfdl-csv-payrixess-stage/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:30:16",
"last_data": "2025-12-22 09:41:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658780,
"location": "s3://sfdl-csv-payrixess-stage/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:44:12",
"last_data": "2025-12-23 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 658918,
"location": "s3://sfdl-csv-payrixess-stage/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:30:32",
"last_data": "2025-12-24 09:41:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659060,
"location": "s3://sfdl-csv-payrixess-stage/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:43:30",
"last_data": "2025-12-24 09:43:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659125,
"location": "s3://sfdl-csv-payrixess-stage/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:26:10",
"last_data": "2025-12-25 09:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659275,
"location": "s3://sfdl-csv-payrixess-stage/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:30:38",
"last_data": "2025-12-26 09:31:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659393,
"location": "s3://sfdl-csv-payrixess-stage/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:41:42",
"last_data": "2025-12-27 09:43:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659489,
"location": "s3://sfdl-csv-payrixess-stage/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:28:41",
"last_data": "2025-12-28 09:28:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659618,
"location": "s3://sfdl-csv-payrixess-stage/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:28:23",
"last_data": "2025-12-30 09:43:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659756,
"location": "s3://sfdl-csv-payrixess-stage/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:44:12",
"last_data": "2025-12-31 09:29:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659877,
"location": "s3://sfdl-csv-payrixess-stage/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:41:39",
"last_data": "2025-12-31 09:41:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 659979,
"location": "s3://sfdl-csv-payrixess-stage/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:30:50",
"last_data": "2026-01-01 09:31:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660070,
"location": "s3://sfdl-csv-payrixess-stage/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:27:37",
"last_data": "2026-01-03 09:49:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660230,
"location": "s3://sfdl-csv-payrixess-stage/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:49:38",
"last_data": "2026-01-04 09:46:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660333,
"location": "s3://sfdl-csv-payrixess-stage/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:47:15",
"last_data": "2026-01-05 09:28:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660469,
"location": "s3://sfdl-csv-payrixess-stage/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:47:59",
"last_data": "2026-01-06 09:27:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660545,
"location": "s3://sfdl-csv-payrixess-stage/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:27:29",
"last_data": "2026-01-07 09:40:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660708,
"location": "s3://sfdl-csv-payrixess-stage/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:43:36",
"last_data": "2026-01-07 09:43:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660815,
"location": "s3://sfdl-csv-payrixess-stage/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:43:08",
"last_data": "2026-01-08 09:44:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 660908,
"location": "s3://sfdl-csv-payrixess-stage/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:29:01",
"last_data": "2026-01-09 09:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661033,
"location": "s3://sfdl-csv-payrixess-stage/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:28:47",
"last_data": "2026-01-11 09:28:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661142,
"location": "s3://sfdl-csv-payrixess-stage/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:28:29",
"last_data": "2026-01-11 09:28:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661258,
"location": "s3://sfdl-csv-payrixess-stage/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:27:19",
"last_data": "2026-01-12 09:31:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661368,
"location": "s3://sfdl-csv-payrixess-stage/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:03",
"last_data": "2026-01-13 09:28:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661519,
"location": "s3://sfdl-csv-payrixess-stage/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:40:23",
"last_data": "2026-01-14 09:44:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661617,
"location": "s3://sfdl-csv-payrixess-stage/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:32:53",
"last_data": "2026-01-16 09:27:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661717,
"location": "s3://sfdl-csv-payrixess-stage/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:27:15",
"last_data": "2026-01-16 09:27:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661833,
"location": "s3://sfdl-csv-payrixess-stage/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:13",
"last_data": "2026-01-17 09:27:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 661985,
"location": "s3://sfdl-csv-payrixess-stage/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:39:27",
"last_data": "2026-01-18 09:39:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662067,
"location": "s3://sfdl-csv-payrixess-stage/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:26:40",
"last_data": "2026-01-19 09:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662208,
"location": "s3://sfdl-csv-payrixess-stage/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:28:42",
"last_data": "2026-01-21 09:43:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662345,
"location": "s3://sfdl-csv-payrixess-stage/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:45:59",
"last_data": "2026-01-22 09:41:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662505,
"location": "s3://sfdl-csv-payrixess-stage/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:41:25",
"last_data": "2026-01-23 09:27:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662622,
"location": "s3://sfdl-csv-payrixess-stage/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:42:18",
"last_data": "2026-01-24 09:44:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662745,
"location": "s3://sfdl-csv-payrixess-stage/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:44:41",
"last_data": "2026-01-25 09:29:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662822,
"location": "s3://sfdl-csv-payrixess-stage/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:29:32",
"last_data": "2026-01-26 09:30:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 662955,
"location": "s3://sfdl-csv-payrixess-stage/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:31:32",
"last_data": "2026-01-27 09:30:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663082,
"location": "s3://sfdl-csv-payrixess-stage/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:30:35",
"last_data": "2026-01-28 09:28:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 663185,
"location": "s3://sfdl-csv-payrixess-stage/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:28:57",
"last_data": "2026-01-28 09:28:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666015,
"location": "s3://sfdl-csv-payrixess-stage/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:28:35",
"last_data": "2026-01-30 09:33:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666149,
"location": "s3://sfdl-csv-payrixess-stage/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:34:06",
"last_data": "2026-01-31 09:29:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666266,
"location": "s3://sfdl-csv-payrixess-stage/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:29:11",
"last_data": "2026-01-31 09:29:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666377,
"location": "s3://sfdl-csv-payrixess-stage/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:27:00",
"last_data": "2026-02-01 09:27:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666543,
"location": "s3://sfdl-csv-payrixess-stage/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:45:11",
"last_data": "2026-02-03 09:36:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666660,
"location": "s3://sfdl-csv-payrixess-stage/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:51:10",
"last_data": "2026-02-04 09:30:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666766,
"location": "s3://sfdl-csv-payrixess-stage/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:32:13",
"last_data": "2026-02-04 09:32:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666878,
"location": "s3://sfdl-csv-payrixess-stage/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:02",
"last_data": "2026-02-05 09:32:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 666992,
"location": "s3://sfdl-csv-payrixess-stage/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:28:16",
"last_data": "2026-02-07 09:27:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667087,
"location": "s3://sfdl-csv-payrixess-stage/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:56",
"last_data": "2026-02-07 09:27:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667205,
"location": "s3://sfdl-csv-payrixess-stage/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:28:15",
"last_data": "2026-02-09 09:42:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667356,
"location": "s3://sfdl-csv-payrixess-stage/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:42:58",
"last_data": "2026-02-09 09:42:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667470,
"location": "s3://sfdl-csv-payrixess-stage/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:39:29",
"last_data": "2026-02-10 09:40:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667597,
"location": "s3://sfdl-csv-payrixess-stage/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:40:25",
"last_data": "2026-02-12 09:32:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667707,
"location": "s3://sfdl-csv-payrixess-stage/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:40:02",
"last_data": "2026-02-13 09:28:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667805,
"location": "s3://sfdl-csv-payrixess-stage/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:28:49",
"last_data": "2026-02-14 09:29:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 667951,
"location": "s3://sfdl-csv-payrixess-stage/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:31",
"last_data": "2026-02-15 09:39:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668039,
"location": "s3://sfdl-csv-payrixess-stage/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:40:40",
"last_data": "2026-02-16 09:28:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668154,
"location": "s3://sfdl-csv-payrixess-stage/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:28:42",
"last_data": "2026-02-17 09:42:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668301,
"location": "s3://sfdl-csv-payrixess-stage/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:51",
"last_data": "2026-02-18 09:43:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668406,
"location": "s3://sfdl-csv-payrixess-stage/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:44:17",
"last_data": "2026-02-18 09:44:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668527,
"location": "s3://sfdl-csv-payrixess-stage/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:41:03",
"last_data": "2026-02-19 09:41:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668633,
"location": "s3://sfdl-csv-payrixess-stage/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:32:19",
"last_data": "2026-02-21 09:39:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668771,
"location": "s3://sfdl-csv-payrixess-stage/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:41:03",
"last_data": "2026-02-21 09:41:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668865,
"location": "s3://sfdl-csv-payrixess-stage/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:38:17",
"last_data": "2026-02-22 09:40:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 668970,
"location": "s3://sfdl-csv-payrixess-stage/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:29:52",
"last_data": "2026-02-23 09:31:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669083,
"location": "s3://sfdl-csv-payrixess-stage/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:27:42",
"last_data": "2026-02-24 09:28:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669204,
"location": "s3://sfdl-csv-payrixess-stage/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:29:25",
"last_data": "2026-02-25 09:29:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669355,
"location": "s3://sfdl-csv-payrixess-stage/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:47:30",
"last_data": "2026-02-26 09:48:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669458,
"location": "s3://sfdl-csv-payrixess-stage/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:38",
"last_data": "2026-02-28 09:40:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669594,
"location": "s3://sfdl-csv-payrixess-stage/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:45:28",
"last_data": "2026-03-01 09:32:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669718,
"location": "s3://sfdl-csv-payrixess-stage/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:41:26",
"last_data": "2026-03-02 09:29:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669796,
"location": "s3://sfdl-csv-payrixess-stage/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:29:53",
"last_data": "2026-03-03 09:33:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 669940,
"location": "s3://sfdl-csv-payrixess-stage/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:34:17",
"last_data": "2026-03-04 09:38:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670113,
"location": "s3://sfdl-csv-payrixess-stage/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:49:31",
"last_data": "2026-03-05 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670211,
"location": "s3://sfdl-csv-payrixess-stage/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:51",
"last_data": "2026-03-06 09:28:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670350,
"location": "s3://sfdl-csv-payrixess-stage/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:09",
"last_data": "2026-03-06 09:47:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670442,
"location": "s3://sfdl-csv-payrixess-stage/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:28:51",
"last_data": "2026-03-07 09:29:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670555,
"location": "s3://sfdl-csv-payrixess-stage/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:29:26",
"last_data": "2026-03-08 09:30:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670693,
"location": "s3://sfdl-csv-payrixess-stage/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:42:59",
"last_data": "2026-03-09 09:44:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670810,
"location": "s3://sfdl-csv-payrixess-stage/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:42:51",
"last_data": "2026-03-11 09:30:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 670925,
"location": "s3://sfdl-csv-payrixess-stage/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:30:55",
"last_data": "2026-03-11 09:30:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671051,
"location": "s3://sfdl-csv-payrixess-stage/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:34:01",
"last_data": "2026-03-12 09:47:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671146,
"location": "s3://sfdl-csv-payrixess-stage/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:29:43",
"last_data": "2026-03-13 09:30:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671280,
"location": "s3://sfdl-csv-payrixess-stage/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:31:07",
"last_data": "2026-03-14 09:31:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671352,
"location": "s3://sfdl-csv-payrixess-stage/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:27:40",
"last_data": "2026-03-15 09:29:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671501,
"location": "s3://sfdl-csv-payrixess-stage/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:30:45",
"last_data": "2026-03-16 09:31:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671598,
"location": "s3://sfdl-csv-payrixess-stage/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:30:37",
"last_data": "2026-03-17 09:32:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671735,
"location": "s3://sfdl-csv-payrixess-stage/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:32:31",
"last_data": "2026-03-18 09:33:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671866,
"location": "s3://sfdl-csv-payrixess-stage/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:42:50",
"last_data": "2026-03-20 09:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 671965,
"location": "s3://sfdl-csv-payrixess-stage/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:30:17",
"last_data": "2026-03-21 09:28:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672082,
"location": "s3://sfdl-csv-payrixess-stage/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:28:53",
"last_data": "2026-03-21 09:28:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672177,
"location": "s3://sfdl-csv-payrixess-stage/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:28:23",
"last_data": "2026-03-22 09:28:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672318,
"location": "s3://sfdl-csv-payrixess-stage/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:28:40",
"last_data": "2026-03-24 09:32:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672466,
"location": "s3://sfdl-csv-payrixess-stage/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:43:52",
"last_data": "2026-03-24 09:43:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672538,
"location": "s3://sfdl-csv-payrixess-stage/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:27:14",
"last_data": "2026-03-26 09:30:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672681,
"location": "s3://sfdl-csv-payrixess-stage/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:30:37",
"last_data": "2026-03-27 09:32:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672815,
"location": "s3://sfdl-csv-payrixess-stage/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:43:40",
"last_data": "2026-03-27 09:43:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 672935,
"location": "s3://sfdl-csv-payrixess-stage/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:42:51",
"last_data": "2026-03-28 09:43:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673023,
"location": "s3://sfdl-csv-payrixess-stage/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:32:02",
"last_data": "2026-03-29 09:32:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673170,
"location": "s3://sfdl-csv-payrixess-stage/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:44:27",
"last_data": "2026-03-31 09:27:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673261,
"location": "s3://sfdl-csv-payrixess-stage/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:27:59",
"last_data": "2026-03-31 09:27:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673429,
"location": "s3://sfdl-csv-payrixess-stage/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:30:50",
"last_data": "2026-04-01 09:39:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673568,
"location": "s3://sfdl-csv-payrixess-stage/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:47:20",
"last_data": "2026-04-03 09:32:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673664,
"location": "s3://sfdl-csv-payrixess-stage/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:53:19",
"last_data": "2026-04-03 09:53:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673774,
"location": "s3://sfdl-csv-payrixess-stage/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:37:24",
"last_data": "2026-04-04 09:37:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 673885,
"location": "s3://sfdl-csv-payrixess-stage/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:29:39",
"last_data": "2026-04-05 09:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674022,
"location": "s3://sfdl-csv-payrixess-stage/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:30:39",
"last_data": "2026-04-06 09:43:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674110,
"location": "s3://sfdl-csv-payrixess-stage/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:28:28",
"last_data": "2026-04-07 09:30:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674264,
"location": "s3://sfdl-csv-payrixess-stage/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:33:51",
"last_data": "2026-04-08 09:34:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674393,
"location": "s3://sfdl-csv-payrixess-stage/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:50:07",
"last_data": "2026-04-09 09:50:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674500,
"location": "s3://sfdl-csv-payrixess-stage/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:41:32",
"last_data": "2026-04-10 09:41:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674604,
"location": "s3://sfdl-csv-payrixess-stage/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:29:19",
"last_data": "2026-04-12 09:29:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674705,
"location": "s3://sfdl-csv-payrixess-stage/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:29:53",
"last_data": "2026-04-12 09:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674827,
"location": "s3://sfdl-csv-payrixess-stage/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:32:48",
"last_data": "2026-04-13 09:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 674945,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-13",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 09:30:10",
"last_data": "2026-04-15 09:29:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675071,
"location": "s3://sfdl-csv-payrixess-stage/raw_incremental/transaction_details/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 09:30:18",
"last_data": "2026-04-15 09:30:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675194,
"location": "s3://sfdl-csv-payrixess-stage/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:41:32",
"last_data": "2026-04-17 09:31:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 675340,
"location": "s3://sfdl-csv-payrixess-stage/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:31:37",
"last_data": "2026-04-17 09:31:37"
},
"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:07:36",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw_incremental/transaction_details'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_transaction_details`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_transaction_details"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}