Schema Info

Schema Name: sfdl_prod_csv.payrixess_mms_interchange_fees

created: 2024-07-24 10:18:19
disabled: False
format: raw
id: 1948
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718262

created: 2026-04-17 09:34:46

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-17/1776436482
id: 1718262
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: 1948
schema_scan_id: 162178488
updated: 2026-04-17 09:35:00

Version 1717057

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-16/1776350803
id: 1717057
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: 1948
schema_scan_id: 162122988
updated: 2026-04-16 09:46:58

Version 1715838

created: 2026-04-15 09:46:53

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-15/1776264410
id: 1715838
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: 1948
schema_scan_id: 162067463
updated: 2026-04-15 09:47:07

Version 1714635

created: 2026-04-14 09:47:24

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-14/1776178032
id: 1714635
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: 1948
schema_scan_id: 162011684
updated: 2026-04-14 09:47:38

Version 1713437

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-13/1776091811
id: 1713437
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: 1948
schema_scan_id: 161954268
updated: 2026-04-13 09:51:31

Version 1712228

created: 2026-04-12 09:36:11

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-12/1776004565
id: 1712228
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: 1948
schema_scan_id: 161903565
updated: 2026-04-12 09:36:22

Version 1711004

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-11/1775917584
id: 1711004
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: 1948
schema_scan_id: 161851925
updated: 2026-04-11 09:26:41

Version 1709840

created: 2026-04-10 09:28:59

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-10/1775831335
id: 1709840
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: 1948
schema_scan_id: 161797298
updated: 2026-04-10 09:29:10

Version 1708683

created: 2026-04-09 09:29:20

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-09/1775744957
id: 1708683
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: 1948
schema_scan_id: 161741349
updated: 2026-04-09 09:29:31

Version 1707508

created: 2026-04-08 09:32:17

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-08/1775658723
id: 1707508
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: 1948
schema_scan_id: 161686235
updated: 2026-04-08 09:32:28

Version 1706332

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-07/1775573084
id: 1706332
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: 1948
schema_scan_id: 161630590
updated: 2026-04-07 09:45:17

Version 1705107

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-06/1775486567
id: 1705107
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: 1948
schema_scan_id: 161572934
updated: 2026-04-06 09:43:11

Version 1703865

created: 2026-04-05 09:30:53

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-05/1775399436
id: 1703865
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: 1948
schema_scan_id: 161523795
updated: 2026-04-05 09:31:04

Version 1702708

created: 2026-04-04 09:28:15

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-04/1775312892
id: 1702708
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: 1948
schema_scan_id: 161471655
updated: 2026-04-04 09:28:29

Version 1701516

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-03/1775226618
id: 1701516
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: 1948
schema_scan_id: 161414323
updated: 2026-04-03 09:30:38

Schema Scans: 15

Last at 2026-04-17 09:34:45

Scan 162178488

duration: 0:00:14.498536

exit_message:

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

id: 162178488

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-17/1776436482",
        "key": "raw/mms_interchange_fees/2026-04-17/1776436482/88e30e84-c6cf-414b-b8ff-2a4b5deb7f50.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17561975463304071979,
        "service_name": "drive-thru",
        "span_id": 12346003772778322246,
        "trace_id": 8118968610837413310
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-17 09:34:45
success: True
trace_id: 8118968610837413310

Scan 162122988

duration: 0:00:11.720536

exit_message:

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

id: 162122988

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-16/1776350803",
        "key": "raw/mms_interchange_fees/2026-04-16/1776350803/ba10efa4-21ea-4524-bdd7-e878664a0e65.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8719863978544266299,
        "service_name": "drive-thru",
        "span_id": 11457472504958526761,
        "trace_id": 13332296490509400931
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-16 09:46:46
success: True
trace_id: 13332296490509400931

Scan 162067463

duration: 0:00:14.316338

exit_message:

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

id: 162067463

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-15/1776264410",
        "key": "raw/mms_interchange_fees/2026-04-15/1776264410/bd61d257-1f51-4fbc-944b-b510d0a19505.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 654375238335179524,
        "service_name": "drive-thru",
        "span_id": 8640850569533152923,
        "trace_id": 11559800122058840245
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-15 09:46:53
success: True
trace_id: 11559800122058840245

Scan 162011684

duration: 0:00:14.368868

exit_message:

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

id: 162011684

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-14/1776178032",
        "key": "raw/mms_interchange_fees/2026-04-14/1776178032/7af8d2ec-a98c-4e6e-ad5c-a2f0dbafa697.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3497539696721455526,
        "service_name": "drive-thru",
        "span_id": 11091235611385493216,
        "trace_id": 4132429093535153160
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-14 09:47:24
success: True
trace_id: 4132429093535153160

Scan 161954268

duration: 0:00:11.921261

exit_message:

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

id: 161954268

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-13/1776091811",
        "key": "raw/mms_interchange_fees/2026-04-13/1776091811/d6eac260-a4ee-4036-be6b-646b90028ae2.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10929435009488187600,
        "service_name": "drive-thru",
        "span_id": 12413369001801028599,
        "trace_id": 392534295499848702
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-13 09:51:20
success: True
trace_id: 392534295499848702

Scan 161903565

duration: 0:00:11.740700

exit_message:

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

id: 161903565

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-12/1776004565",
        "key": "raw/mms_interchange_fees/2026-04-12/1776004565/4f3cff30-155a-44e8-af31-8a44dc721dfe.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7313296785082885086,
        "service_name": "drive-thru",
        "span_id": 9929902756907912455,
        "trace_id": 16337386563777815368
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-12 09:36:11
success: True
trace_id: 16337386563777815368

Scan 161851925

duration: 0:00:14.278851

exit_message:

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

id: 161851925

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-11/1775917584",
        "key": "raw/mms_interchange_fees/2026-04-11/1775917584/53bd442d-7376-4555-9fca-1b3ecc1b155a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5452295348246491523,
        "service_name": "drive-thru",
        "span_id": 1320623395849601384,
        "trace_id": 11306047318645765780
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-11 09:26:27
success: True
trace_id: 11306047318645765780

Scan 161797298

duration: 0:00:11.727210

exit_message:

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

id: 161797298

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-10/1775831335",
        "key": "raw/mms_interchange_fees/2026-04-10/1775831335/4c81654d-40a9-4c00-be20-318b7e9cf211.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1918013228709612117,
        "service_name": "drive-thru",
        "span_id": 3676661716722129824,
        "trace_id": 7349934729857156619
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-10 09:28:59
success: True
trace_id: 7349934729857156619

Scan 161741349

duration: 0:00:11.799256

exit_message:

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

id: 161741349

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-09/1775744957",
        "key": "raw/mms_interchange_fees/2026-04-09/1775744957/69b663fc-5cbb-41e5-b81d-8944d84f8e1b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18310286167876439805,
        "service_name": "drive-thru",
        "span_id": 16536058524494836093,
        "trace_id": 16278555083457284796
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-09 09:29:20
success: True
trace_id: 16278555083457284796

Scan 161686235

duration: 0:00:11.718216

exit_message:

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

id: 161686235

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-08/1775658723",
        "key": "raw/mms_interchange_fees/2026-04-08/1775658723/d920313c-2350-4c63-a222-66c88d07a33b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7628336489748203928,
        "service_name": "drive-thru",
        "span_id": 14043999511216870660,
        "trace_id": 15471397587332186117
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-08 09:32:16
success: True
trace_id: 15471397587332186117

Scan 161630590

duration: 0:00:11.809461

exit_message:

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

id: 161630590

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-07/1775573084",
        "key": "raw/mms_interchange_fees/2026-04-07/1775573084/85aeb355-cb27-4c85-ade4-162aa3b81b1c.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3149905934432946466,
        "service_name": "drive-thru",
        "span_id": 12699687359188210042,
        "trace_id": 4651372926635716322
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-07 09:45:05
success: True
trace_id: 4651372926635716322

Scan 161572934

duration: 0:00:14.338833

exit_message:

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

id: 161572934

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-06/1775486567",
        "key": "raw/mms_interchange_fees/2026-04-06/1775486567/2b42b096-7cd9-4f89-9fcb-a3e3c0f33316.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9851376164275382515,
        "service_name": "drive-thru",
        "span_id": 2365339422603703317,
        "trace_id": 6931800807760794640
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-06 09:42:57
success: True
trace_id: 6931800807760794640

Scan 161523795

duration: 0:00:11.770938

exit_message:

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

id: 161523795

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-05/1775399436",
        "key": "raw/mms_interchange_fees/2026-04-05/1775399436/c4347a78-d732-4c4f-a2a5-5bd5b2f7958d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16944308294920584553,
        "service_name": "drive-thru",
        "span_id": 4615424371748270751,
        "trace_id": 7487205793176168643
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-05 09:30:52
success: True
trace_id: 7487205793176168643

Scan 161471655

duration: 0:00:14.212290

exit_message:

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

id: 161471655

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-04/1775312892",
        "key": "raw/mms_interchange_fees/2026-04-04/1775312892/b7c0fdbf-f37c-4cda-91ce-19eee4f5e440.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7288600440907484900,
        "service_name": "drive-thru",
        "span_id": 2208669300994362074,
        "trace_id": 8078364841346852591
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-04 09:28:15
success: True
trace_id: 8078364841346852591

Scan 161414323

duration: 0:00:14.363900

exit_message:

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

id: 161414323

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_interchange_fees/2026-04-03/1775226618",
        "key": "raw/mms_interchange_fees/2026-04-03/1775226618/35a41aac-65f0-4aa1-b52b-e06407cbb5fc.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9157985132870519461,
        "service_name": "drive-thru",
        "span_id": 13811098779468248972,
        "trace_id": 5644688065828640837
    }
}

running: False
schema_name_id: 1948
start_time: 2026-04-03 09:30:24
success: True
trace_id: 5644688065828640837

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:34:46

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_interchange_fees/2026-04-17/1776436482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_interchange_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_interchange_fees"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-24 10:18:19",
        "disabled": false,
        "format": "raw",
        "id": 1948,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:34:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_interchange_fees/2026-04-17/1776436482'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_interchange_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_interchange_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}