Schema Info

Schema Name: sfdl_stage_csv.payrix_pending_entries

created: 2024-07-08 15:31:48
disabled: False
format: raw
id: 2112
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_csv",
    "table": "payrix_pending_entries"
}

type: csv

Schema Versions: 15

Version 906716

created: 2026-04-17 09:42:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-17/1776436933'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-17/1776436933
id: 906716
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: 2112
schema_scan_id: 6415470
updated: 2026-04-17 09:42:45

Version 906469

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-16/1776349657'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-16/1776349657
id: 906469
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: 2112
schema_scan_id: 6414798
updated: 2026-04-16 09:28:04

Version 906261

created: 2026-04-15 09:31:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-15/1776263475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-15/1776263475
id: 906261
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: 2112
schema_scan_id: 6414384
updated: 2026-04-15 09:31:35

Version 906064

created: 2026-04-14 09:41:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-14/1776177685'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-14/1776177685
id: 906064
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: 2112
schema_scan_id: 6413933
updated: 2026-04-14 09:42:04

Version 905854

created: 2026-04-13 09:46:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-13/1776091569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-13/1776091569
id: 905854
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: 2112
schema_scan_id: 6413383
updated: 2026-04-13 09:46:32

Version 905635

created: 2026-04-12 09:36:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-12/1776004564'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-12/1776004564
id: 905635
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: 2112
schema_scan_id: 6412900
updated: 2026-04-12 09:36:23

Version 905444

created: 2026-04-11 09:44:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-11/1775918659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-11/1775918659
id: 905444
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: 2112
schema_scan_id: 6412557
updated: 2026-04-11 09:44:34

Version 905235

created: 2026-04-10 09:44:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-10/1775832265'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-10/1775832265
id: 905235
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: 2112
schema_scan_id: 6412115
updated: 2026-04-10 09:45:08

Version 905007

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-09/1775745653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-09/1775745653
id: 905007
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: 2112
schema_scan_id: 6411519
updated: 2026-04-09 09:41:27

Version 904779

created: 2026-04-08 09:28:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-08/1775658479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-08/1775658479
id: 904779
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: 2112
schema_scan_id: 6410981
updated: 2026-04-08 09:28:31

Version 904597

created: 2026-04-07 09:45:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-07/1775573123'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-07/1775573123
id: 904597
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: 2112
schema_scan_id: 6410597
updated: 2026-04-07 09:45:51

Version 904360

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-06/1775485865'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-06/1775485865
id: 904360
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: 2112
schema_scan_id: 6410006
updated: 2026-04-06 09:31:36

Version 904156

created: 2026-04-05 09:37:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-05/1775399842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-05/1775399842
id: 904156
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: 2112
schema_scan_id: 6409584
updated: 2026-04-05 09:37:40

Version 903944

created: 2026-04-04 09:28:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-04/1775312892'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-04/1775312892
id: 903944
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: 2112
schema_scan_id: 6409102
updated: 2026-04-04 09:28:40

Version 903763

created: 2026-04-03 10:04:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-03/1775228622'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-03/1775228622
id: 903763
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: 2112
schema_scan_id: 6408790
updated: 2026-04-03 10:04:17

Schema Scans: 15

Last at 2026-04-17 09:42:32

Scan 6415470

duration: 0:00:12.896025

exit_message:

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

id: 6415470

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-17/1776436933",
        "key": "raw/pending_entries/2026-04-17/1776436933/1ebab427-36ae-4bd3-a845-128e7bee046f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9013695453464446237,
        "service_name": "drive-thru",
        "span_id": 7147813508094752013,
        "trace_id": 4442101067703508337
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-17 09:42:32
success: True
trace_id: 4442101067703508337

Scan 6414798

duration: 0:00:15.309049

exit_message:

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

id: 6414798

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-16/1776349657",
        "key": "raw/pending_entries/2026-04-16/1776349657/3bba91e1-9544-4c99-9c45-9d8248279755.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4552704057291108021,
        "service_name": "drive-thru",
        "span_id": 10516572977101956204,
        "trace_id": 14096842005426477451
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-16 09:27:49
success: True
trace_id: 14096842005426477451

Scan 6414384

duration: 0:00:15.224277

exit_message:

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

id: 6414384

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-15/1776263475",
        "key": "raw/pending_entries/2026-04-15/1776263475/40a7b484-c83f-43a2-8f39-1fc95a586f60.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4511575606849156433,
        "service_name": "drive-thru",
        "span_id": 90830408741564712,
        "trace_id": 1075036662074524708
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-15 09:31:19
success: True
trace_id: 1075036662074524708

Scan 6413933

duration: 0:00:15.327837

exit_message:

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

id: 6413933

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-14/1776177685",
        "key": "raw/pending_entries/2026-04-14/1776177685/2276ed12-8e79-4cc6-82a6-d2382236825f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12151581937570509192,
        "service_name": "drive-thru",
        "span_id": 8349548925349099293,
        "trace_id": 8139301140231814285
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-14 09:41:49
success: True
trace_id: 8139301140231814285

Scan 6413383

duration: 0:00:15.348990

exit_message:

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

id: 6413383

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-13/1776091569",
        "key": "raw/pending_entries/2026-04-13/1776091569/1339d4c1-46c5-4d85-a349-c32fa808838d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6007904266194519637,
        "service_name": "drive-thru",
        "span_id": 12274499989464495146,
        "trace_id": 11386706736199439479
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-13 09:46:16
success: True
trace_id: 11386706736199439479

Scan 6412900

duration: 0:00:15.113615

exit_message:

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

id: 6412900

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-12/1776004564",
        "key": "raw/pending_entries/2026-04-12/1776004564/fbf30df5-84f8-4dc0-8408-07706ae2e3c6.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17353663272434192505,
        "service_name": "drive-thru",
        "span_id": 7505648029498453398,
        "trace_id": 3962394013707776661
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-12 09:36:07
success: True
trace_id: 3962394013707776661

Scan 6412557

duration: 0:00:12.670243

exit_message:

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

id: 6412557

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-11/1775918659",
        "key": "raw/pending_entries/2026-04-11/1775918659/5b0f2d0f-5562-42a5-8678-e537b7fd1a8e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 656466505234239817,
        "service_name": "drive-thru",
        "span_id": 17477107723832465246,
        "trace_id": 1400533823010444399
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-11 09:44:21
success: True
trace_id: 1400533823010444399

Scan 6412115

duration: 0:00:13.063305

exit_message:

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

id: 6412115

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-10/1775832265",
        "key": "raw/pending_entries/2026-04-10/1775832265/1ab2dd2a-a975-4a1e-8da0-601931d21c64.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7262419667532667711,
        "service_name": "drive-thru",
        "span_id": 11366526308929148006,
        "trace_id": 8758317021586679946
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-10 09:44:55
success: True
trace_id: 8758317021586679946

Scan 6411519

duration: 0:00:12.779452

exit_message:

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

id: 6411519

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-09/1775745653",
        "key": "raw/pending_entries/2026-04-09/1775745653/0add98f5-3830-4239-8c2a-d559e5889a40.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8910562815435181667,
        "service_name": "drive-thru",
        "span_id": 3315929086248850262,
        "trace_id": 8980004368173098710
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-09 09:41:14
success: True
trace_id: 8980004368173098710

Scan 6410981

duration: 0:00:12.581388

exit_message:

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

id: 6410981

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-08/1775658479",
        "key": "raw/pending_entries/2026-04-08/1775658479/433dc6a6-744d-40fd-a333-cc9554505fba.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3128930646087657216,
        "service_name": "drive-thru",
        "span_id": 11562339088395387055,
        "trace_id": 15004033526565707907
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-08 09:28:18
success: True
trace_id: 15004033526565707907

Scan 6410597

duration: 0:00:12.721959

exit_message:

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

id: 6410597

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-07/1775573123",
        "key": "raw/pending_entries/2026-04-07/1775573123/a1c9eadd-8a53-4fe7-9950-9a00a03490a0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9539685429339624189,
        "service_name": "drive-thru",
        "span_id": 15339758813101960404,
        "trace_id": 1053051605469663599
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-07 09:45:38
success: True
trace_id: 1053051605469663599

Scan 6410006

duration: 0:00:15.374240

exit_message:

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

id: 6410006

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-06/1775485865",
        "key": "raw/pending_entries/2026-04-06/1775485865/16fe957f-0b5d-4a1c-8f01-72c03fe90aaf.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17651303229759594874,
        "service_name": "drive-thru",
        "span_id": 17335790488747758624,
        "trace_id": 4675646034419860573
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-06 09:31:20
success: True
trace_id: 4675646034419860573

Scan 6409584

duration: 0:00:15.093940

exit_message:

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

id: 6409584

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-05/1775399842",
        "key": "raw/pending_entries/2026-04-05/1775399842/4cb5f1d5-4159-4b35-96bb-6ee0686e1471.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3525075534699332534,
        "service_name": "drive-thru",
        "span_id": 10726300030366762448,
        "trace_id": 9963414371329215969
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-05 09:37:25
success: True
trace_id: 9963414371329215969

Scan 6409102

duration: 0:00:12.599491

exit_message:

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

id: 6409102

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-04/1775312892",
        "key": "raw/pending_entries/2026-04-04/1775312892/ea060c5f-4d07-43f0-bacc-53d55d39cc00.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 946698332260720820,
        "service_name": "drive-thru",
        "span_id": 14713971692257351965,
        "trace_id": 7077254083203704484
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-04 09:28:27
success: True
trace_id: 7077254083203704484

Scan 6408790

duration: 0:00:12.880647

exit_message:

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

id: 6408790

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/pending_entries/2026-04-03/1775228622",
        "key": "raw/pending_entries/2026-04-03/1775228622/a43ee159-eb43-41c3-ac75-0ecb48896b71.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9097054776279125615,
        "service_name": "drive-thru",
        "span_id": 2189113124309161207,
        "trace_id": 8746062301300635737
    }
}

running: False
schema_name_id: 2112
start_time: 2026-04-03 10:04:04
success: True
trace_id: 8746062301300635737

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:42:34

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-17/1776436933'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-08 15:31:48",
        "disabled": false,
        "format": "raw",
        "id": 2112,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "payrix_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:42:34",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_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-payrix-stage/raw/pending_entries/2026-04-17/1776436933'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_pending_entries`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_pending_entries"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}