Schema Info
Schema Name: sfdl_prod_drivethru.molo_molomenumarinadefault
- created: 2023-10-17 01:59:36
- disabled: False
- format: raw
- id: 1720
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molomenumarinadefault" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717658
- created: 2026-04-17 03:05:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-17/1776412807
- id: 1717658
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 162167625
- updated: 2026-04-17 03:05:45
-
Version 1716359
- created: 2026-04-16 03:05:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-16/1776326559'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-16/1776326559
- id: 1716359
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 162111747
- updated: 2026-04-16 03:05:59
-
Version 1715222
- created: 2026-04-15 03:05:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-15/1776240028'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-15/1776240028
- id: 1715222
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 162055951
- updated: 2026-04-15 03:05:57
-
Version 1714025
- created: 2026-04-14 03:06:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-14/1776153757'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-14/1776153757
- id: 1714025
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 162000508
- updated: 2026-04-14 03:06:37
-
Version 1712795
- created: 2026-04-13 02:59:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-13/1776066952'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-13/1776066952
- id: 1712795
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161941739
- updated: 2026-04-13 02:59:21
-
Version 1711589
- created: 2026-04-12 03:00:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-12/1775980664'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-12/1775980664
- id: 1711589
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161892639
- updated: 2026-04-12 03:00:54
-
Version 1710481
- created: 2026-04-11 03:07:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-11/1775894425'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-11/1775894425
- id: 1710481
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161841270
- updated: 2026-04-11 03:07:51
-
Version 1709181
- created: 2026-04-10 03:03:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-10/1775808182'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-10/1775808182
- id: 1709181
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161785856
- updated: 2026-04-10 03:03:51
-
Version 1708093
- created: 2026-04-09 03:02:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-09/1775721522'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-09/1775721522
- id: 1708093
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161730140
- updated: 2026-04-09 03:02:21
-
Version 1706964
- created: 2026-04-08 03:08:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-08/1775635351'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-08/1775635351
- id: 1706964
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161675617
- updated: 2026-04-08 03:08:22
-
Version 1705712
- created: 2026-04-07 02:57:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-07/1775548499'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-07/1775548499
- id: 1705712
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161618418
- updated: 2026-04-07 02:57:38
-
Version 1704423
- created: 2026-04-06 03:02:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-06/1775462466'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-06/1775462466
- id: 1704423
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161561435
- updated: 2026-04-06 03:02:44
-
Version 1703249
- created: 2026-04-05 03:03:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-05/1775376093'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-05/1775376093
- id: 1703249
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161514818
- updated: 2026-04-05 03:03:15
-
Version 1702105
- created: 2026-04-04 03:03:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-04/1775289576'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-04/1775289576
- id: 1702105
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161460216
- updated: 2026-04-04 03:03:21
-
Version 1700907
- created: 2026-04-03 03:08:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-03/1775203348'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuMarinaDefault/2026-04-03/1775203348
- id: 1700907
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MarinaId": 2, "MenuId": 1, "Position": 3 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - schema_name_id: 1720
- schema_scan_id: 161401854
- updated: 2026-04-03 03:08:41
Schema Scans: 15
Last at 2026-04-17 03:05:33
-
Scan 162167625
- duration: 0:00:11.652513
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167625
- 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_moloMenuMarinaDefault/2026-04-17/1776412807", "key": "raw/molo_moloMenuMarinaDefault/2026-04-17/1776412807/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17307981630932046457, "service_name": "drive-thru", "span_id": 12667683471997277304, "trace_id": 5261480542756938052 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-17 03:05:33
- success: True
- trace_id: 5261480542756938052
-
Scan 162111747
- duration: 0:00:11.647623
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111747
- 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_moloMenuMarinaDefault/2026-04-16/1776326559", "key": "raw/molo_moloMenuMarinaDefault/2026-04-16/1776326559/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11017714427492897799, "service_name": "drive-thru", "span_id": 14395114349027206594, "trace_id": 729454558068655808 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-16 03:05:48
- success: True
- trace_id: 729454558068655808
-
Scan 162055951
- duration: 0:00:11.755507
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055951
- 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_moloMenuMarinaDefault/2026-04-15/1776240028", "key": "raw/molo_moloMenuMarinaDefault/2026-04-15/1776240028/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17315949214928091491, "service_name": "drive-thru", "span_id": 3849449864923542768, "trace_id": 11958712048885658760 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-15 03:05:45
- success: True
- trace_id: 11958712048885658760
-
Scan 162000508
- duration: 0:00:14.302715
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000508
- 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_moloMenuMarinaDefault/2026-04-14/1776153757", "key": "raw/molo_moloMenuMarinaDefault/2026-04-14/1776153757/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11232263640483548812, "service_name": "drive-thru", "span_id": 1930719413132806113, "trace_id": 1984827587085075180 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-14 03:06:23
- success: True
- trace_id: 1984827587085075180
-
Scan 161941739
- duration: 0:00:11.608487
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941739
- 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_moloMenuMarinaDefault/2026-04-13/1776066952", "key": "raw/molo_moloMenuMarinaDefault/2026-04-13/1776066952/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12542647563988937, "service_name": "drive-thru", "span_id": 17994346210050138779, "trace_id": 8029951183982087999 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-13 02:59:09
- success: True
- trace_id: 8029951183982087999
-
Scan 161892639
- duration: 0:00:14.090759
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892639
- 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_moloMenuMarinaDefault/2026-04-12/1775980664", "key": "raw/molo_moloMenuMarinaDefault/2026-04-12/1775980664/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9021967161549371030, "service_name": "drive-thru", "span_id": 7196167548299698415, "trace_id": 10519834012877411800 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-12 03:00:40
- success: True
- trace_id: 10519834012877411800
-
Scan 161841270
- duration: 0:00:11.610668
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841270
- 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_moloMenuMarinaDefault/2026-04-11/1775894425", "key": "raw/molo_moloMenuMarinaDefault/2026-04-11/1775894425/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 967918377948858962, "service_name": "drive-thru", "span_id": 7511610616556910630, "trace_id": 17712632334204799165 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-11 03:07:39
- success: True
- trace_id: 17712632334204799165
-
Scan 161785856
- duration: 0:00:14.232823
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785856
- 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_moloMenuMarinaDefault/2026-04-10/1775808182", "key": "raw/molo_moloMenuMarinaDefault/2026-04-10/1775808182/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10176345422788637481, "service_name": "drive-thru", "span_id": 1008638895145179571, "trace_id": 16958308876506359965 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-10 03:03:37
- success: True
- trace_id: 16958308876506359965
-
Scan 161730140
- duration: 0:00:14.274947
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730140
- 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_moloMenuMarinaDefault/2026-04-09/1775721522", "key": "raw/molo_moloMenuMarinaDefault/2026-04-09/1775721522/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1905627084264433990, "service_name": "drive-thru", "span_id": 541308270794594887, "trace_id": 7363203939492830411 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-09 03:02:06
- success: True
- trace_id: 7363203939492830411
-
Scan 161675617
- duration: 0:00:14.089803
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675617
- 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_moloMenuMarinaDefault/2026-04-08/1775635351", "key": "raw/molo_moloMenuMarinaDefault/2026-04-08/1775635351/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13258721840773242605, "service_name": "drive-thru", "span_id": 10307631161221701827, "trace_id": 14439529747799857851 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-08 03:08:08
- success: True
- trace_id: 14439529747799857851
-
Scan 161618418
- duration: 0:00:14.084389
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618418
- 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_moloMenuMarinaDefault/2026-04-07/1775548499", "key": "raw/molo_moloMenuMarinaDefault/2026-04-07/1775548499/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1429989415708736565, "service_name": "drive-thru", "span_id": 5639141109487920438, "trace_id": 4045948336554357348 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-07 02:57:24
- success: True
- trace_id: 4045948336554357348
-
Scan 161561435
- duration: 0:00:11.584424
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561435
- 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_moloMenuMarinaDefault/2026-04-06/1775462466", "key": "raw/molo_moloMenuMarinaDefault/2026-04-06/1775462466/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8836390275551496155, "service_name": "drive-thru", "span_id": 214517959359464603, "trace_id": 4187539073103656376 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-06 03:02:32
- success: True
- trace_id: 4187539073103656376
-
Scan 161514818
- duration: 0:00:14.031460
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514818
- 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_moloMenuMarinaDefault/2026-04-05/1775376093", "key": "raw/molo_moloMenuMarinaDefault/2026-04-05/1775376093/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5677950246044900878, "service_name": "drive-thru", "span_id": 14999824141786638162, "trace_id": 3160010260631919487 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-05 03:03:01
- success: True
- trace_id: 3160010260631919487
-
Scan 161460216
- duration: 0:00:11.610168
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460216
- 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_moloMenuMarinaDefault/2026-04-04/1775289576", "key": "raw/molo_moloMenuMarinaDefault/2026-04-04/1775289576/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1619276405296940909, "service_name": "drive-thru", "span_id": 17749892039280172418, "trace_id": 14144857073451600019 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-04 03:03:09
- success: True
- trace_id: 14144857073451600019
-
Scan 161401854
- duration: 0:00:14.116617
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401854
- 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_moloMenuMarinaDefault/2026-04-03/1775203348", "key": "raw/molo_moloMenuMarinaDefault/2026-04-03/1775203348/MenuMarinaDefault.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuMarinaDefault", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2211802299986359158, "service_name": "drive-thru", "span_id": 14452322887353641821, "trace_id": 7599782205134268188 } } - running: False
- schema_name_id: 1720
- start_time: 2026-04-03 03:08:27
- success: True
- trace_id: 7599782205134268188
- attributes:
{ "Hidden": "string", "Id": "string", "MarinaId": "string", "MenuId": "string", "Position": "string" } - created: 2026-04-17 03:05:34
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault" }
- 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:59:36",
"disabled": false,
"format": "raw",
"id": 1720,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molomenumarinadefault"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Hidden": "string",
"Id": "string",
"MarinaId": "string",
"MenuId": "string",
"Position": "string"
},
"created": "2026-04-17 03:05:34",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenumarinadefault`\n(\n `Id` string , `MenuId` string , `MarinaId` string , `Position` string , `Hidden` 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_moloMenuMarinaDefault/2026-04-17/1776412807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenumarinadefault`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenumarinadefault"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}