Schema Info

Schema Name: sfdl_stage_csv.payrixess_mms_other_fees

created: 2024-07-22 13:20:24
disabled: False
format: raw
id: 2178
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906708

created: 2026-04-17 09:39:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-17/1776436749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-17/1776436749
id: 906708
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6415462
updated: 2026-04-17 09:39:34

Version 906499

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-16/1776350883'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-16/1776350883
id: 906499
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6414944
updated: 2026-04-16 09:48:21

Version 906263

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-15/1776263523'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-15/1776263523
id: 906263
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6414394
updated: 2026-04-15 09:32:23

Version 906069

created: 2026-04-14 09:45:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-14/1776177909'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-14/1776177909
id: 906069
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6413939
updated: 2026-04-14 09:45:40

Version 905836

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-13/1776090661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-13/1776090661
id: 905836
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6413270
updated: 2026-04-13 09:31:32

Version 905626

created: 2026-04-12 09:28:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-12/1776004111'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-12/1776004111
id: 905626
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6412844
updated: 2026-04-12 09:29:12

Version 905450

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-11/1775918764'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-11/1775918764
id: 905450
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6412575
updated: 2026-04-11 09:46:20

Version 905231

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-10/1775832154'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-10/1775832154
id: 905231
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6412112
updated: 2026-04-10 09:44:56

Version 905011

created: 2026-04-09 09:43:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-09/1775745815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-09/1775745815
id: 905011
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6411537
updated: 2026-04-09 09:44:03

Version 904798

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-08/1775659219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-08/1775659219
id: 904798
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6411090
updated: 2026-04-08 09:41:07

Version 904573

created: 2026-04-07 09:31:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-07/1775572299'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-07/1775572299
id: 904573
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6410516
updated: 2026-04-07 09:32:03

Version 904354

created: 2026-04-06 09:28:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-06/1775485728'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-06/1775485728
id: 904354
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6409943
updated: 2026-04-06 09:29:06

Version 904169

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-05/1775400245'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-05/1775400245
id: 904169
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6409615
updated: 2026-04-05 09:44:22

Version 903945

created: 2026-04-04 09:28:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-04/1775312902'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-04/1775312902
id: 903945
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6409105
updated: 2026-04-04 09:28:52

Version 903755

created: 2026-04-03 09:55:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-03/1775228125'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
]

hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-03/1775228125
id: 903755
processed: 1

raw_data:

{
    "amount": 6,
    "count": 7,
    "entity": 2,
    "id": 3,
    "month": 1,
    "name": 4,
    "sum": 8,
    "um": 5,
    "year": 0
}

schema_attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

schema_name_id: 2178
schema_scan_id: 6408754
updated: 2026-04-03 09:55:42

Schema Scans: 15

Last at 2026-04-17 09:39:20

Scan 6415462

duration: 0:00:14.627736

exit_message:

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

id: 6415462

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-17/1776436749",
        "key": "raw/mms_other_fees/2026-04-17/1776436749/83e2fe7a-dcf2-48f2-bddd-6dfa4d67bd7c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5109285094884565212,
        "service_name": "drive-thru",
        "span_id": 379280908197609348,
        "trace_id": 13175962332183306822
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-17 09:39:20
success: True
trace_id: 13175962332183306822

Scan 6414944

duration: 0:00:14.345705

exit_message:

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

id: 6414944

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-16/1776350883",
        "key": "raw/mms_other_fees/2026-04-16/1776350883/4591f8d7-7bfe-4b7a-9b95-042ed17d83c8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9860745673940682268,
        "service_name": "drive-thru",
        "span_id": 18408311783406103249,
        "trace_id": 8272049699949390847
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-16 09:48:06
success: True
trace_id: 8272049699949390847

Scan 6414394

duration: 0:00:12.127829

exit_message:

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

id: 6414394

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-15/1776263523",
        "key": "raw/mms_other_fees/2026-04-15/1776263523/fca2eb5b-fe93-48bd-95a2-b930977d5301.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5910607830474127240,
        "service_name": "drive-thru",
        "span_id": 6102685605803802596,
        "trace_id": 15209954378482768809
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-15 09:32:11
success: True
trace_id: 15209954378482768809

Scan 6413939

duration: 0:00:14.645366

exit_message:

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

id: 6413939

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-14/1776177909",
        "key": "raw/mms_other_fees/2026-04-14/1776177909/8106b540-818a-4aba-b3fc-ca317c74a98f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6298442360853250082,
        "service_name": "drive-thru",
        "span_id": 12424576651027081126,
        "trace_id": 14682801927810056347
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-14 09:45:26
success: True
trace_id: 14682801927810056347

Scan 6413270

duration: 0:00:12.004408

exit_message:

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

id: 6413270

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-13/1776090661",
        "key": "raw/mms_other_fees/2026-04-13/1776090661/17dc2618-be35-4ec2-b17b-9542c93fb630.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1833045307513049382,
        "service_name": "drive-thru",
        "span_id": 6053706921781565112,
        "trace_id": 13104432692738878791
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-13 09:31:20
success: True
trace_id: 13104432692738878791

Scan 6412844

duration: 0:00:14.575095

exit_message:

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

id: 6412844

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-12/1776004111",
        "key": "raw/mms_other_fees/2026-04-12/1776004111/76cb3c3d-f749-4f93-ac70-964cfbe69c49.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8453289214692083005,
        "service_name": "drive-thru",
        "span_id": 6686919166104147135,
        "trace_id": 18084077567934720027
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-12 09:28:57
success: True
trace_id: 18084077567934720027

Scan 6412575

duration: 0:00:11.792982

exit_message:

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

id: 6412575

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-11/1775918764",
        "key": "raw/mms_other_fees/2026-04-11/1775918764/9b3fd5dc-eeee-4d70-94b2-ea1a8715c2e0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14563038159503984373,
        "service_name": "drive-thru",
        "span_id": 12997727289585693154,
        "trace_id": 1129207746080907761
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-11 09:46:08
success: True
trace_id: 1129207746080907761

Scan 6412112

duration: 0:02:19.176246

exit_message:

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

id: 6412112

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-10/1775832154",
        "key": "raw/mms_other_fees/2026-04-10/1775832154/cb0eaf30-1897-4688-bfd3-6abe7ffaa78e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4616693421155880484,
        "service_name": "drive-thru",
        "span_id": 12400778861246038322,
        "trace_id": 2652245849613648636
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-10 09:42:37
success: True
trace_id: 2652245849613648636

Scan 6411537

duration: 0:00:11.967258

exit_message:

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

id: 6411537

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-09/1775745815",
        "key": "raw/mms_other_fees/2026-04-09/1775745815/9273870b-4caa-48ae-9449-a5f50e776514.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3417624244790181552,
        "service_name": "drive-thru",
        "span_id": 6006926922003185273,
        "trace_id": 9872572719678480589
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-09 09:43:51
success: True
trace_id: 9872572719678480589

Scan 6411090

duration: 0:00:44.989300

exit_message:

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

id: 6411090

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-08/1775659219",
        "key": "raw/mms_other_fees/2026-04-08/1775659219/dd70fd83-0cb0-45dd-ac63-566eed1853e3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3644429454682434864,
        "service_name": "drive-thru",
        "span_id": 7219471732675443383,
        "trace_id": 11401237629998431184
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-08 09:40:22
success: True
trace_id: 11401237629998431184

Scan 6410516

duration: 0:00:11.937358

exit_message:

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

id: 6410516

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-07/1775572299",
        "key": "raw/mms_other_fees/2026-04-07/1775572299/0a1264e3-76f5-4aa4-824c-7fe2446fe4d3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10068645616404920514,
        "service_name": "drive-thru",
        "span_id": 1173391668036251962,
        "trace_id": 10168861665365703985
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-07 09:31:51
success: True
trace_id: 10168861665365703985

Scan 6409943

duration: 0:00:14.426147

exit_message:

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

id: 6409943

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-06/1775485728",
        "key": "raw/mms_other_fees/2026-04-06/1775485728/ca5216f5-cbe4-413d-97d9-607a957a5623.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13461525008499469824,
        "service_name": "drive-thru",
        "span_id": 9670428376932457014,
        "trace_id": 8819530285046265241
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-06 09:28:52
success: True
trace_id: 8819530285046265241

Scan 6409615

duration: 0:00:11.855395

exit_message:

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

id: 6409615

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-05/1775400245",
        "key": "raw/mms_other_fees/2026-04-05/1775400245/3c6fdeaf-202c-4cc7-b367-546caca4e287.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15862301282974499866,
        "service_name": "drive-thru",
        "span_id": 13973412755051593218,
        "trace_id": 16710774101805750583
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-05 09:44:11
success: True
trace_id: 16710774101805750583

Scan 6409105

duration: 0:00:14.422178

exit_message:

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

id: 6409105

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-04/1775312902",
        "key": "raw/mms_other_fees/2026-04-04/1775312902/39c3afe1-612b-4593-bd0e-2d88dbea2641.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8271081726638501622,
        "service_name": "drive-thru",
        "span_id": 17784685242890923788,
        "trace_id": 4605167006508273493
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-04 09:28:38
success: True
trace_id: 4605167006508273493

Scan 6408754

duration: 0:00:14.363401

exit_message:

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

id: 6408754

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-stage",
        "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-03/1775228125",
        "key": "raw/mms_other_fees/2026-04-03/1775228125/076008b0-6e1d-4cc2-b82d-6091d170863a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrixess_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12885875722141387179,
        "service_name": "drive-thru",
        "span_id": 7168989858298482767,
        "trace_id": 206772027243184186
    }
}

running: False
schema_name_id: 2178
start_time: 2026-04-03 09:55:28
success: True
trace_id: 206772027243184186

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "amount": "string",
    "count": "string",
    "entity": "string",
    "id": "string",
    "month": "string",
    "name": "string",
    "sum": "string",
    "um": "string",
    "year": "string"
}

created: 2026-04-17 09:39:21

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-17/1776436749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-22 13:20:24",
        "disabled": false,
        "format": "raw",
        "id": 2178,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "payrixess_mms_other_fees"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "count": "string",
            "entity": "string",
            "id": "string",
            "month": "string",
            "name": "string",
            "sum": "string",
            "um": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:39:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_other_fees`\n(\n `year`  string , `month`  string , `entity`  string , `id`  string , `name`  string , `um`  string , `amount`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrixess-stage/raw/mms_other_fees/2026-04-17/1776436749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_other_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_other_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}