Schema Info

Schema Name: sfdl_prod_drivethru.molo_molooffersmoloapi_partner
  • created: 2023-10-17 01:58:55
  • disabled: False
  • format: raw
  • id: 1702
  • is_partitioned: False
  • is_schema_datatyped: True
  • name:
    {
        "database": "sfdl_prod_drivethru",
        "table": "molo_molooffersmoloapi_partner"
    }
  • type: drivethrucsv
Schema Versions: 15
    • created: 2026-04-17 03:06:37
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807
    • id: 1717679
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 162167662
    • updated: 2026-04-17 03:06:51
    • created: 2026-04-16 03:06:39
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-16/1776326563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-16/1776326563
    • id: 1716376
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 162111779
    • updated: 2026-04-16 03:06:50
    • created: 2026-04-15 03:04:41
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-15/1776240032'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-15/1776240032
    • id: 1715200
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 162055909
    • updated: 2026-04-15 03:04:52
    • created: 2026-04-14 03:08:22
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-14/1776153760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-14/1776153760
    • id: 1714075
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 162000575
    • updated: 2026-04-14 03:08:34
    • created: 2026-04-13 02:59:41
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-13/1776066955'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-13/1776066955
    • id: 1712815
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161941789
    • updated: 2026-04-13 02:59:52
    • created: 2026-04-12 03:01:07
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-12/1775980667'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-12/1775980667
    • id: 1711603
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161892706
    • updated: 2026-04-12 03:01:21
    • created: 2026-04-11 03:08:38
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-11/1775894429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-11/1775894429
    • id: 1710506
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161841295
    • updated: 2026-04-11 03:08:49
    • created: 2026-04-10 03:09:39
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-10/1775808186'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-10/1775808186
    • id: 1709337
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161786036
    • updated: 2026-04-10 03:09:50
    • created: 2026-04-09 03:03:59
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-09/1775721524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-09/1775721524
    • id: 1708140
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161730303
    • updated: 2026-04-09 03:04:10
    • created: 2026-04-08 03:03:56
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-08/1775635355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-08/1775635355
    • id: 1706868
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161675453
    • updated: 2026-04-08 03:04:07
    • created: 2026-04-07 02:58:15
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-07/1775548504'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-07/1775548504
    • id: 1705736
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161618463
    • updated: 2026-04-07 02:58:27
    • created: 2026-04-06 03:09:51
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-06/1775462469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-06/1775462469
    • id: 1704590
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161561735
    • updated: 2026-04-06 03:10:02
    • created: 2026-04-05 03:07:20
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-05/1775376095'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-05/1775376095
    • id: 1703354
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161514935
    • updated: 2026-04-05 03:07:31
    • created: 2026-04-04 03:03:53
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-04/1775289579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-04/1775289579
    • id: 1702125
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161460295
    • updated: 2026-04-04 03:04:04
    • created: 2026-04-03 03:14:52
    • ddl:
      [
          "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
          "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
          "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-03/1775203351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
          "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
      ]
    • hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-03/1775203351
    • id: 1701052
    • processed: 1
    • raw_data:
      {
          "MoloAPI_Partner_Id": 1,
          "Offers_Id": 0
      }
    • schema_attributes:
      {
          "MoloAPI_Partner_Id": "string",
          "Offers_Id": "string"
      }
    • schema_name_id: 1702
    • schema_scan_id: 161402040
    • updated: 2026-04-03 03:15:03
Schema Scans: 15
Last at 2026-04-17 03:06:37
    • duration: 0:00:14.111725
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162167662
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7771749241482832143,
              "service_name": "drive-thru",
              "span_id": 7358756299082439094,
              "trace_id": 14544210648138292377
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-17 03:06:37
    • success: True
    • trace_id: 14544210648138292377
    • duration: 0:00:12.000825
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162111779
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-16/1776326563",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-16/1776326563/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1936295674112480442,
              "service_name": "drive-thru",
              "span_id": 6397900170984021042,
              "trace_id": 8362471046742633201
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-16 03:06:38
    • success: True
    • trace_id: 8362471046742633201
    • duration: 0:00:11.435974
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162055909
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-15/1776240032",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-15/1776240032/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12666536823090597387,
              "service_name": "drive-thru",
              "span_id": 4910618291200928084,
              "trace_id": 11013727785610940237
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-15 03:04:41
    • success: True
    • trace_id: 11013727785610940237
    • duration: 0:00:11.542378
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 162000575
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-14/1776153760",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-14/1776153760/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 9318855818609202827,
              "service_name": "drive-thru",
              "span_id": 10468431382130986383,
              "trace_id": 1410940319317366373
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-14 03:08:22
    • success: True
    • trace_id: 1410940319317366373
    • duration: 0:00:11.439098
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161941789
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-13/1776066955",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-13/1776066955/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7069496084303019673,
              "service_name": "drive-thru",
              "span_id": 15720306692949685666,
              "trace_id": 2569458068258946019
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-13 02:59:41
    • success: True
    • trace_id: 2569458068258946019
    • duration: 0:00:14.249948
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161892706
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-12/1775980667",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-12/1775980667/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 6256661052728338642,
              "service_name": "drive-thru",
              "span_id": 10116560267050553337,
              "trace_id": 9044551846907741641
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-12 03:01:07
    • success: True
    • trace_id: 9044551846907741641
    • duration: 0:00:11.680015
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161841295
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-11/1775894429",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-11/1775894429/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 10854734809468255709,
              "service_name": "drive-thru",
              "span_id": 18027270909164456992,
              "trace_id": 1986089651986445806
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-11 03:08:37
    • success: True
    • trace_id: 1986089651986445806
    • duration: 0:00:11.513833
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161786036
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-10/1775808186",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-10/1775808186/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 12129219854640148156,
              "service_name": "drive-thru",
              "span_id": 7344933042662066820,
              "trace_id": 5287182753778888699
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-10 03:09:39
    • success: True
    • trace_id: 5287182753778888699
    • duration: 0:00:11.656037
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161730303
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-09/1775721524",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-09/1775721524/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7524477243248466330,
              "service_name": "drive-thru",
              "span_id": 483637840668337456,
              "trace_id": 17596446187549343943
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-09 03:03:59
    • success: True
    • trace_id: 17596446187549343943
    • duration: 0:00:11.632269
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161675453
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-08/1775635355",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-08/1775635355/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7410734272384279188,
              "service_name": "drive-thru",
              "span_id": 16069453988404380499,
              "trace_id": 13161024822316037120
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-08 03:03:55
    • success: True
    • trace_id: 13161024822316037120
    • duration: 0:00:11.568659
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161618463
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-07/1775548504",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-07/1775548504/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 8029109423103145866,
              "service_name": "drive-thru",
              "span_id": 1188682102151799204,
              "trace_id": 11924347182530314086
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-07 02:58:15
    • success: True
    • trace_id: 11924347182530314086
    • duration: 0:00:11.446141
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161561735
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-06/1775462469",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-06/1775462469/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 2024455394290839787,
              "service_name": "drive-thru",
              "span_id": 11382970491432220543,
              "trace_id": 12978999553406043645
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-06 03:09:50
    • success: True
    • trace_id: 12978999553406043645
    • duration: 0:00:11.566082
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161514935
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-05/1775376095",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-05/1775376095/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 7852740051275031950,
              "service_name": "drive-thru",
              "span_id": 16347317753617711015,
              "trace_id": 11634064576573108621
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-05 03:07:20
    • success: True
    • trace_id: 11634064576573108621
    • duration: 0:00:11.508891
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161460295
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-04/1775289579",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-04/1775289579/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 1634276533554688475,
              "service_name": "drive-thru",
              "span_id": 9727882116549663681,
              "trace_id": 1877625094615145691
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-04 03:03:52
    • success: True
    • trace_id: 1877625094615145691
    • duration: 0:00:11.666117
    • exit_message:
      {
          "ddl_changed": true,
          "partitions_applied": false,
          "success": true
      }
    • id: 161402040
    • payload:
      {
          "datatype_dict": null,
          "file_format": "csv",
          "file_properties": {
              "data_has_header_row": true
          },
          "is_schema_datatyped": true,
          "s3": {
              "bucket": "sfdl-drivethrucsv-drivethru-prod",
              "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-03/1775203351",
              "key": "raw/molo_moloOffersMoloAPI_Partner/2026-04-03/1775203351/OffersMoloAPI_Partner.csv.gz"
          },
          "schema": {
              "name": "sfdl_prod_drivethru.molo_moloOffersMoloAPI_Partner",
              "type": "drivethrucsv"
          },
          "trace_context": {
              "parent_id": 11418687061810767386,
              "service_name": "drive-thru",
              "span_id": 13028822629617550186,
              "trace_id": 2007756643299289225
          }
      }
    • running: False
    • schema_name_id: 1702
    • start_time: 2026-04-03 03:14:52
    • success: True
    • trace_id: 2007756643299289225
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
Schema:
  • attributes:
    {
        "MoloAPI_Partner_Id": "string",
        "Offers_Id": "string"
    }
  • created: 2026-04-17 03:06:37
  • ddl:
    {
        "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
        "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
        "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
        "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
    }
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw:
{
    "name": {
        "created": "2023-10-17 01:58:55",
        "disabled": false,
        "format": "raw",
        "id": 1702,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molooffersmoloapi_partner"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "MoloAPI_Partner_Id": "string",
            "Offers_Id": "string"
        },
        "created": "2026-04-17 03:06:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molooffersmoloapi_partner`\n(\n `Offers_Id`  string , `MoloAPI_Partner_Id`  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-drivethrucsv-drivethru-prod/raw/molo_moloOffersMoloAPI_Partner/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molooffersmoloapi_partner`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molooffersmoloapi_partner"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}