Schema Info

Schema Name: sfdl_dev_csv.payrix_pending_entries

created: 2024-07-03 13:59:12
disabled: False
format: raw
id: 2303
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773332

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-17/1776436026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-17/1776436026
id: 4773332
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: 2303
schema_scan_id: 6867662
updated: 2026-04-17 09:27:35

Version 4773305

created: 2026-04-16 09:53:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-16/1776351164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-16/1776351164
id: 4773305
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: 2303
schema_scan_id: 6867547
updated: 2026-04-16 09:53:16

Version 4773238

created: 2026-04-15 10:00:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-15/1776265242'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-15/1776265242
id: 4773238
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: 2303
schema_scan_id: 6867256
updated: 2026-04-15 10:01:09

Version 4773180

created: 2026-04-14 10:03:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-14/1776179023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-14/1776179023
id: 4773180
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: 2303
schema_scan_id: 6867003
updated: 2026-04-14 10:04:01

Version 4773094

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-13/1776090514'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-13/1776090514
id: 4773094
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: 2303
schema_scan_id: 6866578
updated: 2026-04-13 09:29:11

Version 4773068

created: 2026-04-12 09:48:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-12/1776005261'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-12/1776005261
id: 4773068
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: 2303
schema_scan_id: 6866504
updated: 2026-04-12 09:48:16

Version 4772992

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-11/1775917630'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-11/1775917630
id: 4772992
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: 2303
schema_scan_id: 6866214
updated: 2026-04-11 09:28:08

Version 4772954

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-10/1775832176'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-10/1775832176
id: 4772954
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: 2303
schema_scan_id: 6866083
updated: 2026-04-10 09:45:15

Version 4772890

created: 2026-04-09 09:48:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-09/1775746088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-09/1775746088
id: 4772890
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: 2303
schema_scan_id: 6865807
updated: 2026-04-09 09:48:27

Version 4772832

created: 2026-04-08 09:42:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-08/1775659279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-08/1775659279
id: 4772832
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: 2303
schema_scan_id: 6865513
updated: 2026-04-08 09:43:41

Version 4772776

created: 2026-04-07 09:47:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-07/1775573238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-07/1775573238
id: 4772776
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: 2303
schema_scan_id: 6865278
updated: 2026-04-07 09:47:45

Version 4772717

created: 2026-04-06 09:49:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-06/1775486958'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-06/1775486958
id: 4772717
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: 2303
schema_scan_id: 6864963
updated: 2026-04-06 09:50:02

Version 4772637

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-05/1775399206'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-05/1775399206
id: 4772637
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: 2303
schema_scan_id: 6864623
updated: 2026-04-05 09:27:41

Version 4772618

created: 2026-04-04 09:56:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-04/1775314541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-04/1775314541
id: 4772618
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: 2303
schema_scan_id: 6864580
updated: 2026-04-04 09:56:18

Version 4772562

created: 2026-04-03 10:03:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-03/1775228569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-03/1775228569
id: 4772562
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: 2303
schema_scan_id: 6864351
updated: 2026-04-03 10:03:43

Schema Scans: 15

Last at 2026-04-17 09:27:23

Scan 6867662

duration: 0:00:12.735049

exit_message:

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

id: 6867662

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-17/1776436026",
        "key": "raw/pending_entries/2026-04-17/1776436026/b0cb5829-2f12-4670-ae43-3c20a3425175.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4629456111855102378,
        "service_name": "drive-thru",
        "span_id": 5559172838582704556,
        "trace_id": 5922795050409849671
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-17 09:27:23
success: True
trace_id: 5922795050409849671

Scan 6867547

duration: 0:00:15.401908

exit_message:

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

id: 6867547

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-16/1776351164",
        "key": "raw/pending_entries/2026-04-16/1776351164/2bd1d763-9451-4d38-91e3-dc0a114d5f22.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14844512015361215844,
        "service_name": "drive-thru",
        "span_id": 4306085091294421484,
        "trace_id": 18339534522330747569
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-16 09:53:01
success: True
trace_id: 18339534522330747569

Scan 6867256

duration: 0:00:12.667759

exit_message:

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

id: 6867256

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-15/1776265242",
        "key": "raw/pending_entries/2026-04-15/1776265242/c147973f-39e4-4806-8a44-55bad86eace7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16540197669469233684,
        "service_name": "drive-thru",
        "span_id": 8225855908679471166,
        "trace_id": 11236466855430456770
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-15 10:00:57
success: True
trace_id: 11236466855430456770

Scan 6867003

duration: 0:00:15.164665

exit_message:

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

id: 6867003

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-14/1776179023",
        "key": "raw/pending_entries/2026-04-14/1776179023/fa0d8f76-3f7f-4693-bbe0-ca02772bcef8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12177979098639438918,
        "service_name": "drive-thru",
        "span_id": 97974554079637279,
        "trace_id": 11646196487178522111
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-14 10:03:46
success: True
trace_id: 11646196487178522111

Scan 6866578

duration: 0:00:12.752950

exit_message:

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

id: 6866578

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-13/1776090514",
        "key": "raw/pending_entries/2026-04-13/1776090514/180ab928-5029-4096-92b9-93cdd96b0b2a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9861592385666487060,
        "service_name": "drive-thru",
        "span_id": 8682107365621440722,
        "trace_id": 2139664674781887490
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-13 09:28:58
success: True
trace_id: 2139664674781887490

Scan 6866504

duration: 0:00:12.658890

exit_message:

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

id: 6866504

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-12/1776005261",
        "key": "raw/pending_entries/2026-04-12/1776005261/79312fe7-e6ed-4896-9528-e5110618321c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4531871492592110539,
        "service_name": "drive-thru",
        "span_id": 16340181763094986148,
        "trace_id": 1512670536427402849
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-12 09:48:03
success: True
trace_id: 1512670536427402849

Scan 6866214

duration: 0:00:12.718689

exit_message:

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

id: 6866214

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-11/1775917630",
        "key": "raw/pending_entries/2026-04-11/1775917630/6bd4a7d6-b34a-461b-b522-fb861be80233.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10666649293428987348,
        "service_name": "drive-thru",
        "span_id": 14200325689065634421,
        "trace_id": 3512928663752659321
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-11 09:27:56
success: True
trace_id: 3512928663752659321

Scan 6866083

duration: 0:00:12.779821

exit_message:

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

id: 6866083

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-10/1775832176",
        "key": "raw/pending_entries/2026-04-10/1775832176/3b7ea1ee-c0f2-4993-9b99-95145563114f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17961158381179886386,
        "service_name": "drive-thru",
        "span_id": 5825234658848789692,
        "trace_id": 15448541729219512628
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-10 09:45:02
success: True
trace_id: 15448541729219512628

Scan 6865807

duration: 0:00:15.170384

exit_message:

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

id: 6865807

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-09/1775746088",
        "key": "raw/pending_entries/2026-04-09/1775746088/64fea03b-17b0-44da-bcbb-9923686ce5ef.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18062329124248413599,
        "service_name": "drive-thru",
        "span_id": 8944381247181622367,
        "trace_id": 7434329903643166328
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-09 09:48:12
success: True
trace_id: 7434329903643166328

Scan 6865513

duration: 0:01:42.040293

exit_message:

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

id: 6865513

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-08/1775659279",
        "key": "raw/pending_entries/2026-04-08/1775659279/d10cd10b-cf3a-4353-a626-0e521fd97273.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3141665971733283165,
        "service_name": "drive-thru",
        "span_id": 11345061922813844006,
        "trace_id": 8754133776160145411
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-08 09:41:59
success: True
trace_id: 8754133776160145411

Scan 6865278

duration: 0:00:15.291545

exit_message:

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

id: 6865278

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-07/1775573238",
        "key": "raw/pending_entries/2026-04-07/1775573238/d4a2fc2f-846e-4f6c-ab90-08557d6b3c0e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2115256717445951619,
        "service_name": "drive-thru",
        "span_id": 7657609126672202909,
        "trace_id": 13462858377168309548
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-07 09:47:30
success: True
trace_id: 13462858377168309548

Scan 6864963

duration: 0:00:12.691382

exit_message:

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

id: 6864963

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-06/1775486958",
        "key": "raw/pending_entries/2026-04-06/1775486958/f7751736-6480-4410-95c9-e392696c271e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2889503148665620605,
        "service_name": "drive-thru",
        "span_id": 6729880222564156504,
        "trace_id": 9039484841440368951
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-06 09:49:49
success: True
trace_id: 9039484841440368951

Scan 6864623

duration: 0:00:15.119462

exit_message:

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

id: 6864623

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-05/1775399206",
        "key": "raw/pending_entries/2026-04-05/1775399206/0625d69e-fe56-4efe-8cd1-fcd309727b66.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11910965882065073203,
        "service_name": "drive-thru",
        "span_id": 7270874775341135374,
        "trace_id": 12297822138908500086
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-05 09:27:26
success: True
trace_id: 12297822138908500086

Scan 6864580

duration: 0:00:12.812245

exit_message:

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

id: 6864580

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-04/1775314541",
        "key": "raw/pending_entries/2026-04-04/1775314541/7ff18279-444a-481c-ad95-f2c8ba70e5e8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8829105898296512888,
        "service_name": "drive-thru",
        "span_id": 3754817519993345854,
        "trace_id": 1526948398080272229
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-04 09:56:06
success: True
trace_id: 1526948398080272229

Scan 6864351

duration: 0:00:12.787537

exit_message:

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

id: 6864351

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-03/1775228569",
        "key": "raw/pending_entries/2026-04-03/1775228569/0038ceed-ad1e-4787-ae44-ac69cb1324a3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_pending_entries",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13216816628361564721,
        "service_name": "drive-thru",
        "span_id": 751398688400890839,
        "trace_id": 11123365769012002008
    }
}

running: False
schema_name_id: 2303
start_time: 2026-04-03 10:03:31
success: True
trace_id: 11123365769012002008

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:27:24

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-17/1776436026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-03 13:59:12",
        "disabled": false,
        "format": "raw",
        "id": 2303,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_pending_entries"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_hoodie_commit_seqno": "string",
            "_hoodie_commit_time": "string",
            "_hoodie_file_name": "string",
            "_hoodie_partition_path": "string",
            "_hoodie_record_key": "string",
            "adjustment": "string",
            "amount": "string",
            "chargeback": "string",
            "created": "string",
            "creator": "string",
            "currencyrate": "string",
            "description": "string",
            "disbursement": "string",
            "entity_id": "string",
            "entitydebt": "string",
            "entry": "string",
            "event": "string",
            "eventid": "string",
            "fee": "string",
            "fromentity": "string",
            "fund": "string",
            "isfee": "string",
            "modified": "string",
            "modifier": "string",
            "onentity": "string",
            "opposingpendingentry": "string",
            "originalcurrency": "string",
            "originalevent": "string",
            "originaleventid": "string",
            "pending": "string",
            "pending_entry_id": "string",
            "profitshare": "string",
            "refund": "string",
            "revsharestatement": "string",
            "settlement": "string",
            "statement": "string",
            "terminaltxn": "string",
            "txn": "string"
        },
        "created": "2026-04-17 09:27:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_pending_entries`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `isfee`  string , `entitydebt`  string , `modifier`  string , `fee`  string , `pending`  string , `fromentity`  string , `description`  string , `settlement`  string , `revsharestatement`  string , `chargeback`  string , `originaleventid`  string , `statement`  string , `modified`  string , `pending_entry_id`  string , `event`  string , `originalcurrency`  string , `eventid`  string , `creator`  string , `amount`  string , `opposingpendingentry`  string , `created`  string , `originalevent`  string , `txn`  string , `terminaltxn`  string , `onentity`  string , `disbursement`  string , `entry`  string , `profitshare`  string , `fund`  string , `adjustment`  string , `currencyrate`  string , `refund`  string , `entity_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-dev/raw/pending_entries/2026-04-17/1776436026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_pending_entries`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_pending_entries"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}