Schema Info

Schema Name: sfdl_prod_csv.payrix_mms_interchange_fees

created: 2024-07-10 09:33:19
disabled: False
format: raw
id: 1917
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718253

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-17/1776436368
id: 1718253
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: 1917
schema_scan_id: 162178465
updated: 2026-04-17 09:33:11

Version 1717027

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-16/1776349973
id: 1717027
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: 1917
schema_scan_id: 162122791
updated: 2026-04-16 09:33:32

Version 1715882

created: 2026-04-15 11:27:03

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-15/1776270400
id: 1715882
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: 1917
schema_scan_id: 162072772
updated: 2026-04-15 11:27:14

Version 1714954

created: 2026-04-14 21:13:39

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-14/1776219210
id: 1714954
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: 1917
schema_scan_id: 162046416
updated: 2026-04-14 21:13:53

Version 1713420

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-13/1776090883
id: 1713420
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: 1917
schema_scan_id: 161953756
updated: 2026-04-13 09:35:10

Version 1712255

created: 2026-04-12 09:47:12

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-12/1776005222
id: 1712255
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: 1917
schema_scan_id: 161903721
updated: 2026-04-12 09:47:24

Version 1711033

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-11/1775918696
id: 1711033
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: 1917
schema_scan_id: 161852127
updated: 2026-04-11 09:45:19

Version 1709856

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-10/1775832084
id: 1709856
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: 1917
schema_scan_id: 161797505
updated: 2026-04-10 09:41:53

Version 1708685

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-09/1775744960
id: 1708685
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: 1917
schema_scan_id: 161741354
updated: 2026-04-09 09:29:43

Version 1707537

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-08/1775659659
id: 1707537
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: 1917
schema_scan_id: 161686958
updated: 2026-04-08 09:51:34

Version 1706341

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-07/1775573244
id: 1706341
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: 1917
schema_scan_id: 161630774
updated: 2026-04-07 09:47:51

Version 1705088

created: 2026-04-06 09:32:48

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-06/1775485947
id: 1705088
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: 1917
schema_scan_id: 161572766
updated: 2026-04-06 09:32:59

Version 1703879

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-05/1775400116
id: 1703879
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: 1917
schema_scan_id: 161523904
updated: 2026-04-05 09:42:31

Version 1702754

created: 2026-04-04 10:07:02

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-04/1775315209
id: 1702754
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: 1917
schema_scan_id: 161474462
updated: 2026-04-04 10:07:13

Version 1701540

created: 2026-04-03 09:49:35

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-03/1775227756
id: 1701540
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: 1917
schema_scan_id: 161415117
updated: 2026-04-03 09:49:49

Schema Scans: 15

Last at 2026-04-17 09:32:59

Scan 162178465

duration: 0:00:11.743264

exit_message:

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

id: 162178465

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-17/1776436368",
        "key": "raw/mms_interchange_fees/2026-04-17/1776436368/4797c909-fbdb-446e-a54a-b9de83231deb.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 870326043442723491,
        "service_name": "drive-thru",
        "span_id": 3595421723575273999,
        "trace_id": 17237389736699533613
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-17 09:32:59
success: True
trace_id: 17237389736699533613

Scan 162122791

duration: 0:00:14.453205

exit_message:

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

id: 162122791

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-16/1776349973",
        "key": "raw/mms_interchange_fees/2026-04-16/1776349973/82023b76-a986-4781-93d2-47b6a51e2a81.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12210527443702297155,
        "service_name": "drive-thru",
        "span_id": 5768311727162252776,
        "trace_id": 9282000012075206106
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-16 09:33:18
success: True
trace_id: 9282000012075206106

Scan 162072772

duration: 0:00:11.773565

exit_message:

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

id: 162072772

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-15/1776270400",
        "key": "raw/mms_interchange_fees/2026-04-15/1776270400/52f05b04-766d-4490-9d98-4f1950a55d38.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17099351995456787254,
        "service_name": "drive-thru",
        "span_id": 17795295241881234712,
        "trace_id": 14931905574049611975
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-15 11:27:02
success: True
trace_id: 14931905574049611975

Scan 162046416

duration: 0:00:14.329118

exit_message:

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

id: 162046416

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-14/1776219210",
        "key": "raw/mms_interchange_fees/2026-04-14/1776219210/ebefe617-98b5-414e-9117-b08ba4f51b13.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16729486996627651816,
        "service_name": "drive-thru",
        "span_id": 13138143444192188576,
        "trace_id": 10531591980408863535
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-14 21:13:38
success: True
trace_id: 10531591980408863535

Scan 161953756

duration: 0:00:14.366569

exit_message:

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

id: 161953756

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-13/1776090883",
        "key": "raw/mms_interchange_fees/2026-04-13/1776090883/edca2fd4-445d-4e02-854a-b4c7396aba5f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3794303222277838435,
        "service_name": "drive-thru",
        "span_id": 17926326815472924521,
        "trace_id": 10216873573622732160
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-13 09:34:56
success: True
trace_id: 10216873573622732160

Scan 161903721

duration: 0:00:11.611944

exit_message:

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

id: 161903721

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-12/1776005222",
        "key": "raw/mms_interchange_fees/2026-04-12/1776005222/17f9b119-8ea4-4fa3-9cd5-5236cd23d3bd.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12739892034441470366,
        "service_name": "drive-thru",
        "span_id": 6435502715357742777,
        "trace_id": 1514767364145098474
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-12 09:47:12
success: True
trace_id: 1514767364145098474

Scan 161852127

duration: 0:00:14.154051

exit_message:

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

id: 161852127

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-11/1775918696",
        "key": "raw/mms_interchange_fees/2026-04-11/1775918696/884376e9-38c6-4ba5-baf2-36a971d2e63a.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17197049024056599937,
        "service_name": "drive-thru",
        "span_id": 8466268092542806307,
        "trace_id": 18059994115647124658
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-11 09:45:05
success: True
trace_id: 18059994115647124658

Scan 161797505

duration: 0:00:14.257904

exit_message:

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

id: 161797505

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-10/1775832084",
        "key": "raw/mms_interchange_fees/2026-04-10/1775832084/fc612846-1396-451b-9bb8-4f72f352628b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10432590637427098705,
        "service_name": "drive-thru",
        "span_id": 3624233578621685759,
        "trace_id": 231550482521172802
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-10 09:41:39
success: True
trace_id: 231550482521172802

Scan 161741354

duration: 0:00:11.852907

exit_message:

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

id: 161741354

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-09/1775744960",
        "key": "raw/mms_interchange_fees/2026-04-09/1775744960/3ef63475-e544-477b-ae29-0f7a7d613596.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3160114351252076329,
        "service_name": "drive-thru",
        "span_id": 154439852780024166,
        "trace_id": 8332656857499133504
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-09 09:29:32
success: True
trace_id: 8332656857499133504

Scan 161686958

duration: 0:00:14.412485

exit_message:

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

id: 161686958

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-08/1775659659",
        "key": "raw/mms_interchange_fees/2026-04-08/1775659659/6fba3ead-e674-4f15-b725-153e4bd5c030.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12778170768907701679,
        "service_name": "drive-thru",
        "span_id": 6927754209094690156,
        "trace_id": 15834167689095822523
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-08 09:51:19
success: True
trace_id: 15834167689095822523

Scan 161630774

duration: 0:00:11.867286

exit_message:

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

id: 161630774

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-07/1775573244",
        "key": "raw/mms_interchange_fees/2026-04-07/1775573244/4800fcd3-e843-4574-a2d3-5dfabcc03f01.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10855597667025168064,
        "service_name": "drive-thru",
        "span_id": 14531808266420574425,
        "trace_id": 18129967250795740020
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-07 09:47:39
success: True
trace_id: 18129967250795740020

Scan 161572766

duration: 0:00:11.857743

exit_message:

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

id: 161572766

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-06/1775485947",
        "key": "raw/mms_interchange_fees/2026-04-06/1775485947/a210e1a4-bbc3-4058-b81a-437a111b6ba4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14845824401280988291,
        "service_name": "drive-thru",
        "span_id": 8064228245525904746,
        "trace_id": 15060921323733241508
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-06 09:32:47
success: True
trace_id: 15060921323733241508

Scan 161523904

duration: 0:00:11.815745

exit_message:

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

id: 161523904

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-05/1775400116",
        "key": "raw/mms_interchange_fees/2026-04-05/1775400116/7f9f191b-809e-4377-858e-2e201a539c8f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1262429439449160539,
        "service_name": "drive-thru",
        "span_id": 13403959356197256627,
        "trace_id": 3070820040805069833
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-05 09:42:19
success: True
trace_id: 3070820040805069833

Scan 161474462

duration: 0:00:11.856762

exit_message:

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

id: 161474462

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-04/1775315209",
        "key": "raw/mms_interchange_fees/2026-04-04/1775315209/5e0eeca6-68a0-44e4-9c29-f4b7856f61ba.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14056345523118320493,
        "service_name": "drive-thru",
        "span_id": 9605640603124956483,
        "trace_id": 9318708668777386391
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-04 10:07:01
success: True
trace_id: 9318708668777386391

Scan 161415117

duration: 0:00:14.405516

exit_message:

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

id: 161415117

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_interchange_fees/2026-04-03/1775227756",
        "key": "raw/mms_interchange_fees/2026-04-03/1775227756/8ab6c002-4111-4e4d-8487-95721590a791.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 823262896055376887,
        "service_name": "drive-thru",
        "span_id": 6117401126449681269,
        "trace_id": 1203280968453651330
    }
}

running: False
schema_name_id: 1917
start_time: 2026-04-03 09:49:35
success: True
trace_id: 1203280968453651330

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:32:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_interchange_fees/2026-04-17/1776436368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_interchange_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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-10 09:33:19",
        "disabled": false,
        "format": "raw",
        "id": 1917,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrix_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:32:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_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-payrix-prod/raw/mms_interchange_fees/2026-04-17/1776436368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_interchange_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_interchange_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}