Schema Info

Schema Name: sfdl_prod_csv.payrix_fees

created: 2023-07-27 09:04:29
disabled: False
format: raw
id: 1544
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718256

created: 2026-04-17 09:33:19

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-17/1776436384
id: 1718256
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",
    "entity_id": "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: 1544
schema_scan_id: 162178468
updated: 2026-04-17 09:33:30

Version 1717016

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-16/1776349617
id: 1717016
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",
    "entity_id": "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: 1544
schema_scan_id: 162122651
updated: 2026-04-16 09:27:12

Version 1715874

created: 2026-04-15 11:20:36

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-15/1776270001
id: 1715874
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",
    "entity_id": "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: 1544
schema_scan_id: 162072667
updated: 2026-04-15 11:20:50

Version 1714950

created: 2026-04-14 21:11:44

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-14/1776219100
id: 1714950
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",
    "entity_id": "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: 1544
schema_scan_id: 162046408
updated: 2026-04-14 21:11:58

Version 1713423

created: 2026-04-13 09:35:11

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-13/1776090906
id: 1713423
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",
    "entity_id": "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: 1544
schema_scan_id: 161953761
updated: 2026-04-13 09:35:23

Version 1712240

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-12/1776004999
id: 1712240
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",
    "entity_id": "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: 1544
schema_scan_id: 161903628
updated: 2026-04-12 09:43:40

Version 1711021

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-11/1775917874
id: 1711021
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",
    "entity_id": "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: 1544
schema_scan_id: 161852041
updated: 2026-04-11 09:31:40

Version 1709833

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-10/1775831205
id: 1709833
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",
    "entity_id": "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: 1544
schema_scan_id: 161797243
updated: 2026-04-10 09:27:06

Version 1708695

created: 2026-04-09 09:38:12

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-09/1775745486
id: 1708695
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",
    "entity_id": "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: 1544
schema_scan_id: 161741479
updated: 2026-04-09 09:38:26

Version 1707519

created: 2026-04-08 09:36:23

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-08/1775658902
id: 1707519
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",
    "entity_id": "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: 1544
schema_scan_id: 161686339
updated: 2026-04-08 09:36:37

Version 1706304

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-07/1775572113
id: 1706304
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",
    "entity_id": "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: 1544
schema_scan_id: 161630212
updated: 2026-04-07 09:28:59

Version 1705085

created: 2026-04-06 09:30:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-06/1775485815
id: 1705085
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",
    "entity_id": "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: 1544
schema_scan_id: 161572760
updated: 2026-04-06 09:30:31

Version 1703876

created: 2026-04-05 09:39:35

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-05/1775399971
id: 1703876
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",
    "entity_id": "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: 1544
schema_scan_id: 161523889
updated: 2026-04-05 09:39:46

Version 1702735

created: 2026-04-04 09:51:42

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-04/1775314288
id: 1702735
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",
    "entity_id": "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: 1544
schema_scan_id: 161472172
updated: 2026-04-04 09:51:55

Version 1701551

created: 2026-04-03 10:01:02

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/fees/2026-04-03/1775228287
id: 1701551
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",
    "entity_id": "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: 1544
schema_scan_id: 161416411
updated: 2026-04-03 10:01:16

Schema Scans: 15

Last at 2026-04-17 09:33:18

Scan 162178468

duration: 0:00:12.510368

exit_message:

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

id: 162178468

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-17/1776436384",
        "key": "raw/fees/2026-04-17/1776436384/4f2243f7-3ade-4523-a13c-4d2837308478.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11646396676320173898,
        "service_name": "drive-thru",
        "span_id": 1204586912633741003,
        "trace_id": 2537220931754445770
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-17 09:33:18
success: True
trace_id: 2537220931754445770

Scan 162122651

duration: 0:00:12.487459

exit_message:

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

id: 162122651

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-16/1776349617",
        "key": "raw/fees/2026-04-16/1776349617/b1bb8e72-24a2-4c4a-ba83-b43957f3ace2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14599975682665545508,
        "service_name": "drive-thru",
        "span_id": 2467729960785899526,
        "trace_id": 5318198126135310073
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-16 09:27:00
success: True
trace_id: 5318198126135310073

Scan 162072667

duration: 0:00:15.030475

exit_message:

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

id: 162072667

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-15/1776270001",
        "key": "raw/fees/2026-04-15/1776270001/5a366d53-8664-46a9-9589-abd6504f3c59.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 206720363082131396,
        "service_name": "drive-thru",
        "span_id": 8361994646071598429,
        "trace_id": 15676000399065492260
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-15 11:20:35
success: True
trace_id: 15676000399065492260

Scan 162046408

duration: 0:00:14.910154

exit_message:

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

id: 162046408

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-14/1776219100",
        "key": "raw/fees/2026-04-14/1776219100/9fe8bd48-1677-4fc2-ae06-da63d85d72de.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12117262281096486058,
        "service_name": "drive-thru",
        "span_id": 11293869217421999774,
        "trace_id": 6636556096328365202
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-14 21:11:43
success: True
trace_id: 6636556096328365202

Scan 161953761

duration: 0:00:12.556920

exit_message:

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

id: 161953761

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-13/1776090906",
        "key": "raw/fees/2026-04-13/1776090906/50668f59-55a7-43be-83e6-60c0ef0d3352.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10194256691989632810,
        "service_name": "drive-thru",
        "span_id": 2384169191632012319,
        "trace_id": 1602873428977834899
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-13 09:35:10
success: True
trace_id: 1602873428977834899

Scan 161903628

duration: 0:00:12.335585

exit_message:

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

id: 161903628

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-12/1776004999",
        "key": "raw/fees/2026-04-12/1776004999/9e36d8e2-878e-4424-8b1a-0b075499df9c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11032287659970960426,
        "service_name": "drive-thru",
        "span_id": 18261187132885991851,
        "trace_id": 7128421414411704313
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-12 09:43:28
success: True
trace_id: 7128421414411704313

Scan 161852041

duration: 0:00:14.914390

exit_message:

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

id: 161852041

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-11/1775917874",
        "key": "raw/fees/2026-04-11/1775917874/9114e715-2b45-4f40-b2e6-2d7d55c531d2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6312188235839017572,
        "service_name": "drive-thru",
        "span_id": 9502612328244883854,
        "trace_id": 10474683514448124673
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-11 09:31:25
success: True
trace_id: 10474683514448124673

Scan 161797243

duration: 0:00:14.820694

exit_message:

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

id: 161797243

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-10/1775831205",
        "key": "raw/fees/2026-04-10/1775831205/cd2fc9af-a059-468a-90e3-eaafc6497f18.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13161217539265157665,
        "service_name": "drive-thru",
        "span_id": 6260137570294673566,
        "trace_id": 12652821200467965979
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-10 09:26:51
success: True
trace_id: 12652821200467965979

Scan 161741479

duration: 0:00:14.937781

exit_message:

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

id: 161741479

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-09/1775745486",
        "key": "raw/fees/2026-04-09/1775745486/035eae8c-e2e5-4f08-9440-7146f55b90b3.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5512140341109100890,
        "service_name": "drive-thru",
        "span_id": 3601067691737524276,
        "trace_id": 13322016177990417854
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-09 09:38:11
success: True
trace_id: 13322016177990417854

Scan 161686339

duration: 0:00:14.906476

exit_message:

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

id: 161686339

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-08/1775658902",
        "key": "raw/fees/2026-04-08/1775658902/ccd2ec03-420e-4d32-b45a-dd3a0d13e54c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6713710042789810362,
        "service_name": "drive-thru",
        "span_id": 13637920460128993425,
        "trace_id": 12695291150033958124
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-08 09:36:22
success: True
trace_id: 12695291150033958124

Scan 161630212

duration: 0:00:14.969956

exit_message:

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

id: 161630212

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-07/1775572113",
        "key": "raw/fees/2026-04-07/1775572113/2cf6542d-70ce-46a2-9bcd-7ad5bd582fa6.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5587240275752641823,
        "service_name": "drive-thru",
        "span_id": 5605392740258935182,
        "trace_id": 16544930596191990912
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-07 09:28:44
success: True
trace_id: 16544930596191990912

Scan 161572760

duration: 0:00:12.427091

exit_message:

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

id: 161572760

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-06/1775485815",
        "key": "raw/fees/2026-04-06/1775485815/19ffc3d5-b204-4f0b-a6d5-fbca1fecebe5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16292685078562690656,
        "service_name": "drive-thru",
        "span_id": 14674052129937022212,
        "trace_id": 11073279169844927964
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-06 09:30:19
success: True
trace_id: 11073279169844927964

Scan 161523889

duration: 0:00:12.360219

exit_message:

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

id: 161523889

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-05/1775399971",
        "key": "raw/fees/2026-04-05/1775399971/b181222a-b3d4-4bea-b9b7-2e212d38434f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11989116898046707250,
        "service_name": "drive-thru",
        "span_id": 13532451381988389771,
        "trace_id": 13902673271842037013
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-05 09:39:34
success: True
trace_id: 13902673271842037013

Scan 161472172

duration: 0:00:14.953401

exit_message:

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

id: 161472172

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-04/1775314288",
        "key": "raw/fees/2026-04-04/1775314288/b7f99658-c05e-4b55-b023-a92744ef6497.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5744461861703610485,
        "service_name": "drive-thru",
        "span_id": 8559214353118608060,
        "trace_id": 18343742048683378731
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-04 09:51:40
success: True
trace_id: 18343742048683378731

Scan 161416411

duration: 0:00:15.571196

exit_message:

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

id: 161416411

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/fees/2026-04-03/1775228287",
        "key": "raw/fees/2026-04-03/1775228287/207bdf58-c07a-4bd7-8252-79219681ed98.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3037844240945845048,
        "service_name": "drive-thru",
        "span_id": 12828643613254264256,
        "trace_id": 15824715377539305746
    }
}

running: False
schema_name_id: 1544
start_time: 2026-04-03 10:01:00
success: True
trace_id: 15824715377539305746

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",
    "entity_id": "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:33:19

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/fees/2026-04-17/1776436384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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": "2023-07-27 09:04:29",
        "disabled": false,
        "format": "raw",
        "id": 1544,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrix_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",
            "entity_id": "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:33:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/fees/2026-04-17/1776436384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}