Schema Info

Schema Name: sfdl_prod_csv.payrix_mms_other_fees

created: 2024-07-10 09:35:53
disabled: False
format: raw
id: 1925
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718247

created: 2026-04-17 09:30:04

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-17/1776436196
id: 1718247
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: 1925
schema_scan_id: 162178399
updated: 2026-04-17 09:30:15

Version 1717049

created: 2026-04-16 09:44:22

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-16/1776350658
id: 1717049
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: 1925
schema_scan_id: 162122900
updated: 2026-04-16 09:44:35

Version 1715883

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-15/1776270419
id: 1715883
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: 1925
schema_scan_id: 162072775
updated: 2026-04-15 11:27:20

Version 1714942

created: 2026-04-14 21:06:33

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-14/1776218789
id: 1714942
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: 1925
schema_scan_id: 162046336
updated: 2026-04-14 21:06:46

Version 1713438

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-13/1776091770
id: 1713438
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: 1925
schema_scan_id: 161954276
updated: 2026-04-13 09:51:39

Version 1712223

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-12/1776004348
id: 1712223
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: 1925
schema_scan_id: 161903507
updated: 2026-04-12 09:32:45

Version 1711028

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-11/1775918621
id: 1711028
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: 1925
schema_scan_id: 161852109
updated: 2026-04-11 09:43:56

Version 1709862

created: 2026-04-10 09:46:25

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-10/1775832269
id: 1709862
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: 1925
schema_scan_id: 161797559
updated: 2026-04-10 09:46:36

Version 1708702

created: 2026-04-09 09:44:08

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-09/1775745845
id: 1708702
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: 1925
schema_scan_id: 161741577
updated: 2026-04-09 09:44:22

Version 1707538

created: 2026-04-08 09:52:03

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-08/1775659672
id: 1707538
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: 1925
schema_scan_id: 161687046
updated: 2026-04-08 09:52:14

Version 1706318

created: 2026-04-07 09:41:17

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-07/1775572874
id: 1706318
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: 1925
schema_scan_id: 161630519
updated: 2026-04-07 09:41:28

Version 1705082

created: 2026-04-06 09:30:05

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-06/1775485794
id: 1705082
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: 1925
schema_scan_id: 161572752
updated: 2026-04-06 09:30:19

Version 1703882

created: 2026-04-05 09:43:16

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-05/1775400192
id: 1703882
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: 1925
schema_scan_id: 161523910
updated: 2026-04-05 09:43:27

Version 1702750

created: 2026-04-04 10:04:19

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-04/1775315050
id: 1702750
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: 1925
schema_scan_id: 161474388
updated: 2026-04-04 10:04:33

Version 1701512

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-03/1775226530
id: 1701512
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: 1925
schema_scan_id: 161414307
updated: 2026-04-03 09:29:06

Schema Scans: 15

Last at 2026-04-17 09:30:03

Scan 162178399

duration: 0:00:12.045268

exit_message:

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

id: 162178399

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-17/1776436196",
        "key": "raw/mms_other_fees/2026-04-17/1776436196/b93c96ff-b808-4949-a3cd-49bd1e50be61.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 42500117588628963,
        "service_name": "drive-thru",
        "span_id": 9894284388653074350,
        "trace_id": 13053261742428253592
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-17 09:30:03
success: True
trace_id: 13053261742428253592

Scan 162122900

duration: 0:00:14.350978

exit_message:

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

id: 162122900

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-16/1776350658",
        "key": "raw/mms_other_fees/2026-04-16/1776350658/8140ca67-8b84-4a08-8f9f-bbdc6d452b38.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7119862519552063102,
        "service_name": "drive-thru",
        "span_id": 1831970657415250638,
        "trace_id": 2714013899683113620
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-16 09:44:21
success: True
trace_id: 2714013899683113620

Scan 162072775

duration: 0:00:14.469764

exit_message:

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

id: 162072775

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-15/1776270419",
        "key": "raw/mms_other_fees/2026-04-15/1776270419/65c68329-14e9-4774-829e-170acc7f369e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9902306949251626279,
        "service_name": "drive-thru",
        "span_id": 13469789326069203030,
        "trace_id": 9213880793017734704
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-15 11:27:06
success: True
trace_id: 9213880793017734704

Scan 162046336

duration: 0:00:14.402591

exit_message:

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

id: 162046336

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-14/1776218789",
        "key": "raw/mms_other_fees/2026-04-14/1776218789/e3c0128a-2a00-49f3-9deb-8f5782672c7b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9056802656042406982,
        "service_name": "drive-thru",
        "span_id": 3025944082550363791,
        "trace_id": 2031560986788998245
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-14 21:06:32
success: True
trace_id: 2031560986788998245

Scan 161954276

duration: 0:00:14.366294

exit_message:

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

id: 161954276

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-13/1776091770",
        "key": "raw/mms_other_fees/2026-04-13/1776091770/7f5184c8-347d-4e17-ba4c-29a45762d733.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17985225508680017825,
        "service_name": "drive-thru",
        "span_id": 16658301412199523899,
        "trace_id": 141986944304423552
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-13 09:51:24
success: True
trace_id: 141986944304423552

Scan 161903507

duration: 0:00:11.857694

exit_message:

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

id: 161903507

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-12/1776004348",
        "key": "raw/mms_other_fees/2026-04-12/1776004348/bd44a250-9048-40ca-a9f3-8acaf3c9ee03.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1350098287179777439,
        "service_name": "drive-thru",
        "span_id": 14636761407163444664,
        "trace_id": 18354196204849024775
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-12 09:32:33
success: True
trace_id: 18354196204849024775

Scan 161852109

duration: 0:00:11.829541

exit_message:

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

id: 161852109

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-11/1775918621",
        "key": "raw/mms_other_fees/2026-04-11/1775918621/5c3f05e3-6e6f-4e71-9042-59cac9e28a3f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17021942635825132087,
        "service_name": "drive-thru",
        "span_id": 15692004793922959554,
        "trace_id": 15593443735310761943
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-11 09:43:44
success: True
trace_id: 15593443735310761943

Scan 161797559

duration: 0:00:11.893495

exit_message:

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

id: 161797559

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-10/1775832269",
        "key": "raw/mms_other_fees/2026-04-10/1775832269/6f0abc11-331c-4fc2-a305-b81999a4bbb0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13696785925003450421,
        "service_name": "drive-thru",
        "span_id": 11747117159946800904,
        "trace_id": 11156332569282838147
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-10 09:46:24
success: True
trace_id: 11156332569282838147

Scan 161741577

duration: 0:00:14.351661

exit_message:

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

id: 161741577

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-09/1775745845",
        "key": "raw/mms_other_fees/2026-04-09/1775745845/4f3ac99a-a6cc-4f15-913c-bf79134f5886.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2534494082335050712,
        "service_name": "drive-thru",
        "span_id": 14922769952768970971,
        "trace_id": 18006605522413542568
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-09 09:44:08
success: True
trace_id: 18006605522413542568

Scan 161687046

duration: 0:00:11.948628

exit_message:

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

id: 161687046

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-08/1775659672",
        "key": "raw/mms_other_fees/2026-04-08/1775659672/281e599c-e9cd-4ce9-afdb-20dc47be8eb4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16173883655861682683,
        "service_name": "drive-thru",
        "span_id": 10080875152649896498,
        "trace_id": 10503197677417418188
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-08 09:52:02
success: True
trace_id: 10503197677417418188

Scan 161630519

duration: 0:00:11.922904

exit_message:

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

id: 161630519

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-07/1775572874",
        "key": "raw/mms_other_fees/2026-04-07/1775572874/15390fb2-1c74-463e-9c94-a2019fbc94a9.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9344426335751342809,
        "service_name": "drive-thru",
        "span_id": 3299616972514913063,
        "trace_id": 17883567809644542852
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-07 09:41:16
success: True
trace_id: 17883567809644542852

Scan 161572752

duration: 0:00:14.340241

exit_message:

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

id: 161572752

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-06/1775485794",
        "key": "raw/mms_other_fees/2026-04-06/1775485794/57d1a12b-81a1-4bef-bbbb-f308ff2f2639.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1572733729672784986,
        "service_name": "drive-thru",
        "span_id": 6157613266697584901,
        "trace_id": 14773411244408653620
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-06 09:30:05
success: True
trace_id: 14773411244408653620

Scan 161523910

duration: 0:00:11.772535

exit_message:

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

id: 161523910

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-05/1775400192",
        "key": "raw/mms_other_fees/2026-04-05/1775400192/016c1109-9c91-4618-bd1d-3966333f7880.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9085477411554808524,
        "service_name": "drive-thru",
        "span_id": 23239916227897468,
        "trace_id": 600880747652666307
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-05 09:43:15
success: True
trace_id: 600880747652666307

Scan 161474388

duration: 0:00:14.384760

exit_message:

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

id: 161474388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-04/1775315050",
        "key": "raw/mms_other_fees/2026-04-04/1775315050/6e5a2342-edb4-4a33-b0bf-4d11a2bdb70e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15024042066186068909,
        "service_name": "drive-thru",
        "span_id": 5424633373006842359,
        "trace_id": 16115705502308302749
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-04 10:04:19
success: True
trace_id: 16115705502308302749

Scan 161414307

duration: 0:00:11.875805

exit_message:

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

id: 161414307

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-prod",
        "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_other_fees/2026-04-03/1775226530",
        "key": "raw/mms_other_fees/2026-04-03/1775226530/ba68f755-c130-487a-9f27-56335f8cf557.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_other_fees",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10566151852680072146,
        "service_name": "drive-thru",
        "span_id": 3494429105557599115,
        "trace_id": 4591959596635063591
    }
}

running: False
schema_name_id: 1925
start_time: 2026-04-03 09:28:54
success: True
trace_id: 4591959596635063591

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_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-prod/raw/mms_other_fees/2026-04-17/1776436196'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_other_fees`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_other_fees"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-10 09:35:53",
        "disabled": false,
        "format": "raw",
        "id": 1925,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:30:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_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-prod/raw/mms_other_fees/2026-04-17/1776436196'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_other_fees`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_other_fees"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}