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
-
Version 1717679
- 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
-
Version 1716376
- 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
-
Version 1715200
- 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
-
Version 1714075
- 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
-
Version 1712815
- 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
-
Version 1711603
- 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
-
Version 1710506
- 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
-
Version 1709337
- 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
-
Version 1708140
- 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
-
Version 1706868
- 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
-
Version 1705736
- 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
-
Version 1704590
- 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
-
Version 1703354
- 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
-
Version 1702125
- 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
-
Version 1701052
- 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
-
Scan 162167662
- 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
-
Scan 162111779
- 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
-
Scan 162055909
- 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
-
Scan 162000575
- 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
-
Scan 161941789
- 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
-
Scan 161892706
- 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
-
Scan 161841295
- 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
-
Scan 161786036
- 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
-
Scan 161730303
- 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
-
Scan 161675453
- 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
-
Scan 161618463
- 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
-
Scan 161561735
- 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
-
Scan 161514935
- 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
-
Scan 161460295
- 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
-
Scan 161402040
- 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
- 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" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"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"
}
}