Schema Info

Schema Name: sfdl_dev_csv.payrixess_mms_monthly_summary
  • created: 2024-07-22 13:07:13
  • disabled: False
  • format: raw
  • id: 2371
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_dev_csv",
        "table": "payrixess_mms_monthly_summary"
    }
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 09:48:44
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319
    • id: 4773359
    • 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: 2371
    • schema_scan_id: 6867760
    • updated: 2026-04-17 09:48:55
    • created: 2026-04-16 09:39:10
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-16/1776350345'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-16/1776350345
    • id: 4773293
    • 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: 2371
    • schema_scan_id: 6867523
    • updated: 2026-04-16 09:39:21
    • created: 2026-04-15 10:05:05
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-15/1776265500'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-15/1776265500
    • id: 4773244
    • 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: 2371
    • schema_scan_id: 6867282
    • updated: 2026-04-15 10:05:16
    • created: 2026-04-14 09:41:00
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-14/1776177655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-14/1776177655
    • id: 4773153
    • 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: 2371
    • schema_scan_id: 6866885
    • updated: 2026-04-14 09:41:11
    • created: 2026-04-13 09:49:07
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-13/1776091743'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-13/1776091743
    • id: 4773119
    • 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: 2371
    • schema_scan_id: 6866705
    • updated: 2026-04-13 09:49:21
    • created: 2026-04-12 09:28:38
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-12/1776004088'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-12/1776004088
    • id: 4773042
    • 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: 2371
    • schema_scan_id: 6866378
    • updated: 2026-04-12 09:28:49
    • created: 2026-04-11 09:47:01
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-11/1775918814'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-11/1775918814
    • id: 4773020
    • 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: 2371
    • schema_scan_id: 6866325
    • updated: 2026-04-11 09:47:15
    • created: 2026-04-10 09:26:52
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-10/1775831207'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-10/1775831207
    • id: 4772931
    • 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: 2371
    • schema_scan_id: 6865957
    • updated: 2026-04-10 09:27:03
    • created: 2026-04-09 09:48:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-09/1775746106'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-09/1775746106
    • id: 4772895
    • 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: 2371
    • schema_scan_id: 6865814
    • updated: 2026-04-09 09:49:02
    • created: 2026-04-08 09:45:41
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-08/1775659526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-08/1775659526
    • id: 4772836
    • 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: 2371
    • schema_scan_id: 6865528
    • updated: 2026-04-08 09:45:55
    • created: 2026-04-07 09:45:46
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-07/1775573132'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-07/1775573132
    • id: 4772771
    • 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: 2371
    • schema_scan_id: 6865271
    • updated: 2026-04-07 09:46:00
    • created: 2026-04-06 09:45:07
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-06/1775486702'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-06/1775486702
    • id: 4772709
    • 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: 2371
    • schema_scan_id: 6864926
    • updated: 2026-04-06 09:45:21
    • created: 2026-04-05 09:49:26
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-05/1775400553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-05/1775400553
    • id: 4772666
    • 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: 2371
    • schema_scan_id: 6864752
    • updated: 2026-04-05 09:49:39
    • created: 2026-04-04 09:26:24
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-04/1775312780'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-04/1775312780
    • id: 4772587
    • 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: 2371
    • schema_scan_id: 6864453
    • updated: 2026-04-04 09:26:38
    • created: 2026-04-03 09:30:29
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
          "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_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-payrixess-dev/raw/mms_monthly_summary/2026-04-03/1775226625'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-03/1775226625
    • id: 4772531
    • 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: 2371
    • schema_scan_id: 6864226
    • updated: 2026-04-03 09:30:42
Schema Scans: 15
Last at 2026-04-17 09:48:44
    • duration: 0:00:11.722474
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867760
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319",
              "key": "raw/mms_monthly_summary/2026-04-17/1776437319/1b1cdef7-d799-4230-9f95-dadc451d64af.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 2720274393470287594,
              "service_name": "drive-thru",
              "span_id": 16296435672280547327,
              "trace_id": 4637986838851078901
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-17 09:48:44
    • success: True
    • trace_id: 4637986838851078901
    • duration: 0:00:11.816418
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867523
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-16/1776350345",
              "key": "raw/mms_monthly_summary/2026-04-16/1776350345/7d0bcfb0-2ca0-4bdf-b027-8e66a9e51a7a.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8747347312314676318,
              "service_name": "drive-thru",
              "span_id": 5939489026902915086,
              "trace_id": 8085582421244234645
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-16 09:39:10
    • success: True
    • trace_id: 8085582421244234645
    • duration: 0:00:11.904415
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6867282
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-15/1776265500",
              "key": "raw/mms_monthly_summary/2026-04-15/1776265500/f292b4f5-e3ff-4d70-a369-3416a861fd87.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18198007320089722395,
              "service_name": "drive-thru",
              "span_id": 6615491359601905157,
              "trace_id": 14763044887648480335
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-15 10:05:04
    • success: True
    • trace_id: 14763044887648480335
    • duration: 0:00:11.865799
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866885
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-14/1776177655",
              "key": "raw/mms_monthly_summary/2026-04-14/1776177655/eea6845c-96e9-41de-a344-2afb782f93b2.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9030767911787656828,
              "service_name": "drive-thru",
              "span_id": 8095868304815633880,
              "trace_id": 9193301894693459394
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-14 09:40:59
    • success: True
    • trace_id: 9193301894693459394
    • duration: 0:00:14.449656
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866705
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-13/1776091743",
              "key": "raw/mms_monthly_summary/2026-04-13/1776091743/a85f7c89-c795-4f92-ab83-a842cc5bf0d7.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 5458416371622804377,
              "service_name": "drive-thru",
              "span_id": 2197235123552781887,
              "trace_id": 14835443441067090094
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-13 09:49:07
    • success: True
    • trace_id: 14835443441067090094
    • duration: 0:00:11.746869
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866378
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-12/1776004088",
              "key": "raw/mms_monthly_summary/2026-04-12/1776004088/1e211769-749d-470a-b5f2-b3f609c60a3b.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1295762351437800789,
              "service_name": "drive-thru",
              "span_id": 13681207217901942456,
              "trace_id": 10501696303829978049
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-12 09:28:38
    • success: True
    • trace_id: 10501696303829978049
    • duration: 0:00:14.349133
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6866325
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-11/1775918814",
              "key": "raw/mms_monthly_summary/2026-04-11/1775918814/bc228e62-0cdf-4458-967f-043ad40a60c1.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 4275556056971406366,
              "service_name": "drive-thru",
              "span_id": 8117624709608065469,
              "trace_id": 17832028809252035730
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-11 09:47:00
    • success: True
    • trace_id: 17832028809252035730
    • duration: 0:00:11.758943
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865957
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-10/1775831207",
              "key": "raw/mms_monthly_summary/2026-04-10/1775831207/30793aa3-9fe1-482e-9fee-2c984befcabe.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 2572017381028130943,
              "service_name": "drive-thru",
              "span_id": 17834838062202810718,
              "trace_id": 4686087119585048183
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-10 09:26:51
    • success: True
    • trace_id: 4686087119585048183
    • duration: 0:00:11.810305
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865814
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-09/1775746106",
              "key": "raw/mms_monthly_summary/2026-04-09/1775746106/bec585e4-73b8-4c92-900c-b0fbdce7c9a0.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 6053825121424166318,
              "service_name": "drive-thru",
              "span_id": 1600191557757414123,
              "trace_id": 5557227644270062287
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-09 09:48:51
    • success: True
    • trace_id: 5557227644270062287
    • duration: 0:00:14.367639
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865528
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-08/1775659526",
              "key": "raw/mms_monthly_summary/2026-04-08/1775659526/2ae61d21-ecb9-4cdb-ac11-fb0e00b8b2a9.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9865209075953183966,
              "service_name": "drive-thru",
              "span_id": 17739252090413495542,
              "trace_id": 4901874400627635642
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-08 09:45:41
    • success: True
    • trace_id: 4901874400627635642
    • duration: 0:00:14.561518
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6865271
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-07/1775573132",
              "key": "raw/mms_monthly_summary/2026-04-07/1775573132/797e2b0b-0883-4098-b6eb-1ba78606d119.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17911171074878539580,
              "service_name": "drive-thru",
              "span_id": 18187930358875505659,
              "trace_id": 4589388226993789951
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-07 09:45:46
    • success: True
    • trace_id: 4589388226993789951
    • duration: 0:00:14.321839
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864926
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-06/1775486702",
              "key": "raw/mms_monthly_summary/2026-04-06/1775486702/737b8a1a-58ff-4e05-9a4e-2e6004820303.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18062135208442129186,
              "service_name": "drive-thru",
              "span_id": 7915771757583519760,
              "trace_id": 6726916109566435878
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-06 09:45:06
    • success: True
    • trace_id: 6726916109566435878
    • duration: 0:00:14.400448
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864752
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-05/1775400553",
              "key": "raw/mms_monthly_summary/2026-04-05/1775400553/dc2c67a5-83ae-4ee6-80e9-28c7100cc26d.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 5617468254977201911,
              "service_name": "drive-thru",
              "span_id": 1272728899943814300,
              "trace_id": 16811867399635353176
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-05 09:49:25
    • success: True
    • trace_id: 16811867399635353176
    • duration: 0:00:14.333136
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864453
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-04/1775312780",
              "key": "raw/mms_monthly_summary/2026-04-04/1775312780/bee04e1a-8f99-411c-a9a1-3c810d432b8e.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9841759065185411734,
              "service_name": "drive-thru",
              "span_id": 14183543131930442108,
              "trace_id": 4022802306877530782
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-04 09:26:24
    • success: True
    • trace_id: 4022802306877530782
    • duration: 0:00:14.363257
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6864226
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-dev",
              "hive_path": "s3://sfdl-csv-payrixess-dev/raw/mms_monthly_summary/2026-04-03/1775226625",
              "key": "raw/mms_monthly_summary/2026-04-03/1775226625/94f3372c-0285-4aff-9fe0-39066cb52eb2.csv.gz"
          },
          "schema": {
              "name": "sfdl_dev_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9636077257276703752,
              "service_name": "drive-thru",
              "span_id": 4050323852524252998,
              "trace_id": 1788429174569367699
          }
      }
    • running: False
    • schema_name_id: 2371
    • start_time: 2026-04-03 09:30:28
    • success: True
    • trace_id: 1788429174569367699
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:48:44
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_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-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
        "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_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-22 13:07:13",
        "disabled": false,
        "format": "raw",
        "id": 2371,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "payrixess_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:48:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.payrixess_mms_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-payrixess-dev/raw/mms_monthly_summary/2026-04-17/1776437319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.payrixess_mms_monthly_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.payrixess_mms_monthly_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}