Schema Info

Schema Name: sfdl_prod_csv.payrixess_fees

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

name:

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

type: csv

Schema Versions: 15

Version 1718241

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-17/1776436111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-17/1776436111
id: 1718241
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 162178376
updated: 2026-04-17 09:28:46

Version 1717031

created: 2026-04-16 09:34:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-16/1776350034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-16/1776350034
id: 1717031
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 162122799
updated: 2026-04-16 09:34:17

Version 1715821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-15/1776263217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-15/1776263217
id: 1715821
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 162066866
updated: 2026-04-15 09:27:20

Version 1714628

created: 2026-04-14 09:40:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-14/1776177604'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-14/1776177604
id: 1714628
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 162011360
updated: 2026-04-14 09:40:30

Version 1713413

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-13/1776090776'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-13/1776090776
id: 1713413
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161953726
updated: 2026-04-13 09:33:11

Version 1712222

created: 2026-04-12 09:32:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-12/1776004308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-12/1776004308
id: 1712222
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161903489
updated: 2026-04-12 09:32:18

Version 1711017

created: 2026-04-11 09:29:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-11/1775917766'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-11/1775917766
id: 1711017
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161852011
updated: 2026-04-11 09:29:43

Version 1709845

created: 2026-04-10 09:31:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-10/1775831489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-10/1775831489
id: 1709845
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161797366
updated: 2026-04-10 09:31:55

Version 1708689

created: 2026-04-09 09:32:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-09/1775745123'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-09/1775745123
id: 1708689
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161741410
updated: 2026-04-09 09:32:29

Version 1707509

created: 2026-04-08 09:32:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-08/1775658726'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-08/1775658726
id: 1707509
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161686238
updated: 2026-04-08 09:32:40

Version 1706307

created: 2026-04-07 09:29:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-07/1775572119'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-07/1775572119
id: 1706307
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161630218
updated: 2026-04-07 09:29:16

Version 1705096

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-06/1775486466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-06/1775486466
id: 1705096
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161572901
updated: 2026-04-06 09:41:27

Version 1703863

created: 2026-04-05 09:30:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-05/1775399428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-05/1775399428
id: 1703863
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161523789
updated: 2026-04-05 09:30:56

Version 1702709

created: 2026-04-04 09:28:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-04/1775312895'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-04/1775312895
id: 1702709
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161471656
updated: 2026-04-04 09:28:30

Version 1701524

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-03/1775226764'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/fees/2026-04-03/1775226764
id: 1701524
processed: 1

raw_data:

{
    "_hoodie_commit_seqno": 1,
    "_hoodie_commit_time": 0,
    "_hoodie_file_name": 4,
    "_hoodie_partition_path": 3,
    "_hoodie_record_key": 2,
    "amount": 26,
    "collection": 28,
    "collectionfactor": 29,
    "collectionincludecurrent": 30,
    "collectionoffset": 31,
    "created": 6,
    "creator": 7,
    "currency": 27,
    "description": 16,
    "entity": 10,
    "fee_id": 5,
    "finish": 24,
    "forentity": 12,
    "fromentity": 13,
    "frozen": 18,
    "inactive": 17,
    "maximum": 19,
    "modified": 8,
    "modifier": 9,
    "name": 15,
    "org_id": 11,
    "schedule": 21,
    "schedulefactor": 22,
    "start": 23,
    "txnfee": 25,
    "type": 14,
    "um": 20
}

schema_attributes:

{
    "_hoodie_commit_seqno": "string",
    "_hoodie_commit_time": "string",
    "_hoodie_file_name": "string",
    "_hoodie_partition_path": "string",
    "_hoodie_record_key": "string",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

schema_name_id: 1964
schema_scan_id: 161414349
updated: 2026-04-03 09:33:10

Schema Scans: 15

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

Scan 162178376

duration: 0:00:12.415752

exit_message:

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

id: 162178376

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/fees/2026-04-17/1776436111",
        "key": "raw/fees/2026-04-17/1776436111/c8812877-bfe0-4dc5-96cb-bb15c7fb6747.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11933254089104695366,
        "service_name": "drive-thru",
        "span_id": 13868880256171840037,
        "trace_id": 16283044332953408196
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-17 09:28:34
success: True
trace_id: 16283044332953408196

Scan 162122799

duration: 0:00:15.217944

exit_message:

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

id: 162122799

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/fees/2026-04-16/1776350034",
        "key": "raw/fees/2026-04-16/1776350034/37d651e0-cfcf-49cf-9f49-2fbb6aeacf3a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6446869221731349311,
        "service_name": "drive-thru",
        "span_id": 7718397804533579978,
        "trace_id": 13246805752079561138
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-16 09:34:02
success: True
trace_id: 13246805752079561138

Scan 162066866

duration: 0:00:15.125561

exit_message:

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

id: 162066866

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/fees/2026-04-15/1776263217",
        "key": "raw/fees/2026-04-15/1776263217/310086e0-f6c4-4e41-96de-b3e54da2d437.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4105544674972210687,
        "service_name": "drive-thru",
        "span_id": 4018363938979394408,
        "trace_id": 15741171904391053574
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-15 09:27:05
success: True
trace_id: 15741171904391053574

Scan 162011360

duration: 0:00:12.380848

exit_message:

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

id: 162011360

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/fees/2026-04-14/1776177604",
        "key": "raw/fees/2026-04-14/1776177604/b4e18219-de68-4d8f-8f15-11355785f014.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15665131448310424248,
        "service_name": "drive-thru",
        "span_id": 2933102816172362962,
        "trace_id": 5695729183075656148
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-14 09:40:18
success: True
trace_id: 5695729183075656148

Scan 161953726

duration: 0:00:12.469008

exit_message:

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

id: 161953726

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/fees/2026-04-13/1776090776",
        "key": "raw/fees/2026-04-13/1776090776/8c958ff8-9a2a-4f3c-aa52-1a70427b4b12.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1027521550822831032,
        "service_name": "drive-thru",
        "span_id": 1310290408201860789,
        "trace_id": 1430928073919214992
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-13 09:32:59
success: True
trace_id: 1430928073919214992

Scan 161903489

duration: 0:00:15.077781

exit_message:

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

id: 161903489

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/fees/2026-04-12/1776004308",
        "key": "raw/fees/2026-04-12/1776004308/bf93ca6c-4e70-4c20-8636-6f2c0c9e62c7.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9652640237537199806,
        "service_name": "drive-thru",
        "span_id": 1109921506706317698,
        "trace_id": 17153182517551242400
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-12 09:32:03
success: True
trace_id: 17153182517551242400

Scan 161852011

duration: 0:00:14.767685

exit_message:

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

id: 161852011

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/fees/2026-04-11/1775917766",
        "key": "raw/fees/2026-04-11/1775917766/230f06be-348f-4912-a5f3-acecb2d55e21.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12473944184729621805,
        "service_name": "drive-thru",
        "span_id": 2461426521606997601,
        "trace_id": 2690800822309032240
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-11 09:29:28
success: True
trace_id: 2690800822309032240

Scan 161797366

duration: 0:00:12.311531

exit_message:

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

id: 161797366

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/fees/2026-04-10/1775831489",
        "key": "raw/fees/2026-04-10/1775831489/8393b279-ad2f-434a-a986-1fb32d855dd8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14980860047926570060,
        "service_name": "drive-thru",
        "span_id": 16904049666182850686,
        "trace_id": 12556562938552802731
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-10 09:31:42
success: True
trace_id: 12556562938552802731

Scan 161741410

duration: 0:00:14.787183

exit_message:

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

id: 161741410

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/fees/2026-04-09/1775745123",
        "key": "raw/fees/2026-04-09/1775745123/bf2e4d15-d41f-4180-8444-1c56b651df1d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17269152957047108200,
        "service_name": "drive-thru",
        "span_id": 3213204571917942893,
        "trace_id": 17534049811895656407
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-09 09:32:14
success: True
trace_id: 17534049811895656407

Scan 161686238

duration: 0:00:12.400203

exit_message:

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

id: 161686238

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/fees/2026-04-08/1775658726",
        "key": "raw/fees/2026-04-08/1775658726/115e601d-fd5a-4b0e-887d-b9b43de129a5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11875441506244033802,
        "service_name": "drive-thru",
        "span_id": 4151057762749910856,
        "trace_id": 9875270445413255901
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-08 09:32:28
success: True
trace_id: 9875270445413255901

Scan 161630218

duration: 0:00:14.893086

exit_message:

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

id: 161630218

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/fees/2026-04-07/1775572119",
        "key": "raw/fees/2026-04-07/1775572119/9693292e-e57b-4703-afc9-a64435318818.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 366409363075543341,
        "service_name": "drive-thru",
        "span_id": 10465600402861245671,
        "trace_id": 3473211160946301547
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-07 09:29:01
success: True
trace_id: 3473211160946301547

Scan 161572901

duration: 0:00:12.494117

exit_message:

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

id: 161572901

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/fees/2026-04-06/1775486466",
        "key": "raw/fees/2026-04-06/1775486466/9c7fd0aa-d265-4f9e-85e8-5e250301dfef.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2003253749111829624,
        "service_name": "drive-thru",
        "span_id": 2416641185834482632,
        "trace_id": 6087835935207271135
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-06 09:41:15
success: True
trace_id: 6087835935207271135

Scan 161523789

duration: 0:00:15.158150

exit_message:

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

id: 161523789

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/fees/2026-04-05/1775399428",
        "key": "raw/fees/2026-04-05/1775399428/e5faec96-27c1-4484-8d46-603acc1acb0b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11280805820202669056,
        "service_name": "drive-thru",
        "span_id": 6173803431367717893,
        "trace_id": 13339473443060012909
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-05 09:30:41
success: True
trace_id: 13339473443060012909

Scan 161471656

duration: 0:00:12.195334

exit_message:

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

id: 161471656

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/fees/2026-04-04/1775312895",
        "key": "raw/fees/2026-04-04/1775312895/b6a2985e-75fd-41f8-a92e-f87cf09ac6e6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9349249819460372748,
        "service_name": "drive-thru",
        "span_id": 857072853844646624,
        "trace_id": 14191777173284159695
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-04 09:28:18
success: True
trace_id: 14191777173284159695

Scan 161414349

duration: 0:00:12.419900

exit_message:

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

id: 161414349

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/fees/2026-04-03/1775226764",
        "key": "raw/fees/2026-04-03/1775226764/1f32dcd9-bb14-4b1d-a477-75a6051bff2d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4158194933482357857,
        "service_name": "drive-thru",
        "span_id": 7975921692036371233,
        "trace_id": 17092995987176362938
    }
}

running: False
schema_name_id: 1964
start_time: 2026-04-03 09:32:58
success: True
trace_id: 17092995987176362938

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",
    "amount": "string",
    "collection": "string",
    "collectionfactor": "string",
    "collectionincludecurrent": "string",
    "collectionoffset": "string",
    "created": "string",
    "creator": "string",
    "currency": "string",
    "description": "string",
    "entity": "string",
    "fee_id": "string",
    "finish": "string",
    "forentity": "string",
    "fromentity": "string",
    "frozen": "string",
    "inactive": "string",
    "maximum": "string",
    "modified": "string",
    "modifier": "string",
    "name": "string",
    "org_id": "string",
    "schedule": "string",
    "schedulefactor": "string",
    "start": "string",
    "txnfee": "string",
    "type": "string",
    "um": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-17/1776436111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
}

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:21:20",
        "disabled": false,
        "format": "raw",
        "id": 1964,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrixess_fees"
        },
        "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",
            "amount": "string",
            "collection": "string",
            "collectionfactor": "string",
            "collectionincludecurrent": "string",
            "collectionoffset": "string",
            "created": "string",
            "creator": "string",
            "currency": "string",
            "description": "string",
            "entity": "string",
            "fee_id": "string",
            "finish": "string",
            "forentity": "string",
            "fromentity": "string",
            "frozen": "string",
            "inactive": "string",
            "maximum": "string",
            "modified": "string",
            "modifier": "string",
            "name": "string",
            "org_id": "string",
            "schedule": "string",
            "schedulefactor": "string",
            "start": "string",
            "txnfee": "string",
            "type": "string",
            "um": "string"
        },
        "created": "2026-04-17 09:28:35",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_fees`\n(\n `_hoodie_commit_time`  string , `_hoodie_commit_seqno`  string , `_hoodie_record_key`  string , `_hoodie_partition_path`  string , `_hoodie_file_name`  string , `fee_id`  string , `created`  string , `creator`  string , `modified`  string , `modifier`  string , `entity`  string , `org_id`  string , `forentity`  string , `fromentity`  string , `type`  string , `name`  string , `description`  string , `inactive`  string , `frozen`  string , `maximum`  string , `um`  string , `schedule`  string , `schedulefactor`  string , `start`  string , `finish`  string , `txnfee`  string , `amount`  string , `currency`  string , `collection`  string , `collectionfactor`  string , `collectionincludecurrent`  string , `collectionoffset`  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/fees/2026-04-17/1776436111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}