Schema Info

Schema Name: sfdl_prod_csv.payrixess_pending_entries

created: 2024-07-24 10:20:09
disabled: False
format: raw
id: 1958
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718239

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-17/1776436099
id: 1718239
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: 1958
schema_scan_id: 162178373
updated: 2026-04-17 09:28:34

Version 1717021

created: 2026-04-16 09:29:17

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-16/1776349748
id: 1717021
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: 1958
schema_scan_id: 162122713
updated: 2026-04-16 09:29:30

Version 1715823

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-15/1776263213
id: 1715823
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: 1958
schema_scan_id: 162066868
updated: 2026-04-15 09:27:24

Version 1714636

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-14/1776178028
id: 1714636
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: 1958
schema_scan_id: 162011696
updated: 2026-04-14 09:47:41

Version 1713432

created: 2026-04-13 09:48:54

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-13/1776091696
id: 1713432
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: 1958
schema_scan_id: 161954106
updated: 2026-04-13 09:49:05

Version 1712216

created: 2026-04-12 09:30:11

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-12/1776004208
id: 1712216
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: 1958
schema_scan_id: 161903446
updated: 2026-04-12 09:30:22

Version 1711040

created: 2026-04-11 09:46:57

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-11/1775918812
id: 1711040
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: 1958
schema_scan_id: 161852213
updated: 2026-04-11 09:47:11

Version 1709863

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-10/1775832265
id: 1709863
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: 1958
schema_scan_id: 161797562
updated: 2026-04-10 09:46:40

Version 1708680

created: 2026-04-09 09:29:10

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-09/1775744928
id: 1708680
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: 1958
schema_scan_id: 161741342
updated: 2026-04-09 09:29:24

Version 1707542

created: 2026-04-08 09:53:18

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-08/1775659826
id: 1707542
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: 1958
schema_scan_id: 161687212
updated: 2026-04-08 09:53:32

Version 1706301

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-07/1775572098
id: 1706301
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: 1958
schema_scan_id: 161630199
updated: 2026-04-07 09:28:36

Version 1705099

created: 2026-04-06 09:41:29

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-06/1775486483
id: 1705099
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: 1958
schema_scan_id: 161572909
updated: 2026-04-06 09:41:40

Version 1703858

created: 2026-04-05 09:29:54

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-05/1775399381
id: 1703858
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: 1958
schema_scan_id: 161523771
updated: 2026-04-05 09:30:06

Version 1702706

created: 2026-04-04 09:27:56

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-04/1775312869
id: 1702706
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: 1958
schema_scan_id: 161471646
updated: 2026-04-04 09:28:09

Version 1701531

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-03/1775227038
id: 1701531
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: 1958
schema_scan_id: 161414440
updated: 2026-04-03 09:37:44

Schema Scans: 15

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

Scan 162178373

duration: 0:00:12.689710

exit_message:

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

id: 162178373

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-17/1776436099",
        "key": "raw/pending_entries/2026-04-17/1776436099/dae0018c-79b2-4e66-9750-fbca01a170ca.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9299387914102361173,
        "service_name": "drive-thru",
        "span_id": 3921457835481087514,
        "trace_id": 8022514455420536029
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-17 09:28:21
success: True
trace_id: 8022514455420536029

Scan 162122713

duration: 0:00:15.119115

exit_message:

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

id: 162122713

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-16/1776349748",
        "key": "raw/pending_entries/2026-04-16/1776349748/c2d39d0f-0f8d-4e3f-910e-3c3b387dbc08.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14884844621505982168,
        "service_name": "drive-thru",
        "span_id": 2405700896949154375,
        "trace_id": 10707211434188137822
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-16 09:29:15
success: True
trace_id: 10707211434188137822

Scan 162066868

duration: 0:00:15.344183

exit_message:

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

id: 162066868

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-15/1776263213",
        "key": "raw/pending_entries/2026-04-15/1776263213/722a71c8-b30d-4373-8019-424d2a24ab38.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5028162275972660639,
        "service_name": "drive-thru",
        "span_id": 3156918411717668213,
        "trace_id": 6393943515101352884
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-15 09:27:09
success: True
trace_id: 6393943515101352884

Scan 162011696

duration: 0:00:12.860981

exit_message:

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

id: 162011696

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-14/1776178028",
        "key": "raw/pending_entries/2026-04-14/1776178028/f0c9e1fa-80ac-4845-977e-b4b611ae5289.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18273986303444697766,
        "service_name": "drive-thru",
        "span_id": 1244517323125028011,
        "trace_id": 15791472415569485724
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-14 09:47:28
success: True
trace_id: 15791472415569485724

Scan 161954106

duration: 0:00:12.588034

exit_message:

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

id: 161954106

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-13/1776091696",
        "key": "raw/pending_entries/2026-04-13/1776091696/b91e73f3-2f95-417d-99bb-124cfaafafc4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16760533475087048610,
        "service_name": "drive-thru",
        "span_id": 6272287394946105236,
        "trace_id": 18323302760909853007
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-13 09:48:53
success: True
trace_id: 18323302760909853007

Scan 161903446

duration: 0:00:12.489762

exit_message:

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

id: 161903446

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-12/1776004208",
        "key": "raw/pending_entries/2026-04-12/1776004208/8a00ac68-a704-47ac-b9f6-cb96d75853e2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3028962491821767754,
        "service_name": "drive-thru",
        "span_id": 6976595139174583400,
        "trace_id": 6363840781444168525
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-12 09:30:10
success: True
trace_id: 6363840781444168525

Scan 161852213

duration: 0:00:15.142956

exit_message:

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

id: 161852213

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-11/1775918812",
        "key": "raw/pending_entries/2026-04-11/1775918812/2211a154-6ad1-4d55-95a8-b4442fd92a9a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14947933305227248756,
        "service_name": "drive-thru",
        "span_id": 7553043873064981589,
        "trace_id": 16756810524724429720
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-11 09:46:56
success: True
trace_id: 16756810524724429720

Scan 161797562

duration: 0:00:12.579742

exit_message:

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

id: 161797562

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-10/1775832265",
        "key": "raw/pending_entries/2026-04-10/1775832265/178dc6a2-33f1-447a-82ee-091566c40304.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15517377190742144275,
        "service_name": "drive-thru",
        "span_id": 5688085165385179912,
        "trace_id": 11947353695916152747
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-10 09:46:28
success: True
trace_id: 11947353695916152747

Scan 161741342

duration: 0:00:15.221908

exit_message:

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

id: 161741342

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-09/1775744928",
        "key": "raw/pending_entries/2026-04-09/1775744928/b712a5c9-0e5f-4219-94c6-0dbd5760419c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6165155150128836945,
        "service_name": "drive-thru",
        "span_id": 11084719218021216441,
        "trace_id": 11676663133287296814
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-09 09:29:09
success: True
trace_id: 11676663133287296814

Scan 161687212

duration: 0:00:15.241881

exit_message:

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

id: 161687212

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-08/1775659826",
        "key": "raw/pending_entries/2026-04-08/1775659826/ded310c8-3c8d-40cf-b390-6eb88e7afd5e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11990916211826712798,
        "service_name": "drive-thru",
        "span_id": 2562381561528757185,
        "trace_id": 4197071510643469412
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-08 09:53:17
success: True
trace_id: 4197071510643469412

Scan 161630199

duration: 0:00:15.080108

exit_message:

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

id: 161630199

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-07/1775572098",
        "key": "raw/pending_entries/2026-04-07/1775572098/f935ce6c-0682-4d0f-b4cf-54a529355f95.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12179939622489243863,
        "service_name": "drive-thru",
        "span_id": 7273733975894037875,
        "trace_id": 845157346164563725
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-07 09:28:21
success: True
trace_id: 845157346164563725

Scan 161572909

duration: 0:00:12.575960

exit_message:

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

id: 161572909

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-06/1775486483",
        "key": "raw/pending_entries/2026-04-06/1775486483/1392cfe8-5400-46ba-b747-7c5d494bf7c2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 703221943956123183,
        "service_name": "drive-thru",
        "span_id": 6519804810778455339,
        "trace_id": 9033782971096435619
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-06 09:41:27
success: True
trace_id: 9033782971096435619

Scan 161523771

duration: 0:00:12.627733

exit_message:

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

id: 161523771

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-05/1775399381",
        "key": "raw/pending_entries/2026-04-05/1775399381/27d7a78f-140c-4027-aee5-5f82111c1423.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3954817835075883756,
        "service_name": "drive-thru",
        "span_id": 15614082076703177376,
        "trace_id": 18174460261020608271
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-05 09:29:53
success: True
trace_id: 18174460261020608271

Scan 161471646

duration: 0:00:15.038340

exit_message:

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

id: 161471646

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-04/1775312869",
        "key": "raw/pending_entries/2026-04-04/1775312869/bcaed1f2-325e-4d22-a0de-8855bd1e42b1.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10375600769802262163,
        "service_name": "drive-thru",
        "span_id": 4989442071858564949,
        "trace_id": 7343194481048356940
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-04 09:27:54
success: True
trace_id: 7343194481048356940

Scan 161414440

duration: 0:00:15.234664

exit_message:

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

id: 161414440

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/pending_entries/2026-04-03/1775227038",
        "key": "raw/pending_entries/2026-04-03/1775227038/60f3839e-f230-4044-8e36-b45f56ece9f1.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16803856706492585237,
        "service_name": "drive-thru",
        "span_id": 13020551207923517592,
        "trace_id": 11481178491797018262
    }
}

running: False
schema_name_id: 1958
start_time: 2026-04-03 09:37:29
success: True
trace_id: 11481178491797018262

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:23

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-24 10:20:09",
        "disabled": false,
        "format": "raw",
        "id": 1958,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:23",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/pending_entries/2026-04-17/1776436099'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_pending_entries`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_pending_entries"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}