Schema Info

Schema Name: sfdl_stage_csv.payrix_mms_other_fees

created: 2024-07-08 15:32:15
disabled: False
format: raw
id: 2114
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 906701

created: 2026-04-17 09:36:05

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-17/1776436544
id: 906701
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: 2114
schema_scan_id: 6415451
updated: 2026-04-17 09:36:19

Version 906478

created: 2026-04-16 09:32:55

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-16/1776349964
id: 906478
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: 2114
schema_scan_id: 6414862
updated: 2026-04-16 09:33:06

Version 906278

created: 2026-04-15 09:45:59

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-15/1776264349
id: 906278
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: 2114
schema_scan_id: 6414425
updated: 2026-04-15 09:46:13

Version 906066

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-14/1776177701
id: 906066
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: 2114
schema_scan_id: 6413935
updated: 2026-04-14 09:42:08

Version 905827

created: 2026-04-13 09:27:36

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-13/1776090451
id: 905827
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: 2114
schema_scan_id: 6413250
updated: 2026-04-13 09:27:50

Version 905639

created: 2026-04-12 09:39:33

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-12/1776004769
id: 905639
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: 2114
schema_scan_id: 6412915
updated: 2026-04-12 09:39:47

Version 905419

created: 2026-04-11 09:25:54

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-11/1775917547
id: 905419
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: 2114
schema_scan_id: 6412436
updated: 2026-04-11 09:26:05

Version 905224

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-10/1775832046
id: 905224
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: 2114
schema_scan_id: 6412081
updated: 2026-04-10 09:41:01

Version 904999

created: 2026-04-09 09:32:05

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-09/1775745108
id: 904999
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: 2114
schema_scan_id: 6411479
updated: 2026-04-09 09:32:16

Version 904811

created: 2026-04-08 09:45:38

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-08/1775659528
id: 904811
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: 2114
schema_scan_id: 6411103
updated: 2026-04-08 09:45:49

Version 904595

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-07/1775573086
id: 904595
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: 2114
schema_scan_id: 6410592
updated: 2026-04-07 09:45:13

Version 904371

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-06/1775486078
id: 904371
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: 2114
schema_scan_id: 6410038
updated: 2026-04-06 09:35:00

Version 904163

created: 2026-04-05 09:38:37

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-05/1775399895
id: 904163
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: 2114
schema_scan_id: 6409606
updated: 2026-04-05 09:38:51

Version 903972

created: 2026-04-04 09:51:25

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-04/1775314277
id: 903972
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: 2114
schema_scan_id: 6409242
updated: 2026-04-04 09:51:39

Version 903767

created: 2026-04-03 10:04:40

ddl:

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

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_other_fees/2026-04-03/1775228670
id: 903767
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: 2114
schema_scan_id: 6408795
updated: 2026-04-03 10:04:54

Schema Scans: 15

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

Scan 6415451

duration: 0:00:14.830876

exit_message:

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

id: 6415451

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_other_fees/2026-04-17/1776436544",
        "key": "raw/mms_other_fees/2026-04-17/1776436544/9e551eb3-2dd9-42db-81be-80a2957fda1b.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12707874406043756297,
        "service_name": "drive-thru",
        "span_id": 76834503951142777,
        "trace_id": 14791043833396216112
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-17 09:36:04
success: True
trace_id: 14791043833396216112

Scan 6414862

duration: 0:00:11.989279

exit_message:

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

id: 6414862

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_other_fees/2026-04-16/1776349964",
        "key": "raw/mms_other_fees/2026-04-16/1776349964/f7617f38-c87b-4e40-aabc-e80e57ab6a17.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3433728331039805188,
        "service_name": "drive-thru",
        "span_id": 4305083471998342609,
        "trace_id": 9148904931485946143
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-16 09:32:54
success: True
trace_id: 9148904931485946143

Scan 6414425

duration: 0:00:14.813602

exit_message:

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

id: 6414425

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_other_fees/2026-04-15/1776264349",
        "key": "raw/mms_other_fees/2026-04-15/1776264349/45450b09-e49b-4bde-99d5-cf6dbcb1dda8.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2958035979557772019,
        "service_name": "drive-thru",
        "span_id": 8151047447308324758,
        "trace_id": 10888048015701080455
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-15 09:45:59
success: True
trace_id: 10888048015701080455

Scan 6413935

duration: 0:00:14.502161

exit_message:

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

id: 6413935

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_other_fees/2026-04-14/1776177701",
        "key": "raw/mms_other_fees/2026-04-14/1776177701/46b04f17-0bd4-4080-a486-fb098ac6ff86.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5013773440267115419,
        "service_name": "drive-thru",
        "span_id": 12518925124493138402,
        "trace_id": 13093193662315358505
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-14 09:41:53
success: True
trace_id: 13093193662315358505

Scan 6413250

duration: 0:00:14.595144

exit_message:

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

id: 6413250

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_other_fees/2026-04-13/1776090451",
        "key": "raw/mms_other_fees/2026-04-13/1776090451/9752840e-d79b-4caf-93a6-bc8fa2affa02.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17554828639772634373,
        "service_name": "drive-thru",
        "span_id": 3696454372846471864,
        "trace_id": 5157323196267271602
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-13 09:27:35
success: True
trace_id: 5157323196267271602

Scan 6412915

duration: 0:00:14.436260

exit_message:

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

id: 6412915

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_other_fees/2026-04-12/1776004769",
        "key": "raw/mms_other_fees/2026-04-12/1776004769/ca100d99-c2d8-4e27-97e7-d6d15c6ae53e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6416709995881708378,
        "service_name": "drive-thru",
        "span_id": 6542827814148962660,
        "trace_id": 14280201404154176838
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-12 09:39:33
success: True
trace_id: 14280201404154176838

Scan 6412436

duration: 0:00:12.064736

exit_message:

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

id: 6412436

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_other_fees/2026-04-11/1775917547",
        "key": "raw/mms_other_fees/2026-04-11/1775917547/f4a4b109-474f-4551-9420-4ea54f7a9afc.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7557708801130639450,
        "service_name": "drive-thru",
        "span_id": 907404755023230443,
        "trace_id": 14731571631013982517
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-11 09:25:53
success: True
trace_id: 14731571631013982517

Scan 6412081

duration: 0:00:11.786702

exit_message:

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

id: 6412081

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_other_fees/2026-04-10/1775832046",
        "key": "raw/mms_other_fees/2026-04-10/1775832046/6947cdfd-fd81-4d9a-bc2e-6f844d1b5a16.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11858747141362022543,
        "service_name": "drive-thru",
        "span_id": 9958697051221159002,
        "trace_id": 2124636834391651937
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-10 09:40:49
success: True
trace_id: 2124636834391651937

Scan 6411479

duration: 0:00:11.898479

exit_message:

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

id: 6411479

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_other_fees/2026-04-09/1775745108",
        "key": "raw/mms_other_fees/2026-04-09/1775745108/48468c64-91eb-40fa-95ea-ff2fb1197345.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5992547902150936948,
        "service_name": "drive-thru",
        "span_id": 16405058712395261214,
        "trace_id": 10746298576923297283
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-09 09:32:04
success: True
trace_id: 10746298576923297283

Scan 6411103

duration: 0:00:11.902513

exit_message:

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

id: 6411103

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_other_fees/2026-04-08/1775659528",
        "key": "raw/mms_other_fees/2026-04-08/1775659528/d92b013d-602e-40b4-8d03-e26bdc51e964.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2658038135969400758,
        "service_name": "drive-thru",
        "span_id": 1364583236255872080,
        "trace_id": 16665704225608169191
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-08 09:45:37
success: True
trace_id: 16665704225608169191

Scan 6410592

duration: 0:00:12.220985

exit_message:

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

id: 6410592

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_other_fees/2026-04-07/1775573086",
        "key": "raw/mms_other_fees/2026-04-07/1775573086/5df4644f-99a0-452d-a68f-8a7232e4cd6f.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 551455974419108772,
        "service_name": "drive-thru",
        "span_id": 12312408317535077552,
        "trace_id": 5359355066002971862
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-07 09:45:00
success: True
trace_id: 5359355066002971862

Scan 6410038

duration: 0:00:14.706242

exit_message:

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

id: 6410038

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_other_fees/2026-04-06/1775486078",
        "key": "raw/mms_other_fees/2026-04-06/1775486078/1d91676b-5b43-4061-9356-65f382da3d61.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16847972444789262429,
        "service_name": "drive-thru",
        "span_id": 18347289952994810759,
        "trace_id": 9102532783614919019
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-06 09:34:45
success: True
trace_id: 9102532783614919019

Scan 6409606

duration: 0:00:14.425039

exit_message:

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

id: 6409606

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_other_fees/2026-04-05/1775399895",
        "key": "raw/mms_other_fees/2026-04-05/1775399895/96b77def-9014-4433-aafc-347d5743aeae.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6153825620026699930,
        "service_name": "drive-thru",
        "span_id": 18238137187850159495,
        "trace_id": 17423836746859440355
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-05 09:38:37
success: True
trace_id: 17423836746859440355

Scan 6409242

duration: 0:00:14.481171

exit_message:

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

id: 6409242

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_other_fees/2026-04-04/1775314277",
        "key": "raw/mms_other_fees/2026-04-04/1775314277/55680d61-590a-4344-8b7d-be1d012df8df.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7018714836925497728,
        "service_name": "drive-thru",
        "span_id": 4612142345169467652,
        "trace_id": 14257523844295343000
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-04 09:51:25
success: True
trace_id: 14257523844295343000

Scan 6408795

duration: 0:00:14.592184

exit_message:

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

id: 6408795

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_other_fees/2026-04-03/1775228670",
        "key": "raw/mms_other_fees/2026-04-03/1775228670/313574c2-4812-43a4-9e27-4e1af638d9c1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7516627314128765981,
        "service_name": "drive-thru",
        "span_id": 10450937751094358068,
        "trace_id": 219482318781064187
    }
}

running: False
schema_name_id: 2114
start_time: 2026-04-03 10:04:40
success: True
trace_id: 219482318781064187

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:36:05

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_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-payrix-stage/raw/mms_other_fees/2026-04-17/1776436544'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_other_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_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-08 15:32:15",
        "disabled": false,
        "format": "raw",
        "id": 2114,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "payrix_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:36:05",
        "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_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-payrix-stage/raw/mms_other_fees/2026-04-17/1776436544'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_other_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_other_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}