Schema Info

Schema Name: sfdl_dev_csv.payrix_mms_fee_summary

created: 2024-07-03 14:01:26
disabled: False
format: raw
id: 2310
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 4773342

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-17/1776436433
id: 4773342
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: 2310
schema_scan_id: 6867679
updated: 2026-04-17 09:34:22

Version 4773277

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-16/1776349864
id: 4773277
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: 2310
schema_scan_id: 6867416
updated: 2026-04-16 09:32:03

Version 4773223

created: 2026-04-15 09:40:18

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-15/1776264003
id: 4773223
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: 2310
schema_scan_id: 6867176
updated: 2026-04-15 09:40:32

Version 4773164

created: 2026-04-14 09:44:27

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-14/1776177834
id: 4773164
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: 2310
schema_scan_id: 6866906
updated: 2026-04-14 09:44:41

Version 4773114

created: 2026-04-13 09:45:32

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-13/1776091527
id: 4773114
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: 2310
schema_scan_id: 6866688
updated: 2026-04-13 09:45:45

Version 4773038

created: 2026-04-12 09:27:52

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-12/1776004068
id: 4773038
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: 2310
schema_scan_id: 6866371
updated: 2026-04-12 09:28:03

Version 4773002

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-11/1775917806
id: 4773002
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: 2310
schema_scan_id: 6866261
updated: 2026-04-11 09:30:58

Version 4772940

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-10/1775831296
id: 4772940
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: 2310
schema_scan_id: 6865990
updated: 2026-04-10 09:28:46

Version 4772884

created: 2026-04-09 09:45:02

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-09/1775745895
id: 4772884
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: 2310
schema_scan_id: 6865766
updated: 2026-04-09 09:45:15

Version 4772843

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-08/1775659672
id: 4772843
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: 2310
schema_scan_id: 6865553
updated: 2026-04-08 09:48:14

Version 4772777

created: 2026-04-07 09:47:40

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-07/1775573211
id: 4772777
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: 2310
schema_scan_id: 6865279
updated: 2026-04-07 09:47:51

Version 4772715

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-06/1775486854
id: 4772715
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: 2310
schema_scan_id: 6864954
updated: 2026-04-06 09:48:16

Version 4772634

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-05/1775399190
id: 4772634
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: 2310
schema_scan_id: 6864618
updated: 2026-04-05 09:26:46

Version 4772601

created: 2026-04-04 09:43:27

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-04/1775313798
id: 4772601
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: 2310
schema_scan_id: 6864507
updated: 2026-04-04 09:43:38

Version 4772553

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

ddl:

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

hive_path: s3://sfdl-csv-payrix-dev/raw/mms_fee_summary/2026-04-03/1775228120
id: 4772553
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: 2310
schema_scan_id: 6864341
updated: 2026-04-03 09:55:54

Schema Scans: 15

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

Scan 6867679

duration: 0:00:14.429748

exit_message:

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

id: 6867679

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_fee_summary/2026-04-17/1776436433",
        "key": "raw/mms_fee_summary/2026-04-17/1776436433/e55796f6-778f-435c-b4e2-ae70f2d02020.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6593965021477855238,
        "service_name": "drive-thru",
        "span_id": 10329029803207077865,
        "trace_id": 4881131319925202832
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-17 09:34:07
success: True
trace_id: 4881131319925202832

Scan 6867416

duration: 0:00:14.486622

exit_message:

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

id: 6867416

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_fee_summary/2026-04-16/1776349864",
        "key": "raw/mms_fee_summary/2026-04-16/1776349864/03476909-8f8e-410b-9be8-63587240f593.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6321492333994639879,
        "service_name": "drive-thru",
        "span_id": 7498892898168953827,
        "trace_id": 15864916449788890574
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-16 09:31:48
success: True
trace_id: 15864916449788890574

Scan 6867176

duration: 0:00:14.500356

exit_message:

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

id: 6867176

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_fee_summary/2026-04-15/1776264003",
        "key": "raw/mms_fee_summary/2026-04-15/1776264003/eca09fb1-2c81-4343-a63a-ff8653cbee07.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4316284038583595513,
        "service_name": "drive-thru",
        "span_id": 12936622224744715848,
        "trace_id": 11630789841478975134
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-15 09:40:18
success: True
trace_id: 11630789841478975134

Scan 6866906

duration: 0:00:14.557192

exit_message:

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

id: 6866906

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_fee_summary/2026-04-14/1776177834",
        "key": "raw/mms_fee_summary/2026-04-14/1776177834/9edd621b-2fc9-401b-bc0f-d5930fc34166.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7307973390032644977,
        "service_name": "drive-thru",
        "span_id": 8153805908394554628,
        "trace_id": 13313656616555429530
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-14 09:44:26
success: True
trace_id: 13313656616555429530

Scan 6866688

duration: 0:00:14.310414

exit_message:

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

id: 6866688

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_fee_summary/2026-04-13/1776091527",
        "key": "raw/mms_fee_summary/2026-04-13/1776091527/23de6d10-d0b6-4184-8d9e-e780d8cb2a42.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11055362256137221650,
        "service_name": "drive-thru",
        "span_id": 16629465589259218412,
        "trace_id": 12757167414090206613
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-13 09:45:31
success: True
trace_id: 12757167414090206613

Scan 6866371

duration: 0:00:11.870256

exit_message:

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

id: 6866371

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_fee_summary/2026-04-12/1776004068",
        "key": "raw/mms_fee_summary/2026-04-12/1776004068/06a12c42-6cd5-4c61-8898-dd0f4dbe1bec.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5334991202969431171,
        "service_name": "drive-thru",
        "span_id": 5902968880563701801,
        "trace_id": 16946267119473858937
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-12 09:27:52
success: True
trace_id: 16946267119473858937

Scan 6866261

duration: 0:00:11.844172

exit_message:

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

id: 6866261

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_fee_summary/2026-04-11/1775917806",
        "key": "raw/mms_fee_summary/2026-04-11/1775917806/1489dd54-dcc0-4ff1-a379-5eb035177c63.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14751288192958714163,
        "service_name": "drive-thru",
        "span_id": 10798294502241396925,
        "trace_id": 6990993191155278334
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-11 09:30:46
success: True
trace_id: 6990993191155278334

Scan 6865990

duration: 0:00:14.352945

exit_message:

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

id: 6865990

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_fee_summary/2026-04-10/1775831296",
        "key": "raw/mms_fee_summary/2026-04-10/1775831296/6d897419-ca59-4313-9908-ab4f2a9b6738.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7149896887585519173,
        "service_name": "drive-thru",
        "span_id": 6085577856650760698,
        "trace_id": 12138021088365873963
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-10 09:28:31
success: True
trace_id: 12138021088365873963

Scan 6865766

duration: 0:00:14.398696

exit_message:

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

id: 6865766

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_fee_summary/2026-04-09/1775745895",
        "key": "raw/mms_fee_summary/2026-04-09/1775745895/2f7d9a68-f9fd-4c4d-b9e8-52d08e5fe147.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15953801643100977869,
        "service_name": "drive-thru",
        "span_id": 15907770093363819719,
        "trace_id": 1978953308695985661
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-09 09:45:01
success: True
trace_id: 1978953308695985661

Scan 6865553

duration: 0:00:12.024988

exit_message:

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

id: 6865553

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_fee_summary/2026-04-08/1775659672",
        "key": "raw/mms_fee_summary/2026-04-08/1775659672/dbddcfe0-2c3b-4475-ac5c-a62ff9523360.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5148036717712463057,
        "service_name": "drive-thru",
        "span_id": 7449995376778002430,
        "trace_id": 914185846178613796
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-08 09:48:03
success: True
trace_id: 914185846178613796

Scan 6865279

duration: 0:00:11.853941

exit_message:

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

id: 6865279

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_fee_summary/2026-04-07/1775573211",
        "key": "raw/mms_fee_summary/2026-04-07/1775573211/7d683873-f082-4ccd-bf20-5e15c7e97cf7.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11314179086379815357,
        "service_name": "drive-thru",
        "span_id": 10298005926670806645,
        "trace_id": 8450321264597458991
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-07 09:47:39
success: True
trace_id: 8450321264597458991

Scan 6864954

duration: 0:00:11.827428

exit_message:

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

id: 6864954

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_fee_summary/2026-04-06/1775486854",
        "key": "raw/mms_fee_summary/2026-04-06/1775486854/03cd80bc-f477-4c68-8b23-a87eee6c21cf.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8275207286616158460,
        "service_name": "drive-thru",
        "span_id": 4716963263315372094,
        "trace_id": 197665622590191416
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-06 09:48:04
success: True
trace_id: 197665622590191416

Scan 6864618

duration: 0:00:11.809220

exit_message:

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

id: 6864618

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_fee_summary/2026-04-05/1775399190",
        "key": "raw/mms_fee_summary/2026-04-05/1775399190/bf59b70b-f467-4341-af5b-2f8c1387c359.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4765676043221413707,
        "service_name": "drive-thru",
        "span_id": 7910693314041814223,
        "trace_id": 1110614499516742333
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-05 09:26:34
success: True
trace_id: 1110614499516742333

Scan 6864507

duration: 0:00:11.782297

exit_message:

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

id: 6864507

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_fee_summary/2026-04-04/1775313798",
        "key": "raw/mms_fee_summary/2026-04-04/1775313798/7c885e5f-ccaa-4830-88a4-1d000c11b6bd.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15614102860315490467,
        "service_name": "drive-thru",
        "span_id": 5902630805543396195,
        "trace_id": 13811114116017241095
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-04 09:43:26
success: True
trace_id: 13811114116017241095

Scan 6864341

duration: 0:00:14.463746

exit_message:

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

id: 6864341

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_fee_summary/2026-04-03/1775228120",
        "key": "raw/mms_fee_summary/2026-04-03/1775228120/886e4905-c322-44f3-9805-21cdcc838958.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15838528871240467530,
        "service_name": "drive-thru",
        "span_id": 6770019792615509780,
        "trace_id": 10573475236580651219
    }
}

running: False
schema_name_id: 2310
start_time: 2026-04-03 09:55:40
success: True
trace_id: 10573475236580651219

Partitions:

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

Schema:

attributes:

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

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

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_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-dev/raw/mms_fee_summary/2026-04-17/1776436433'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_fee_summary`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_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-03 14:01:26",
        "disabled": false,
        "format": "raw",
        "id": 2310,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:34:08",
        "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_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-dev/raw/mms_fee_summary/2026-04-17/1776436433'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrix_mms_fee_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrix_mms_fee_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}