Schema Info

Schema Name: sfdl_prod_csv.payrixess_mms_monthly_summary
  • created: 2024-07-24 10:21:33
  • disabled: False
  • format: raw
  • id: 1965
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_prod_csv",
        "table": "payrixess_mms_monthly_summary"
    }
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 09:35:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513
    • id: 1718263
    • 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: 1965
    • schema_scan_id: 162178500
    • updated: 2026-04-17 09:35:31
    • created: 2026-04-16 09:47:16
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-16/1776350831'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-16/1776350831
    • id: 1717058
    • 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: 1965
    • schema_scan_id: 162122998
    • updated: 2026-04-16 09:47:28
    • created: 2026-04-15 09:44:35
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-15/1776264269'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-15/1776264269
    • id: 1715833
    • 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: 1965
    • schema_scan_id: 162067355
    • updated: 2026-04-15 09:44:46
    • created: 2026-04-14 09:28:46
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-14/1776176920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-14/1776176920
    • id: 1714620
    • 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: 1965
    • schema_scan_id: 162011148
    • updated: 2026-04-14 09:28:58
    • created: 2026-04-13 09:51:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-13/1776091797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-13/1776091797
    • id: 1713442
    • 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: 1965
    • schema_scan_id: 161954323
    • updated: 2026-04-13 09:52:12
    • created: 2026-04-12 09:38:42
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-12/1776004718'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-12/1776004718
    • id: 1712234
    • 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: 1965
    • schema_scan_id: 161903614
    • updated: 2026-04-12 09:38:54
    • created: 2026-04-11 09:26:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-11/1775917612'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-11/1775917612
    • id: 1711006
    • 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: 1965
    • schema_scan_id: 161851934
    • updated: 2026-04-11 09:27:12
    • created: 2026-04-10 09:28:01
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-10/1775831275'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-10/1775831275
    • id: 1709837
    • 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: 1965
    • schema_scan_id: 161797279
    • updated: 2026-04-10 09:28:12
    • created: 2026-04-09 09:34:11
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-09/1775745248'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-09/1775745248
    • id: 1708693
    • 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: 1965
    • schema_scan_id: 161741424
    • updated: 2026-04-09 09:34:22
    • created: 2026-04-08 09:31:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-08/1775658713'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-08/1775658713
    • id: 1707506
    • 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: 1965
    • schema_scan_id: 161686232
    • updated: 2026-04-08 09:32:12
    • created: 2026-04-07 09:46:26
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-07/1775573181'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-07/1775573181
    • id: 1706338
    • 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: 1965
    • schema_scan_id: 161630693
    • updated: 2026-04-07 09:46:40
    • created: 2026-04-06 09:26:47
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-06/1775485602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-06/1775485602
    • id: 1705079
    • 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: 1965
    • schema_scan_id: 161572670
    • updated: 2026-04-06 09:27:01
    • created: 2026-04-05 09:47:53
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-05/1775400455'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-05/1775400455
    • id: 1703893
    • 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: 1965
    • schema_scan_id: 161524059
    • updated: 2026-04-05 09:48:07
    • created: 2026-04-04 09:37:43
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-04/1775313459'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-04/1775313459
    • id: 1702721
    • 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: 1965
    • schema_scan_id: 161471777
    • updated: 2026-04-04 09:37:54
    • created: 2026-04-03 09:29:01
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-03/1775226535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-03/1775226535
    • id: 1701513
    • 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: 1965
    • schema_scan_id: 161414309
    • updated: 2026-04-03 09:29:12
Schema Scans: 15
Last at 2026-04-17 09:35:17
    • duration: 0:00:14.358675
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162178500
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-17/1776436513",
              "key": "raw/mms_monthly_summary/2026-04-17/1776436513/ad33637e-09a6-4d9c-ac7a-2e408f24bb77.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1221299587262487035,
              "service_name": "drive-thru",
              "span_id": 1987634841990887852,
              "trace_id": 1659763443130009508
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-17 09:35:17
    • success: True
    • trace_id: 1659763443130009508
    • duration: 0:00:11.834564
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162122998
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-16/1776350831",
              "key": "raw/mms_monthly_summary/2026-04-16/1776350831/493f3fe5-207f-4b0f-ae21-d9880a6370f3.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9215419138643730667,
              "service_name": "drive-thru",
              "span_id": 10540854889006299921,
              "trace_id": 4160898806127030824
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-16 09:47:16
    • success: True
    • trace_id: 4160898806127030824
    • duration: 0:00:11.897970
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162067355
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-15/1776264269",
              "key": "raw/mms_monthly_summary/2026-04-15/1776264269/889882fa-976c-438c-909c-e3f5ddb5a33d.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10597030881437064207,
              "service_name": "drive-thru",
              "span_id": 16859381275546709555,
              "trace_id": 2405117821374439674
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-15 09:44:35
    • success: True
    • trace_id: 2405117821374439674
    • duration: 0:00:11.766754
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162011148
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-14/1776176920",
              "key": "raw/mms_monthly_summary/2026-04-14/1776176920/45fa6cce-a0b5-45fd-81c6-2b16e5cff4e0.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13773243625241839517,
              "service_name": "drive-thru",
              "span_id": 15723545768593997514,
              "trace_id": 164381269902586066
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-14 09:28:46
    • success: True
    • trace_id: 164381269902586066
    • duration: 0:00:14.397260
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161954323
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-13/1776091797",
              "key": "raw/mms_monthly_summary/2026-04-13/1776091797/1403d292-9c8d-4f49-9bff-f2b69e0a9b71.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 2305074691541413771,
              "service_name": "drive-thru",
              "span_id": 8295664508162186853,
              "trace_id": 2313370152605560580
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-13 09:51:58
    • success: True
    • trace_id: 2313370152605560580
    • duration: 0:00:11.904500
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161903614
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-12/1776004718",
              "key": "raw/mms_monthly_summary/2026-04-12/1776004718/22b9fb1f-c15f-4404-bc20-b12fe4b5918a.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 11341381004364223414,
              "service_name": "drive-thru",
              "span_id": 7178731572674200082,
              "trace_id": 7572365433425732746
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-12 09:38:42
    • success: True
    • trace_id: 7572365433425732746
    • duration: 0:00:14.260545
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161851934
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-11/1775917612",
              "key": "raw/mms_monthly_summary/2026-04-11/1775917612/8b15eb00-f5fd-4788-aec8-617d476918dc.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10557709950695404614,
              "service_name": "drive-thru",
              "span_id": 17807199609178366179,
              "trace_id": 16587399893972472007
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-11 09:26:57
    • success: True
    • trace_id: 16587399893972472007
    • duration: 0:00:11.820386
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161797279
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-10/1775831275",
              "key": "raw/mms_monthly_summary/2026-04-10/1775831275/6c097c24-3fd4-4d14-90e7-f3d270c9699b.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 14688208589992605847,
              "service_name": "drive-thru",
              "span_id": 886335102559547123,
              "trace_id": 10531868880276817932
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-10 09:28:01
    • success: True
    • trace_id: 10531868880276817932
    • duration: 0:00:11.755155
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161741424
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-09/1775745248",
              "key": "raw/mms_monthly_summary/2026-04-09/1775745248/8ef89411-2ecb-44c7-98db-e8f1fb8e9c1c.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10520003464595094513,
              "service_name": "drive-thru",
              "span_id": 5014730387134274789,
              "trace_id": 11123155070296356213
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-09 09:34:11
    • success: True
    • trace_id: 11123155070296356213
    • duration: 0:00:14.284101
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161686232
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-08/1775658713",
              "key": "raw/mms_monthly_summary/2026-04-08/1775658713/925208d2-29ff-4e2c-b6de-c126ed1cc84e.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 2544130644197517043,
              "service_name": "drive-thru",
              "span_id": 14727288385556681142,
              "trace_id": 3289528424327468583
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-08 09:31:58
    • success: True
    • trace_id: 3289528424327468583
    • duration: 0:00:14.344608
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161630693
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-07/1775573181",
              "key": "raw/mms_monthly_summary/2026-04-07/1775573181/2c49f7b5-5d4a-4629-b21a-48f80e9917dd.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 12853749081867021536,
              "service_name": "drive-thru",
              "span_id": 15007114896757039727,
              "trace_id": 15671821461691960567
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-07 09:46:26
    • success: True
    • trace_id: 15671821461691960567
    • duration: 0:00:14.365063
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161572670
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-06/1775485602",
              "key": "raw/mms_monthly_summary/2026-04-06/1775485602/b2593c2c-a752-496e-87a2-f824888f52ec.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18142366993077654643,
              "service_name": "drive-thru",
              "span_id": 3919220758916600692,
              "trace_id": 13041844745486691089
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-06 09:26:47
    • success: True
    • trace_id: 13041844745486691089
    • duration: 0:00:14.319870
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161524059
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-05/1775400455",
              "key": "raw/mms_monthly_summary/2026-04-05/1775400455/413e061e-e4a8-4e2b-9f39-84f27990518c.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 6340329481787592551,
              "service_name": "drive-thru",
              "span_id": 13530473902962330554,
              "trace_id": 2719883764076441502
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-05 09:47:53
    • success: True
    • trace_id: 2719883764076441502
    • duration: 0:00:11.716487
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161471777
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-04/1775313459",
              "key": "raw/mms_monthly_summary/2026-04-04/1775313459/18981d48-52e4-4cbd-bd99-d2aa8d34f597.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 1456145966113597765,
              "service_name": "drive-thru",
              "span_id": 12160611663483381385,
              "trace_id": 10498603681440641402
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-04 09:37:43
    • success: True
    • trace_id: 10498603681440641402
    • duration: 0:00:11.800978
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161414309
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-prod",
              "hive_path": "s3://sfdl-csv-payrixess-prod/raw/mms_monthly_summary/2026-04-03/1775226535",
              "key": "raw/mms_monthly_summary/2026-04-03/1775226535/496fba0b-2025-41ce-8767-fa0c9e400ea4.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 7587538466625229312,
              "service_name": "drive-thru",
              "span_id": 18280314063140922702,
              "trace_id": 13896681460953186075
          }
      }
    • running: False
    • schema_name_id: 1965
    • start_time: 2026-04-03 09:29:00
    • success: True
    • trace_id: 13896681460953186075
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:35:17
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
        "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
    }
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw:
{
    "name": {
        "created": "2024-07-24 10:21:33",
        "disabled": false,
        "format": "raw",
        "id": 1965,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:35:17",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/mms_monthly_summary/2026-04-17/1776436513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrixess_mms_monthly_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrixess_mms_monthly_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}