Schema Info

Schema Name: sfdl_prod_csv.payrix_mms_fee_summary

created: 2024-07-10 09:32:21
disabled: False
format: raw
id: 1915
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718248

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-17/1776436217
id: 1718248
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: 1915
schema_scan_id: 162178411
updated: 2026-04-17 09:30:48

Version 1717028

created: 2026-04-16 09:33:20

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-16/1776349995
id: 1717028
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: 1915
schema_scan_id: 162122792
updated: 2026-04-16 09:33:34

Version 1715878

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-15/1776270265
id: 1715878
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: 1915
schema_scan_id: 162072719
updated: 2026-04-15 11:24:43

Version 1714946

created: 2026-04-14 21:11:28

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-14/1776219079
id: 1714946
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: 1915
schema_scan_id: 162046405
updated: 2026-04-14 21:11:39

Version 1713409

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-13/1776090662
id: 1713409
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: 1915
schema_scan_id: 161953720
updated: 2026-04-13 09:31:30

Version 1712247

created: 2026-04-12 09:44:02

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-12/1776005031
id: 1712247
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: 1915
schema_scan_id: 161903646
updated: 2026-04-12 09:44:16

Version 1711024

created: 2026-04-11 09:42:49

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-11/1775918545
id: 1711024
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: 1915
schema_scan_id: 161852093
updated: 2026-04-11 09:43:01

Version 1709830

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-10/1775831196
id: 1709830
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: 1915
schema_scan_id: 161797240
updated: 2026-04-10 09:26:54

Version 1708678

created: 2026-04-09 09:28:13

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-09/1775744890
id: 1708678
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: 1915
schema_scan_id: 161741336
updated: 2026-04-09 09:28:24

Version 1707534

created: 2026-04-08 09:50:09

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-08/1775659621
id: 1707534
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: 1915
schema_scan_id: 161686835
updated: 2026-04-08 09:50:23

Version 1706331

created: 2026-04-07 09:44:56

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-07/1775573079
id: 1706331
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: 1915
schema_scan_id: 161630585
updated: 2026-04-07 09:45:07

Version 1705119

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-06/1775486686
id: 1705119
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: 1915
schema_scan_id: 161572970
updated: 2026-04-06 09:45:01

Version 1703878

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-05/1775400063
id: 1703878
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: 1915
schema_scan_id: 161523901
updated: 2026-04-05 09:41:34

Version 1702737

created: 2026-04-04 09:51:58

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-04/1775314312
id: 1702737
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: 1915
schema_scan_id: 161472185
updated: 2026-04-04 09:52:09

Version 1701528

created: 2026-04-03 09:35:56

ddl:

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

hive_path: s3://sfdl-csv-payrix-prod/raw/mms_fee_summary/2026-04-03/1775226939
id: 1701528
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: 1915
schema_scan_id: 161414399
updated: 2026-04-03 09:36:07

Schema Scans: 15

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

Scan 162178411

duration: 0:00:14.317664

exit_message:

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

id: 162178411

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_fee_summary/2026-04-17/1776436217",
        "key": "raw/mms_fee_summary/2026-04-17/1776436217/bd6de52e-5852-4d76-8105-edaf664e1ea7.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16627344534844811987,
        "service_name": "drive-thru",
        "span_id": 12267172777160060471,
        "trace_id": 11502368810644593652
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-17 09:30:34
success: True
trace_id: 11502368810644593652

Scan 162122792

duration: 0:00:14.286615

exit_message:

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

id: 162122792

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_fee_summary/2026-04-16/1776349995",
        "key": "raw/mms_fee_summary/2026-04-16/1776349995/cf9460f7-e418-44a5-a0df-5f34408c72af.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1535859967562406674,
        "service_name": "drive-thru",
        "span_id": 5706161606461167759,
        "trace_id": 248768421802497765
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-16 09:33:20
success: True
trace_id: 248768421802497765

Scan 162072719

duration: 0:00:11.750551

exit_message:

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

id: 162072719

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_fee_summary/2026-04-15/1776270265",
        "key": "raw/mms_fee_summary/2026-04-15/1776270265/7649a5c0-df31-4172-8fc8-fab109d0ecb4.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5360737093881177768,
        "service_name": "drive-thru",
        "span_id": 2131142189896914977,
        "trace_id": 17961999016498990844
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-15 11:24:31
success: True
trace_id: 17961999016498990844

Scan 162046405

duration: 0:00:12.084058

exit_message:

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

id: 162046405

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_fee_summary/2026-04-14/1776219079",
        "key": "raw/mms_fee_summary/2026-04-14/1776219079/10b3976b-1e62-4128-8362-d1f124c88ce5.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13135868891694327743,
        "service_name": "drive-thru",
        "span_id": 15386520817749289158,
        "trace_id": 1774699469626513463
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-14 21:11:27
success: True
trace_id: 1774699469626513463

Scan 161953720

duration: 0:00:14.408383

exit_message:

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

id: 161953720

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_fee_summary/2026-04-13/1776090662",
        "key": "raw/mms_fee_summary/2026-04-13/1776090662/727953f1-e0c8-4136-a1a0-fe51d419a0bd.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3532208348642621369,
        "service_name": "drive-thru",
        "span_id": 8292518637825518307,
        "trace_id": 3141158552818500942
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-13 09:31:15
success: True
trace_id: 3141158552818500942

Scan 161903646

duration: 0:00:14.287560

exit_message:

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

id: 161903646

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_fee_summary/2026-04-12/1776005031",
        "key": "raw/mms_fee_summary/2026-04-12/1776005031/73de7cf3-d2be-4943-b05d-21c4a4bd2070.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9584500163672988792,
        "service_name": "drive-thru",
        "span_id": 6001915253042864336,
        "trace_id": 12451422908449195674
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-12 09:44:01
success: True
trace_id: 12451422908449195674

Scan 161852093

duration: 0:00:11.687419

exit_message:

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

id: 161852093

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_fee_summary/2026-04-11/1775918545",
        "key": "raw/mms_fee_summary/2026-04-11/1775918545/1861ac8f-17ea-496a-b2ae-df24ad44f217.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2362602525954927326,
        "service_name": "drive-thru",
        "span_id": 9240998470187558105,
        "trace_id": 1972778667669238776
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-11 09:42:49
success: True
trace_id: 1972778667669238776

Scan 161797240

duration: 0:00:14.263877

exit_message:

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

id: 161797240

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_fee_summary/2026-04-10/1775831196",
        "key": "raw/mms_fee_summary/2026-04-10/1775831196/2fe550fc-a55f-49f1-a5c0-7f0eea8b214f.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5290910809415088006,
        "service_name": "drive-thru",
        "span_id": 7195529064691028122,
        "trace_id": 9938279850506000187
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-10 09:26:40
success: True
trace_id: 9938279850506000187

Scan 161741336

duration: 0:00:11.683395

exit_message:

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

id: 161741336

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_fee_summary/2026-04-09/1775744890",
        "key": "raw/mms_fee_summary/2026-04-09/1775744890/46d8b13a-dec0-427d-9f26-984ac4d7664d.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4247199266047686813,
        "service_name": "drive-thru",
        "span_id": 9337691934908546216,
        "trace_id": 1073255646373764026
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-09 09:28:13
success: True
trace_id: 1073255646373764026

Scan 161686835

duration: 0:00:14.283107

exit_message:

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

id: 161686835

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_fee_summary/2026-04-08/1775659621",
        "key": "raw/mms_fee_summary/2026-04-08/1775659621/d30908f1-0009-4afc-baff-f008087cd43e.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12330882870059565267,
        "service_name": "drive-thru",
        "span_id": 1654993810287589804,
        "trace_id": 16526828350854186352
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-08 09:50:08
success: True
trace_id: 16526828350854186352

Scan 161630585

duration: 0:00:11.754705

exit_message:

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

id: 161630585

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_fee_summary/2026-04-07/1775573079",
        "key": "raw/mms_fee_summary/2026-04-07/1775573079/8ca5dd03-c852-4d8f-94ce-6176df1bfa93.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11072890525709595155,
        "service_name": "drive-thru",
        "span_id": 17418727172085696664,
        "trace_id": 16538250732855239580
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-07 09:44:55
success: True
trace_id: 16538250732855239580

Scan 161572970

duration: 0:00:11.635695

exit_message:

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

id: 161572970

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_fee_summary/2026-04-06/1775486686",
        "key": "raw/mms_fee_summary/2026-04-06/1775486686/16e0d763-2b29-4786-a740-2d6bddd3b1d0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7316545546908322329,
        "service_name": "drive-thru",
        "span_id": 1721256462096560059,
        "trace_id": 3481397293294415729
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-06 09:44:50
success: True
trace_id: 3481397293294415729

Scan 161523901

duration: 0:00:11.824927

exit_message:

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

id: 161523901

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_fee_summary/2026-04-05/1775400063",
        "key": "raw/mms_fee_summary/2026-04-05/1775400063/427917ee-1d79-4b6f-970c-7ff77fcfb441.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6358099627280953869,
        "service_name": "drive-thru",
        "span_id": 17010789275430734318,
        "trace_id": 7014763913193004348
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-05 09:41:22
success: True
trace_id: 7014763913193004348

Scan 161472185

duration: 0:00:11.843729

exit_message:

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

id: 161472185

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_fee_summary/2026-04-04/1775314312",
        "key": "raw/mms_fee_summary/2026-04-04/1775314312/527906f1-4116-4e24-8c00-c22fa1bd6a64.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14022220487591075134,
        "service_name": "drive-thru",
        "span_id": 5333092576273599784,
        "trace_id": 1405759955540520832
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-04 09:51:58
success: True
trace_id: 1405759955540520832

Scan 161414399

duration: 0:00:11.937745

exit_message:

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

id: 161414399

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_fee_summary/2026-04-03/1775226939",
        "key": "raw/mms_fee_summary/2026-04-03/1775226939/4a15e7c7-cf3f-4ba7-88ff-22f4c725052b.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1133448310470111390,
        "service_name": "drive-thru",
        "span_id": 10486964870894121624,
        "trace_id": 9586818417434033869
    }
}

running: False
schema_name_id: 1915
start_time: 2026-04-03 09:35:55
success: True
trace_id: 9586818417434033869

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

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_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-payrix-prod/raw/mms_fee_summary/2026-04-17/1776436217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_fee_summary`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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-10 09:32:21",
        "disabled": false,
        "format": "raw",
        "id": 1915,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrix_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:30:35",
        "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_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-payrix-prod/raw/mms_fee_summary/2026-04-17/1776436217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_fee_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_fee_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}