Schema Info

Schema Name: sfdl_dev_csv.payrix_mms_interchange_fees

created: 2024-07-03 13:59:58
disabled: False
format: raw
id: 2305
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773339

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-17/1776436244
id: 4773339
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: 2305
schema_scan_id: 6867674
updated: 2026-04-17 09:31:15

Version 4773299

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-16/1776350774
id: 4773299
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: 2305
schema_scan_id: 6867537
updated: 2026-04-16 09:46:51

Version 4773225

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-15/1776263966
id: 4773225
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: 2305
schema_scan_id: 6867178
updated: 2026-04-15 09:40:42

Version 4773165

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-14/1776177876
id: 4773165
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: 2305
schema_scan_id: 6866907
updated: 2026-04-14 09:44:58

Version 4773121

created: 2026-04-13 09:49:38

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-13/1776091746
id: 4773121
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: 2305
schema_scan_id: 6866709
updated: 2026-04-13 09:49:52

Version 4773061

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-12/1776005208
id: 4773061
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: 2305
schema_scan_id: 6866494
updated: 2026-04-12 09:47:16

Version 4773006

created: 2026-04-11 09:32:37

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-11/1775917937
id: 4773006
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: 2305
schema_scan_id: 6866267
updated: 2026-04-11 09:32:51

Version 4772956

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-10/1775832159
id: 4772956
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: 2305
schema_scan_id: 6866085
updated: 2026-04-10 09:45:29

Version 4772882

created: 2026-04-09 09:37:35

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-09/1775745437
id: 4772882
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: 2305
schema_scan_id: 6865751
updated: 2026-04-09 09:37:49

Version 4772825

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-08/1775658598
id: 4772825
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: 2305
schema_scan_id: 6865477
updated: 2026-04-08 09:30:39

Version 4772772

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-07/1775573133
id: 4772772
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: 2305
schema_scan_id: 6865272
updated: 2026-04-07 09:46:03

Version 4772720

created: 2026-04-06 09:51:00

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-06/1775487048
id: 4772720
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: 2305
schema_scan_id: 6864967
updated: 2026-04-06 09:51:21

Version 4772668

created: 2026-04-05 09:50:57

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-05/1775400646
id: 4772668
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: 2305
schema_scan_id: 6864761
updated: 2026-04-05 09:51:11

Version 4772619

created: 2026-04-04 09:57:24

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-04/1775314603
id: 4772619
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: 2305
schema_scan_id: 6864583
updated: 2026-04-04 09:57:35

Version 4772554

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-03/1775228273
id: 4772554
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: 2305
schema_scan_id: 6864342
updated: 2026-04-03 09:58:26

Schema Scans: 15

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

Scan 6867674

duration: 0:00:11.834406

exit_message:

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

id: 6867674

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-17/1776436244",
        "key": "raw/mms_interchange_fees/2026-04-17/1776436244/52f35fd7-db4c-4829-ae31-15193de00c8a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10446617089585279482,
        "service_name": "drive-thru",
        "span_id": 6434202745639358992,
        "trace_id": 10782765737146809276
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-17 09:31:04
success: True
trace_id: 10782765737146809276

Scan 6867537

duration: 0:00:11.905820

exit_message:

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

id: 6867537

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-16/1776350774",
        "key": "raw/mms_interchange_fees/2026-04-16/1776350774/6ccef2b4-3de9-4032-ba39-e7b622c4e3cb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14690652470548660247,
        "service_name": "drive-thru",
        "span_id": 9955041479691937483,
        "trace_id": 11186835685105537837
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-16 09:46:39
success: True
trace_id: 11186835685105537837

Scan 6867178

duration: 0:00:11.926403

exit_message:

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

id: 6867178

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-15/1776263966",
        "key": "raw/mms_interchange_fees/2026-04-15/1776263966/80c1b853-9246-4f06-8298-34d271ce80a4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7195865408400755331,
        "service_name": "drive-thru",
        "span_id": 12323629617801389341,
        "trace_id": 1941237317893258886
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-15 09:40:30
success: True
trace_id: 1941237317893258886

Scan 6866907

duration: 0:00:11.861825

exit_message:

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

id: 6866907

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-14/1776177876",
        "key": "raw/mms_interchange_fees/2026-04-14/1776177876/57d3abfc-5e7c-47dd-8ee5-00adb6423c66.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15553672296632742787,
        "service_name": "drive-thru",
        "span_id": 736528579373488068,
        "trace_id": 17823386678494408559
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-14 09:44:47
success: True
trace_id: 17823386678494408559

Scan 6866709

duration: 0:00:14.398237

exit_message:

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

id: 6866709

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-13/1776091746",
        "key": "raw/mms_interchange_fees/2026-04-13/1776091746/75aecb27-0558-402a-ae19-abf6d7b90a79.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1344227712634246312,
        "service_name": "drive-thru",
        "span_id": 11841294994188088484,
        "trace_id": 13749997173295708864
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-13 09:49:37
success: True
trace_id: 13749997173295708864

Scan 6866494

duration: 0:00:11.955355

exit_message:

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

id: 6866494

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-12/1776005208",
        "key": "raw/mms_interchange_fees/2026-04-12/1776005208/fa554e92-7984-476a-80fc-c913704ddfa7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12313769114185558290,
        "service_name": "drive-thru",
        "span_id": 1333167768974371874,
        "trace_id": 11175756219972741208
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-12 09:47:04
success: True
trace_id: 11175756219972741208

Scan 6866267

duration: 0:00:14.556227

exit_message:

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

id: 6866267

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-11/1775917937",
        "key": "raw/mms_interchange_fees/2026-04-11/1775917937/e787d676-438e-4b90-a709-d3d738476cf4.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15699572827934777709,
        "service_name": "drive-thru",
        "span_id": 9582847792504110749,
        "trace_id": 1876143537768116359
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-11 09:32:37
success: True
trace_id: 1876143537768116359

Scan 6866085

duration: 0:00:14.471529

exit_message:

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

id: 6866085

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-10/1775832159",
        "key": "raw/mms_interchange_fees/2026-04-10/1775832159/0f7638d6-9045-4458-9934-ebfefe7ccd7a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3043979343071877099,
        "service_name": "drive-thru",
        "span_id": 15475511637433424694,
        "trace_id": 9935964509501711298
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-10 09:45:15
success: True
trace_id: 9935964509501711298

Scan 6865751

duration: 0:00:14.468065

exit_message:

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

id: 6865751

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-09/1775745437",
        "key": "raw/mms_interchange_fees/2026-04-09/1775745437/f589b031-f753-4458-a867-7b64354f39fc.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14236608089539946872,
        "service_name": "drive-thru",
        "span_id": 8489153262786891362,
        "trace_id": 3807106625497729361
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-09 09:37:34
success: True
trace_id: 3807106625497729361

Scan 6865477

duration: 0:00:14.314141

exit_message:

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

id: 6865477

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-08/1775658598",
        "key": "raw/mms_interchange_fees/2026-04-08/1775658598/8c3d65e7-0196-40a3-b050-11ad41c6774e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9101370070369875925,
        "service_name": "drive-thru",
        "span_id": 5113416198610474917,
        "trace_id": 3436473879613244441
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-08 09:30:25
success: True
trace_id: 3436473879613244441

Scan 6865272

duration: 0:00:14.568596

exit_message:

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

id: 6865272

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-07/1775573133",
        "key": "raw/mms_interchange_fees/2026-04-07/1775573133/c405bff2-10f7-4ee8-a553-b0732518e099.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13533854995373701824,
        "service_name": "drive-thru",
        "span_id": 5828922807807298935,
        "trace_id": 14578108353467568347
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-07 09:45:49
success: True
trace_id: 14578108353467568347

Scan 6864967

duration: 0:00:22.070208

exit_message:

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

id: 6864967

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-06/1775487048",
        "key": "raw/mms_interchange_fees/2026-04-06/1775487048/cbefcea3-5869-4256-a7a5-8b252f64bf84.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7656477323876474016,
        "service_name": "drive-thru",
        "span_id": 3734974952323996720,
        "trace_id": 3156451326281175088
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-06 09:50:59
success: True
trace_id: 3156451326281175088

Scan 6864761

duration: 0:00:14.408180

exit_message:

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

id: 6864761

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-05/1775400646",
        "key": "raw/mms_interchange_fees/2026-04-05/1775400646/b5c6e75b-ce96-46a1-b079-af10fece82eb.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15214741380784139416,
        "service_name": "drive-thru",
        "span_id": 263194001084583492,
        "trace_id": 2180283210857589052
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-05 09:50:56
success: True
trace_id: 2180283210857589052

Scan 6864583

duration: 0:00:11.907883

exit_message:

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

id: 6864583

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-04/1775314603",
        "key": "raw/mms_interchange_fees/2026-04-04/1775314603/78db8cdd-0bef-48a3-9451-78137d1d6b8e.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12023272833651982281,
        "service_name": "drive-thru",
        "span_id": 3751790260711125493,
        "trace_id": 15082358958706410295
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-04 09:57:24
success: True
trace_id: 15082358958706410295

Scan 6864342

duration: 0:00:11.874132

exit_message:

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

id: 6864342

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_interchange_fees/2026-04-03/1775228273",
        "key": "raw/mms_interchange_fees/2026-04-03/1775228273/243f15c2-ea2c-4642-9291-9d8799402d4a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17333709838583701938,
        "service_name": "drive-thru",
        "span_id": 15106324789500490151,
        "trace_id": 4752097540079106769
    }
}

running: False
schema_name_id: 2305
start_time: 2026-04-03 09:58:15
success: True
trace_id: 4752097540079106769

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:31:04

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2024-07-03 13:59:58",
        "disabled": false,
        "format": "raw",
        "id": 2305,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:31:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_interchange_fees/2026-04-17/1776436244'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_interchange_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_interchange_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}