Schema Info

Schema Name: sfdl_stage_csv.payrixess_pending_entries

created: 2024-07-22 13:20:04
disabled: False
format: raw
id: 2176
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906688

created: 2026-04-17 09:28:07

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-17/1776436078
id: 906688
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: 2176
schema_scan_id: 6415361
updated: 2026-04-17 09:28:21

Version 906467

created: 2026-04-16 09:26:52

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-16/1776349604
id: 906467
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: 2176
schema_scan_id: 6414796
updated: 2026-04-16 09:27:04

Version 906284

created: 2026-04-15 09:47:12

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-15/1776264420
id: 906284
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: 2176
schema_scan_id: 6414431
updated: 2026-04-15 09:47:23

Version 906072

created: 2026-04-14 09:47:13

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-14/1776178028
id: 906072
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: 2176
schema_scan_id: 6413943
updated: 2026-04-14 09:47:27

Version 905856

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-13/1776091584
id: 905856
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: 2176
schema_scan_id: 6413385
updated: 2026-04-13 09:46:41

Version 905641

created: 2026-04-12 09:43:03

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-12/1776004976
id: 905641
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: 2176
schema_scan_id: 6412922
updated: 2026-04-12 09:43:15

Version 905421

created: 2026-04-11 09:26:40

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-11/1775917593
id: 905421
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: 2176
schema_scan_id: 6412449
updated: 2026-04-11 09:26:51

Version 905241

created: 2026-04-10 09:47:13

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-10/1775832417
id: 905241
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: 2176
schema_scan_id: 6412127
updated: 2026-04-10 09:47:24

Version 905022

created: 2026-04-09 09:47:56

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-09/1775746071
id: 905022
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: 2176
schema_scan_id: 6411595
updated: 2026-04-09 09:48:10

Version 904804

created: 2026-04-08 09:43:14

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-08/1775659384
id: 904804
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: 2176
schema_scan_id: 6411096
updated: 2026-04-08 09:43:32

Version 904585

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-07/1775572794
id: 904585
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: 2176
schema_scan_id: 6410548
updated: 2026-04-07 09:40:34

Version 904377

created: 2026-04-06 09:42:53

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-06/1775486564
id: 904377
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: 2176
schema_scan_id: 6410045
updated: 2026-04-06 09:43:07

Version 904168

created: 2026-04-05 09:43:02

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-05/1775400176
id: 904168
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: 2176
schema_scan_id: 6409614
updated: 2026-04-05 09:43:16

Version 903967

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-04/1775314245
id: 903967
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: 2176
schema_scan_id: 6409232
updated: 2026-04-04 09:51:02

Version 903735

created: 2026-04-03 09:32:31

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-03/1775226745
id: 903735
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: 2176
schema_scan_id: 6408655
updated: 2026-04-03 09:32:43

Schema Scans: 15

Last at 2026-04-17 09:28:05

Scan 6415361

duration: 0:00:15.328492

exit_message:

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

id: 6415361

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-17/1776436078",
        "key": "raw/pending_entries/2026-04-17/1776436078/ab00d4ee-b664-480f-9783-632a08694f17.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17482626600944004443,
        "service_name": "drive-thru",
        "span_id": 2472694035116603207,
        "trace_id": 16239249093034357528
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-17 09:28:05
success: True
trace_id: 16239249093034357528

Scan 6414796

duration: 0:00:12.654656

exit_message:

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

id: 6414796

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-16/1776349604",
        "key": "raw/pending_entries/2026-04-16/1776349604/e03c8da3-d79e-47eb-b83d-c8dc69743523.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6263986902019118889,
        "service_name": "drive-thru",
        "span_id": 8366616562874808669,
        "trace_id": 2734187841694054030
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-16 09:26:51
success: True
trace_id: 2734187841694054030

Scan 6414431

duration: 0:00:12.685531

exit_message:

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

id: 6414431

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-15/1776264420",
        "key": "raw/pending_entries/2026-04-15/1776264420/2fb306aa-1b0a-4c7e-bcd0-799e2a23a073.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15105397575144366459,
        "service_name": "drive-thru",
        "span_id": 4500496481594588971,
        "trace_id": 13045297540396149668
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-15 09:47:10
success: True
trace_id: 13045297540396149668

Scan 6413943

duration: 0:00:15.200974

exit_message:

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

id: 6413943

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-14/1776178028",
        "key": "raw/pending_entries/2026-04-14/1776178028/6a722ceb-471e-4295-b786-e9248a900e36.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6464822039779723829,
        "service_name": "drive-thru",
        "span_id": 4118439727813112975,
        "trace_id": 16526460483257497281
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-14 09:47:12
success: True
trace_id: 16526460483257497281

Scan 6413385

duration: 0:00:12.743244

exit_message:

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

id: 6413385

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-13/1776091584",
        "key": "raw/pending_entries/2026-04-13/1776091584/24bcf563-0f4a-4bdd-addd-cb8ad6ec826d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16227995429475022280,
        "service_name": "drive-thru",
        "span_id": 3224479763637621424,
        "trace_id": 15586621954062104206
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-13 09:46:28
success: True
trace_id: 15586621954062104206

Scan 6412922

duration: 0:00:13.098580

exit_message:

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

id: 6412922

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-12/1776004976",
        "key": "raw/pending_entries/2026-04-12/1776004976/ab7959da-3357-403e-92ce-766540b77706.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13053078794615716268,
        "service_name": "drive-thru",
        "span_id": 6663656578811888646,
        "trace_id": 9478688068308772112
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-12 09:43:02
success: True
trace_id: 9478688068308772112

Scan 6412449

duration: 0:00:12.660147

exit_message:

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

id: 6412449

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-11/1775917593",
        "key": "raw/pending_entries/2026-04-11/1775917593/a86c096a-0265-4f83-a8ad-c599741bb9a9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3494465691729074940,
        "service_name": "drive-thru",
        "span_id": 3099936705628978836,
        "trace_id": 13241332181910286830
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-11 09:26:39
success: True
trace_id: 13241332181910286830

Scan 6412127

duration: 0:00:12.815940

exit_message:

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

id: 6412127

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-10/1775832417",
        "key": "raw/pending_entries/2026-04-10/1775832417/299bcc0c-ebfc-4f73-bf32-b608d9a4d417.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15303797953648438420,
        "service_name": "drive-thru",
        "span_id": 949241959411940785,
        "trace_id": 6819521731910124665
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-10 09:47:11
success: True
trace_id: 6819521731910124665

Scan 6411595

duration: 0:00:15.259802

exit_message:

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

id: 6411595

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-09/1775746071",
        "key": "raw/pending_entries/2026-04-09/1775746071/f4a147de-b46a-40c2-9c59-e28656730ea8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3241901388577607300,
        "service_name": "drive-thru",
        "span_id": 45269222707233130,
        "trace_id": 14351595654635737807
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-09 09:47:54
success: True
trace_id: 14351595654635737807

Scan 6411096

duration: 0:00:20.346837

exit_message:

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

id: 6411096

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-08/1775659384",
        "key": "raw/pending_entries/2026-04-08/1775659384/9a1c9b4b-b61d-48c2-be9a-741d41e16831.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7301902747340839688,
        "service_name": "drive-thru",
        "span_id": 15198796244560816550,
        "trace_id": 8840577284005451311
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-08 09:43:12
success: True
trace_id: 8840577284005451311

Scan 6410548

duration: 0:00:15.308616

exit_message:

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

id: 6410548

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-07/1775572794",
        "key": "raw/pending_entries/2026-04-07/1775572794/ca09b278-a421-4b44-b2e0-1089c7097eca.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15570921983476756187,
        "service_name": "drive-thru",
        "span_id": 8394772583239927090,
        "trace_id": 1414265618142003692
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-07 09:40:19
success: True
trace_id: 1414265618142003692

Scan 6410045

duration: 0:00:15.376242

exit_message:

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

id: 6410045

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-06/1775486564",
        "key": "raw/pending_entries/2026-04-06/1775486564/20e53116-d429-457c-aa54-7354c4f738a7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7905991291145736754,
        "service_name": "drive-thru",
        "span_id": 9876523910418343082,
        "trace_id": 14696786025422930718
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-06 09:42:51
success: True
trace_id: 14696786025422930718

Scan 6409614

duration: 0:00:15.552447

exit_message:

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

id: 6409614

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-05/1775400176",
        "key": "raw/pending_entries/2026-04-05/1775400176/2b8b2063-1bba-48e6-91dc-a3b5c0fbbb84.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13470575553273621003,
        "service_name": "drive-thru",
        "span_id": 10388542246865905979,
        "trace_id": 3138287598299285552
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-05 09:43:00
success: True
trace_id: 3138287598299285552

Scan 6409232

duration: 0:00:12.636313

exit_message:

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

id: 6409232

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-04/1775314245",
        "key": "raw/pending_entries/2026-04-04/1775314245/5381f873-bac6-4b00-a40f-fd219d575490.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12930302568336281154,
        "service_name": "drive-thru",
        "span_id": 11691689413800846770,
        "trace_id": 16573048894425251296
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-04 09:50:49
success: True
trace_id: 16573048894425251296

Scan 6408655

duration: 0:00:12.651375

exit_message:

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

id: 6408655

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/pending_entries/2026-04-03/1775226745",
        "key": "raw/pending_entries/2026-04-03/1775226745/492787e0-2b48-41e7-912a-e00c11eee908.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12744911565307409463,
        "service_name": "drive-thru",
        "span_id": 7151993384482672401,
        "trace_id": 2231304003075546708
    }
}

running: False
schema_name_id: 2176
start_time: 2026-04-03 09:32:30
success: True
trace_id: 2231304003075546708

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:28:07

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pending_entries/2026-04-17/1776436078'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_pending_entries`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_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-22 13:20:04",
        "disabled": false,
        "format": "raw",
        "id": 2176,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:28:07",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/pending_entries/2026-04-17/1776436078'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_pending_entries`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_pending_entries"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}