Schema Info

Schema Name: sfdl_dev_csv.payrixess_fees

created: 2024-07-22 13:00:06
disabled: False
format: raw
id: 2355
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773337

created: 2026-04-17 09:30:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-17/1776436217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-17/1776436217
id: 4773337
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: 2355
schema_scan_id: 6867669
updated: 2026-04-17 09:31:03

Version 4773286

created: 2026-04-16 09:33:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-16/1776350018'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-16/1776350018
id: 4773286
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: 2355
schema_scan_id: 6867453
updated: 2026-04-16 09:34:10

Version 4773217

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-15/1776263691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-15/1776263691
id: 4773217
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: 2355
schema_scan_id: 6867169
updated: 2026-04-15 09:35:20

Version 4773154

created: 2026-04-14 09:41:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-14/1776177673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-14/1776177673
id: 4773154
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: 2355
schema_scan_id: 6866890
updated: 2026-04-14 09:41:55

Version 4773103

created: 2026-04-13 09:34:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-13/1776090822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-13/1776090822
id: 4773103
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: 2355
schema_scan_id: 6866597
updated: 2026-04-13 09:34:19

Version 4773045

created: 2026-04-12 09:28:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-12/1776004101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-12/1776004101
id: 4773045
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: 2355
schema_scan_id: 6866383
updated: 2026-04-12 09:29:08

Version 4772990

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-11/1775917640'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-11/1775917640
id: 4772990
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: 2355
schema_scan_id: 6866209
updated: 2026-04-11 09:27:51

Version 4772936

created: 2026-04-10 09:27:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-10/1775831236'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-10/1775831236
id: 4772936
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: 2355
schema_scan_id: 6865969
updated: 2026-04-10 09:28:02

Version 4772873

created: 2026-04-09 09:30:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-09/1775744971'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-09/1775744971
id: 4772873
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: 2355
schema_scan_id: 6865689
updated: 2026-04-09 09:30:29

Version 4772821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-08/1775658519'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-08/1775658519
id: 4772821
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: 2355
schema_scan_id: 6865460
updated: 2026-04-08 09:29:52

Version 4772758

created: 2026-04-07 09:32:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-07/1775572329'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-07/1775572329
id: 4772758
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: 2355
schema_scan_id: 6865242
updated: 2026-04-07 09:32:28

Version 4772688

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-06/1775485796'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-06/1775485796
id: 4772688
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: 2355
schema_scan_id: 6864830
updated: 2026-04-06 09:30:36

Version 4772651

created: 2026-04-05 09:46:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-05/1775400337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-05/1775400337
id: 4772651
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: 2355
schema_scan_id: 6864722
updated: 2026-04-05 09:46:14

Version 4772594

created: 2026-04-04 09:27:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-04/1775312829'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-04/1775312829
id: 4772594
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: 2355
schema_scan_id: 6864467
updated: 2026-04-04 09:27:49

Version 4772534

created: 2026-04-03 09:35:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-03/1775226903'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-03/1775226903
id: 4772534
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: 2355
schema_scan_id: 6864272
updated: 2026-04-03 09:35:33

Schema Scans: 15

Last at 2026-04-17 09:30:48

Scan 6867669

duration: 0:00:15.056766

exit_message:

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

id: 6867669

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-17/1776436217",
        "key": "raw/fees/2026-04-17/1776436217/a9a6aa58-df62-4dfb-b05c-b4baedf111c0.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17729278641965179519,
        "service_name": "drive-thru",
        "span_id": 12373636069776062152,
        "trace_id": 11460547962261312911
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-17 09:30:48
success: True
trace_id: 11460547962261312911

Scan 6867453

duration: 0:00:14.859041

exit_message:

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

id: 6867453

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-16/1776350018",
        "key": "raw/fees/2026-04-16/1776350018/7aa27ff0-99cc-4abf-b86c-a33670b35839.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14067638050781971012,
        "service_name": "drive-thru",
        "span_id": 6743403662594188634,
        "trace_id": 5880469984560172505
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-16 09:33:55
success: True
trace_id: 5880469984560172505

Scan 6867169

duration: 0:00:15.007321

exit_message:

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

id: 6867169

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-15/1776263691",
        "key": "raw/fees/2026-04-15/1776263691/a6add4f9-797f-441c-b884-47842afabcf9.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8870516003402185998,
        "service_name": "drive-thru",
        "span_id": 3462370159291920394,
        "trace_id": 15865984579012817192
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-15 09:35:05
success: True
trace_id: 15865984579012817192

Scan 6866890

duration: 0:00:12.440322

exit_message:

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

id: 6866890

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-14/1776177673",
        "key": "raw/fees/2026-04-14/1776177673/c8f0d83b-fff2-4f81-b0a2-bc0c4ece8825.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12318754998993033410,
        "service_name": "drive-thru",
        "span_id": 17971313526921525971,
        "trace_id": 6656516836661180654
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-14 09:41:42
success: True
trace_id: 6656516836661180654

Scan 6866597

duration: 0:00:12.517940

exit_message:

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

id: 6866597

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-13/1776090822",
        "key": "raw/fees/2026-04-13/1776090822/14a3bd68-9788-40d0-bcb8-183c369293ff.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14819121274049991597,
        "service_name": "drive-thru",
        "span_id": 4715279984453182230,
        "trace_id": 10774366378220061747
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-13 09:34:06
success: True
trace_id: 10774366378220061747

Scan 6866383

duration: 0:00:14.834754

exit_message:

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

id: 6866383

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-12/1776004101",
        "key": "raw/fees/2026-04-12/1776004101/6e2e02d3-a116-4a1c-9509-1a0ecfcea87a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17763758460794062423,
        "service_name": "drive-thru",
        "span_id": 14446547177696323012,
        "trace_id": 56284832019407335
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-12 09:28:53
success: True
trace_id: 56284832019407335

Scan 6866209

duration: 0:00:12.385200

exit_message:

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

id: 6866209

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-11/1775917640",
        "key": "raw/fees/2026-04-11/1775917640/4d82e377-36e3-4857-94dc-308e719faf1e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 729203540081246262,
        "service_name": "drive-thru",
        "span_id": 4539240449850909759,
        "trace_id": 16219119153893041850
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-11 09:27:39
success: True
trace_id: 16219119153893041850

Scan 6865969

duration: 0:00:12.509141

exit_message:

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

id: 6865969

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-10/1775831236",
        "key": "raw/fees/2026-04-10/1775831236/18480a88-a5ba-4a2c-bcdf-1929796cdc47.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14842099131057082857,
        "service_name": "drive-thru",
        "span_id": 17070511647434573737,
        "trace_id": 2105382471283900894
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-10 09:27:50
success: True
trace_id: 2105382471283900894

Scan 6865689

duration: 0:00:15.093283

exit_message:

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

id: 6865689

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-09/1775744971",
        "key": "raw/fees/2026-04-09/1775744971/8fd21fc7-e308-4c5c-a35f-6f988669ca5b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14651053448513325339,
        "service_name": "drive-thru",
        "span_id": 4802424094315976870,
        "trace_id": 18152810245799582570
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-09 09:30:14
success: True
trace_id: 18152810245799582570

Scan 6865460

duration: 0:00:14.953242

exit_message:

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

id: 6865460

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-08/1775658519",
        "key": "raw/fees/2026-04-08/1775658519/89ff143d-9466-4ad1-bfb6-7f5c43c930eb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2017847309827592770,
        "service_name": "drive-thru",
        "span_id": 9058655947511207483,
        "trace_id": 15529913824077779362
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-08 09:29:37
success: True
trace_id: 15529913824077779362

Scan 6865242

duration: 0:00:15.047197

exit_message:

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

id: 6865242

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-07/1775572329",
        "key": "raw/fees/2026-04-07/1775572329/ac5f12f4-52a3-4989-9187-3b6656174394.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6317129174387916061,
        "service_name": "drive-thru",
        "span_id": 12628784307958211027,
        "trace_id": 9845138148339467612
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-07 09:32:13
success: True
trace_id: 9845138148339467612

Scan 6864830

duration: 0:00:15.028768

exit_message:

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

id: 6864830

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-06/1775485796",
        "key": "raw/fees/2026-04-06/1775485796/1ad17e98-5a94-47ec-8eaa-30ad620c2ffa.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 830140752736576340,
        "service_name": "drive-thru",
        "span_id": 14202286859502010772,
        "trace_id": 10935508451422915457
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-06 09:30:21
success: True
trace_id: 10935508451422915457

Scan 6864722

duration: 0:00:12.429300

exit_message:

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

id: 6864722

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-05/1775400337",
        "key": "raw/fees/2026-04-05/1775400337/d42fb6f4-8249-4c1b-9084-edde9ad8ca19.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4632094730999106702,
        "service_name": "drive-thru",
        "span_id": 2582979608791139078,
        "trace_id": 13177529204783701244
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-05 09:46:02
success: True
trace_id: 13177529204783701244

Scan 6864467

duration: 0:00:14.925248

exit_message:

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

id: 6864467

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-04/1775312829",
        "key": "raw/fees/2026-04-04/1775312829/2f011483-b51e-438c-97a6-d95a38c830b8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13396406235843902311,
        "service_name": "drive-thru",
        "span_id": 10744915763161946335,
        "trace_id": 13319374307722499311
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-04 09:27:35
success: True
trace_id: 13319374307722499311

Scan 6864272

duration: 0:00:14.944006

exit_message:

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

id: 6864272

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/fees/2026-04-03/1775226903",
        "key": "raw/fees/2026-04-03/1775226903/42d509d9-87c8-42e0-8ca4-def347011cbb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18395914608196870157,
        "service_name": "drive-thru",
        "span_id": 2926050804548591599,
        "trace_id": 6246232848054088097
    }
}

running: False
schema_name_id: 2355
start_time: 2026-04-03 09:35:18
success: True
trace_id: 6246232848054088097

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:30:49

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-17/1776436217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 13:00:06",
        "disabled": false,
        "format": "raw",
        "id": 2355,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:30:49",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-17/1776436217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}