Schema Info
Schema Name: sfdl_prod_drivethru.molo_molomenuuserpreferences
- created: 2023-10-17 01:59:03
- disabled: False
- format: raw
- id: 1704
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molomenuuserpreferences" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717626
- created: 2026-04-17 03:03:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-17/1776412805
- id: 1717626
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 162167523
- updated: 2026-04-17 03:04:05
-
Version 1716396
- created: 2026-04-16 03:07:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-16/1776326559'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-16/1776326559
- id: 1716396
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 162111820
- updated: 2026-04-16 03:07:50
-
Version 1715230
- created: 2026-04-15 03:06:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-15/1776240029'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-15/1776240029
- id: 1715230
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 162055960
- updated: 2026-04-15 03:06:12
-
Version 1714058
- created: 2026-04-14 03:07:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-14/1776153757'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-14/1776153757
- id: 1714058
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 162000557
- updated: 2026-04-14 03:07:58
-
Version 1712790
- created: 2026-04-13 02:59:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-13/1776066951'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-13/1776066951
- id: 1712790
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161941732
- updated: 2026-04-13 02:59:15
-
Version 1711599
- created: 2026-04-12 03:01:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-12/1775980664'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-12/1775980664
- id: 1711599
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161892695
- updated: 2026-04-12 03:01:14
-
Version 1710455
- created: 2026-04-11 03:06:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-11/1775894425'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-11/1775894425
- id: 1710455
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161841244
- updated: 2026-04-11 03:06:56
-
Version 1709369
- created: 2026-04-10 03:10:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-10/1775808182'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-10/1775808182
- id: 1709369
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161786069
- updated: 2026-04-10 03:11:02
-
Version 1708096
- created: 2026-04-09 03:02:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-09/1775721522'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-09/1775721522
- id: 1708096
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161730161
- updated: 2026-04-09 03:02:34
-
Version 1706908
- created: 2026-04-08 03:05:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-08/1775635355'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-08/1775635355
- id: 1706908
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161675529
- updated: 2026-04-08 03:05:58
-
Version 1705718
- created: 2026-04-07 02:57:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-07/1775548500'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-07/1775548500
- id: 1705718
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161618433
- updated: 2026-04-07 02:57:54
-
Version 1704481
- created: 2026-04-06 03:05:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-06/1775462466'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-06/1775462466
- id: 1704481
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161561564
- updated: 2026-04-06 03:05:33
-
Version 1703319
- created: 2026-04-05 03:05:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-05/1775376093'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-05/1775376093
- id: 1703319
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161514898
- updated: 2026-04-05 03:06:11
-
Version 1702117
- created: 2026-04-04 03:03:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-04/1775289576'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-04/1775289576
- id: 1702117
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161460262
- updated: 2026-04-04 03:03:46
-
Version 1700913
- created: 2026-04-03 03:08:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-03/1775203349'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMenuUserPreferences/2026-04-03/1775203349
- id: 1700913
- processed: 1
- raw_data:
{ "Hidden": 4, "Id": 0, "MenuId": 1, "Position": 3, "UserId": 2 } - schema_attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - schema_name_id: 1704
- schema_scan_id: 161401865
- updated: 2026-04-03 03:08:59
Schema Scans: 15
Last at 2026-04-17 03:03:51
-
Scan 162167523
- duration: 0:00:14.289419
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167523
- 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_moloMenuUserPreferences/2026-04-17/1776412805", "key": "raw/molo_moloMenuUserPreferences/2026-04-17/1776412805/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6047455983963280656, "service_name": "drive-thru", "span_id": 18061044819305177768, "trace_id": 14783511440163620049 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-17 03:03:51
- success: True
- trace_id: 14783511440163620049
-
Scan 162111820
- duration: 0:00:14.297566
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111820
- 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_moloMenuUserPreferences/2026-04-16/1776326559", "key": "raw/molo_moloMenuUserPreferences/2026-04-16/1776326559/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16089915391485878162, "service_name": "drive-thru", "span_id": 12789004015174688880, "trace_id": 5043458595934159091 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-16 03:07:36
- success: True
- trace_id: 5043458595934159091
-
Scan 162055960
- duration: 0:00:11.691584
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055960
- 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_moloMenuUserPreferences/2026-04-15/1776240029", "key": "raw/molo_moloMenuUserPreferences/2026-04-15/1776240029/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11665886174545949932, "service_name": "drive-thru", "span_id": 13464994622084980429, "trace_id": 12985441184283018126 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-15 03:06:00
- success: True
- trace_id: 12985441184283018126
-
Scan 162000557
- duration: 0:00:14.446676
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000557
- 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_moloMenuUserPreferences/2026-04-14/1776153757", "key": "raw/molo_moloMenuUserPreferences/2026-04-14/1776153757/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6939472480091952921, "service_name": "drive-thru", "span_id": 13092439343940045382, "trace_id": 8608136116162755951 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-14 03:07:43
- success: True
- trace_id: 8608136116162755951
-
Scan 161941732
- duration: 0:00:14.266815
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941732
- 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_moloMenuUserPreferences/2026-04-13/1776066951", "key": "raw/molo_moloMenuUserPreferences/2026-04-13/1776066951/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3496299292228832433, "service_name": "drive-thru", "span_id": 6389812797718926836, "trace_id": 15260118011397457833 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-13 02:59:01
- success: True
- trace_id: 15260118011397457833
-
Scan 161892695
- duration: 0:00:14.264522
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892695
- 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_moloMenuUserPreferences/2026-04-12/1775980664", "key": "raw/molo_moloMenuUserPreferences/2026-04-12/1775980664/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5827431830995122659, "service_name": "drive-thru", "span_id": 10522757240397304251, "trace_id": 13590083980071740712 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-12 03:01:00
- success: True
- trace_id: 13590083980071740712
-
Scan 161841244
- duration: 0:00:14.409500
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841244
- 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_moloMenuUserPreferences/2026-04-11/1775894425", "key": "raw/molo_moloMenuUserPreferences/2026-04-11/1775894425/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6302502738273722068, "service_name": "drive-thru", "span_id": 3847336827724621219, "trace_id": 11555762451665054248 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-11 03:06:42
- success: True
- trace_id: 11555762451665054248
-
Scan 161786069
- duration: 0:00:14.410367
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786069
- 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_moloMenuUserPreferences/2026-04-10/1775808182", "key": "raw/molo_moloMenuUserPreferences/2026-04-10/1775808182/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17916941746495971787, "service_name": "drive-thru", "span_id": 5453563382006424776, "trace_id": 4370971075901710443 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-10 03:10:47
- success: True
- trace_id: 4370971075901710443
-
Scan 161730161
- duration: 0:00:14.460840
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730161
- 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_moloMenuUserPreferences/2026-04-09/1775721522", "key": "raw/molo_moloMenuUserPreferences/2026-04-09/1775721522/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4835302467217388764, "service_name": "drive-thru", "span_id": 17328472928954746022, "trace_id": 5403625278829578890 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-09 03:02:19
- success: True
- trace_id: 5403625278829578890
-
Scan 161675529
- duration: 0:00:11.730674
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675529
- 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_moloMenuUserPreferences/2026-04-08/1775635355", "key": "raw/molo_moloMenuUserPreferences/2026-04-08/1775635355/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15430034375879199192, "service_name": "drive-thru", "span_id": 4173956670891797337, "trace_id": 15445719327219490501 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-08 03:05:46
- success: True
- trace_id: 15445719327219490501
-
Scan 161618433
- duration: 0:00:14.242014
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618433
- 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_moloMenuUserPreferences/2026-04-07/1775548500", "key": "raw/molo_moloMenuUserPreferences/2026-04-07/1775548500/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12301967656592882057, "service_name": "drive-thru", "span_id": 4164206441942901417, "trace_id": 1441079772094177246 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-07 02:57:40
- success: True
- trace_id: 1441079772094177246
-
Scan 161561564
- duration: 0:00:14.230622
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561564
- 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_moloMenuUserPreferences/2026-04-06/1775462466", "key": "raw/molo_moloMenuUserPreferences/2026-04-06/1775462466/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2979751353378011467, "service_name": "drive-thru", "span_id": 6479543688658508682, "trace_id": 4512613788757496913 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-06 03:05:18
- success: True
- trace_id: 4512613788757496913
-
Scan 161514898
- duration: 0:00:14.304099
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514898
- 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_moloMenuUserPreferences/2026-04-05/1775376093", "key": "raw/molo_moloMenuUserPreferences/2026-04-05/1775376093/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12021599443039901446, "service_name": "drive-thru", "span_id": 2904347171811420108, "trace_id": 17204888784493772902 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-05 03:05:56
- success: True
- trace_id: 17204888784493772902
-
Scan 161460262
- duration: 0:00:11.605849
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460262
- 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_moloMenuUserPreferences/2026-04-04/1775289576", "key": "raw/molo_moloMenuUserPreferences/2026-04-04/1775289576/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15293426927994617448, "service_name": "drive-thru", "span_id": 14797317388910198433, "trace_id": 4230141242491127336 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-04 03:03:35
- success: True
- trace_id: 4230141242491127336
-
Scan 161401865
- duration: 0:00:14.257285
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401865
- 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_moloMenuUserPreferences/2026-04-03/1775203349", "key": "raw/molo_moloMenuUserPreferences/2026-04-03/1775203349/MenuUserPreferences.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMenuUserPreferences", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4566030710703901405, "service_name": "drive-thru", "span_id": 8907105164318622497, "trace_id": 1527437500546787213 } } - running: False
- schema_name_id: 1704
- start_time: 2026-04-03 03:08:45
- success: True
- trace_id: 1527437500546787213
- attributes:
{ "Hidden": "string", "Id": "string", "MenuId": "string", "Position": "string", "UserId": "string" } - created: 2026-04-17 03:03:52
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences" }
- 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:03",
"disabled": false,
"format": "raw",
"id": 1704,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molomenuuserpreferences"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Hidden": "string",
"Id": "string",
"MenuId": "string",
"Position": "string",
"UserId": "string"
},
"created": "2026-04-17 03:03:52",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomenuuserpreferences`\n(\n `Id` string , `MenuId` string , `UserId` 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_moloMenuUserPreferences/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomenuuserpreferences`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomenuuserpreferences"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}