Schema Info

Schema Name: sfdl_prod_csv.payrixess_mms_fee_summary

created: 2024-07-24 10:22:43
disabled: False
format: raw
id: 1970
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718261

created: 2026-04-17 09:34:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-17/1776436478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-17/1776436478
id: 1718261
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 162178487
updated: 2026-04-17 09:34:53

Version 1717060

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-16/1776350909'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-16/1776350909
id: 1717060
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 162123143
updated: 2026-04-16 09:48:49

Version 1715834

created: 2026-04-15 09:44:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-15/1776264279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-15/1776264279
id: 1715834
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 162067357
updated: 2026-04-15 09:44:54

Version 1714617

created: 2026-04-14 09:28:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-14/1776176905'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-14/1776176905
id: 1714617
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 162011132
updated: 2026-04-14 09:28:46

Version 1713408

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-13/1776090653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-13/1776090653
id: 1713408
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161953718
updated: 2026-04-13 09:31:15

Version 1712235

created: 2026-04-12 09:38:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-12/1776004729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-12/1776004729
id: 1712235
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161903615
updated: 2026-04-12 09:39:08

Version 1711005

created: 2026-04-11 09:26:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-11/1775917593'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-11/1775917593
id: 1711005
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161851927
updated: 2026-04-11 09:26:50

Version 1709843

created: 2026-04-10 09:31:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-10/1775831485'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-10/1775831485
id: 1709843
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161797361
updated: 2026-04-10 09:31:44

Version 1708713

created: 2026-04-09 09:48:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-09/1775746071'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-09/1775746071
id: 1708713
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161741767
updated: 2026-04-09 09:48:14

Version 1707540

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-08/1775659727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-08/1775659727
id: 1707540
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161687118
updated: 2026-04-08 09:52:45

Version 1706328

created: 2026-04-07 09:43:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-07/1775573012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-07/1775573012
id: 1706328
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161630562
updated: 2026-04-07 09:43:57

Version 1705118

created: 2026-04-06 09:44:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-06/1775486649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-06/1775486649
id: 1705118
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161572958
updated: 2026-04-06 09:44:52

Version 1703862

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-05/1775399431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-05/1775399431
id: 1703862
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161523787
updated: 2026-04-05 09:30:52

Version 1702717

created: 2026-04-04 09:36:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-04/1775313401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-04/1775313401
id: 1702717
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161471739
updated: 2026-04-04 09:36:58

Version 1701518

created: 2026-04-03 09:30:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-03/1775226628'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-03/1775226628
id: 1701518
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 1970
schema_scan_id: 161414326
updated: 2026-04-03 09:30:44

Schema Scans: 15

Last at 2026-04-17 09:34:41

Scan 162178487

duration: 0:00:11.790178

exit_message:

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

id: 162178487

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-17/1776436478",
        "key": "raw/mms_fee_summary/2026-04-17/1776436478/fa5f725b-c2bd-42fe-8e89-562bebfd9ae8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18157356281975595970,
        "service_name": "drive-thru",
        "span_id": 10183935093527676739,
        "trace_id": 18190112401294945865
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-17 09:34:41
success: True
trace_id: 18190112401294945865

Scan 162123143

duration: 0:00:14.433172

exit_message:

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

id: 162123143

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-16/1776350909",
        "key": "raw/mms_fee_summary/2026-04-16/1776350909/8a0022e9-eb67-47bb-83b2-155f7b27972f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 671307771851022123,
        "service_name": "drive-thru",
        "span_id": 11893512931030676601,
        "trace_id": 6473117682021535963
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-16 09:48:34
success: True
trace_id: 6473117682021535963

Scan 162067357

duration: 0:00:11.699839

exit_message:

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

id: 162067357

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-15/1776264279",
        "key": "raw/mms_fee_summary/2026-04-15/1776264279/dfae3f67-772e-418e-a0a9-d0d1b16ee927.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13039313963275437459,
        "service_name": "drive-thru",
        "span_id": 16920631592772553456,
        "trace_id": 17869606261650815953
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-15 09:44:42
success: True
trace_id: 17869606261650815953

Scan 162011132

duration: 0:00:14.584274

exit_message:

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

id: 162011132

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-14/1776176905",
        "key": "raw/mms_fee_summary/2026-04-14/1776176905/19d3c81d-09b8-4941-8c9a-4e2ab9312558.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2997945089150720748,
        "service_name": "drive-thru",
        "span_id": 3573419020710716919,
        "trace_id": 9608760596541557497
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-14 09:28:32
success: True
trace_id: 9608760596541557497

Scan 161953718

duration: 0:00:14.411911

exit_message:

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

id: 161953718

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-13/1776090653",
        "key": "raw/mms_fee_summary/2026-04-13/1776090653/5f343c66-2e37-443f-b609-7e3cde8dd030.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17621577172393712728,
        "service_name": "drive-thru",
        "span_id": 16989852876904596261,
        "trace_id": 16084298034510962342
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-13 09:31:01
success: True
trace_id: 16084298034510962342

Scan 161903615

duration: 0:00:14.331761

exit_message:

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

id: 161903615

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-12/1776004729",
        "key": "raw/mms_fee_summary/2026-04-12/1776004729/8d92a959-4253-4d32-9ba2-809813828925.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10860590728412940943,
        "service_name": "drive-thru",
        "span_id": 12369368301521294103,
        "trace_id": 1425378313967890220
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-12 09:38:54
success: True
trace_id: 1425378313967890220

Scan 161851927

duration: 0:00:14.225019

exit_message:

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

id: 161851927

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-11/1775917593",
        "key": "raw/mms_fee_summary/2026-04-11/1775917593/b44fa894-e1aa-4150-b29f-bae07e3cdbcd.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 326405296804344424,
        "service_name": "drive-thru",
        "span_id": 14153151217789220097,
        "trace_id": 11754523568404524859
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-11 09:26:36
success: True
trace_id: 11754523568404524859

Scan 161797361

duration: 0:00:11.719779

exit_message:

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

id: 161797361

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-10/1775831485",
        "key": "raw/mms_fee_summary/2026-04-10/1775831485/47b2b0c2-7cc4-4d9f-959b-bfb3f7126507.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15163865132764254925,
        "service_name": "drive-thru",
        "span_id": 2529934405675445973,
        "trace_id": 14078236730975228266
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-10 09:31:32
success: True
trace_id: 14078236730975228266

Scan 161741767

duration: 0:00:14.416907

exit_message:

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

id: 161741767

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-09/1775746071",
        "key": "raw/mms_fee_summary/2026-04-09/1775746071/62040a72-e8bb-49cd-baff-47f05c661360.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2262209173336988834,
        "service_name": "drive-thru",
        "span_id": 10189732392287009647,
        "trace_id": 8918395223451920547
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-09 09:47:59
success: True
trace_id: 8918395223451920547

Scan 161687118

duration: 0:00:11.785729

exit_message:

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

id: 161687118

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-08/1775659727",
        "key": "raw/mms_fee_summary/2026-04-08/1775659727/bd67bfa0-0408-472a-ba0b-8bc8a8b6a81f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11220598880255091225,
        "service_name": "drive-thru",
        "span_id": 5569117528714364850,
        "trace_id": 9429729949678200734
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-08 09:52:34
success: True
trace_id: 9429729949678200734

Scan 161630562

duration: 0:00:14.330376

exit_message:

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

id: 161630562

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-07/1775573012",
        "key": "raw/mms_fee_summary/2026-04-07/1775573012/7174f983-6601-4d2d-9b73-01d1bca6cf20.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16683993108709684001,
        "service_name": "drive-thru",
        "span_id": 18259566697454967343,
        "trace_id": 13285528232332931479
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-07 09:43:42
success: True
trace_id: 13285528232332931479

Scan 161572958

duration: 0:00:11.846069

exit_message:

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

id: 161572958

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-06/1775486649",
        "key": "raw/mms_fee_summary/2026-04-06/1775486649/0af2825a-cd3c-44a0-97e3-53b508145038.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13492329048792826841,
        "service_name": "drive-thru",
        "span_id": 4880667325964823519,
        "trace_id": 6954206091395985480
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-06 09:44:40
success: True
trace_id: 6954206091395985480

Scan 161523787

duration: 0:00:14.208645

exit_message:

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

id: 161523787

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-05/1775399431",
        "key": "raw/mms_fee_summary/2026-04-05/1775399431/7a5cbec5-d748-4032-a0aa-8bb92417b4de.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10844261904608435523,
        "service_name": "drive-thru",
        "span_id": 4190981416716278097,
        "trace_id": 3157416144467284329
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-05 09:30:38
success: True
trace_id: 3157416144467284329

Scan 161471739

duration: 0:00:14.284707

exit_message:

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

id: 161471739

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-04/1775313401",
        "key": "raw/mms_fee_summary/2026-04-04/1775313401/b9536935-0b96-42c2-89cd-732ea2300ce8.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17168057923583662050,
        "service_name": "drive-thru",
        "span_id": 169758000235527058,
        "trace_id": 10298738367112196379
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-04 09:36:44
success: True
trace_id: 10298738367112196379

Scan 161414326

duration: 0:00:11.735805

exit_message:

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

id: 161414326

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-prod",
        "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_fee_summary/2026-04-03/1775226628",
        "key": "raw/mms_fee_summary/2026-04-03/1775226628/c3a65813-7778-4262-8376-3cc18ba5e217.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 518630728957658346,
        "service_name": "drive-thru",
        "span_id": 3779747003788829896,
        "trace_id": 16110167660384893924
    }
}

running: False
schema_name_id: 1970
start_time: 2026-04-03 09:30:32
success: True
trace_id: 16110167660384893924

Partitions:

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

Schema:

attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

created: 2026-04-17 09:34:42

ddl:

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

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-24 10:22:43",
        "disabled": false,
        "format": "raw",
        "id": 1970,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrixess_mms_fee_summary"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "count": "string",
            "entity": "string",
            "month": "string",
            "sum": "string",
            "tag": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:34:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrixess_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  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-prod/raw/mms_fee_summary/2026-04-17/1776436478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_fee_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_fee_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}