Schema Info

Schema Name: sfdl_dev_csv.payrixess_mms_interchange_fees

created: 2024-07-22 13:07:35
disabled: False
format: raw
id: 2373
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773355

created: 2026-04-17 09:44:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-17/1776437039'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-17/1776437039
id: 4773355
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6867728
updated: 2026-04-17 09:44:42

Version 4773285

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-16/1776349984'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-16/1776349984
id: 4773285
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6867442
updated: 2026-04-16 09:33:22

Version 4773245

created: 2026-04-15 10:05:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-15/1776265520'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-15/1776265520
id: 4773245
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6867285
updated: 2026-04-15 10:05:36

Version 4773175

created: 2026-04-14 10:02:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-14/1776178934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-14/1776178934
id: 4773175
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6866989
updated: 2026-04-14 10:02:40

Version 4773101

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-13/1776090818'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-13/1776090818
id: 4773101
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6866594
updated: 2026-04-13 09:34:05

Version 4773056

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-12/1776005005'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-12/1776005005
id: 4773056
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6866478
updated: 2026-04-12 09:43:57

Version 4773014

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-11/1775918691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-11/1775918691
id: 4773014
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6866294
updated: 2026-04-11 09:45:06

Version 4772964

created: 2026-04-10 09:47:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-10/1775832394'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-10/1775832394
id: 4772964
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6866097
updated: 2026-04-10 09:47:27

Version 4772900

created: 2026-04-09 09:50:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-09/1775746179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-09/1775746179
id: 4772900
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6865820
updated: 2026-04-09 09:50:48

Version 4772812

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-08/1775658400'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-08/1775658400
id: 4772812
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6865417
updated: 2026-04-08 09:27:22

Version 4772781

created: 2026-04-07 09:49:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-07/1775573335'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-07/1775573335
id: 4772781
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6865284
updated: 2026-04-07 09:49:47

Version 4772690

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-06/1775485791'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-06/1775485791
id: 4772690
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6864832
updated: 2026-04-06 09:30:51

Version 4772665

created: 2026-04-05 09:49:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-05/1775400501'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-05/1775400501
id: 4772665
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6864746
updated: 2026-04-05 09:49:20

Version 4772588

created: 2026-04-04 09:26:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-04/1775312785'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-04/1775312785
id: 4772588
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6864454
updated: 2026-04-04 09:26:50

Version 4772530

created: 2026-04-03 09:30:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-03/1775226596'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-03/1775226596
id: 4772530
processed: 1

raw_data:

{
    "entity": 2,
    "fee_count": 4,
    "fee_name": 3,
    "fee_sum": 5,
    "month": 1,
    "txn_sum": 6,
    "year": 0
}

schema_attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

schema_name_id: 2373
schema_scan_id: 6864225
updated: 2026-04-03 09:30:23

Schema Scans: 15

Last at 2026-04-17 09:44:31

Scan 6867728

duration: 0:00:11.918841

exit_message:

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

id: 6867728

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-17/1776437039",
        "key": "raw/mms_interchange_fees/2026-04-17/1776437039/4a7a4896-5603-4324-8450-bc6849f07b8f.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9538882034962760194,
        "service_name": "drive-thru",
        "span_id": 4979589327206916037,
        "trace_id": 12565962967501147615
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-17 09:44:31
success: True
trace_id: 12565962967501147615

Scan 6867442

duration: 0:00:14.497413

exit_message:

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

id: 6867442

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-16/1776349984",
        "key": "raw/mms_interchange_fees/2026-04-16/1776349984/78defa6e-f85a-496a-8ea1-bc556deb9b85.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3221377907315714881,
        "service_name": "drive-thru",
        "span_id": 18444232234408725240,
        "trace_id": 7731968388680517084
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-16 09:33:07
success: True
trace_id: 7731968388680517084

Scan 6867285

duration: 0:00:11.861715

exit_message:

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

id: 6867285

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-15/1776265520",
        "key": "raw/mms_interchange_fees/2026-04-15/1776265520/bcc376d8-ef04-4bc4-9fe1-76f0ac512232.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6988038824433871558,
        "service_name": "drive-thru",
        "span_id": 14396531610478998514,
        "trace_id": 4195768113392371129
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-15 10:05:24
success: True
trace_id: 4195768113392371129

Scan 6866989

duration: 0:00:11.962264

exit_message:

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

id: 6866989

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-14/1776178934",
        "key": "raw/mms_interchange_fees/2026-04-14/1776178934/f35609f8-fdc9-4016-b669-347217e10dfc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17006670445570121517,
        "service_name": "drive-thru",
        "span_id": 5939076028076366288,
        "trace_id": 7648574905832470239
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-14 10:02:28
success: True
trace_id: 7648574905832470239

Scan 6866594

duration: 0:00:14.548552

exit_message:

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

id: 6866594

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-13/1776090818",
        "key": "raw/mms_interchange_fees/2026-04-13/1776090818/16cb861d-259f-4c92-8100-b0f58865745c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16138862157420472125,
        "service_name": "drive-thru",
        "span_id": 3413857443047484117,
        "trace_id": 15308943699223699058
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-13 09:33:50
success: True
trace_id: 15308943699223699058

Scan 6866478

duration: 0:00:14.311969

exit_message:

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

id: 6866478

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-12/1776005005",
        "key": "raw/mms_interchange_fees/2026-04-12/1776005005/596c750c-cb0e-4011-b263-4925f5fa442b.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4259298778193977953,
        "service_name": "drive-thru",
        "span_id": 4552107147898406044,
        "trace_id": 2507460300186704561
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-12 09:43:42
success: True
trace_id: 2507460300186704561

Scan 6866294

duration: 0:00:11.658049

exit_message:

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

id: 6866294

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-11/1775918691",
        "key": "raw/mms_interchange_fees/2026-04-11/1775918691/60191a55-ab8c-48ad-8089-93b2353eac62.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7758594318603425056,
        "service_name": "drive-thru",
        "span_id": 14719766537927570891,
        "trace_id": 7080826215829633130
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-11 09:44:54
success: True
trace_id: 7080826215829633130

Scan 6866097

duration: 0:00:11.778166

exit_message:

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

id: 6866097

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-10/1775832394",
        "key": "raw/mms_interchange_fees/2026-04-10/1775832394/5b34e59e-0acd-4547-8ac7-0883e234d566.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8977161995503562170,
        "service_name": "drive-thru",
        "span_id": 17241741367135064534,
        "trace_id": 6333783141598013930
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-10 09:47:15
success: True
trace_id: 6333783141598013930

Scan 6865820

duration: 0:00:14.444969

exit_message:

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

id: 6865820

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-09/1775746179",
        "key": "raw/mms_interchange_fees/2026-04-09/1775746179/e02062fb-fa81-4ef2-867b-4de9e43821a4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17545215130737294598,
        "service_name": "drive-thru",
        "span_id": 9152204590764737797,
        "trace_id": 16124254506628269607
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-09 09:50:33
success: True
trace_id: 16124254506628269607

Scan 6865417

duration: 0:00:11.805895

exit_message:

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

id: 6865417

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-08/1775658400",
        "key": "raw/mms_interchange_fees/2026-04-08/1775658400/2d36eb1d-0708-4d08-8b34-23942cb21735.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2626723111257096844,
        "service_name": "drive-thru",
        "span_id": 8025589282595973919,
        "trace_id": 2881577803737207898
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-08 09:27:10
success: True
trace_id: 2881577803737207898

Scan 6865284

duration: 0:00:11.925964

exit_message:

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

id: 6865284

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-07/1775573335",
        "key": "raw/mms_interchange_fees/2026-04-07/1775573335/5116b3b1-9a8a-4d59-9bcf-222ae4f9ad41.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3703971107636466179,
        "service_name": "drive-thru",
        "span_id": 1786758943862545729,
        "trace_id": 201811455496946268
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-07 09:49:35
success: True
trace_id: 201811455496946268

Scan 6864832

duration: 0:00:14.430477

exit_message:

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

id: 6864832

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-06/1775485791",
        "key": "raw/mms_interchange_fees/2026-04-06/1775485791/491b1b44-288a-4fa7-97bd-cc3b9ff8e4b5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5940095539573890247,
        "service_name": "drive-thru",
        "span_id": 16481954645505678787,
        "trace_id": 13320328970014740501
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-06 09:30:36
success: True
trace_id: 13320328970014740501

Scan 6864746

duration: 0:00:11.781973

exit_message:

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

id: 6864746

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-05/1775400501",
        "key": "raw/mms_interchange_fees/2026-04-05/1775400501/f9fe1661-6826-4b52-95fe-1fedd2be2882.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9773588626093873046,
        "service_name": "drive-thru",
        "span_id": 1042321063022566645,
        "trace_id": 15317521391333638680
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-05 09:49:08
success: True
trace_id: 15317521391333638680

Scan 6864454

duration: 0:00:11.837959

exit_message:

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

id: 6864454

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-04/1775312785",
        "key": "raw/mms_interchange_fees/2026-04-04/1775312785/4bdb216b-bcc2-4496-abb2-29b212833f35.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14187657636700974640,
        "service_name": "drive-thru",
        "span_id": 16739214565629253831,
        "trace_id": 14457905874004170507
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-04 09:26:38
success: True
trace_id: 14457905874004170507

Scan 6864225

duration: 0:00:14.391175

exit_message:

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

id: 6864225

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-03/1775226596",
        "key": "raw/mms_interchange_fees/2026-04-03/1775226596/339999b8-9e30-4f64-82ab-ceaa81329348.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1496405400488906369,
        "service_name": "drive-thru",
        "span_id": 5269159646249538338,
        "trace_id": 17541617391556561879
    }
}

running: False
schema_name_id: 2373
start_time: 2026-04-03 09:30:09
success: True
trace_id: 17541617391556561879

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "entity": "string",
    "fee_count": "string",
    "fee_name": "string",
    "fee_sum": "string",
    "month": "string",
    "txn_sum": "string",
    "year": "string"
}

created: 2026-04-17 09:44:31

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-17/1776437039'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-22 13:07:35",
        "disabled": false,
        "format": "raw",
        "id": 2373,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_mms_interchange_fees"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "entity": "string",
            "fee_count": "string",
            "fee_name": "string",
            "fee_sum": "string",
            "month": "string",
            "txn_sum": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:44:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_interchange_fees`\n(\n `year`  string , `month`  string , `entity`  string , `fee_name`  string , `fee_count`  string , `fee_sum`  string , `txn_sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-dev/raw/mms_interchange_fees/2026-04-17/1776437039'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_interchange_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_interchange_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}