Schema Info

Schema Name: sfdl_dev_csv.payrixess_pending_entries

created: 2024-07-22 13:05:44
disabled: False
format: raw
id: 2364
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_csv",
    "table": "payrixess_pending_entries"
}

type: csv

Schema Versions: 15

Version 4773361

created: 2026-04-17 09:49:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-17/1776437378'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-17/1776437378
id: 4773361
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6867771
updated: 2026-04-17 09:50:11

Version 4773297

created: 2026-04-16 09:41:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-16/1776350471'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-16/1776350471
id: 4773297
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6867535
updated: 2026-04-16 09:41:37

Version 4773240

created: 2026-04-15 10:03:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-15/1776265425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-15/1776265425
id: 4773240
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6867278
updated: 2026-04-15 10:04:01

Version 4773184

created: 2026-04-14 10:04:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-14/1776179035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-14/1776179035
id: 4773184
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6867013
updated: 2026-04-14 10:04:35

Version 4773123

created: 2026-04-13 09:49:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-13/1776091776'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-13/1776091776
id: 4773123
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6866713
updated: 2026-04-13 09:50:09

Version 4773059

created: 2026-04-12 09:45:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-12/1776005128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-12/1776005128
id: 4773059
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6866492
updated: 2026-04-12 09:45:47

Version 4772988

created: 2026-04-11 09:27:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-11/1775917601'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-11/1775917601
id: 4772988
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6866196
updated: 2026-04-11 09:27:28

Version 4772959

created: 2026-04-10 09:45:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-10/1775832194'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-10/1775832194
id: 4772959
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6866092
updated: 2026-04-10 09:45:57

Version 4772896

created: 2026-04-09 09:50:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-09/1775746191'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-09/1775746191
id: 4772896
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6865816
updated: 2026-04-09 09:50:15

Version 4772814

created: 2026-04-08 09:27:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-08/1775658439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-08/1775658439
id: 4772814
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6865429
updated: 2026-04-08 09:27:48

Version 4772767

created: 2026-04-07 09:44:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-07/1775573071'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-07/1775573071
id: 4772767
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6865263
updated: 2026-04-07 09:45:13

Version 4772694

created: 2026-04-06 09:31:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-06/1775485878'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-06/1775485878
id: 4772694
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6864837
updated: 2026-04-06 09:31:37

Version 4772638

created: 2026-04-05 09:27:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-05/1775399263'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-05/1775399263
id: 4772638
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6864626
updated: 2026-04-05 09:28:04

Version 4772611

created: 2026-04-04 09:51:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-04/1775314265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-04/1775314265
id: 4772611
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6864541
updated: 2026-04-04 09:51:26

Version 4772545

created: 2026-04-03 09:48:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-03/1775227690'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-03/1775227690
id: 4772545
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "adjustment": 34,
    "amount": 23,
    "chargeback": 14,
    "created": 25,
    "creator": 22,
    "currencyrate": 35,
    "description": 11,
    "disbursement": 30,
    "entity_id": 37,
    "entitydebt": 6,
    "entry": 31,
    "event": 19,
    "eventid": 21,
    "fee": 8,
    "fromentity": 10,
    "fund": 33,
    "isfee": 5,
    "modified": 17,
    "modifier": 7,
    "onentity": 29,
    "opposingpendingentry": 24,
    "originalcurrency": 20,
    "originalevent": 26,
    "originaleventid": 15,
    "pending": 9,
    "pending_entry_id": 18,
    "profitshare": 32,
    "refund": 36,
    "revsharestatement": 13,
    "settlement": 12,
    "statement": 16,
    "terminaltxn": 28,
    "txn": 27
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

schema_name_id: 2364
schema_scan_id: 6864315
updated: 2026-04-03 09:48:35

Schema Scans: 15

Last at 2026-04-17 09:49:58

Scan 6867771

duration: 0:00:12.676264

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6867771

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-17/1776437378",
        "key": "raw/pending_entries/2026-04-17/1776437378/be918214-44e9-477e-8679-213dfaab3854.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3516050631633634698,
        "service_name": "drive-thru",
        "span_id": 5770964596708732259,
        "trace_id": 13213553581039418040
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-17 09:49:58
success: True
trace_id: 13213553581039418040

Scan 6867535

duration: 0:00:12.907666

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6867535

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-16/1776350471",
        "key": "raw/pending_entries/2026-04-16/1776350471/d2898b09-e9b6-409a-a738-d3ae943c1565.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15715234177537356148,
        "service_name": "drive-thru",
        "span_id": 10913636621014525621,
        "trace_id": 15147715223333637657
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-16 09:41:24
success: True
trace_id: 15147715223333637657

Scan 6867278

duration: 0:00:12.733181

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6867278

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-15/1776265425",
        "key": "raw/pending_entries/2026-04-15/1776265425/db8e288d-fb8d-4a8c-8b5c-1614b27737be.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 65348033146322687,
        "service_name": "drive-thru",
        "span_id": 10772935027639515979,
        "trace_id": 1413220221527987002
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-15 10:03:49
success: True
trace_id: 1413220221527987002

Scan 6867013

duration: 0:00:15.377958

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6867013

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-14/1776179035",
        "key": "raw/pending_entries/2026-04-14/1776179035/1b79d899-5c20-4ab3-ba8f-6487be41392b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4933137515177279180,
        "service_name": "drive-thru",
        "span_id": 7443126903253325281,
        "trace_id": 9051149613003022050
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-14 10:04:20
success: True
trace_id: 9051149613003022050

Scan 6866713

duration: 0:00:12.605972

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6866713

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-13/1776091776",
        "key": "raw/pending_entries/2026-04-13/1776091776/9592b2c8-d359-4c59-b249-3ba6a1f44422.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15317234272732333228,
        "service_name": "drive-thru",
        "span_id": 1799797549278005862,
        "trace_id": 4123131081370605218
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-13 09:49:57
success: True
trace_id: 4123131081370605218

Scan 6866492

duration: 0:00:15.221060

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6866492

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-12/1776005128",
        "key": "raw/pending_entries/2026-04-12/1776005128/4733c805-c6b7-45eb-b6ee-2b19ee89a49e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6393171030548677901,
        "service_name": "drive-thru",
        "span_id": 17178255811666649495,
        "trace_id": 6380589880274335049
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-12 09:45:32
success: True
trace_id: 6380589880274335049

Scan 6866196

duration: 0:00:12.740496

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6866196

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-11/1775917601",
        "key": "raw/pending_entries/2026-04-11/1775917601/139e92d0-c896-45a8-9706-e23d2bcc560e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10737893232975395953,
        "service_name": "drive-thru",
        "span_id": 3414221747017606882,
        "trace_id": 17535828155854107492
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-11 09:27:15
success: True
trace_id: 17535828155854107492

Scan 6866092

duration: 0:00:12.688990

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6866092

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-10/1775832194",
        "key": "raw/pending_entries/2026-04-10/1775832194/552df141-7e54-43cd-a8f9-40f7d362cceb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18425712245471108981,
        "service_name": "drive-thru",
        "span_id": 4356284698298642742,
        "trace_id": 1459770434744478875
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-10 09:45:44
success: True
trace_id: 1459770434744478875

Scan 6865816

duration: 0:00:12.774262

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6865816

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-09/1775746191",
        "key": "raw/pending_entries/2026-04-09/1775746191/04b69a79-2df5-473e-ae8c-347e697b585e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5313735350544102978,
        "service_name": "drive-thru",
        "span_id": 2429452222860471451,
        "trace_id": 16145324210798591843
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-09 09:50:03
success: True
trace_id: 16145324210798591843

Scan 6865429

duration: 0:00:12.603129

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6865429

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-08/1775658439",
        "key": "raw/pending_entries/2026-04-08/1775658439/af8918ad-2739-44da-8880-f3ca33c1dfcb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2756304809557470925,
        "service_name": "drive-thru",
        "span_id": 11323365056682716489,
        "trace_id": 5171822090046285579
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-08 09:27:35
success: True
trace_id: 5171822090046285579

Scan 6865263

duration: 0:00:15.451471

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6865263

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-07/1775573071",
        "key": "raw/pending_entries/2026-04-07/1775573071/cc7ca10b-0ac0-4272-89c7-4f40a2e6a4b4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10859618224089852386,
        "service_name": "drive-thru",
        "span_id": 16472819444173426075,
        "trace_id": 5017503356396732218
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-07 09:44:57
success: True
trace_id: 5017503356396732218

Scan 6864837

duration: 0:00:15.420624

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6864837

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-06/1775485878",
        "key": "raw/pending_entries/2026-04-06/1775485878/ff53d5c7-a13f-4981-bcac-611659c81612.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9505384672947349923,
        "service_name": "drive-thru",
        "span_id": 6740350821334094565,
        "trace_id": 3388612580997908746
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-06 09:31:21
success: True
trace_id: 3388612580997908746

Scan 6864626

duration: 0:00:15.153022

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6864626

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-05/1775399263",
        "key": "raw/pending_entries/2026-04-05/1775399263/e1670802-f283-4d9d-ab5d-de8f7bd59edd.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14998244945547358968,
        "service_name": "drive-thru",
        "span_id": 12352418238925873332,
        "trace_id": 2105040632900963369
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-05 09:27:49
success: True
trace_id: 2105040632900963369

Scan 6864541

duration: 0:00:15.302106

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6864541

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-04/1775314265",
        "key": "raw/pending_entries/2026-04-04/1775314265/fd72870c-bb59-4979-a2d1-d7fe0709766e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9574125580601682298,
        "service_name": "drive-thru",
        "span_id": 9334841896571164312,
        "trace_id": 5328733771073820528
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-04 09:51:11
success: True
trace_id: 5328733771073820528

Scan 6864315

duration: 0:00:15.450939

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6864315

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/pending_entries/2026-04-03/1775227690",
        "key": "raw/pending_entries/2026-04-03/1775227690/ea80b5f1-d053-49c5-9e13-e4772c6b079f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12005905696268753059,
        "service_name": "drive-thru",
        "span_id": 15903005839720743448,
        "trace_id": 13445393904297983612
    }
}

running: False
schema_name_id: 2364
start_time: 2026-04-03 09:48:20
success: True
trace_id: 13445393904297983612

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "adjustment": "string",
    "amount": "string",
    "chargeback": "string",
    "created": "string",
    "creator": "string",
    "currencyrate": "string",
    "description": "string",
    "disbursement": "string",
    "entity_id": "string",
    "entitydebt": "string",
    "entry": "string",
    "event": "string",
    "eventid": "string",
    "fee": "string",
    "fromentity": "string",
    "fund": "string",
    "isfee": "string",
    "modified": "string",
    "modifier": "string",
    "onentity": "string",
    "opposingpendingentry": "string",
    "originalcurrency": "string",
    "originalevent": "string",
    "originaleventid": "string",
    "pending": "string",
    "pending_entry_id": "string",
    "profitshare": "string",
    "refund": "string",
    "revsharestatement": "string",
    "settlement": "string",
    "statement": "string",
    "terminaltxn": "string",
    "txn": "string"
}

created: 2026-04-17 09:49:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-17/1776437378'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-07-22 13:05:44",
        "disabled": false,
        "format": "raw",
        "id": 2364,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_pending_entries"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_hoodie_commit_seqno": "string",
            "_hoodie_commit_time": "string",
            "_hoodie_file_name": "string",
            "_hoodie_partition_path": "string",
            "_hoodie_record_key": "string",
            "adjustment": "string",
            "amount": "string",
            "chargeback": "string",
            "created": "string",
            "creator": "string",
            "currencyrate": "string",
            "description": "string",
            "disbursement": "string",
            "entity_id": "string",
            "entitydebt": "string",
            "entry": "string",
            "event": "string",
            "eventid": "string",
            "fee": "string",
            "fromentity": "string",
            "fund": "string",
            "isfee": "string",
            "modified": "string",
            "modifier": "string",
            "onentity": "string",
            "opposingpendingentry": "string",
            "originalcurrency": "string",
            "originalevent": "string",
            "originaleventid": "string",
            "pending": "string",
            "pending_entry_id": "string",
            "profitshare": "string",
            "refund": "string",
            "revsharestatement": "string",
            "settlement": "string",
            "statement": "string",
            "terminaltxn": "string",
            "txn": "string"
        },
        "created": "2026-04-17 09:49:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\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/pending_entries/2026-04-17/1776437378'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_pending_entries`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_pending_entries"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}