Schema Info

Schema Name: sfdl_dev_csv.payrix_fees

created: 2023-08-18 15:52:43
disabled: False
format: raw
id: 2235
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773348

created: 2026-04-17 09:39:07

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-17/1776436733
id: 4773348
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: 2235
schema_scan_id: 6867689
updated: 2026-04-17 09:39:21

Version 4773278

created: 2026-04-16 09:31:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-16/1776349892
id: 4773278
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: 2235
schema_scan_id: 6867418
updated: 2026-04-16 09:32:11

Version 4773234

created: 2026-04-15 09:59:58

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-15/1776265175
id: 4773234
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: 2235
schema_scan_id: 6867247
updated: 2026-04-15 10:00:10

Version 4773173

created: 2026-04-14 10:00:59

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-14/1776178850
id: 4773173
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: 2235
schema_scan_id: 6866968
updated: 2026-04-14 10:01:13

Version 4773109

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-13/1776091151
id: 4773109
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: 2235
schema_scan_id: 6866637
updated: 2026-04-13 09:40:00

Version 4773048

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-12/1776004722
id: 4773048
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: 2235
schema_scan_id: 6866431
updated: 2026-04-12 09:39:08

Version 4773009

created: 2026-04-11 09:41:55

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-11/1775918505
id: 4773009
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: 2235
schema_scan_id: 6866270
updated: 2026-04-11 09:42:06

Version 4772944

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-10/1775831366
id: 4772944
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: 2235
schema_scan_id: 6866016
updated: 2026-04-10 09:29:48

Version 4772874

created: 2026-04-09 09:30:34

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-09/1775745005
id: 4772874
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: 2235
schema_scan_id: 6865698
updated: 2026-04-09 09:30:45

Version 4772837

created: 2026-04-08 09:46:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-08/1775659571
id: 4772837
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: 2235
schema_scan_id: 6865535
updated: 2026-04-08 09:46:37

Version 4772760

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-07/1775572349
id: 4772760
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: 2235
schema_scan_id: 6865249
updated: 2026-04-07 09:32:48

Version 4772703

created: 2026-04-06 09:42:06

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-06/1775486455
id: 4772703
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: 2235
schema_scan_id: 6864900
updated: 2026-04-06 09:42:20

Version 4772645

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-05/1775399690
id: 4772645
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: 2235
schema_scan_id: 6864664
updated: 2026-04-05 09:35:05

Version 4772603

created: 2026-04-04 09:43:41

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-04/1775313808
id: 4772603
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: 2235
schema_scan_id: 6864509
updated: 2026-04-04 09:43:52

Version 4772549

created: 2026-04-03 09:54:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/fees/2026-04-03/1775228032
id: 4772549
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: 2235
schema_scan_id: 6864336
updated: 2026-04-03 09:54:40

Schema Scans: 15

Last at 2026-04-17 09:39:06

Scan 6867689

duration: 0:00:15.056315

exit_message:

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

id: 6867689

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-17/1776436733",
        "key": "raw/fees/2026-04-17/1776436733/12187eb9-bd72-4ebc-8823-c782686d7208.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11687455867019765362,
        "service_name": "drive-thru",
        "span_id": 14795769596630137259,
        "trace_id": 6932624427750594487
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-17 09:39:06
success: True
trace_id: 6932624427750594487

Scan 6867418

duration: 0:00:15.180633

exit_message:

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

id: 6867418

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-16/1776349892",
        "key": "raw/fees/2026-04-16/1776349892/53c885f9-2f90-4b7b-a9f6-5accf09f3388.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10196523807392266434,
        "service_name": "drive-thru",
        "span_id": 17079088406332381232,
        "trace_id": 12903637215492204350
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-16 09:31:56
success: True
trace_id: 12903637215492204350

Scan 6867247

duration: 0:00:12.524407

exit_message:

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

id: 6867247

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-15/1776265175",
        "key": "raw/fees/2026-04-15/1776265175/b0c4b955-ea8d-4cdc-af91-b2accb7fe16a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13069288168585753335,
        "service_name": "drive-thru",
        "span_id": 3259868231287297059,
        "trace_id": 977363884392901763
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-15 09:59:57
success: True
trace_id: 977363884392901763

Scan 6866968

duration: 0:00:15.041057

exit_message:

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

id: 6866968

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-14/1776178850",
        "key": "raw/fees/2026-04-14/1776178850/ec228206-2b83-4857-84a9-db7fdaeee61d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17792065551255769973,
        "service_name": "drive-thru",
        "span_id": 7979107265323970934,
        "trace_id": 4241854263545324646
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-14 10:00:58
success: True
trace_id: 4241854263545324646

Scan 6866637

duration: 0:00:12.415019

exit_message:

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

id: 6866637

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-13/1776091151",
        "key": "raw/fees/2026-04-13/1776091151/698b685f-9d58-41d8-952e-881ae9a84faf.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16451050314328654269,
        "service_name": "drive-thru",
        "span_id": 14205661584933703543,
        "trace_id": 11369674561806420558
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-13 09:39:47
success: True
trace_id: 11369674561806420558

Scan 6866431

duration: 0:00:12.537264

exit_message:

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

id: 6866431

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-12/1776004722",
        "key": "raw/fees/2026-04-12/1776004722/241d046e-78ba-4184-9de5-a0b9147770b6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12822710728851635523,
        "service_name": "drive-thru",
        "span_id": 7034327769981313054,
        "trace_id": 12718001326847021597
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-12 09:38:56
success: True
trace_id: 12718001326847021597

Scan 6866270

duration: 0:00:12.526432

exit_message:

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

id: 6866270

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-11/1775918505",
        "key": "raw/fees/2026-04-11/1775918505/036e3233-2c8e-4622-a6a3-f4aca22fc068.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13646545714665113390,
        "service_name": "drive-thru",
        "span_id": 9705775267451265265,
        "trace_id": 9552203925889937192
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-11 09:41:54
success: True
trace_id: 9552203925889937192

Scan 6866016

duration: 0:00:12.419418

exit_message:

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

id: 6866016

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-10/1775831366",
        "key": "raw/fees/2026-04-10/1775831366/459a9173-8b4c-46e8-a239-2b9ee55f5e60.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5595320672473733333,
        "service_name": "drive-thru",
        "span_id": 9673311009994714667,
        "trace_id": 17041030276180483708
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-10 09:29:36
success: True
trace_id: 17041030276180483708

Scan 6865698

duration: 0:00:12.535706

exit_message:

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

id: 6865698

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-09/1775745005",
        "key": "raw/fees/2026-04-09/1775745005/2a3fa514-aabe-4d0e-b0ec-00f4dd862970.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10217174801775948675,
        "service_name": "drive-thru",
        "span_id": 13654432414199143840,
        "trace_id": 6671702431153772304
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-09 09:30:33
success: True
trace_id: 6671702431153772304

Scan 6865535

duration: 0:00:12.573723

exit_message:

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

id: 6865535

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-08/1775659571",
        "key": "raw/fees/2026-04-08/1775659571/802d1db5-7e0b-4ed5-8f66-2a13547a2c0a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18164640818672543847,
        "service_name": "drive-thru",
        "span_id": 6893487399073529379,
        "trace_id": 14085826064587888171
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-08 09:46:25
success: True
trace_id: 14085826064587888171

Scan 6865249

duration: 0:00:12.568316

exit_message:

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

id: 6865249

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-07/1775572349",
        "key": "raw/fees/2026-04-07/1775572349/0e8d936b-0415-4e9a-aef8-b411410e0ba8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6483766441952557435,
        "service_name": "drive-thru",
        "span_id": 15362531704299443903,
        "trace_id": 10812728484370471004
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-07 09:32:36
success: True
trace_id: 10812728484370471004

Scan 6864900

duration: 0:00:15.348683

exit_message:

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

id: 6864900

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-06/1775486455",
        "key": "raw/fees/2026-04-06/1775486455/fe5d82e6-3ab2-4bbd-82fd-1f7574bf3255.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15855806257691751065,
        "service_name": "drive-thru",
        "span_id": 18129221293251461920,
        "trace_id": 3837323464825514731
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-06 09:42:04
success: True
trace_id: 3837323464825514731

Scan 6864664

duration: 0:00:12.502119

exit_message:

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

id: 6864664

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-05/1775399690",
        "key": "raw/fees/2026-04-05/1775399690/5d08e48a-4250-4d77-9573-d2fbc354d0e6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7160735746466743307,
        "service_name": "drive-thru",
        "span_id": 3388707882072791086,
        "trace_id": 15916423092022325061
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-05 09:34:53
success: True
trace_id: 15916423092022325061

Scan 6864509

duration: 0:00:12.534383

exit_message:

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

id: 6864509

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-04/1775313808",
        "key": "raw/fees/2026-04-04/1775313808/6301fd07-5e7a-41bb-87c2-fa31977b8658.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11243226370132037613,
        "service_name": "drive-thru",
        "span_id": 11443841085174086575,
        "trace_id": 12854925608631635313
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-04 09:43:40
success: True
trace_id: 12854925608631635313

Scan 6864336

duration: 0:00:14.979838

exit_message:

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

id: 6864336

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/fees/2026-04-03/1775228032",
        "key": "raw/fees/2026-04-03/1775228032/8f17cd91-b10c-4e28-a44f-f394502557d4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9877627224161415142,
        "service_name": "drive-thru",
        "span_id": 12592274511705527359,
        "trace_id": 1969101524339105843
    }
}

running: False
schema_name_id: 2235
start_time: 2026-04-03 09:54:25
success: True
trace_id: 1969101524339105843

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:39:07

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-17/1776436733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_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": "2023-08-18 15:52:43",
        "disabled": false,
        "format": "raw",
        "id": 2235,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:39:07",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/fees/2026-04-17/1776436733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}