Schema Info

Schema Name: sfdl_dev_csv.payrix_mms_monthly_summary

created: 2024-07-03 13:59:55
disabled: False
format: raw
id: 2304
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773334

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-17/1776436081'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-17/1776436081
id: 4773334
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6867665
updated: 2026-04-17 09:28:23

Version 4773273

created: 2026-04-16 09:30:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-16/1776349839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-16/1776349839
id: 4773273
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6867409
updated: 2026-04-16 09:31:03

Version 4773219

created: 2026-04-15 09:36:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-15/1776263769'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-15/1776263769
id: 4773219
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6867172
updated: 2026-04-15 09:36:32

Version 4773177

created: 2026-04-14 10:02:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-14/1776178947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-14/1776178947
id: 4773177
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6866993
updated: 2026-04-14 10:02:52

Version 4773092

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-13/1776090504'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-13/1776090504
id: 4773092
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6866576
updated: 2026-04-13 09:28:48

Version 4773040

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-12/1776004075'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-12/1776004075
id: 4773040
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6866373
updated: 2026-04-12 09:28:24

Version 4772997

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-11/1775917770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-11/1775917770
id: 4772997
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6866243
updated: 2026-04-11 09:30:06

Version 4772950

created: 2026-04-10 09:39:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-10/1775831988'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-10/1775831988
id: 4772950
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6866069
updated: 2026-04-10 09:40:07

Version 4772887

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-09/1775745944'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-09/1775745944
id: 4772887
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6865783
updated: 2026-04-09 09:46:20

Version 4772810

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-08/1775658392'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-08/1775658392
id: 4772810
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6865410
updated: 2026-04-08 09:26:55

Version 4772773

created: 2026-04-07 09:46:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-07/1775573183'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-07/1775573183
id: 4772773
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6865274
updated: 2026-04-07 09:46:39

Version 4772687

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-06/1775485799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-06/1775485799
id: 4772687
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6864829
updated: 2026-04-06 09:30:21

Version 4772655

created: 2026-04-05 09:47:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-05/1775400431'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-05/1775400431
id: 4772655
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6864727
updated: 2026-04-05 09:47:46

Version 4772616

created: 2026-04-04 09:55:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-04/1775314517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-04/1775314517
id: 4772616
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6864577
updated: 2026-04-04 09:55:58

Version 4772558

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-03/1775228435'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
]

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-03/1775228435
id: 4772558
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 2304
schema_scan_id: 6864347
updated: 2026-04-03 10:00:51

Schema Scans: 15

Last at 2026-04-17 09:28:11

Scan 6867665

duration: 0:00:11.870039

exit_message:

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

id: 6867665

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-17/1776436081",
        "key": "raw/mms_monthly_summary/2026-04-17/1776436081/bd89412e-e7b8-400b-b3ae-0e2aaabfb272.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11928609416060259949,
        "service_name": "drive-thru",
        "span_id": 6328511557416945241,
        "trace_id": 4438851457651288577
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-17 09:28:11
success: True
trace_id: 4438851457651288577

Scan 6867409

duration: 0:00:12.180740

exit_message:

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

id: 6867409

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-16/1776349839",
        "key": "raw/mms_monthly_summary/2026-04-16/1776349839/cf6cdeb0-8c9c-4df5-99b8-6c879d962340.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6027461864399279961,
        "service_name": "drive-thru",
        "span_id": 16547155133905898478,
        "trace_id": 17037309430413077323
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-16 09:30:51
success: True
trace_id: 17037309430413077323

Scan 6867172

duration: 0:00:12.006728

exit_message:

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

id: 6867172

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-15/1776263769",
        "key": "raw/mms_monthly_summary/2026-04-15/1776263769/14f3b0bb-cb1d-4340-9283-fe3fb6b5fd17.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16532618891665222851,
        "service_name": "drive-thru",
        "span_id": 10341245684946744746,
        "trace_id": 4247403081448109934
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-15 09:36:20
success: True
trace_id: 4247403081448109934

Scan 6866993

duration: 0:00:11.950025

exit_message:

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

id: 6866993

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-14/1776178947",
        "key": "raw/mms_monthly_summary/2026-04-14/1776178947/777be244-5ca9-44df-9ad4-fecc0e9b69d5.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15704450012313330106,
        "service_name": "drive-thru",
        "span_id": 11472930560151892820,
        "trace_id": 6215931917785660728
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-14 10:02:40
success: True
trace_id: 6215931917785660728

Scan 6866576

duration: 0:00:11.839649

exit_message:

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

id: 6866576

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-13/1776090504",
        "key": "raw/mms_monthly_summary/2026-04-13/1776090504/bde3d06e-f1c4-48db-b217-220964c198c0.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5178846649464633122,
        "service_name": "drive-thru",
        "span_id": 2974244631122868195,
        "trace_id": 9982645951525811400
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-13 09:28:36
success: True
trace_id: 9982645951525811400

Scan 6866373

duration: 0:00:14.364273

exit_message:

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

id: 6866373

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-12/1776004075",
        "key": "raw/mms_monthly_summary/2026-04-12/1776004075/27fc3787-3d56-4ff2-bcd2-9e181f63cd11.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10843066849616518950,
        "service_name": "drive-thru",
        "span_id": 4051476846678785688,
        "trace_id": 8250905416511648008
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-12 09:28:10
success: True
trace_id: 8250905416511648008

Scan 6866243

duration: 0:00:11.749289

exit_message:

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

id: 6866243

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-11/1775917770",
        "key": "raw/mms_monthly_summary/2026-04-11/1775917770/cbb7233a-19b5-4606-b91c-ec68a5924287.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18336800621243516911,
        "service_name": "drive-thru",
        "span_id": 7348307968550912143,
        "trace_id": 8503346905019056991
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-11 09:29:54
success: True
trace_id: 8503346905019056991

Scan 6866069

duration: 0:00:14.362426

exit_message:

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

id: 6866069

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-10/1775831988",
        "key": "raw/mms_monthly_summary/2026-04-10/1775831988/7e35f27c-8cfc-43b5-b483-602de513db98.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15632333197316894825,
        "service_name": "drive-thru",
        "span_id": 12300975996051409616,
        "trace_id": 12707444772030013848
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-10 09:39:52
success: True
trace_id: 12707444772030013848

Scan 6865783

duration: 0:00:14.505432

exit_message:

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

id: 6865783

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-09/1775745944",
        "key": "raw/mms_monthly_summary/2026-04-09/1775745944/3d130716-d663-4980-bc11-2690f2ea6de0.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 481986431994221526,
        "service_name": "drive-thru",
        "span_id": 3740857576556734937,
        "trace_id": 10236352004255045876
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-09 09:46:06
success: True
trace_id: 10236352004255045876

Scan 6865410

duration: 0:00:11.729493

exit_message:

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

id: 6865410

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-08/1775658392",
        "key": "raw/mms_monthly_summary/2026-04-08/1775658392/6d8b5f4d-d2ec-43da-a552-546ffb90755a.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 523578224084446922,
        "service_name": "drive-thru",
        "span_id": 4381279438507899969,
        "trace_id": 17544649223562824205
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-08 09:26:44
success: True
trace_id: 17544649223562824205

Scan 6865274

duration: 0:00:11.838068

exit_message:

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

id: 6865274

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-07/1775573183",
        "key": "raw/mms_monthly_summary/2026-04-07/1775573183/8bea9704-398a-434b-b403-bec6d07bc554.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15850008848674802384,
        "service_name": "drive-thru",
        "span_id": 7454374374282308004,
        "trace_id": 11240127978810526424
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-07 09:46:27
success: True
trace_id: 11240127978810526424

Scan 6864829

duration: 0:00:14.445550

exit_message:

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

id: 6864829

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-06/1775485799",
        "key": "raw/mms_monthly_summary/2026-04-06/1775485799/770fd07e-bcaa-45e7-8a1b-3566656c5830.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2148897459509366481,
        "service_name": "drive-thru",
        "span_id": 13835369585817772335,
        "trace_id": 15756467510962397471
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-06 09:30:07
success: True
trace_id: 15756467510962397471

Scan 6864727

duration: 0:00:11.809943

exit_message:

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

id: 6864727

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-05/1775400431",
        "key": "raw/mms_monthly_summary/2026-04-05/1775400431/3ec82d56-ab42-42a2-8f1e-80faec1a59e6.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4737421828997641173,
        "service_name": "drive-thru",
        "span_id": 6978012055266968316,
        "trace_id": 13088577755774257486
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-05 09:47:35
success: True
trace_id: 13088577755774257486

Scan 6864577

duration: 0:00:14.511466

exit_message:

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

id: 6864577

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-04/1775314517",
        "key": "raw/mms_monthly_summary/2026-04-04/1775314517/e759e48b-204e-4822-b8ef-db93cd834302.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12364416260779925279,
        "service_name": "drive-thru",
        "span_id": 10654140089018127667,
        "trace_id": 11803494188372222658
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-04 09:55:44
success: True
trace_id: 11803494188372222658

Scan 6864347

duration: 0:00:11.979262

exit_message:

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

id: 6864347

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-dev",
        "hive_path": "s3://sfdl-csv-payrix-dev/raw/mms_monthly_summary/2026-04-03/1775228435",
        "key": "raw/mms_monthly_summary/2026-04-03/1775228435/81b714ac-0c44-4ddd-bb34-60acd912eba7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_monthly_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7085506039965013000,
        "service_name": "drive-thru",
        "span_id": 2262441554213192993,
        "trace_id": 2718955339379713735
    }
}

running: False
schema_name_id: 2304
start_time: 2026-04-03 10:00:39
success: True
trace_id: 2718955339379713735

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-17/1776436081'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_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-03 13:59:55",
        "disabled": false,
        "format": "raw",
        "id": 2304,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrix_mms_monthly_summary"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "base": "string",
            "count": "string",
            "entity": "string",
            "month": "string",
            "sum": "string",
            "tag": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:28:11",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  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-dev/raw/mms_monthly_summary/2026-04-17/1776436081'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_monthly_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_monthly_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}