Schema Info

Schema Name: sfdl_stage_csv.payrix_mms_interchange_fees

created: 2024-07-08 15:34:50
disabled: False
format: raw
id: 2121
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906703

created: 2026-04-17 09:38:38

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-17/1776436698
id: 906703
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: 2121
schema_scan_id: 6415453
updated: 2026-04-17 09:38:50

Version 906480

created: 2026-04-16 09:34:12

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-16/1776350027
id: 906480
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: 2121
schema_scan_id: 6414865
updated: 2026-04-16 09:34:26

Version 906281

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-15/1776264331
id: 906281
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: 2121
schema_scan_id: 6414428
updated: 2026-04-15 09:46:25

Version 906063

created: 2026-04-14 09:41:43

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-14/1776177678
id: 906063
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: 2121
schema_scan_id: 6413932
updated: 2026-04-14 09:41:54

Version 905857

created: 2026-04-13 09:46:45

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-13/1776091596
id: 905857
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: 2121
schema_scan_id: 6413387
updated: 2026-04-13 09:46:59

Version 905629

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-12/1776004142
id: 905629
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: 2121
schema_scan_id: 6412857
updated: 2026-04-12 09:29:51

Version 905435

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-11/1775917933
id: 905435
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: 2121
schema_scan_id: 6412539
updated: 2026-04-11 09:32:51

Version 905236

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-10/1775832259
id: 905236
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: 2121
schema_scan_id: 6412117
updated: 2026-04-10 09:45:16

Version 904997

created: 2026-04-09 09:29:07

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-09/1775744933
id: 904997
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: 2121
schema_scan_id: 6411475
updated: 2026-04-09 09:29:22

Version 904813

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-08/1775659563
id: 904813
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: 2121
schema_scan_id: 6411105
updated: 2026-04-08 09:46:30

Version 904572

created: 2026-04-07 09:29:56

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-07/1775572184
id: 904572
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: 2121
schema_scan_id: 6410495
updated: 2026-04-07 09:30:09

Version 904375

created: 2026-04-06 09:38:21

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-06/1775486269
id: 904375
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: 2121
schema_scan_id: 6410043
updated: 2026-04-06 09:38:32

Version 904178

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-05/1775400660
id: 904178
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: 2121
schema_scan_id: 6409626
updated: 2026-04-05 09:51:26

Version 903963

created: 2026-04-04 09:49:56

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-04/1775314188
id: 903963
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: 2121
schema_scan_id: 6409221
updated: 2026-04-04 09:50:07

Version 903741

created: 2026-04-03 09:37:47

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-03/1775227045
id: 903741
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: 2121
schema_scan_id: 6408670
updated: 2026-04-03 09:38:01

Schema Scans: 15

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

Scan 6415453

duration: 0:00:11.982716

exit_message:

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

id: 6415453

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-17/1776436698",
        "key": "raw/mms_interchange_fees/2026-04-17/1776436698/0ff7a53a-0639-4516-8c26-3b005b82b7a6.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1834593499628043886,
        "service_name": "drive-thru",
        "span_id": 7178899683239918336,
        "trace_id": 14133096092642135322
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-17 09:38:38
success: True
trace_id: 14133096092642135322

Scan 6414865

duration: 0:00:14.444007

exit_message:

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

id: 6414865

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-16/1776350027",
        "key": "raw/mms_interchange_fees/2026-04-16/1776350027/d7ca0b85-6358-4582-8302-7fad776f4349.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5670995999177232053,
        "service_name": "drive-thru",
        "span_id": 4956793913019417551,
        "trace_id": 4023224247462923647
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-16 09:34:11
success: True
trace_id: 4023224247462923647

Scan 6414428

duration: 0:00:11.901409

exit_message:

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

id: 6414428

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-15/1776264331",
        "key": "raw/mms_interchange_fees/2026-04-15/1776264331/fb826b76-8a6f-4aa9-b7ad-533a3f5813a7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7181662780006509468,
        "service_name": "drive-thru",
        "span_id": 14605603258323259908,
        "trace_id": 10092921377189572492
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-15 09:46:13
success: True
trace_id: 10092921377189572492

Scan 6413932

duration: 0:00:11.847977

exit_message:

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

id: 6413932

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-14/1776177678",
        "key": "raw/mms_interchange_fees/2026-04-14/1776177678/e366fd04-9aee-4de5-80ca-2b291c6d1625.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13834767737129687128,
        "service_name": "drive-thru",
        "span_id": 6602552003717476888,
        "trace_id": 4523680696531968751
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-14 09:41:42
success: True
trace_id: 4523680696531968751

Scan 6413387

duration: 0:00:14.455642

exit_message:

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

id: 6413387

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-13/1776091596",
        "key": "raw/mms_interchange_fees/2026-04-13/1776091596/02a64ad4-26e3-442c-8549-5c0c61cd0850.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6017297263903898749,
        "service_name": "drive-thru",
        "span_id": 4387918390724550795,
        "trace_id": 16552603959473431474
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-13 09:46:45
success: True
trace_id: 16552603959473431474

Scan 6412857

duration: 0:00:11.977683

exit_message:

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

id: 6412857

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-12/1776004142",
        "key": "raw/mms_interchange_fees/2026-04-12/1776004142/bc114e9f-d0aa-4bb2-b8cf-e7c6a8c614e3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2972723215221725027,
        "service_name": "drive-thru",
        "span_id": 2154581126392878270,
        "trace_id": 4226401511730233894
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-12 09:29:39
success: True
trace_id: 4226401511730233894

Scan 6412539

duration: 0:00:14.317186

exit_message:

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

id: 6412539

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-11/1775917933",
        "key": "raw/mms_interchange_fees/2026-04-11/1775917933/80ffffb1-7608-429c-bc21-035484253a88.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7150807452433541,
        "service_name": "drive-thru",
        "span_id": 495258840989356907,
        "trace_id": 2837627519780672525
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-11 09:32:37
success: True
trace_id: 2837627519780672525

Scan 6412117

duration: 0:00:12.007537

exit_message:

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

id: 6412117

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-10/1775832259",
        "key": "raw/mms_interchange_fees/2026-04-10/1775832259/14db37df-f9f2-4977-a986-f1493cc81160.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10585398572268935919,
        "service_name": "drive-thru",
        "span_id": 2473684034623770679,
        "trace_id": 5762791931929620229
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-10 09:45:04
success: True
trace_id: 5762791931929620229

Scan 6411475

duration: 0:00:15.204299

exit_message:

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

id: 6411475

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-09/1775744933",
        "key": "raw/mms_interchange_fees/2026-04-09/1775744933/39714023-29de-453a-a751-7760bc567169.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5799523543892843671,
        "service_name": "drive-thru",
        "span_id": 15316952248747778285,
        "trace_id": 5778393930059539461
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-09 09:29:07
success: True
trace_id: 5778393930059539461

Scan 6411105

duration: 0:00:14.405562

exit_message:

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

id: 6411105

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-08/1775659563",
        "key": "raw/mms_interchange_fees/2026-04-08/1775659563/d7d7e615-c37c-44ae-9a7d-2f04e17de45c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5510137795666157027,
        "service_name": "drive-thru",
        "span_id": 11504358166903258055,
        "trace_id": 450366274404181848
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-08 09:46:16
success: True
trace_id: 450366274404181848

Scan 6410495

duration: 0:00:14.277585

exit_message:

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

id: 6410495

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-07/1775572184",
        "key": "raw/mms_interchange_fees/2026-04-07/1775572184/cc99ec1a-1cfe-4f26-82ba-b3b157f867f7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11954280079987468369,
        "service_name": "drive-thru",
        "span_id": 17464349134742028665,
        "trace_id": 5151672106979160892
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-07 09:29:55
success: True
trace_id: 5151672106979160892

Scan 6410043

duration: 0:00:11.951326

exit_message:

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

id: 6410043

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-06/1775486269",
        "key": "raw/mms_interchange_fees/2026-04-06/1775486269/bc5e491e-2840-4b10-9c44-b5e168a0c49a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9860062982984073939,
        "service_name": "drive-thru",
        "span_id": 4002504052528816101,
        "trace_id": 2964309792436985140
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-06 09:38:20
success: True
trace_id: 2964309792436985140

Scan 6409626

duration: 0:00:14.357576

exit_message:

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

id: 6409626

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-05/1775400660",
        "key": "raw/mms_interchange_fees/2026-04-05/1775400660/2eaaaa1f-cfe2-4f34-8289-7d14921eb9ff.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15013543015304157834,
        "service_name": "drive-thru",
        "span_id": 5287995009153005217,
        "trace_id": 8330878248593360649
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-05 09:51:12
success: True
trace_id: 8330878248593360649

Scan 6409221

duration: 0:00:11.800479

exit_message:

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

id: 6409221

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-04/1775314188",
        "key": "raw/mms_interchange_fees/2026-04-04/1775314188/868086b0-382c-4ae4-9978-3e51606c32d0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4998924724244964423,
        "service_name": "drive-thru",
        "span_id": 16592320883801076215,
        "trace_id": 2867525765345369258
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-04 09:49:56
success: True
trace_id: 2867525765345369258

Scan 6408670

duration: 0:00:14.648075

exit_message:

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

id: 6408670

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_interchange_fees/2026-04-03/1775227045",
        "key": "raw/mms_interchange_fees/2026-04-03/1775227045/607a0e0d-0cf1-4ed8-beb2-eced95005ca7.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_interchange_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7086564265664090145,
        "service_name": "drive-thru",
        "span_id": 138735554429375968,
        "trace_id": 13718172757502428496
    }
}

running: False
schema_name_id: 2121
start_time: 2026-04-03 09:37:46
success: True
trace_id: 13718172757502428496

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

ddl:

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