Schema Info

Schema Name: sfdl_stage_csv.payrix_fees

created: 2023-07-26 09:04:53
disabled: False
format: raw
id: 1806
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906685

created: 2026-04-17 09:26:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-17/1776435963
id: 906685
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: 1806
schema_scan_id: 6415338
updated: 2026-04-17 09:26:20

Version 906473

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-16/1776349867
id: 906473
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: 1806
schema_scan_id: 6414854
updated: 2026-04-16 09:31:34

Version 906275

created: 2026-04-15 09:43:07

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-15/1776264172
id: 906275
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: 1806
schema_scan_id: 6414422
updated: 2026-04-15 09:43:18

Version 906044

created: 2026-04-14 09:27:35

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-14/1776176851
id: 906044
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: 1806
schema_scan_id: 6413815
updated: 2026-04-14 09:27:49

Version 905848

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-13/1776091216
id: 905848
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: 1806
schema_scan_id: 6413327
updated: 2026-04-13 09:40:40

Version 905650

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-12/1776005084
id: 905650
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: 1806
schema_scan_id: 6412949
updated: 2026-04-12 09:45:02

Version 905427

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-11/1775917618
id: 905427
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: 1806
schema_scan_id: 6412463
updated: 2026-04-11 09:27:22

Version 905220

created: 2026-04-10 09:40:18

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-10/1775832013
id: 905220
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: 1806
schema_scan_id: 6412064
updated: 2026-04-10 09:40:29

Version 905004

created: 2026-04-09 09:35:51

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-09/1775745340
id: 905004
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: 1806
schema_scan_id: 6411515
updated: 2026-04-09 09:36:05

Version 904792

created: 2026-04-08 09:33:10

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-08/1775658786
id: 904792
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: 1806
schema_scan_id: 6411059
updated: 2026-04-08 09:33:21

Version 904581

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-07/1775572741
id: 904581
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: 1806
schema_scan_id: 6410533
updated: 2026-04-07 09:39:16

Version 904367

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-06/1775485988
id: 904367
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: 1806
schema_scan_id: 6410033
updated: 2026-04-06 09:33:29

Version 904158

created: 2026-04-05 09:38:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-05/1775399887
id: 904158
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: 1806
schema_scan_id: 6409600
updated: 2026-04-05 09:38:34

Version 903943

created: 2026-04-04 09:28:26

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-04/1775312900
id: 903943
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: 1806
schema_scan_id: 6409101
updated: 2026-04-04 09:28:37

Version 903760

created: 2026-04-03 09:58:03

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/fees/2026-04-03/1775228276
id: 903760
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: 1806
schema_scan_id: 6408774
updated: 2026-04-03 09:58:17

Schema Scans: 15

Last at 2026-04-17 09:26:07

Scan 6415338

duration: 0:00:12.546719

exit_message:

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

id: 6415338

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-17/1776435963",
        "key": "raw/fees/2026-04-17/1776435963/1c52fd19-cbe4-43d1-ae89-96b01d967d60.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3052003802365897490,
        "service_name": "drive-thru",
        "span_id": 4035057258179483883,
        "trace_id": 10062898582420536849
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-17 09:26:07
success: True
trace_id: 10062898582420536849

Scan 6414854

duration: 0:00:12.532921

exit_message:

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

id: 6414854

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-16/1776349867",
        "key": "raw/fees/2026-04-16/1776349867/954d76b4-4cc7-4125-9af3-6f218b1098e0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15330717692304871219,
        "service_name": "drive-thru",
        "span_id": 3521094513198192838,
        "trace_id": 14818173905652399903
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-16 09:31:21
success: True
trace_id: 14818173905652399903

Scan 6414422

duration: 0:00:12.690745

exit_message:

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

id: 6414422

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-15/1776264172",
        "key": "raw/fees/2026-04-15/1776264172/e0f6a6f0-6054-49c6-9ee4-4330f843930f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1604403584611788659,
        "service_name": "drive-thru",
        "span_id": 5535634549748544289,
        "trace_id": 10893515617182251425
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-15 09:43:06
success: True
trace_id: 10893515617182251425

Scan 6413815

duration: 0:00:15.106002

exit_message:

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

id: 6413815

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-14/1776176851",
        "key": "raw/fees/2026-04-14/1776176851/6a67b230-4b28-4453-bad7-0085e89c9840.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10065917390496716964,
        "service_name": "drive-thru",
        "span_id": 9546145079004079432,
        "trace_id": 1167925908624876660
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-14 09:27:34
success: True
trace_id: 1167925908624876660

Scan 6413327

duration: 0:00:12.533499

exit_message:

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

id: 6413327

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-13/1776091216",
        "key": "raw/fees/2026-04-13/1776091216/6e1d59eb-7a4c-402c-a238-75401736e34c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4535436807179873150,
        "service_name": "drive-thru",
        "span_id": 14893898858179452263,
        "trace_id": 10724591428804332924
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-13 09:40:28
success: True
trace_id: 10724591428804332924

Scan 6412949

duration: 0:00:15.102638

exit_message:

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

id: 6412949

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-12/1776005084",
        "key": "raw/fees/2026-04-12/1776005084/4d5e3a6f-d1ba-4123-bb3f-6f536834a0af.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14477449774651297963,
        "service_name": "drive-thru",
        "span_id": 12597897023633518762,
        "trace_id": 1155723306470072994
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-12 09:44:47
success: True
trace_id: 1155723306470072994

Scan 6412463

duration: 0:00:12.543920

exit_message:

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

id: 6412463

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-11/1775917618",
        "key": "raw/fees/2026-04-11/1775917618/3ec802af-8545-49ff-9dfe-6946b0bf0e29.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2438969432435617201,
        "service_name": "drive-thru",
        "span_id": 3449261711210698454,
        "trace_id": 18097771020249160516
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-11 09:27:10
success: True
trace_id: 18097771020249160516

Scan 6412064

duration: 0:00:12.493372

exit_message:

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

id: 6412064

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-10/1775832013",
        "key": "raw/fees/2026-04-10/1775832013/f3a2364d-07fb-4c05-b981-311020e65cff.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5377971630913788191,
        "service_name": "drive-thru",
        "span_id": 1641280473251166820,
        "trace_id": 3320087003325020613
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-10 09:40:16
success: True
trace_id: 3320087003325020613

Scan 6411515

duration: 0:00:15.104461

exit_message:

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

id: 6411515

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-09/1775745340",
        "key": "raw/fees/2026-04-09/1775745340/36daaccd-7c66-4da8-afea-dee3a8d43378.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13913508785959873662,
        "service_name": "drive-thru",
        "span_id": 1902763035030257628,
        "trace_id": 3217526698793434942
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-09 09:35:50
success: True
trace_id: 3217526698793434942

Scan 6411059

duration: 0:00:12.677556

exit_message:

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

id: 6411059

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-08/1775658786",
        "key": "raw/fees/2026-04-08/1775658786/51c0c018-7966-48f0-a43e-7d831780342a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1400412695731882210,
        "service_name": "drive-thru",
        "span_id": 3221641012918824551,
        "trace_id": 17748781450783301239
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-08 09:33:08
success: True
trace_id: 17748781450783301239

Scan 6410533

duration: 0:00:12.520363

exit_message:

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

id: 6410533

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-07/1775572741",
        "key": "raw/fees/2026-04-07/1775572741/3b3bed67-dfa3-406c-839d-aa05132fdd5c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16945972293206652054,
        "service_name": "drive-thru",
        "span_id": 15933342921484601030,
        "trace_id": 11199341334543125862
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-07 09:39:03
success: True
trace_id: 11199341334543125862

Scan 6410033

duration: 0:00:15.017477

exit_message:

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

id: 6410033

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-06/1775485988",
        "key": "raw/fees/2026-04-06/1775485988/ac6114e1-ce04-4df6-8e76-f213301fabe4.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11081472077066672764,
        "service_name": "drive-thru",
        "span_id": 14411270482974130660,
        "trace_id": 5983709826642688815
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-06 09:33:14
success: True
trace_id: 5983709826642688815

Scan 6409600

duration: 0:00:15.019775

exit_message:

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

id: 6409600

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-05/1775399887",
        "key": "raw/fees/2026-04-05/1775399887/f137f96b-4aa1-4e2c-bf26-00795244bc4e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16846097637585964961,
        "service_name": "drive-thru",
        "span_id": 4572945763782896832,
        "trace_id": 8708320927719770470
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-05 09:38:19
success: True
trace_id: 8708320927719770470

Scan 6409101

duration: 0:00:12.389446

exit_message:

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

id: 6409101

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-04/1775312900",
        "key": "raw/fees/2026-04-04/1775312900/27df6b86-4e3a-45a8-bbb4-3caf2a2a63ab.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8752301749719891065,
        "service_name": "drive-thru",
        "span_id": 5425174405611899783,
        "trace_id": 13644672917288837248
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-04 09:28:24
success: True
trace_id: 13644672917288837248

Scan 6408774

duration: 0:00:15.356380

exit_message:

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

id: 6408774

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/fees/2026-04-03/1775228276",
        "key": "raw/fees/2026-04-03/1775228276/0090da4d-2e78-47d2-ae4c-f651cbfcf409.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17183893383234220954,
        "service_name": "drive-thru",
        "span_id": 10946022820568115683,
        "trace_id": 2094030080134783490
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-03 09:58:02
success: True
trace_id: 2094030080134783490

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:26:09

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-07-26 09:04:53",
        "disabled": false,
        "format": "raw",
        "id": 1806,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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",
            "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:26:09",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/fees/2026-04-17/1776435963'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}