Schema Info

Schema Name: sfdl_stage_csv.payrixess_mms_monthly_summary
  • created: 2024-07-22 13:21:12
  • disabled: False
  • format: raw
  • id: 2183
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_stage_csv",
        "table": "payrixess_mms_monthly_summary"
    }
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 09:39:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782
    • id: 906712
    • 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: 2183
    • schema_scan_id: 6415466
    • updated: 2026-04-17 09:40:13
    • created: 2026-04-16 09:47:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-16/1776350867'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-16/1776350867
    • id: 906496
    • 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: 2183
    • schema_scan_id: 6414941
    • updated: 2026-04-16 09:48:03
    • created: 2026-04-15 09:47:54
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-15/1776264449'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-15/1776264449
    • id: 906287
    • 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: 2183
    • schema_scan_id: 6414435
    • updated: 2026-04-15 09:48:08
    • created: 2026-04-14 09:32:52
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-14/1776177167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-14/1776177167
    • id: 906053
    • 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: 2183
    • schema_scan_id: 6413902
    • updated: 2026-04-14 09:33:03
    • created: 2026-04-13 09:31:33
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-13/1776090683'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-13/1776090683
    • id: 905838
    • 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: 2183
    • schema_scan_id: 6413276
    • updated: 2026-04-13 09:31:44
    • created: 2026-04-12 09:28:12
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-12/1776004087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-12/1776004087
    • id: 905625
    • 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: 2183
    • schema_scan_id: 6412840
    • updated: 2026-04-12 09:28:25
    • created: 2026-04-11 09:43:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-11/1775918617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-11/1775918617
    • id: 905443
    • 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: 2183
    • schema_scan_id: 6412556
    • updated: 2026-04-11 09:44:10
    • created: 2026-04-10 09:27:09
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-10/1775831219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-10/1775831219
    • id: 905210
    • 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: 2183
    • schema_scan_id: 6412000
    • updated: 2026-04-10 09:27:20
    • created: 2026-04-09 09:44:31
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-09/1775745843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-09/1775745843
    • id: 905014
    • 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: 2183
    • schema_scan_id: 6411543
    • updated: 2026-04-09 09:44:42
    • created: 2026-04-08 09:43:08
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-08/1775659377'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-08/1775659377
    • id: 904803
    • 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: 2183
    • schema_scan_id: 6411095
    • updated: 2026-04-08 09:43:37
    • created: 2026-04-07 09:27:42
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-07/1775572058'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-07/1775572058
    • id: 904570
    • 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: 2183
    • schema_scan_id: 6410467
    • updated: 2026-04-07 09:27:56
    • created: 2026-04-06 09:31:09
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-06/1775485851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-06/1775485851
    • id: 904359
    • 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: 2183
    • schema_scan_id: 6410001
    • updated: 2026-04-06 09:31:22
    • created: 2026-04-05 09:45:58
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-05/1775400353'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-05/1775400353
    • id: 904174
    • 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: 2183
    • schema_scan_id: 6409622
    • updated: 2026-04-05 09:46:11
    • created: 2026-04-04 09:28:55
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-04/1775312920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-04/1775312920
    • id: 903950
    • 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: 2183
    • schema_scan_id: 6409113
    • updated: 2026-04-04 09:29:06
    • created: 2026-04-03 09:56:50
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
          "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-03/1775228206'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
      ]
    • hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-03/1775228206
    • id: 903758
    • 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: 2183
    • schema_scan_id: 6408763
    • updated: 2026-04-03 09:57:01
Schema Scans: 15
Last at 2026-04-17 09:39:59
    • duration: 0:00:14.579361
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6415466
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782",
              "key": "raw/mms_monthly_summary/2026-04-17/1776436782/37b124a5-0ad3-4c6a-b3bf-c6dfae6a8066.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 434374168051036955,
              "service_name": "drive-thru",
              "span_id": 9557891163057392781,
              "trace_id": 3727247518956388992
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-17 09:39:59
    • success: True
    • trace_id: 3727247518956388992
    • duration: 0:00:11.915148
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6414941
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-16/1776350867",
              "key": "raw/mms_monthly_summary/2026-04-16/1776350867/e5bc2e58-0fda-4c67-8a26-debc80acdcda.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 7766868798863627957,
              "service_name": "drive-thru",
              "span_id": 17838756000862033783,
              "trace_id": 12466993025510383834
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-16 09:47:51
    • success: True
    • trace_id: 12466993025510383834
    • duration: 0:00:14.473570
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6414435
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-15/1776264449",
              "key": "raw/mms_monthly_summary/2026-04-15/1776264449/876690c9-36a5-4b91-9284-56cade2983c2.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 9803417530377420819,
              "service_name": "drive-thru",
              "span_id": 15646935107540270151,
              "trace_id": 6989744810931841403
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-15 09:47:53
    • success: True
    • trace_id: 6989744810931841403
    • duration: 0:00:11.860519
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6413902
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-14/1776177167",
              "key": "raw/mms_monthly_summary/2026-04-14/1776177167/2e79ceda-3421-4ac4-a4aa-700637824bf1.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 17326710242812112758,
              "service_name": "drive-thru",
              "span_id": 3371028296082349386,
              "trace_id": 11223796453920025940
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-14 09:32:52
    • success: True
    • trace_id: 11223796453920025940
    • duration: 0:00:12.009098
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6413276
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-13/1776090683",
              "key": "raw/mms_monthly_summary/2026-04-13/1776090683/84343b1c-f640-4932-b1c4-72d6104eeeba.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 5224841798018187995,
              "service_name": "drive-thru",
              "span_id": 14663002398779066313,
              "trace_id": 5991987038437080658
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-13 09:31:32
    • success: True
    • trace_id: 5991987038437080658
    • duration: 0:00:14.285610
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6412840
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-12/1776004087",
              "key": "raw/mms_monthly_summary/2026-04-12/1776004087/080f8d6b-7d31-4570-88f5-e02dbbcdef1c.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 4301539021587016066,
              "service_name": "drive-thru",
              "span_id": 48071340602968722,
              "trace_id": 2635117898481217088
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-12 09:28:11
    • success: True
    • trace_id: 2635117898481217088
    • duration: 0:00:11.799670
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6412556
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-11/1775918617",
              "key": "raw/mms_monthly_summary/2026-04-11/1775918617/338bad9d-be68-43f9-a20b-03eb166ed373.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 3952701962607835403,
              "service_name": "drive-thru",
              "span_id": 12203701684220235825,
              "trace_id": 4938588026160911805
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-11 09:43:58
    • success: True
    • trace_id: 4938588026160911805
    • duration: 0:00:11.887564
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6412000
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-10/1775831219",
              "key": "raw/mms_monthly_summary/2026-04-10/1775831219/55cfef13-75e9-4ad7-8eec-40a6999027cd.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 8757465901256702966,
              "service_name": "drive-thru",
              "span_id": 13798387379587204245,
              "trace_id": 1646735286288001745
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-10 09:27:08
    • success: True
    • trace_id: 1646735286288001745
    • duration: 0:00:11.989346
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6411543
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-09/1775745843",
              "key": "raw/mms_monthly_summary/2026-04-09/1775745843/57ef3b8d-7bfa-46ad-9722-52d5ead05d67.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 10520650175459665643,
              "service_name": "drive-thru",
              "span_id": 412631702475253567,
              "trace_id": 14299410939605508695
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-09 09:44:30
    • success: True
    • trace_id: 14299410939605508695
    • duration: 0:00:29.800365
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6411095
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-08/1775659377",
              "key": "raw/mms_monthly_summary/2026-04-08/1775659377/373be664-448c-425a-993e-8a7a041dd096.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 3932831140804943407,
              "service_name": "drive-thru",
              "span_id": 10670892856073427148,
              "trace_id": 15136597610500009288
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-08 09:43:07
    • success: True
    • trace_id: 15136597610500009288
    • duration: 0:00:14.343988
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6410467
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-07/1775572058",
              "key": "raw/mms_monthly_summary/2026-04-07/1775572058/0282c43f-725f-460c-b733-b9c0b5f0d9d1.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 5933833264089447420,
              "service_name": "drive-thru",
              "span_id": 9782725967916019996,
              "trace_id": 6202478953346059545
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-07 09:27:42
    • success: True
    • trace_id: 6202478953346059545
    • duration: 0:00:14.306823
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6410001
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-06/1775485851",
              "key": "raw/mms_monthly_summary/2026-04-06/1775485851/48ac4b71-8562-4d3b-94b8-6cc91c8c7fa2.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 16513489755727968098,
              "service_name": "drive-thru",
              "span_id": 5150124105769969246,
              "trace_id": 4478072683100077963
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-06 09:31:08
    • success: True
    • trace_id: 4478072683100077963
    • duration: 0:00:14.419382
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6409622
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-05/1775400353",
              "key": "raw/mms_monthly_summary/2026-04-05/1775400353/43a88a98-4668-4aa1-99d7-f648c708fcec.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 2070469444042910125,
              "service_name": "drive-thru",
              "span_id": 965807817758158779,
              "trace_id": 14610729616297384905
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-05 09:45:57
    • success: True
    • trace_id: 14610729616297384905
    • duration: 0:00:11.712198
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6409113
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-04/1775312920",
              "key": "raw/mms_monthly_summary/2026-04-04/1775312920/e86dca61-e542-4ca5-88b4-486df327e5f7.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 11405402676967602630,
              "service_name": "drive-thru",
              "span_id": 8070181956951840750,
              "trace_id": 13107369708829031979
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-04 09:28:54
    • success: True
    • trace_id: 13107369708829031979
    • duration: 0:00:11.822829
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 6408763
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-csv-payrixess-stage",
              "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-03/1775228206",
              "key": "raw/mms_monthly_summary/2026-04-03/1775228206/f0877ad9-24bf-4108-9db4-cb1c6c05542b.csv.gz"
          },
          "schema": {
              "name": "sfdl_stage_csv.payrixess_mms_monthly_summary",
              "type": "csv"
          },
          "trace_context": {
              "parent_id": 18425920152908624338,
              "service_name": "drive-thru",
              "span_id": 9320292954156980698,
              "trace_id": 7215881947236434151
          }
      }
    • running: False
    • schema_name_id: 2183
    • start_time: 2026-04-03 09:56:50
    • success: True
    • trace_id: 7215881947236434151
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:39:59
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
        "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
    }
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw:
{
    "name": {
        "created": "2024-07-22 13:21:12",
        "disabled": false,
        "format": "raw",
        "id": 2183,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:39:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}