Schema Info

Schema Name: sfdl_stage_csv.payrixess_mms_interchange_fees

created: 2024-07-22 13:15:56
disabled: False
format: raw
id: 2173
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906693

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-17/1776436433
id: 906693
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: 2173
schema_scan_id: 6415441
updated: 2026-04-17 09:34:18

Version 906500

created: 2026-04-16 09:48:16

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-16/1776350888
id: 906500
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: 2173
schema_scan_id: 6414945
updated: 2026-04-16 09:48:30

Version 906283

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-15/1776264412
id: 906283
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: 2173
schema_scan_id: 6414430
updated: 2026-04-15 09:47:21

Version 906055

created: 2026-04-14 09:33:01

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-14/1776177177
id: 906055
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: 2173
schema_scan_id: 6413907
updated: 2026-04-14 09:33:15

Version 905835

created: 2026-04-13 09:31:15

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-13/1776090653
id: 905835
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: 2173
schema_scan_id: 6413269
updated: 2026-04-13 09:31:27

Version 905628

created: 2026-04-12 09:29:32

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-12/1776004155
id: 905628
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: 2173
schema_scan_id: 6412856
updated: 2026-04-12 09:29:46

Version 905447

created: 2026-04-11 09:45:03

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-11/1775918691
id: 905447
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: 2173
schema_scan_id: 6412566
updated: 2026-04-11 09:45:14

Version 905229

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-10/1775832149
id: 905229
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: 2173
schema_scan_id: 6412110
updated: 2026-04-10 09:44:52

Version 905016

created: 2026-04-09 09:44:35

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-09/1775745848
id: 905016
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: 2173
schema_scan_id: 6411545
updated: 2026-04-09 09:44:49

Version 904797

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-08/1775659215
id: 904797
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: 2173
schema_scan_id: 6411089
updated: 2026-04-08 09:40:32

Version 904586

created: 2026-04-07 09:40:21

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-07/1775572808
id: 904586
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: 2173
schema_scan_id: 6410550
updated: 2026-04-07 09:40:35

Version 904358

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-06/1775485830
id: 904358
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: 2173
schema_scan_id: 6409997
updated: 2026-04-06 09:30:53

Version 904145

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

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-05/1775399194
id: 904145
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: 2173
schema_scan_id: 6409485
updated: 2026-04-05 09:27:08

Version 903966

created: 2026-04-04 09:50:15

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-04/1775314206
id: 903966
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: 2173
schema_scan_id: 6409230
updated: 2026-04-04 09:50:28

Version 903756

created: 2026-04-03 09:56:13

ddl:

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

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-03/1775228168
id: 903756
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: 2173
schema_scan_id: 6408757
updated: 2026-04-03 09:56:24

Schema Scans: 15

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

Scan 6415441

duration: 0:00:12.034702

exit_message:

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

id: 6415441

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-17/1776436433",
        "key": "raw/mms_interchange_fees/2026-04-17/1776436433/8142df80-0960-48b7-b7bd-f99b0ee41d39.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14600815256133139169,
        "service_name": "drive-thru",
        "span_id": 13467291584864787019,
        "trace_id": 5294162342001384389
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-17 09:34:06
success: True
trace_id: 5294162342001384389

Scan 6414945

duration: 0:00:14.519666

exit_message:

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

id: 6414945

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-16/1776350888",
        "key": "raw/mms_interchange_fees/2026-04-16/1776350888/6cc0154f-28bf-4bca-a7d6-2cbd75786cfc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 468046949787364874,
        "service_name": "drive-thru",
        "span_id": 4964320340435879516,
        "trace_id": 8095385911398977356
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-16 09:48:15
success: True
trace_id: 8095385911398977356

Scan 6414430

duration: 0:00:11.853225

exit_message:

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

id: 6414430

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-15/1776264412",
        "key": "raw/mms_interchange_fees/2026-04-15/1776264412/8c2aa9ad-c02f-46a2-9f45-438490650c07.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4722396442951413385,
        "service_name": "drive-thru",
        "span_id": 16866821973949083487,
        "trace_id": 3001250464098126197
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-15 09:47:10
success: True
trace_id: 3001250464098126197

Scan 6413907

duration: 0:00:14.406491

exit_message:

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

id: 6413907

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-14/1776177177",
        "key": "raw/mms_interchange_fees/2026-04-14/1776177177/c713c6ac-2658-48a0-ae74-e62b1ad5839a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16288733964902522824,
        "service_name": "drive-thru",
        "span_id": 3329686793432267395,
        "trace_id": 9795748422607857359
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-14 09:33:01
success: True
trace_id: 9795748422607857359

Scan 6413269

duration: 0:00:11.940891

exit_message:

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

id: 6413269

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-13/1776090653",
        "key": "raw/mms_interchange_fees/2026-04-13/1776090653/285d7939-5482-4d58-b81f-4cc13c3814a8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11201363612005427868,
        "service_name": "drive-thru",
        "span_id": 10218764527036800011,
        "trace_id": 11657691426165507107
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-13 09:31:15
success: True
trace_id: 11657691426165507107

Scan 6412856

duration: 0:00:14.563439

exit_message:

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

id: 6412856

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-12/1776004155",
        "key": "raw/mms_interchange_fees/2026-04-12/1776004155/6dcb960b-4052-44f1-96a2-baeea8cfc95a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 811674642723098218,
        "service_name": "drive-thru",
        "span_id": 5771812226188416169,
        "trace_id": 13565462980955642582
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-12 09:29:32
success: True
trace_id: 13565462980955642582

Scan 6412566

duration: 0:00:11.974948

exit_message:

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

id: 6412566

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-11/1775918691",
        "key": "raw/mms_interchange_fees/2026-04-11/1775918691/504e9bbb-1e89-45c5-837b-a676fe97bee7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5279453074187583223,
        "service_name": "drive-thru",
        "span_id": 9115488678321333475,
        "trace_id": 528765619647080136
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-11 09:45:03
success: True
trace_id: 528765619647080136

Scan 6412110

duration: 0:02:19.440305

exit_message:

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

id: 6412110

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-10/1775832149",
        "key": "raw/mms_interchange_fees/2026-04-10/1775832149/a2a66d6e-a86e-4b86-b2f4-078dd9edbebc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9328184011129184001,
        "service_name": "drive-thru",
        "span_id": 7191652656274028116,
        "trace_id": 13100926238447394680
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-10 09:42:32
success: True
trace_id: 13100926238447394680

Scan 6411545

duration: 0:00:14.473082

exit_message:

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

id: 6411545

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-09/1775745848",
        "key": "raw/mms_interchange_fees/2026-04-09/1775745848/a2e35c61-2a81-49cb-8080-d9050e95b04d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5246668132501656891,
        "service_name": "drive-thru",
        "span_id": 13686464452297269299,
        "trace_id": 1386819024871345517
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-09 09:44:35
success: True
trace_id: 1386819024871345517

Scan 6411089

duration: 0:00:14.345017

exit_message:

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

id: 6411089

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-08/1775659215",
        "key": "raw/mms_interchange_fees/2026-04-08/1775659215/641be34c-045c-446a-837c-ebbc591d69ca.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3272556169291588390,
        "service_name": "drive-thru",
        "span_id": 17691793004556208620,
        "trace_id": 9905567906081279695
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-08 09:40:18
success: True
trace_id: 9905567906081279695

Scan 6410550

duration: 0:00:14.411493

exit_message:

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

id: 6410550

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-07/1775572808",
        "key": "raw/mms_interchange_fees/2026-04-07/1775572808/b6a36d2d-b184-4480-8c40-a9c92ecbbea0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14062846946960302274,
        "service_name": "drive-thru",
        "span_id": 239077252400440441,
        "trace_id": 6100630852392466151
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-07 09:40:21
success: True
trace_id: 6100630852392466151

Scan 6409997

duration: 0:00:11.964425

exit_message:

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

id: 6409997

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-06/1775485830",
        "key": "raw/mms_interchange_fees/2026-04-06/1775485830/adf0a45e-76c9-4da3-897b-94ccdb3ab5e9.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14595427681848133839,
        "service_name": "drive-thru",
        "span_id": 13322285506768174268,
        "trace_id": 13312984886053519126
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-06 09:30:41
success: True
trace_id: 13312984886053519126

Scan 6409485

duration: 0:00:14.368149

exit_message:

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

id: 6409485

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-05/1775399194",
        "key": "raw/mms_interchange_fees/2026-04-05/1775399194/c8029f98-179b-4b8f-8d1f-263da899c22e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13251063284659695767,
        "service_name": "drive-thru",
        "span_id": 2767562464263266555,
        "trace_id": 1518071848361571274
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-05 09:26:54
success: True
trace_id: 1518071848361571274

Scan 6409230

duration: 0:00:14.251832

exit_message:

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

id: 6409230

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-04/1775314206",
        "key": "raw/mms_interchange_fees/2026-04-04/1775314206/f7cc5ab7-7cc0-4eec-b8aa-0e5ac5cda08a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14739718025534254713,
        "service_name": "drive-thru",
        "span_id": 8478828437829399522,
        "trace_id": 11357985546144179905
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-04 09:50:14
success: True
trace_id: 11357985546144179905

Scan 6408757

duration: 0:00:11.840441

exit_message:

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

id: 6408757

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_interchange_fees/2026-04-03/1775228168",
        "key": "raw/mms_interchange_fees/2026-04-03/1775228168/4f50062b-6505-4aa0-b34f-d773312f8051.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6332906943418955222,
        "service_name": "drive-thru",
        "span_id": 4811369360785558882,
        "trace_id": 17141119644400103109
    }
}

running: False
schema_name_id: 2173
start_time: 2026-04-03 09:56:12
success: True
trace_id: 17141119644400103109

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:06

ddl:

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