Schema Info
Schema Name: sfdl_dev_csv.payrixess_txns
- created: 2024-07-22 12:55:44
- disabled: False
- format: raw
- id: 2337
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_csv", "table": "payrixess_txns" } - type: csv
Schema Versions: 1
-
Version 4707580
- created: 2024-07-22 12:55:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_txns`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_txns`\n(\n `txn_id` string , `created` string , `modified` string , `token` string , `payment` string , `fortxn` string , `fromtxn` string , `batch` string , `subscription` string , `type` string , `expiration` string , `currency` string , `platform` string , `authdate` string , `authcode` string , `captured` string , `settled` string , `settledcurrency` string , `settledtotal` string , `allowpartial` string , `order` string , `description` string , `descriptor` string , `terminal` string , `entrymode` string , `origin` string , `tax` string , `total` string , `authorization` string , `approved` string , `cvv` string , `swiped` string , `emv` string , `signature` string , `company` string , `city` string , `state` string , `zip` string , `country` string , `status` string , `refunded` string , `reserved` string , `discount` string , `shipping` string , `duty` string , `pin` string , `tracenumber` string , `cvvstatus` string , `unauthreason` string , `fee` string , `fundingcurrency` string , `coftype` string , `originalapproved` string , `servicecode` string , `authtokencustomer` string , `debtrepayment` string , `statement` string , `conveniencefee` string , `surcharge` string , `channel` string , `funded` string , `fundingenabled` string , `merchant_id` string , `entity_id` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-csv-payrixess-dev/raw_incremental/txns'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_txns" ] - hive_path: s3://sfdl-csv-payrixess-dev/raw_incremental/txns
- id: 4707580
- processed: 1
- raw_data:
{ "allowpartial": 19, "approved": 29, "authcode": 14, "authdate": 13, "authorization": 28, "authtokencustomer": 54, "batch": 7, "captured": 15, "channel": 59, "city": 35, "coftype": 51, "company": 34, "conveniencefee": 57, "country": 38, "created": 1, "currency": 11, "cvv": 30, "cvvstatus": 47, "debtrepayment": 55, "description": 21, "descriptor": 22, "discount": 42, "duty": 44, "emv": 32, "entity_id": 63, "entrymode": 24, "expiration": 10, "fee": 49, "fortxn": 5, "fromtxn": 6, "funded": 60, "fundingcurrency": 50, "fundingenabled": 61, "merchant_id": 62, "modified": 2, "order": 20, "origin": 25, "originalapproved": 52, "payment": 4, "pin": 45, "platform": 12, "refunded": 40, "reserved": 41, "servicecode": 53, "settled": 16, "settledcurrency": 17, "settledtotal": 18, "shipping": 43, "signature": 33, "state": 36, "statement": 56, "status": 39, "subscription": 8, "surcharge": 58, "swiped": 31, "tax": 26, "terminal": 23, "token": 3, "total": 27, "tracenumber": 46, "txn_id": 0, "type": 9, "unauthreason": 48, "zip": 37 } - schema_attributes:
{ "allowpartial": "string", "approved": "string", "authcode": "string", "authdate": "string", "authorization": "string", "authtokencustomer": "string", "batch": "string", "captured": "string", "channel": "string", "city": "string", "coftype": "string", "company": "string", "conveniencefee": "string", "country": "string", "created": "string", "currency": "string", "cvv": "string", "cvvstatus": "string", "debtrepayment": "string", "description": "string", "descriptor": "string", "discount": "string", "duty": "string", "emv": "string", "entity_id": "string", "entrymode": "string", "expiration": "string", "fee": "string", "fortxn": "string", "fromtxn": "string", "funded": "string", "fundingcurrency": "string", "fundingenabled": "string", "merchant_id": "string", "modified": "string", "order": "string", "origin": "string", "originalapproved": "string", "payment": "string", "pin": "string", "platform": "string", "refunded": "string", "reserved": "string", "servicecode": "string", "settled": "string", "settledcurrency": "string", "settledtotal": "string", "shipping": "string", "signature": "string", "state": "string", "statement": "string", "status": "string", "subscription": "string", "surcharge": "string", "swiped": "string", "tax": "string", "terminal": "string", "token": "string", "total": "string", "tracenumber": "string", "txn_id": "string", "type": "string", "unauthreason": "string", "zip": "string" } - schema_name_id: 2337
- schema_scan_id: 6543612
- updated: 2024-07-22 12:56:00
Schema Scans: 5
Last at 2026-04-17 09:51:18
-
Scan 6867786
- duration: 0:00:05.053421
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6867786
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-16", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns", "key": "raw_incremental/txns/dt=2026-04-16/20bee67b-f643-42f0-8bab-7d7ca080cdba.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_txns", "type": "csv" }, "trace_context": { "parent_id": 490160090771025360, "service_name": "drive-thru", "span_id": 17831037610984602859, "trace_id": 7943479206052827002 } } - running: False
- schema_name_id: 2337
- start_time: 2026-04-17 09:51:18
- success: True
- trace_id: 7943479206052827002
-
Scan 6867777
- duration: 0:00:02.308296
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6867777
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns", "key": "raw_incremental/txns/dt=2026-04-15/1ec5bedb-dbc5-4776-a443-63693bb20615.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_txns", "type": "csv" }, "trace_context": { "parent_id": 6392521542432039445, "service_name": "drive-thru", "span_id": 14682152331211213404, "trace_id": 9267685150538517117 } } - running: False
- schema_name_id: 2337
- start_time: 2026-04-17 09:50:24
- success: True
- trace_id: 9267685150538517117
-
Scan 6867452
- duration: 0:00:04.978740
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 6867452
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns", "key": "raw_incremental/txns/dt=2026-04-15/eef22452-3870-4f38-9502-bfc6a3689da6.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_txns", "type": "csv" }, "trace_context": { "parent_id": 6518590786758580581, "service_name": "drive-thru", "span_id": 7862837017722848755, "trace_id": 8645822529450371388 } } - running: False
- schema_name_id: 2337
- start_time: 2026-04-16 09:33:29
- success: True
- trace_id: 8645822529450371388
-
Scan 6867449
- duration: 0:00:02.174921
- exit_message:
{ "ddl_changed": false, "partitions_applied": false, "success": true } - id: 6867449
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-14", "name": "dt", "type": "string", "value": "2026-04-14" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns", "key": "raw_incremental/txns/dt=2026-04-14/e3d68959-1b55-473a-9255-83ac73d19569.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_txns", "type": "csv" }, "trace_context": { "parent_id": 687507379582392099, "service_name": "drive-thru", "span_id": 17106602136872830058, "trace_id": 6425082736561049740 } } - running: False
- schema_name_id: 2337
- start_time: 2026-04-16 09:33:22
- success: True
- trace_id: 6425082736561049740
-
Scan 6543612
- duration: 0:00:18.841879
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2, "partitions_applied": false, "success": true } - id: 6543612
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2024-07-21", "name": "dt", "type": "string", "value": "2024-07-21" }, "s3": { "bucket": "sfdl-csv-payrixess-dev", "hive_path": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns", "key": "raw_incremental/txns/dt=2024-07-21/ec002743-5f8b-45c5-a96c-9008ee26dce0.csv.gz" }, "schema": { "name": "sfdl_dev_csv.payrixess_txns", "type": "csv" }, "trace_context": { "parent_id": 313468651077654905, "service_name": "drive-thru", "span_id": 3603027918781699521, "trace_id": 11838620626280527924 } } - running: False
- schema_name_id: 2337
- start_time: 2024-07-22 12:55:44
- success: True
- trace_id: 11838620626280527924
- count: 129
- ddl:
[ "ALTER TABLE\n `sfdl_dev_csv.payrixess_txns`\nADD\n\n\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-11'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-24'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-06'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-27'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-02'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-06'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-10'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-20'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-26'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-30'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-03'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-14'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 304256, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-09", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 09:26:49", "last_data": "2025-12-11 09:30:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304371, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 09:32:02", "last_data": "2025-12-11 09:32:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304437, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-11", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 09:42:22", "last_data": "2025-12-12 09:42:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304494, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-12", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 09:28:40", "last_data": "2025-12-14 09:43:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304575, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-14 09:43:37", "last_data": "2025-12-14 09:43:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304626, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-14", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 09:29:11", "last_data": "2025-12-15 09:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304685, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-15", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 09:29:13", "last_data": "2025-12-17 09:39:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304785, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-16", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 09:44:17", "last_data": "2025-12-18 09:27:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304802, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 09:26:44", "last_data": "2025-12-18 09:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304883, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-18", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 09:39:43", "last_data": "2025-12-19 09:42:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 304952, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-19", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 09:32:35", "last_data": "2025-12-21 09:28:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305009, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-21 09:29:31", "last_data": "2025-12-21 09:29:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305084, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-21", "name": "dt", "value": "2025-12-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 09:39:56", "last_data": "2025-12-23 09:27:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305138, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 09:27:11", "last_data": "2025-12-23 09:27:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305190, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-23", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 09:27:26", "last_data": "2025-12-25 09:31:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305300, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-24", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 09:45:06", "last_data": "2025-12-26 09:27:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305356, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 09:41:44", "last_data": "2025-12-26 09:41:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305378, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-26", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 09:25:59", "last_data": "2025-12-27 09:39:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305484, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-27", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 09:41:05", "last_data": "2025-12-29 09:30:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 305554, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-28", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 09:32:07", "last_data": "2025-12-30 09:27:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306893, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-29", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 09:42:37", "last_data": "2025-12-31 09:41:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 306956, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 09:43:20", "last_data": "2025-12-31 09:43:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307015, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-31", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 09:44:22", "last_data": "2026-01-01 09:45:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307057, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-01", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 09:42:10", "last_data": "2026-01-03 09:28:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307109, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 09:30:46", "last_data": "2026-01-03 09:30:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307188, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-03", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 09:33:59", "last_data": "2026-01-05 09:39:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307275, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-04", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 09:41:40", "last_data": "2026-01-06 09:27:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307312, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 09:29:10", "last_data": "2026-01-06 09:29:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307361, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-06", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 09:26:12", "last_data": "2026-01-07 09:30:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307443, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-07", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 09:29:21", "last_data": "2026-01-08 09:30:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307500, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-08", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 09:28:43", "last_data": "2026-01-10 09:28:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307565, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-09", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 09:29:15", "last_data": "2026-01-11 09:27:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307636, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-10", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 09:29:15", "last_data": "2026-01-12 09:39:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307724, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-11", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 09:41:07", "last_data": "2026-01-13 09:28:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307771, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 09:28:42", "last_data": "2026-01-13 09:28:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307845, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-13", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 09:41:51", "last_data": "2026-01-15 09:29:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307915, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 09:29:47", "last_data": "2026-01-15 09:29:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 307976, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-15", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 09:40:44", "last_data": "2026-01-16 09:41:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308021, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-16", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 09:43:29", "last_data": "2026-01-17 09:44:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308072, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-17", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 09:28:23", "last_data": "2026-01-19 09:26:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308138, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-18", "name": "dt", "value": "2026-01-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 09:27:06", "last_data": "2026-01-20 09:44:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308245, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 09:45:47", "last_data": "2026-01-20 09:45:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308279, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-20", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 09:30:04", "last_data": "2026-01-21 09:30:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308470, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-21", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 09:42:24", "last_data": "2026-01-22 09:46:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308511, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-22", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 09:29:14", "last_data": "2026-01-23 09:45:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308573, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-23", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 09:27:24", "last_data": "2026-01-25 09:26:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308679, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 09:45:46", "last_data": "2026-01-25 09:45:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308717, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-25", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 09:39:29", "last_data": "2026-01-27 09:27:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308784, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 09:28:42", "last_data": "2026-01-27 09:28:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308849, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-27", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 09:29:50", "last_data": "2026-01-28 09:30:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308925, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-28", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 09:40:36", "last_data": "2026-01-30 09:29:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 308980, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 09:32:37", "last_data": "2026-01-30 09:32:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309053, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-30", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-31 09:42:17", "last_data": "2026-02-01 09:29:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309078, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-31/", "name": "dt", "value": "2026-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-01 09:29:28", "last_data": "2026-02-01 09:29:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309160, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-01", "name": "dt", "value": "2026-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 09:32:35", "last_data": "2026-02-02 09:33:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309209, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-02", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 09:29:34", "last_data": "2026-02-03 09:30:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309278, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-03", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 09:29:59", "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": 309349, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-04", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-05 09:30:14", "last_data": "2026-02-06 09:27:31" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309412, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-05", "name": "dt", "value": "2026-02-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-06 09:43:02", "last_data": "2026-02-07 09:28:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309468, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-06", "name": "dt", "value": "2026-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-07 09:28:09", "last_data": "2026-02-08 09:27:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309526, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-07", "name": "dt", "value": "2026-02-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-08 09:27:55", "last_data": "2026-02-09 09:30:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309638, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-08", "name": "dt", "value": "2026-02-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-09 09:42:30", "last_data": "2026-02-10 09:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309668, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-09/", "name": "dt", "value": "2026-02-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 09:27:29", "last_data": "2026-02-10 09:27:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309726, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-10", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-11 09:29:26", "last_data": "2026-02-11 09:30:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309794, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-11", "name": "dt", "value": "2026-02-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 09:30:39", "last_data": "2026-02-13 09:32:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309891, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-12", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-13 09:47:51", "last_data": "2026-02-14 09:39:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 309932, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-14 09:39:47", "last_data": "2026-02-14 09:39:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310003, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-14", "name": "dt", "value": "2026-02-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-15 09:41:04", "last_data": "2026-02-16 09:31:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310062, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-15", "name": "dt", "value": "2026-02-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-16 09:31:24", "last_data": "2026-02-17 09:30:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310201, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-16", "name": "dt", "value": "2026-02-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 09:30:31", "last_data": "2026-02-18 09:33:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310268, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-18 09:33:57", "last_data": "2026-02-18 09:33:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310326, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-18", "name": "dt", "value": "2026-02-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-19 09:31:27", "last_data": "2026-02-20 09:41:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310422, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-19/", "name": "dt", "value": "2026-02-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-20 09:43:47", "last_data": "2026-02-20 09:43:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310467, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-20", "name": "dt", "value": "2026-02-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-21 09:28:42", "last_data": "2026-02-22 09:43:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310541, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-21/", "name": "dt", "value": "2026-02-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-22 09:44:10", "last_data": "2026-02-22 09:44:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310608, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-22", "name": "dt", "value": "2026-02-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-23 09:30:30", "last_data": "2026-02-23 09:40:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310656, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-23", "name": "dt", "value": "2026-02-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-24 09:30:06", "last_data": "2026-02-24 09:31:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310722, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-24", "name": "dt", "value": "2026-02-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-25 09:39:37", "last_data": "2026-02-25 09:45:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310797, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-25", "name": "dt", "value": "2026-02-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-26 09:41:33", "last_data": "2026-02-27 09:41:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310865, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-26", "name": "dt", "value": "2026-02-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-27 09:42:24", "last_data": "2026-02-28 09:32:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310907, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-27/", "name": "dt", "value": "2026-02-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-28 09:31:58", "last_data": "2026-02-28 09:31:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 310975, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-28", "name": "dt", "value": "2026-02-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-01 09:32:45", "last_data": "2026-03-02 09:27:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311025, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-01/", "name": "dt", "value": "2026-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 09:28:15", "last_data": "2026-03-02 09:28:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311104, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-02", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-03 09:47:55", "last_data": "2026-03-04 09:34:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311163, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-03/", "name": "dt", "value": "2026-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-04 09:35:09", "last_data": "2026-03-04 09:35:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311222, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-04", "name": "dt", "value": "2026-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-05 09:29:45", "last_data": "2026-03-06 09:40:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311290, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-05/", "name": "dt", "value": "2026-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-06 09:41:46", "last_data": "2026-03-06 09:41:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311340, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-06", "name": "dt", "value": "2026-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-07 09:38:36", "last_data": "2026-03-08 09:42:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311445, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-07", "name": "dt", "value": "2026-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-08 09:44:38", "last_data": "2026-03-09 09:42:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311508, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-08", "name": "dt", "value": "2026-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-09 09:43:47", "last_data": "2026-03-10 09:31:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311575, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-09", "name": "dt", "value": "2026-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-10 09:31:34", "last_data": "2026-03-11 09:28:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311614, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-10", "name": "dt", "value": "2026-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-11 09:29:13", "last_data": "2026-03-12 09:28:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311681, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-11", "name": "dt", "value": "2026-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-12 09:28:35", "last_data": "2026-03-13 09:29:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311753, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-12/", "name": "dt", "value": "2026-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-13 09:30:27", "last_data": "2026-03-13 09:30:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311788, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-13", "name": "dt", "value": "2026-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-14 09:31:02", "last_data": "2026-03-15 09:44:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311885, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-14/", "name": "dt", "value": "2026-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 09:44:51", "last_data": "2026-03-15 09:44:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 311920, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-15", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-16 09:27:42", "last_data": "2026-03-16 09:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312024, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-16", "name": "dt", "value": "2026-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-17 09:28:59", "last_data": "2026-03-18 09:27:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312125, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-17", "name": "dt", "value": "2026-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-18 09:44:04", "last_data": "2026-03-19 09:44:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312190, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-18/", "name": "dt", "value": "2026-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-19 09:45:01", "last_data": "2026-03-19 09:45:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312242, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-19", "name": "dt", "value": "2026-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-20 09:33:56", "last_data": "2026-03-21 09:43:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312322, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-20", "name": "dt", "value": "2026-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-21 09:44:34", "last_data": "2026-03-22 09:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312342, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-21/", "name": "dt", "value": "2026-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-22 09:27:50", "last_data": "2026-03-22 09:27:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312407, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-22", "name": "dt", "value": "2026-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-23 09:28:24", "last_data": "2026-03-23 09:29:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312511, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-23", "name": "dt", "value": "2026-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 09:41:57", "last_data": "2026-03-25 09:42:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312580, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-24", "name": "dt", "value": "2026-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-25 09:44:46", "last_data": "2026-03-26 09:30:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312619, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-26 09:33:12", "last_data": "2026-03-26 09:33:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312686, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-26", "name": "dt", "value": "2026-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-27 09:42:23", "last_data": "2026-03-27 09:42:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312717, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-27", "name": "dt", "value": "2026-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 09:27:46", "last_data": "2026-03-29 09:27:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312790, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-28", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-29 09:27:27", "last_data": "2026-03-30 09:25:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312898, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-29", "name": "dt", "value": "2026-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-30 09:43:06", "last_data": "2026-03-31 09:28:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312939, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-30", "name": "dt", "value": "2026-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-31 09:29:59", "last_data": "2026-04-01 09:29:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 312992, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-31", "name": "dt", "value": "2026-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-01 09:33:16", "last_data": "2026-04-02 09:33:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313064, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-01", "name": "dt", "value": "2026-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-02 09:33:52", "last_data": "2026-04-03 09:31:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313126, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-02/", "name": "dt", "value": "2026-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 09:33:52", "last_data": "2026-04-03 09:33:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313185, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-03", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-04 09:37:56", "last_data": "2026-04-04 09:50:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313265, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-04", "name": "dt", "value": "2026-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-05 09:44:49", "last_data": "2026-04-05 09:46:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313311, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-05", "name": "dt", "value": "2026-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-06 09:34:33", "last_data": "2026-04-06 09:35:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313401, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-06", "name": "dt", "value": "2026-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-07 09:32:11", "last_data": "2026-04-08 09:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313447, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-07/", "name": "dt", "value": "2026-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 09:30:33", "last_data": "2026-04-08 09:30:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313526, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-08", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 09:46:04", "last_data": "2026-04-10 09:29:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313596, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 09:42:17", "last_data": "2026-04-10 09:42:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313628, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-10", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 09:29:25", "last_data": "2026-04-12 09:29:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313696, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-11/", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-12 09:30:07", "last_data": "2026-04-12 09:30:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313756, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-12", "name": "dt", "value": "2026-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 09:35:40", "last_data": "2026-04-13 09:35:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313830, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-13", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 10:00:44", "last_data": "2026-04-14 10:02:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313903, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-14", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 09:58:22", "last_data": "2026-04-16 09:33:24" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 313945, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 09:33:31", "last_data": "2026-04-17 09:50:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 314036, "location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-17 09:51:20", "last_data": "2026-04-17 09:51:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "allowpartial": "string", "approved": "string", "authcode": "string", "authdate": "string", "authorization": "string", "authtokencustomer": "string", "batch": "string", "captured": "string", "channel": "string", "city": "string", "coftype": "string", "company": "string", "conveniencefee": "string", "country": "string", "created": "string", "currency": "string", "cvv": "string", "cvvstatus": "string", "debtrepayment": "string", "description": "string", "descriptor": "string", "discount": "string", "duty": "string", "emv": "string", "entity_id": "string", "entrymode": "string", "expiration": "string", "fee": "string", "fortxn": "string", "fromtxn": "string", "funded": "string", "fundingcurrency": "string", "fundingenabled": "string", "merchant_id": "string", "modified": "string", "order": "string", "origin": "string", "originalapproved": "string", "payment": "string", "pin": "string", "platform": "string", "refunded": "string", "reserved": "string", "servicecode": "string", "settled": "string", "settledcurrency": "string", "settledtotal": "string", "shipping": "string", "signature": "string", "state": "string", "statement": "string", "status": "string", "subscription": "string", "surcharge": "string", "swiped": "string", "tax": "string", "terminal": "string", "token": "string", "total": "string", "tracenumber": "string", "txn_id": "string", "type": "string", "unauthreason": "string", "zip": "string" } - created: 2024-07-22 12:55:46
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_txns`\n(\n `txn_id` string , `created` string , `modified` string , `token` string , `payment` string , `fortxn` string , `fromtxn` string , `batch` string , `subscription` string , `type` string , `expiration` string , `currency` string , `platform` string , `authdate` string , `authcode` string , `captured` string , `settled` string , `settledcurrency` string , `settledtotal` string , `allowpartial` string , `order` string , `description` string , `descriptor` string , `terminal` string , `entrymode` string , `origin` string , `tax` string , `total` string , `authorization` string , `approved` string , `cvv` string , `swiped` string , `emv` string , `signature` string , `company` string , `city` string , `state` string , `zip` string , `country` string , `status` string , `refunded` string , `reserved` string , `discount` string , `shipping` string , `duty` string , `pin` string , `tracenumber` string , `cvvstatus` string , `unauthreason` string , `fee` string , `fundingcurrency` string , `coftype` string , `originalapproved` string , `servicecode` string , `authtokencustomer` string , `debtrepayment` string , `statement` string , `conveniencefee` string , `surcharge` string , `channel` string , `funded` string , `fundingenabled` string , `merchant_id` string , `entity_id` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-csv-payrixess-dev/raw_incremental/txns'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_txns`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_txns" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-07-22 12:55:44",
"disabled": false,
"format": "raw",
"id": 2337,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_csv",
"table": "payrixess_txns"
},
"type": "csv"
},
"partition": {
"count": 129,
"ddl": [
"ALTER TABLE\n `sfdl_dev_csv.payrixess_txns`\nADD\n\n\n PARTITION (dt='2025-12-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-09'\n PARTITION (dt='2025-12-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-11'\n PARTITION (dt='2025-12-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-12'\n PARTITION (dt='2025-12-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-13/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-14'\n PARTITION (dt='2025-12-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-15'\n PARTITION (dt='2025-12-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-16'\n PARTITION (dt='2025-12-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-18'\n PARTITION (dt='2025-12-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-19'\n PARTITION (dt='2025-12-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-20/'\n PARTITION (dt='2025-12-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-21'\n PARTITION (dt='2025-12-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-23'\n PARTITION (dt='2025-12-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-24'\n PARTITION (dt='2025-12-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-26'\n PARTITION (dt='2025-12-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-27'\n PARTITION (dt='2025-12-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-28'\n PARTITION (dt='2025-12-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-29'\n PARTITION (dt='2025-12-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-31'\n PARTITION (dt='2026-01-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-01'\n PARTITION (dt='2026-01-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-03'\n PARTITION (dt='2026-01-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-04'\n PARTITION (dt='2026-01-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-06'\n PARTITION (dt='2026-01-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-07'\n PARTITION (dt='2026-01-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-08'\n PARTITION (dt='2026-01-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-09'\n PARTITION (dt='2026-01-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-10'\n PARTITION (dt='2026-01-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-11'\n PARTITION (dt='2026-01-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-13'\n PARTITION (dt='2026-01-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-15'\n PARTITION (dt='2026-01-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-16'\n PARTITION (dt='2026-01-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-17'\n PARTITION (dt='2026-01-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-18'\n PARTITION (dt='2026-01-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-20'\n PARTITION (dt='2026-01-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-21'\n PARTITION (dt='2026-01-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-22'\n PARTITION (dt='2026-01-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-23'\n PARTITION (dt='2026-01-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-25'\n PARTITION (dt='2026-01-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-27'\n PARTITION (dt='2026-01-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-28'\n PARTITION (dt='2026-01-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-30'\n PARTITION (dt='2026-01-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-31/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-01'\n PARTITION (dt='2026-02-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-02'\n PARTITION (dt='2026-02-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-03'\n PARTITION (dt='2026-02-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-04'\n PARTITION (dt='2026-02-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-05'\n PARTITION (dt='2026-02-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-06'\n PARTITION (dt='2026-02-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-07'\n PARTITION (dt='2026-02-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-08'\n PARTITION (dt='2026-02-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-10'\n PARTITION (dt='2026-02-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-11'\n PARTITION (dt='2026-02-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-12'\n PARTITION (dt='2026-02-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-13/'\n PARTITION (dt='2026-02-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-14'\n PARTITION (dt='2026-02-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-15'\n PARTITION (dt='2026-02-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-16'\n PARTITION (dt='2026-02-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-17/'\n PARTITION (dt='2026-02-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-18'\n PARTITION (dt='2026-02-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-19/'\n PARTITION (dt='2026-02-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-20'\n PARTITION (dt='2026-02-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-21/'\n PARTITION (dt='2026-02-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-22'\n PARTITION (dt='2026-02-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-23'\n PARTITION (dt='2026-02-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-24'\n PARTITION (dt='2026-02-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-25'\n PARTITION (dt='2026-02-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-26'\n PARTITION (dt='2026-02-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-27/'\n PARTITION (dt='2026-02-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-28'\n PARTITION (dt='2026-03-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-02'\n PARTITION (dt='2026-03-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-04'\n PARTITION (dt='2026-03-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-06'\n PARTITION (dt='2026-03-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-07'\n PARTITION (dt='2026-03-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-08'\n PARTITION (dt='2026-03-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-09'\n PARTITION (dt='2026-03-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-10'\n PARTITION (dt='2026-03-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-11'\n PARTITION (dt='2026-03-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-12/'\n PARTITION (dt='2026-03-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-13'\n PARTITION (dt='2026-03-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-14/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-15'\n PARTITION (dt='2026-03-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-16'\n PARTITION (dt='2026-03-17') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-17'\n PARTITION (dt='2026-03-18') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-18/'\n PARTITION (dt='2026-03-19') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-19'\n PARTITION (dt='2026-03-20') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-20'\n PARTITION (dt='2026-03-21') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-21/'\n PARTITION (dt='2026-03-22') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-22'\n PARTITION (dt='2026-03-23') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-23'\n PARTITION (dt='2026-03-24') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-24'\n PARTITION (dt='2026-03-25') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-25/'\n PARTITION (dt='2026-03-26') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-26'\n PARTITION (dt='2026-03-27') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-27'\n PARTITION (dt='2026-03-28') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-28'\n PARTITION (dt='2026-03-29') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-29'\n PARTITION (dt='2026-03-30') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-30'\n PARTITION (dt='2026-03-31') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-31'\n PARTITION (dt='2026-04-01') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-01'\n PARTITION (dt='2026-04-02') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-03'\n PARTITION (dt='2026-04-04') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-04'\n PARTITION (dt='2026-04-05') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-05'\n PARTITION (dt='2026-04-06') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-06'\n PARTITION (dt='2026-04-07') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-08'\n PARTITION (dt='2026-04-09') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-10'\n PARTITION (dt='2026-04-11') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-11/'\n PARTITION (dt='2026-04-12') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-12'\n PARTITION (dt='2026-04-13') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-13'\n PARTITION (dt='2026-04-14') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-14'\n PARTITION (dt='2026-04-15') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15'\n PARTITION (dt='2026-04-16') location 's3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 304256,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-09",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 09:26:49",
"last_data": "2025-12-11 09:30:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304371,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 09:32:02",
"last_data": "2025-12-11 09:32:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304437,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-11",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 09:42:22",
"last_data": "2025-12-12 09:42:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304494,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-12",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 09:28:40",
"last_data": "2025-12-14 09:43:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304575,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-14 09:43:37",
"last_data": "2025-12-14 09:43:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304626,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-14",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 09:29:11",
"last_data": "2025-12-15 09:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304685,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-15",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 09:29:13",
"last_data": "2025-12-17 09:39:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304785,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-16",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 09:44:17",
"last_data": "2025-12-18 09:27:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304802,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 09:26:44",
"last_data": "2025-12-18 09:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304883,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-18",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 09:39:43",
"last_data": "2025-12-19 09:42:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 304952,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-19",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 09:32:35",
"last_data": "2025-12-21 09:28:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305009,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-21 09:29:31",
"last_data": "2025-12-21 09:29:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305084,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-21",
"name": "dt",
"value": "2025-12-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 09:39:56",
"last_data": "2025-12-23 09:27:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305138,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 09:27:11",
"last_data": "2025-12-23 09:27:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305190,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-23",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 09:27:26",
"last_data": "2025-12-25 09:31:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305300,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-24",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 09:45:06",
"last_data": "2025-12-26 09:27:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305356,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 09:41:44",
"last_data": "2025-12-26 09:41:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305378,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-26",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 09:25:59",
"last_data": "2025-12-27 09:39:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305484,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-27",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 09:41:05",
"last_data": "2025-12-29 09:30:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 305554,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-28",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 09:32:07",
"last_data": "2025-12-30 09:27:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306893,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-29",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 09:42:37",
"last_data": "2025-12-31 09:41:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 306956,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 09:43:20",
"last_data": "2025-12-31 09:43:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307015,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2025-12-31",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 09:44:22",
"last_data": "2026-01-01 09:45:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307057,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-01",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 09:42:10",
"last_data": "2026-01-03 09:28:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307109,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 09:30:46",
"last_data": "2026-01-03 09:30:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307188,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-03",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 09:33:59",
"last_data": "2026-01-05 09:39:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307275,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-04",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 09:41:40",
"last_data": "2026-01-06 09:27:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307312,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 09:29:10",
"last_data": "2026-01-06 09:29:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307361,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-06",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 09:26:12",
"last_data": "2026-01-07 09:30:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307443,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-07",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 09:29:21",
"last_data": "2026-01-08 09:30:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307500,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-08",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 09:28:43",
"last_data": "2026-01-10 09:28:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307565,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-09",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 09:29:15",
"last_data": "2026-01-11 09:27:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307636,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-10",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 09:29:15",
"last_data": "2026-01-12 09:39:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307724,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-11",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 09:41:07",
"last_data": "2026-01-13 09:28:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307771,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 09:28:42",
"last_data": "2026-01-13 09:28:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307845,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-13",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 09:41:51",
"last_data": "2026-01-15 09:29:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307915,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 09:29:47",
"last_data": "2026-01-15 09:29:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 307976,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-15",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 09:40:44",
"last_data": "2026-01-16 09:41:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308021,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-16",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 09:43:29",
"last_data": "2026-01-17 09:44:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308072,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-17",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 09:28:23",
"last_data": "2026-01-19 09:26:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308138,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-18",
"name": "dt",
"value": "2026-01-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 09:27:06",
"last_data": "2026-01-20 09:44:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308245,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 09:45:47",
"last_data": "2026-01-20 09:45:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308279,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-20",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 09:30:04",
"last_data": "2026-01-21 09:30:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308470,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-21",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 09:42:24",
"last_data": "2026-01-22 09:46:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308511,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-22",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 09:29:14",
"last_data": "2026-01-23 09:45:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308573,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-23",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 09:27:24",
"last_data": "2026-01-25 09:26:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308679,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 09:45:46",
"last_data": "2026-01-25 09:45:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308717,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-25",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 09:39:29",
"last_data": "2026-01-27 09:27:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308784,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 09:28:42",
"last_data": "2026-01-27 09:28:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308849,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-27",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 09:29:50",
"last_data": "2026-01-28 09:30:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308925,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-28",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 09:40:36",
"last_data": "2026-01-30 09:29:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 308980,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 09:32:37",
"last_data": "2026-01-30 09:32:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309053,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-30",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-31 09:42:17",
"last_data": "2026-02-01 09:29:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309078,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-01-31/",
"name": "dt",
"value": "2026-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-01 09:29:28",
"last_data": "2026-02-01 09:29:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309160,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-01",
"name": "dt",
"value": "2026-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 09:32:35",
"last_data": "2026-02-02 09:33:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309209,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-02",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 09:29:34",
"last_data": "2026-02-03 09:30:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309278,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-03",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 09:29:59",
"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": 309349,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-04",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-05 09:30:14",
"last_data": "2026-02-06 09:27:31"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309412,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-05",
"name": "dt",
"value": "2026-02-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-06 09:43:02",
"last_data": "2026-02-07 09:28:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309468,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-06",
"name": "dt",
"value": "2026-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-07 09:28:09",
"last_data": "2026-02-08 09:27:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309526,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-07",
"name": "dt",
"value": "2026-02-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-08 09:27:55",
"last_data": "2026-02-09 09:30:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309638,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-08",
"name": "dt",
"value": "2026-02-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-09 09:42:30",
"last_data": "2026-02-10 09:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309668,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-09/",
"name": "dt",
"value": "2026-02-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 09:27:29",
"last_data": "2026-02-10 09:27:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309726,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-10",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-11 09:29:26",
"last_data": "2026-02-11 09:30:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309794,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-11",
"name": "dt",
"value": "2026-02-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 09:30:39",
"last_data": "2026-02-13 09:32:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309891,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-12",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-13 09:47:51",
"last_data": "2026-02-14 09:39:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 309932,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-14 09:39:47",
"last_data": "2026-02-14 09:39:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310003,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-14",
"name": "dt",
"value": "2026-02-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-15 09:41:04",
"last_data": "2026-02-16 09:31:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310062,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-15",
"name": "dt",
"value": "2026-02-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-16 09:31:24",
"last_data": "2026-02-17 09:30:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310201,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-16",
"name": "dt",
"value": "2026-02-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 09:30:31",
"last_data": "2026-02-18 09:33:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310268,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-18 09:33:57",
"last_data": "2026-02-18 09:33:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310326,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-18",
"name": "dt",
"value": "2026-02-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-19 09:31:27",
"last_data": "2026-02-20 09:41:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310422,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-19/",
"name": "dt",
"value": "2026-02-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-20 09:43:47",
"last_data": "2026-02-20 09:43:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310467,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-20",
"name": "dt",
"value": "2026-02-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-21 09:28:42",
"last_data": "2026-02-22 09:43:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310541,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-21/",
"name": "dt",
"value": "2026-02-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-22 09:44:10",
"last_data": "2026-02-22 09:44:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310608,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-22",
"name": "dt",
"value": "2026-02-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-23 09:30:30",
"last_data": "2026-02-23 09:40:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310656,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-23",
"name": "dt",
"value": "2026-02-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-24 09:30:06",
"last_data": "2026-02-24 09:31:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310722,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-24",
"name": "dt",
"value": "2026-02-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-25 09:39:37",
"last_data": "2026-02-25 09:45:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310797,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-25",
"name": "dt",
"value": "2026-02-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-26 09:41:33",
"last_data": "2026-02-27 09:41:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310865,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-26",
"name": "dt",
"value": "2026-02-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-27 09:42:24",
"last_data": "2026-02-28 09:32:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310907,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-27/",
"name": "dt",
"value": "2026-02-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-28 09:31:58",
"last_data": "2026-02-28 09:31:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 310975,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-02-28",
"name": "dt",
"value": "2026-02-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-01 09:32:45",
"last_data": "2026-03-02 09:27:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311025,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-01/",
"name": "dt",
"value": "2026-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 09:28:15",
"last_data": "2026-03-02 09:28:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311104,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-02",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-03 09:47:55",
"last_data": "2026-03-04 09:34:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311163,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-03/",
"name": "dt",
"value": "2026-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-04 09:35:09",
"last_data": "2026-03-04 09:35:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311222,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-04",
"name": "dt",
"value": "2026-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-05 09:29:45",
"last_data": "2026-03-06 09:40:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311290,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-05/",
"name": "dt",
"value": "2026-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-06 09:41:46",
"last_data": "2026-03-06 09:41:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311340,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-06",
"name": "dt",
"value": "2026-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-07 09:38:36",
"last_data": "2026-03-08 09:42:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311445,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-07",
"name": "dt",
"value": "2026-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-08 09:44:38",
"last_data": "2026-03-09 09:42:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311508,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-08",
"name": "dt",
"value": "2026-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-09 09:43:47",
"last_data": "2026-03-10 09:31:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311575,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-09",
"name": "dt",
"value": "2026-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-10 09:31:34",
"last_data": "2026-03-11 09:28:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311614,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-10",
"name": "dt",
"value": "2026-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-11 09:29:13",
"last_data": "2026-03-12 09:28:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311681,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-11",
"name": "dt",
"value": "2026-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-12 09:28:35",
"last_data": "2026-03-13 09:29:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311753,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-12/",
"name": "dt",
"value": "2026-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-13 09:30:27",
"last_data": "2026-03-13 09:30:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311788,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-13",
"name": "dt",
"value": "2026-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-14 09:31:02",
"last_data": "2026-03-15 09:44:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311885,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-14/",
"name": "dt",
"value": "2026-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 09:44:51",
"last_data": "2026-03-15 09:44:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 311920,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-15",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-16 09:27:42",
"last_data": "2026-03-16 09:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312024,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-16",
"name": "dt",
"value": "2026-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-17 09:28:59",
"last_data": "2026-03-18 09:27:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312125,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-17",
"name": "dt",
"value": "2026-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-18 09:44:04",
"last_data": "2026-03-19 09:44:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312190,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-18/",
"name": "dt",
"value": "2026-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-19 09:45:01",
"last_data": "2026-03-19 09:45:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312242,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-19",
"name": "dt",
"value": "2026-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-20 09:33:56",
"last_data": "2026-03-21 09:43:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312322,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-20",
"name": "dt",
"value": "2026-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-21 09:44:34",
"last_data": "2026-03-22 09:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312342,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-21/",
"name": "dt",
"value": "2026-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-22 09:27:50",
"last_data": "2026-03-22 09:27:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312407,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-22",
"name": "dt",
"value": "2026-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-23 09:28:24",
"last_data": "2026-03-23 09:29:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312511,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-23",
"name": "dt",
"value": "2026-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 09:41:57",
"last_data": "2026-03-25 09:42:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312580,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-24",
"name": "dt",
"value": "2026-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-25 09:44:46",
"last_data": "2026-03-26 09:30:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312619,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-26 09:33:12",
"last_data": "2026-03-26 09:33:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312686,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-26",
"name": "dt",
"value": "2026-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-27 09:42:23",
"last_data": "2026-03-27 09:42:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312717,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-27",
"name": "dt",
"value": "2026-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 09:27:46",
"last_data": "2026-03-29 09:27:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312790,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-28",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-29 09:27:27",
"last_data": "2026-03-30 09:25:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312898,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-29",
"name": "dt",
"value": "2026-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-30 09:43:06",
"last_data": "2026-03-31 09:28:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312939,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-30",
"name": "dt",
"value": "2026-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-31 09:29:59",
"last_data": "2026-04-01 09:29:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 312992,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-03-31",
"name": "dt",
"value": "2026-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-01 09:33:16",
"last_data": "2026-04-02 09:33:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313064,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-01",
"name": "dt",
"value": "2026-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-02 09:33:52",
"last_data": "2026-04-03 09:31:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313126,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-02/",
"name": "dt",
"value": "2026-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 09:33:52",
"last_data": "2026-04-03 09:33:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313185,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-03",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-04 09:37:56",
"last_data": "2026-04-04 09:50:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313265,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-04",
"name": "dt",
"value": "2026-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-05 09:44:49",
"last_data": "2026-04-05 09:46:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313311,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-05",
"name": "dt",
"value": "2026-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-06 09:34:33",
"last_data": "2026-04-06 09:35:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313401,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-06",
"name": "dt",
"value": "2026-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-07 09:32:11",
"last_data": "2026-04-08 09:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313447,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-07/",
"name": "dt",
"value": "2026-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 09:30:33",
"last_data": "2026-04-08 09:30:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313526,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-08",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 09:46:04",
"last_data": "2026-04-10 09:29:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313596,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 09:42:17",
"last_data": "2026-04-10 09:42:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313628,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-10",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 09:29:25",
"last_data": "2026-04-12 09:29:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313696,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-11/",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-12 09:30:07",
"last_data": "2026-04-12 09:30:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313756,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-12",
"name": "dt",
"value": "2026-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 09:35:40",
"last_data": "2026-04-13 09:35:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313830,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-13",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 10:00:44",
"last_data": "2026-04-14 10:02:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313903,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-14",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 09:58:22",
"last_data": "2026-04-16 09:33:24"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 313945,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-15",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 09:33:31",
"last_data": "2026-04-17 09:50:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 314036,
"location": "s3://sfdl-csv-payrixess-dev/raw_incremental/txns/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-17 09:51:20",
"last_data": "2026-04-17 09:51:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"allowpartial": "string",
"approved": "string",
"authcode": "string",
"authdate": "string",
"authorization": "string",
"authtokencustomer": "string",
"batch": "string",
"captured": "string",
"channel": "string",
"city": "string",
"coftype": "string",
"company": "string",
"conveniencefee": "string",
"country": "string",
"created": "string",
"currency": "string",
"cvv": "string",
"cvvstatus": "string",
"debtrepayment": "string",
"description": "string",
"descriptor": "string",
"discount": "string",
"duty": "string",
"emv": "string",
"entity_id": "string",
"entrymode": "string",
"expiration": "string",
"fee": "string",
"fortxn": "string",
"fromtxn": "string",
"funded": "string",
"fundingcurrency": "string",
"fundingenabled": "string",
"merchant_id": "string",
"modified": "string",
"order": "string",
"origin": "string",
"originalapproved": "string",
"payment": "string",
"pin": "string",
"platform": "string",
"refunded": "string",
"reserved": "string",
"servicecode": "string",
"settled": "string",
"settledcurrency": "string",
"settledtotal": "string",
"shipping": "string",
"signature": "string",
"state": "string",
"statement": "string",
"status": "string",
"subscription": "string",
"surcharge": "string",
"swiped": "string",
"tax": "string",
"terminal": "string",
"token": "string",
"total": "string",
"tracenumber": "string",
"txn_id": "string",
"type": "string",
"unauthreason": "string",
"zip": "string"
},
"created": "2024-07-22 12:55:46",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_txns`\n(\n `txn_id` string , `created` string , `modified` string , `token` string , `payment` string , `fortxn` string , `fromtxn` string , `batch` string , `subscription` string , `type` string , `expiration` string , `currency` string , `platform` string , `authdate` string , `authcode` string , `captured` string , `settled` string , `settledcurrency` string , `settledtotal` string , `allowpartial` string , `order` string , `description` string , `descriptor` string , `terminal` string , `entrymode` string , `origin` string , `tax` string , `total` string , `authorization` string , `approved` string , `cvv` string , `swiped` string , `emv` string , `signature` string , `company` string , `city` string , `state` string , `zip` string , `country` string , `status` string , `refunded` string , `reserved` string , `discount` string , `shipping` string , `duty` string , `pin` string , `tracenumber` string , `cvvstatus` string , `unauthreason` string , `fee` string , `fundingcurrency` string , `coftype` string , `originalapproved` string , `servicecode` string , `authtokencustomer` string , `debtrepayment` string , `statement` string , `conveniencefee` string , `surcharge` string , `channel` string , `funded` string , `fundingenabled` string , `merchant_id` string , `entity_id` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-csv-payrixess-dev/raw_incremental/txns'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_txns`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_txns"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}