Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloseasonalinventoryitems
- created: 2025-07-11 02:17:53
- disabled: False
- format: raw
- id: 4256
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloseasonalinventoryitems" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717733
- created: 2026-04-17 03:08:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-17/1776412849
- id: 1717733
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 162167735
- updated: 2026-04-17 03:08:58
-
Version 1716438
- created: 2026-04-16 03:09:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-16/1776326602'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-16/1776326602
- id: 1716438
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 162111872
- updated: 2026-04-16 03:09:27
-
Version 1715254
- created: 2026-04-15 03:06:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-15/1776240072'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-15/1776240072
- id: 1715254
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 162055996
- updated: 2026-04-15 03:07:11
-
Version 1714079
- created: 2026-04-14 03:08:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-14/1776153837'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-14/1776153837
- id: 1714079
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 162000581
- updated: 2026-04-14 03:08:43
-
Version 1712841
- created: 2026-04-13 03:00:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-13/1776066997'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-13/1776066997
- id: 1712841
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161941902
- updated: 2026-04-13 03:00:38
-
Version 1711626
- created: 2026-04-12 03:01:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-12/1775980708'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-12/1775980708
- id: 1711626
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161892795
- updated: 2026-04-12 03:02:01
-
Version 1710468
- created: 2026-04-11 03:07:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-11/1775894475'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-11/1775894475
- id: 1710468
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161841257
- updated: 2026-04-11 03:07:24
-
Version 1709379
- created: 2026-04-10 03:11:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-10/1775808233'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-10/1775808233
- id: 1709379
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161786080
- updated: 2026-04-10 03:11:22
-
Version 1708117
- created: 2026-04-09 03:03:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-09/1775721565'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-09/1775721565
- id: 1708117
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161730226
- updated: 2026-04-09 03:03:15
-
Version 1706887
- created: 2026-04-08 03:04:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-08/1775635394'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-08/1775635394
- id: 1706887
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161675491
- updated: 2026-04-08 03:05:03
-
Version 1705752
- created: 2026-04-07 02:58:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-07/1775548550'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-07/1775548550
- id: 1705752
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161618532
- updated: 2026-04-07 02:59:10
-
Version 1704543
- created: 2026-04-06 03:07:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-06/1775462511'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-06/1775462511
- id: 1704543
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161561654
- updated: 2026-04-06 03:08:04
-
Version 1703348
- created: 2026-04-05 03:07:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-05/1775376136'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-05/1775376136
- id: 1703348
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161514929
- updated: 2026-04-05 03:07:18
-
Version 1702179
- created: 2026-04-04 03:06:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-04/1775289620'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-04/1775289620
- id: 1702179
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161460420
- updated: 2026-04-04 03:06:32
-
Version 1701003
- created: 2026-04-03 03:12:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-03/1775203392'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSeasonalInventoryItems/2026-04-03/1775203392
- id: 1701003
- processed: 1
- raw_data:
{ "Id": 0, "ItemMasterId": 2, "SeasonalPriceId": 1 } - schema_attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - schema_name_id: 4256
- schema_scan_id: 161401976
- updated: 2026-04-03 03:12:30
Schema Scans: 15
Last at 2026-04-17 03:08:44
-
Scan 162167735
- duration: 0:00:14.264091
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167735
- 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_moloSeasonalInventoryItems/2026-04-17/1776412849", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-17/1776412849/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11040109080547163282, "service_name": "drive-thru", "span_id": 1591893045574577274, "trace_id": 14903075470116766494 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-17 03:08:44
- success: True
- trace_id: 14903075470116766494
-
Scan 162111872
- duration: 0:00:14.085841
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111872
- 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_moloSeasonalInventoryItems/2026-04-16/1776326602", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-16/1776326602/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2807255211082619322, "service_name": "drive-thru", "span_id": 8463105434053262918, "trace_id": 8836659625546709892 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-16 03:09:13
- success: True
- trace_id: 8836659625546709892
-
Scan 162055996
- duration: 0:00:14.267280
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055996
- 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_moloSeasonalInventoryItems/2026-04-15/1776240072", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-15/1776240072/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17856224122122113902, "service_name": "drive-thru", "span_id": 1174916581161154108, "trace_id": 13689341074476301147 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-15 03:06:56
- success: True
- trace_id: 13689341074476301147
-
Scan 162000581
- duration: 0:00:11.589200
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000581
- 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_moloSeasonalInventoryItems/2026-04-14/1776153837", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-14/1776153837/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8024881484771104375, "service_name": "drive-thru", "span_id": 17913062219178774467, "trace_id": 13705713498560696495 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-14 03:08:32
- success: True
- trace_id: 13705713498560696495
-
Scan 161941902
- duration: 0:00:11.425182
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941902
- 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_moloSeasonalInventoryItems/2026-04-13/1776066997", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-13/1776066997/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 924545989688799823, "service_name": "drive-thru", "span_id": 10440140633303914626, "trace_id": 4234610408162078702 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-13 03:00:27
- success: True
- trace_id: 4234610408162078702
-
Scan 161892795
- duration: 0:00:14.111361
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892795
- 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_moloSeasonalInventoryItems/2026-04-12/1775980708", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-12/1775980708/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 144666500420394181, "service_name": "drive-thru", "span_id": 9463976601244155665, "trace_id": 8257258712100000318 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-12 03:01:47
- success: True
- trace_id: 8257258712100000318
-
Scan 161841257
- duration: 0:00:14.129513
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841257
- 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_moloSeasonalInventoryItems/2026-04-11/1775894475", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-11/1775894475/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11877288731692888943, "service_name": "drive-thru", "span_id": 7567177312573343930, "trace_id": 15747231557107424932 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-11 03:07:10
- success: True
- trace_id: 15747231557107424932
-
Scan 161786080
- duration: 0:00:11.538299
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786080
- 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_moloSeasonalInventoryItems/2026-04-10/1775808233", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-10/1775808233/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2972930950765191477, "service_name": "drive-thru", "span_id": 5649858652932405516, "trace_id": 2125728702669893651 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-10 03:11:11
- success: True
- trace_id: 2125728702669893651
-
Scan 161730226
- duration: 0:00:14.223430
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730226
- 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_moloSeasonalInventoryItems/2026-04-09/1775721565", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-09/1775721565/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12889673423114936495, "service_name": "drive-thru", "span_id": 17336639207793550333, "trace_id": 3646510905702280604 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-09 03:03:00
- success: True
- trace_id: 3646510905702280604
-
Scan 161675491
- duration: 0:00:13.977823
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675491
- 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_moloSeasonalInventoryItems/2026-04-08/1775635394", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-08/1775635394/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11357558565611590027, "service_name": "drive-thru", "span_id": 7985652187221714476, "trace_id": 16577955696527744959 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-08 03:04:49
- success: True
- trace_id: 16577955696527744959
-
Scan 161618532
- duration: 0:00:14.057891
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618532
- 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_moloSeasonalInventoryItems/2026-04-07/1775548550", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-07/1775548550/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17124403865057404846, "service_name": "drive-thru", "span_id": 793730275697711860, "trace_id": 8068864255656735154 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-07 02:58:56
- success: True
- trace_id: 8068864255656735154
-
Scan 161561654
- duration: 0:00:11.545106
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561654
- 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_moloSeasonalInventoryItems/2026-04-06/1775462511", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-06/1775462511/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3872927649034599845, "service_name": "drive-thru", "span_id": 3193400081436593020, "trace_id": 14799476531924586 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-06 03:07:52
- success: True
- trace_id: 14799476531924586
-
Scan 161514929
- duration: 0:00:11.552395
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514929
- 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_moloSeasonalInventoryItems/2026-04-05/1775376136", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-05/1775376136/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11910497300772572480, "service_name": "drive-thru", "span_id": 16368430186367909388, "trace_id": 8020812219289799083 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-05 03:07:06
- success: True
- trace_id: 8020812219289799083
-
Scan 161460420
- duration: 0:00:14.056681
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460420
- 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_moloSeasonalInventoryItems/2026-04-04/1775289620", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-04/1775289620/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8464595087159152322, "service_name": "drive-thru", "span_id": 1429008424791665486, "trace_id": 5402236789961075807 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-04 03:06:18
- success: True
- trace_id: 5402236789961075807
-
Scan 161401976
- duration: 0:00:14.202661
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401976
- 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_moloSeasonalInventoryItems/2026-04-03/1775203392", "key": "raw/molo_moloSeasonalInventoryItems/2026-04-03/1775203392/SeasonalInventoryItems.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSeasonalInventoryItems", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16283400179929895481, "service_name": "drive-thru", "span_id": 12863682571022615113, "trace_id": 3226136954823017010 } } - running: False
- schema_name_id: 4256
- start_time: 2026-04-03 03:12:16
- success: True
- trace_id: 3226136954823017010
- attributes:
{ "Id": "string", "ItemMasterId": "string", "SeasonalPriceId": "string" } - created: 2026-04-17 03:08:45
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2025-07-11 02:17:53",
"disabled": false,
"format": "raw",
"id": 4256,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloseasonalinventoryitems"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"ItemMasterId": "string",
"SeasonalPriceId": "string"
},
"created": "2026-04-17 03:08:45",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloseasonalinventoryitems`\n(\n `Id` string , `SeasonalPriceId` string , `ItemMasterId` 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_moloSeasonalInventoryItems/2026-04-17/1776412849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloseasonalinventoryitems`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloseasonalinventoryitems"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}