Schema Info

Schema Name: sfdl_prod_csv.payrix_mms_monthly_summary
  • created: 2024-07-10 09:32:06
  • disabled: False
  • format: raw
  • id: 1914
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_prod_csv",
        "table": "payrix_mms_monthly_summary"
    }
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 09:26:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012
    • id: 1718235
    • 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: 1914
    • schema_scan_id: 162178346
    • updated: 2026-04-17 09:27:09
    • created: 2026-04-16 09:27:13
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628
    • id: 1717017
    • 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: 1914
    • schema_scan_id: 162122654
    • updated: 2026-04-16 09:27:24
    • created: 2026-04-15 11:28:09
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463
    • id: 1715885
    • 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: 1914
    • schema_scan_id: 162072820
    • updated: 2026-04-15 11:28:23
    • created: 2026-04-14 21:06:49
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795
    • id: 1714943
    • 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: 1914
    • schema_scan_id: 162046338
    • updated: 2026-04-14 21:07:03
    • created: 2026-04-13 09:52:14
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773
    • id: 1713443
    • 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: 1914
    • schema_scan_id: 161954352
    • updated: 2026-04-13 09:52:25
    • created: 2026-04-12 09:44:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072
    • id: 1712250
    • 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: 1914
    • schema_scan_id: 161903650
    • updated: 2026-04-12 09:44:48
    • created: 2026-04-11 09:43:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610
    • id: 1711026
    • 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: 1914
    • schema_scan_id: 161852103
    • updated: 2026-04-11 09:43:47
    • created: 2026-04-10 09:46:14
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251
    • id: 1709860
    • 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: 1914
    • schema_scan_id: 161797549
    • updated: 2026-04-10 09:46:28
    • created: 2026-04-09 09:27:50
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866
    • id: 1708675
    • 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: 1914
    • schema_scan_id: 161741333
    • updated: 2026-04-09 09:28:01
    • created: 2026-04-08 09:50:09
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658
    • id: 1707535
    • 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: 1914
    • schema_scan_id: 161686836
    • updated: 2026-04-08 09:50:23
    • created: 2026-04-07 09:45:28
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123
    • id: 1706334
    • 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: 1914
    • schema_scan_id: 161630624
    • updated: 2026-04-07 09:45:42
    • created: 2026-04-06 09:30:17
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806
    • id: 1705084
    • 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: 1914
    • schema_scan_id: 161572758
    • updated: 2026-04-06 09:30:28
    • created: 2026-04-05 09:45:48
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344
    • id: 1703887
    • 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: 1914
    • schema_scan_id: 161523963
    • updated: 2026-04-05 09:45:59
    • created: 2026-04-04 10:03:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917
    • id: 1702746
    • 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: 1914
    • schema_scan_id: 161474317
    • updated: 2026-04-04 10:04:05
    • created: 2026-04-03 09:28:36
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
          "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511
    • id: 1701510
    • 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: 1914
    • schema_scan_id: 161414301
    • updated: 2026-04-03 09:28:48
Schema Scans: 15
Last at 2026-04-17 09:26:58
    • duration: 0:00:11.833895
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162178346
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012",
              "key": "raw/mms_monthly_summary/2026-04-17/1776436012/5ea27689-0e48-4dfe-9aeb-496cd8c8102d.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17072314771495368869,
              "service_name": "drive-thru",
              "span_id": 4118141906635093823,
              "trace_id": 9248437058451748027
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-17 09:26:58
    • success: True
    • trace_id: 9248437058451748027
    • duration: 0:00:11.843492
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162122654
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-16/1776349628",
              "key": "raw/mms_monthly_summary/2026-04-16/1776349628/93fb0d36-afcf-47da-a0fa-43c302c9f274.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 15039197422514931203,
              "service_name": "drive-thru",
              "span_id": 16572463817953393543,
              "trace_id": 14048474190340800768
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-16 09:27:12
    • success: True
    • trace_id: 14048474190340800768
    • duration: 0:00:14.388997
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162072820
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-15/1776270463",
              "key": "raw/mms_monthly_summary/2026-04-15/1776270463/cdcbf06d-6957-4d06-919b-5963fbed1782.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 16559887651165163825,
              "service_name": "drive-thru",
              "span_id": 15480152146369961424,
              "trace_id": 12913757506220339138
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-15 11:28:09
    • success: True
    • trace_id: 12913757506220339138
    • duration: 0:00:14.518439
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162046338
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-14/1776218795",
              "key": "raw/mms_monthly_summary/2026-04-14/1776218795/a8fcd5bd-6771-4ea6-9acd-fbf80e669d1f.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 12471555937220713124,
              "service_name": "drive-thru",
              "span_id": 521873819455204715,
              "trace_id": 12494620324134275196
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-14 21:06:48
    • success: True
    • trace_id: 12494620324134275196
    • duration: 0:00:11.888098
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161954352
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-13/1776091773",
              "key": "raw/mms_monthly_summary/2026-04-13/1776091773/f1294be0-3ce1-44ff-bd45-a8bde9fbfb4d.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 6242858551872610855,
              "service_name": "drive-thru",
              "span_id": 4307555726860482605,
              "trace_id": 17408383814193433301
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-13 09:52:13
    • success: True
    • trace_id: 17408383814193433301
    • duration: 0:00:11.669126
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161903650
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-12/1776005072",
              "key": "raw/mms_monthly_summary/2026-04-12/1776005072/b3fceea0-4c64-488e-87b7-5ef219051d9c.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13806734064598577460,
              "service_name": "drive-thru",
              "span_id": 18076158281859051805,
              "trace_id": 4456360837694579743
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-12 09:44:37
    • success: True
    • trace_id: 4456360837694579743
    • duration: 0:00:11.747512
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161852103
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-11/1775918610",
              "key": "raw/mms_monthly_summary/2026-04-11/1775918610/2a06a6d5-aead-4d3c-8f57-ab22602c0f88.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10873868372674010062,
              "service_name": "drive-thru",
              "span_id": 12057891019167161391,
              "trace_id": 2637008250381215344
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-11 09:43:35
    • success: True
    • trace_id: 2637008250381215344
    • duration: 0:00:14.379750
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161797549
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-10/1775832251",
              "key": "raw/mms_monthly_summary/2026-04-10/1775832251/6910824d-b388-4931-96b9-a368f32d7236.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 12724830952887729783,
              "service_name": "drive-thru",
              "span_id": 1225585330038387085,
              "trace_id": 3789284457738349150
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-10 09:46:13
    • success: True
    • trace_id: 3789284457738349150
    • duration: 0:00:11.798584
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161741333
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-09/1775744866",
              "key": "raw/mms_monthly_summary/2026-04-09/1775744866/c62d07b6-2d03-48ab-bb4a-f2a0d40ea9d7.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10845539750888096139,
              "service_name": "drive-thru",
              "span_id": 3261734393068711896,
              "trace_id": 11771560639288826531
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-09 09:27:50
    • success: True
    • trace_id: 11771560639288826531
    • duration: 0:00:14.323882
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161686836
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-08/1775659658",
              "key": "raw/mms_monthly_summary/2026-04-08/1775659658/0aa28b4a-7feb-4661-b1e2-bc41df9e0e74.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17834089895043479566,
              "service_name": "drive-thru",
              "span_id": 4183544044775194834,
              "trace_id": 12392105760606284984
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-08 09:50:09
    • success: True
    • trace_id: 12392105760606284984
    • duration: 0:00:14.350716
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161630624
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-07/1775573123",
              "key": "raw/mms_monthly_summary/2026-04-07/1775573123/32c8bf03-731d-447c-a832-2c7fd191a5db.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 3102465936866037917,
              "service_name": "drive-thru",
              "span_id": 5635168398145217657,
              "trace_id": 14156803913226001252
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-07 09:45:28
    • success: True
    • trace_id: 14156803913226001252
    • duration: 0:00:11.808469
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161572758
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-06/1775485806",
              "key": "raw/mms_monthly_summary/2026-04-06/1775485806/7c820b8c-c2b6-461b-87de-cea0f0611f85.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8063461533810955430,
              "service_name": "drive-thru",
              "span_id": 18183108752093164844,
              "trace_id": 14091142344964438469
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-06 09:30:16
    • success: True
    • trace_id: 14091142344964438469
    • duration: 0:00:11.727458
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161523963
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-05/1775400344",
              "key": "raw/mms_monthly_summary/2026-04-05/1775400344/a3f39f49-6d1c-40e4-ab16-7dfc8114de74.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 13107823339717553483,
              "service_name": "drive-thru",
              "span_id": 2379344228054842287,
              "trace_id": 17037603973870812299
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-05 09:45:48
    • success: True
    • trace_id: 17037603973870812299
    • duration: 0:00:14.358681
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161474317
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-04/1775314917",
              "key": "raw/mms_monthly_summary/2026-04-04/1775314917/876548ab-6fbc-4695-8f23-cb8c8765c684.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 3486704146638080589,
              "service_name": "drive-thru",
              "span_id": 911598645647641721,
              "trace_id": 10162517720852521414
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-04 10:03:51
    • success: True
    • trace_id: 10162517720852521414
    • duration: 0:00:11.759326
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161414301
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrix-prod",
              "hive_path": "s3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-03/1775226511",
              "key": "raw/mms_monthly_summary/2026-04-03/1775226511/cf8f4a59-f404-436d-8763-3949a2841587.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_csv.payrix_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17224149978860508701,
              "service_name": "drive-thru",
              "span_id": 4473824256674829408,
              "trace_id": 10581407894775704181
          }
      }
    • running: False
    • schema_name_id: 1914
    • start_time: 2026-04-03 09:28:36
    • success: True
    • trace_id: 10581407894775704181
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:26:58
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
        "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_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-10 09:32:06",
        "disabled": false,
        "format": "raw",
        "id": 1914,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "payrix_mms_monthly_summary"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "base": "string",
            "count": "string",
            "entity": "string",
            "month": "string",
            "sum": "string",
            "tag": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:26:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.payrix_mms_monthly_summary`\n(\n `year`  string , `month`  string , `entity`  string , `base`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-prod/raw/mms_monthly_summary/2026-04-17/1776436012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.payrix_mms_monthly_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.payrix_mms_monthly_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}