Schema Info

Schema Name: sfdl_dev_csv.payrixess_mms_fee_summary

created: 2024-07-22 13:08:36
disabled: False
format: raw
id: 2378
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773366

created: 2026-04-17 09:54:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-17/1776437632'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-17/1776437632
id: 4773366
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: 2378
schema_scan_id: 6867809
updated: 2026-04-17 09:54:30

Version 4773289

created: 2026-04-16 09:36:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-16/1776350154'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-16/1776350154
id: 4773289
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: 2378
schema_scan_id: 6867504
updated: 2026-04-16 09:36:13

Version 4773212

created: 2026-04-15 09:33:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-15/1776263626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-15/1776263626
id: 4773212
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: 2378
schema_scan_id: 6867141
updated: 2026-04-15 09:34:04

Version 4773181

created: 2026-04-14 10:03:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-14/1776179026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-14/1776179026
id: 4773181
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: 2378
schema_scan_id: 6867004
updated: 2026-04-14 10:04:08

Version 4773100

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-13/1776090813'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-13/1776090813
id: 4773100
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: 2378
schema_scan_id: 6866593
updated: 2026-04-13 09:33:50

Version 4773069

created: 2026-04-12 09:48:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-12/1776005286'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-12/1776005286
id: 4773069
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: 2378
schema_scan_id: 6866505
updated: 2026-04-12 09:48:26

Version 4773022

created: 2026-04-11 09:47:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-11/1775918829'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-11/1775918829
id: 4773022
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: 2378
schema_scan_id: 6866333
updated: 2026-04-11 09:47:42

Version 4772955

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-10/1775832184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-10/1775832184
id: 4772955
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: 2378
schema_scan_id: 6866084
updated: 2026-04-10 09:45:20

Version 4772901

created: 2026-04-09 09:50:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-09/1775746201'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-09/1775746201
id: 4772901
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: 2378
schema_scan_id: 6865821
updated: 2026-04-09 09:50:57

Version 4772817

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-08/1775658475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-08/1775658475
id: 4772817
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: 2378
schema_scan_id: 6865440
updated: 2026-04-08 09:28:26

Version 4772769

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-07/1775573101'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-07/1775573101
id: 4772769
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: 2378
schema_scan_id: 6865267
updated: 2026-04-07 09:45:30

Version 4772708

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-06/1775486666'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-06/1775486666
id: 4772708
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: 2378
schema_scan_id: 6864919
updated: 2026-04-06 09:44:51

Version 4772661

created: 2026-04-05 09:48:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-05/1775400478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-05/1775400478
id: 4772661
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: 2378
schema_scan_id: 6864739
updated: 2026-04-05 09:48:52

Version 4772591

created: 2026-04-04 09:27:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-04/1775312808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-04/1775312808
id: 4772591
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: 2378
schema_scan_id: 6864461
updated: 2026-04-04 09:27:29

Version 4772529

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-03/1775226591'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-03/1775226591
id: 4772529
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: 2378
schema_scan_id: 6864224
updated: 2026-04-03 09:30:09

Schema Scans: 15

Last at 2026-04-17 09:54:16

Scan 6867809

duration: 0:00:14.422729

exit_message:

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

id: 6867809

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-17/1776437632",
        "key": "raw/mms_fee_summary/2026-04-17/1776437632/597bef82-769f-4609-8bb4-de5ba2aef554.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5534005698082102971,
        "service_name": "drive-thru",
        "span_id": 5773492146810022615,
        "trace_id": 16402236899298041690
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-17 09:54:16
success: True
trace_id: 16402236899298041690

Scan 6867504

duration: 0:00:11.978592

exit_message:

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

id: 6867504

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-16/1776350154",
        "key": "raw/mms_fee_summary/2026-04-16/1776350154/4d3b5dde-dc44-44ac-8f41-96a13413350d.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9726243418283483954,
        "service_name": "drive-thru",
        "span_id": 335139765422897182,
        "trace_id": 5588455385126860006
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-16 09:36:01
success: True
trace_id: 5588455385126860006

Scan 6867141

duration: 0:00:14.375559

exit_message:

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

id: 6867141

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-15/1776263626",
        "key": "raw/mms_fee_summary/2026-04-15/1776263626/2bb708df-b939-4221-8bf8-f6b9c09e86e8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2860895999776093465,
        "service_name": "drive-thru",
        "span_id": 4668891797454795190,
        "trace_id": 10624195325966288214
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-15 09:33:50
success: True
trace_id: 10624195325966288214

Scan 6867004

duration: 0:00:11.946697

exit_message:

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

id: 6867004

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-14/1776179026",
        "key": "raw/mms_fee_summary/2026-04-14/1776179026/4fdfdc95-5ef2-432b-849d-8cf6dd1f1a34.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18186856718600562239,
        "service_name": "drive-thru",
        "span_id": 11799642526927581226,
        "trace_id": 3743342379186285939
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-14 10:03:56
success: True
trace_id: 3743342379186285939

Scan 6866593

duration: 0:00:11.757663

exit_message:

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

id: 6866593

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-13/1776090813",
        "key": "raw/mms_fee_summary/2026-04-13/1776090813/3084dba4-c900-4c5f-a72c-ee0b24491ee3.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1172664952178307750,
        "service_name": "drive-thru",
        "span_id": 17180307516732984427,
        "trace_id": 8115813247316116106
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-13 09:33:38
success: True
trace_id: 8115813247316116106

Scan 6866505

duration: 0:00:11.756894

exit_message:

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

id: 6866505

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-12/1776005286",
        "key": "raw/mms_fee_summary/2026-04-12/1776005286/039c67f7-537d-4a23-8648-e201a097e688.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15905635545908367097,
        "service_name": "drive-thru",
        "span_id": 5693862035066959929,
        "trace_id": 1265589085422884603
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-12 09:48:14
success: True
trace_id: 1265589085422884603

Scan 6866333

duration: 0:00:14.461583

exit_message:

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

id: 6866333

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-11/1775918829",
        "key": "raw/mms_fee_summary/2026-04-11/1775918829/a41dcda8-8e9e-4ef1-9ac8-9eda124e1757.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16509804077572088612,
        "service_name": "drive-thru",
        "span_id": 7884223466224210625,
        "trace_id": 9483239021161349796
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-11 09:47:28
success: True
trace_id: 9483239021161349796

Scan 6866084

duration: 0:00:11.835743

exit_message:

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

id: 6866084

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-10/1775832184",
        "key": "raw/mms_fee_summary/2026-04-10/1775832184/f9d48062-cbbd-497b-b2e0-0b9674c1d1e2.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10598652484197645027,
        "service_name": "drive-thru",
        "span_id": 6949228826062653681,
        "trace_id": 13969592201401622766
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-10 09:45:08
success: True
trace_id: 13969592201401622766

Scan 6865821

duration: 0:00:14.506049

exit_message:

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

id: 6865821

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-09/1775746201",
        "key": "raw/mms_fee_summary/2026-04-09/1775746201/4856b62c-8a83-4e1e-b0f4-00100df57993.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6395830788107891445,
        "service_name": "drive-thru",
        "span_id": 7001026043953958202,
        "trace_id": 502062004511277674
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-09 09:50:43
success: True
trace_id: 502062004511277674

Scan 6865440

duration: 0:00:14.315000

exit_message:

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

id: 6865440

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-08/1775658475",
        "key": "raw/mms_fee_summary/2026-04-08/1775658475/a47073f9-87b1-4c4c-9da7-ed1ed9d19bf8.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4008288480401537804,
        "service_name": "drive-thru",
        "span_id": 12986366653969109316,
        "trace_id": 13703434575606168943
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-08 09:28:11
success: True
trace_id: 13703434575606168943

Scan 6865267

duration: 0:00:14.596212

exit_message:

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

id: 6865267

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-07/1775573101",
        "key": "raw/mms_fee_summary/2026-04-07/1775573101/988a2623-5ab5-4884-b187-f37540e52a3c.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3801450546054058560,
        "service_name": "drive-thru",
        "span_id": 2170414217059901309,
        "trace_id": 10860730282999610104
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-07 09:45:15
success: True
trace_id: 10860730282999610104

Scan 6864919

duration: 0:00:11.905850

exit_message:

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

id: 6864919

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-06/1775486666",
        "key": "raw/mms_fee_summary/2026-04-06/1775486666/8b468aa3-ed94-4c18-b675-c01309536a53.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5031111997373178225,
        "service_name": "drive-thru",
        "span_id": 16103060516022699775,
        "trace_id": 4852517397210206232
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-06 09:44:39
success: True
trace_id: 4852517397210206232

Scan 6864739

duration: 0:00:11.691596

exit_message:

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

id: 6864739

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-05/1775400478",
        "key": "raw/mms_fee_summary/2026-04-05/1775400478/79ec50e7-46f2-4578-aa64-99d6ff2e0162.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1905466553215864561,
        "service_name": "drive-thru",
        "span_id": 9784414707951015263,
        "trace_id": 12467260252262498472
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-05 09:48:41
success: True
trace_id: 12467260252262498472

Scan 6864461

duration: 0:00:11.816280

exit_message:

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

id: 6864461

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-04/1775312808",
        "key": "raw/mms_fee_summary/2026-04-04/1775312808/5020d2c4-b2be-45df-bed5-ab05f9460d76.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3476163484685195459,
        "service_name": "drive-thru",
        "span_id": 1738553779939036183,
        "trace_id": 2160300639479966872
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-04 09:27:17
success: True
trace_id: 2160300639479966872

Scan 6864224

duration: 0:00:14.308060

exit_message:

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

id: 6864224

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrixess-dev",
        "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_fee_summary/2026-04-03/1775226591",
        "key": "raw/mms_fee_summary/2026-04-03/1775226591/6003400d-a6bd-4f56-a6f8-f29c1f0de1b5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrixess_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8136008853921053310,
        "service_name": "drive-thru",
        "span_id": 16342680127149563330,
        "trace_id": 12980262862239069984
    }
}

running: False
schema_name_id: 2378
start_time: 2026-04-03 09:29:54
success: True
trace_id: 12980262862239069984

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:54:17

ddl:

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

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-07-22 13:08:36",
        "disabled": false,
        "format": "raw",
        "id": 2378,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:54:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/mms_fee_summary/2026-04-17/1776437632'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_fee_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_fee_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}