Schema Info
Schema Name: sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset
- created: 2023-10-17 02:01:58
- disabled: False
- format: raw
- id: 1785
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molotechniciancalendarsettingsset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717819
- created: 2026-04-17 03:13:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131
- id: 1717819
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 162167855
- updated: 2026-04-17 03:13:23
-
Version 1716560
- created: 2026-04-16 03:13:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-16/1776326733'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-16/1776326733
- id: 1716560
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 162112019
- updated: 2026-04-16 03:14:04
-
Version 1715371
- created: 2026-04-15 03:12:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-15/1776240199'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-15/1776240199
- id: 1715371
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 162056171
- updated: 2026-04-15 03:12:46
-
Version 1714191
- created: 2026-04-14 03:12:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-14/1776154166'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-14/1776154166
- id: 1714191
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 162000715
- updated: 2026-04-14 03:13:03
-
Version 1712940
- created: 2026-04-13 03:05:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-13/1776067160'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-13/1776067160
- id: 1712940
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161942732
- updated: 2026-04-13 03:05:55
-
Version 1711702
- created: 2026-04-12 03:05:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-12/1775980861'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-12/1775980861
- id: 1711702
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161893353
- updated: 2026-04-12 03:05:54
-
Version 1710566
- created: 2026-04-11 03:11:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-11/1775894630'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-11/1775894630
- id: 1710566
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161841373
- updated: 2026-04-11 03:11:24
-
Version 1709417
- created: 2026-04-10 03:12:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-10/1775808390'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-10/1775808390
- id: 1709417
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161786124
- updated: 2026-04-10 03:13:06
-
Version 1708261
- created: 2026-04-09 03:09:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-09/1775721719'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-09/1775721719
- id: 1708261
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161730544
- updated: 2026-04-09 03:09:51
-
Version 1706955
- created: 2026-04-08 03:07:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-08/1775635551'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-08/1775635551
- id: 1706955
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161675602
- updated: 2026-04-08 03:07:58
-
Version 1705889
- created: 2026-04-07 03:05:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-07/1775548712'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-07/1775548712
- id: 1705889
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161619509
- updated: 2026-04-07 03:05:53
-
Version 1704603
- created: 2026-04-06 03:10:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-06/1775462662'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-06/1775462662
- id: 1704603
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161561747
- updated: 2026-04-06 03:10:31
-
Version 1703403
- created: 2026-04-05 03:09:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-05/1775376294'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-05/1775376294
- id: 1703403
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161514988
- updated: 2026-04-05 03:09:24
-
Version 1702279
- created: 2026-04-04 03:11:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-04/1775289775'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-04/1775289775
- id: 1702279
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161460592
- updated: 2026-04-04 03:11:15
-
Version 1701018
- created: 2026-04-03 03:13:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-03/1775203541'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-03/1775203541
- id: 1701018
- processed: 1
- raw_data:
{ "AspNetUser_Id": 22, "Friday": 5, "FridayEnd": 17, "FridayStart": 16, "Id": 0, "Monday": 1, "MondayEnd": 9, "MondayStart": 8, "Saturday": 6, "SaturdayEnd": 19, "SaturdayStart": 18, "Sunday": 7, "SundayEnd": 21, "SundayStart": 20, "Thursday": 4, "ThursdayEnd": 15, "ThursdayStart": 14, "Tuesday": 2, "TuesdayEnd": 11, "TuesdayStart": 10, "Wednesday": 3, "WednesdayEnd": 13, "WednesdayStart": 12 } - schema_attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - schema_name_id: 1785
- schema_scan_id: 161401993
- updated: 2026-04-03 03:13:17
Schema Scans: 15
Last at 2026-04-17 03:13:09
-
Scan 162167855
- duration: 0:00:14.679528
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167855
- 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_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 902629404466217262, "service_name": "drive-thru", "span_id": 10047684626409778671, "trace_id": 15893433161059494022 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-17 03:13:09
- success: True
- trace_id: 15893433161059494022
-
Scan 162112019
- duration: 0:00:12.148056
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112019
- 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_moloTechnicianCalendarSettingsSet/2026-04-16/1776326733", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-16/1776326733/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6044667497430495620, "service_name": "drive-thru", "span_id": 16010830655245306369, "trace_id": 4098210103113432820 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-16 03:13:52
- success: True
- trace_id: 4098210103113432820
-
Scan 162056171
- duration: 0:00:12.229645
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056171
- 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_moloTechnicianCalendarSettingsSet/2026-04-15/1776240199", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-15/1776240199/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1383936477931442616, "service_name": "drive-thru", "span_id": 8484698909505861021, "trace_id": 8477189035486271086 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-15 03:12:34
- success: True
- trace_id: 8477189035486271086
-
Scan 162000715
- duration: 0:00:14.587895
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000715
- 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_moloTechnicianCalendarSettingsSet/2026-04-14/1776154166", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-14/1776154166/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7059101139197982215, "service_name": "drive-thru", "span_id": 15122921668450875837, "trace_id": 10546658043450661139 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-14 03:12:48
- success: True
- trace_id: 10546658043450661139
-
Scan 161942732
- duration: 0:00:15.281094
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942732
- 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_moloTechnicianCalendarSettingsSet/2026-04-13/1776067160", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-13/1776067160/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7765942995113779143, "service_name": "drive-thru", "span_id": 3288773320142854470, "trace_id": 16471600372631344032 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-13 03:05:39
- success: True
- trace_id: 16471600372631344032
-
Scan 161893353
- duration: 0:00:14.576242
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893353
- 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_moloTechnicianCalendarSettingsSet/2026-04-12/1775980861", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-12/1775980861/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6349290887806734488, "service_name": "drive-thru", "span_id": 9397948783081510587, "trace_id": 6686580676238398000 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-12 03:05:40
- success: True
- trace_id: 6686580676238398000
-
Scan 161841373
- duration: 0:00:12.243540
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841373
- 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_moloTechnicianCalendarSettingsSet/2026-04-11/1775894630", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-11/1775894630/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8194060983271093785, "service_name": "drive-thru", "span_id": 1451633618778048875, "trace_id": 2843703826483892354 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-11 03:11:12
- success: True
- trace_id: 2843703826483892354
-
Scan 161786124
- duration: 0:00:14.671764
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786124
- 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_moloTechnicianCalendarSettingsSet/2026-04-10/1775808390", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-10/1775808390/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1995726514818624876, "service_name": "drive-thru", "span_id": 9555548814835002874, "trace_id": 14782582565998132047 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-10 03:12:52
- success: True
- trace_id: 14782582565998132047
-
Scan 161730544
- duration: 0:00:12.381695
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730544
- 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_moloTechnicianCalendarSettingsSet/2026-04-09/1775721719", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-09/1775721719/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4108557336796084011, "service_name": "drive-thru", "span_id": 14979403081836717853, "trace_id": 3051740916010558989 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-09 03:09:39
- success: True
- trace_id: 3051740916010558989
-
Scan 161675602
- duration: 0:00:11.999578
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675602
- 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_moloTechnicianCalendarSettingsSet/2026-04-08/1775635551", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-08/1775635551/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15202105703520053973, "service_name": "drive-thru", "span_id": 1723584417724970280, "trace_id": 13069718797780913076 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-08 03:07:46
- success: True
- trace_id: 13069718797780913076
-
Scan 161619509
- duration: 0:00:14.736355
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619509
- 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_moloTechnicianCalendarSettingsSet/2026-04-07/1775548712", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-07/1775548712/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1445988856035667442, "service_name": "drive-thru", "span_id": 16467360147928772989, "trace_id": 5513028181491699493 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-07 03:05:38
- success: True
- trace_id: 5513028181491699493
-
Scan 161561747
- duration: 0:00:14.666005
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561747
- 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_moloTechnicianCalendarSettingsSet/2026-04-06/1775462662", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-06/1775462662/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 581063527879298671, "service_name": "drive-thru", "span_id": 14250979266313255940, "trace_id": 405108441781034971 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-06 03:10:16
- success: True
- trace_id: 405108441781034971
-
Scan 161514988
- duration: 0:00:14.669214
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514988
- 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_moloTechnicianCalendarSettingsSet/2026-04-05/1775376294", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-05/1775376294/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8426253331453467329, "service_name": "drive-thru", "span_id": 9464363060813334486, "trace_id": 15552664425420398634 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-05 03:09:09
- success: True
- trace_id: 15552664425420398634
-
Scan 161460592
- duration: 0:00:14.655413
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460592
- 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_moloTechnicianCalendarSettingsSet/2026-04-04/1775289775", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-04/1775289775/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5654032234095932437, "service_name": "drive-thru", "span_id": 10635556561438723640, "trace_id": 5029654463241947211 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-04 03:11:00
- success: True
- trace_id: 5029654463241947211
-
Scan 161401993
- duration: 0:00:14.756461
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401993
- 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_moloTechnicianCalendarSettingsSet/2026-04-03/1775203541", "key": "raw/molo_moloTechnicianCalendarSettingsSet/2026-04-03/1775203541/TechnicianCalendarSettingsSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloTechnicianCalendarSettingsSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 989083914504785205, "service_name": "drive-thru", "span_id": 13288901049787040619, "trace_id": 11914239288247961108 } } - running: False
- schema_name_id: 1785
- start_time: 2026-04-03 03:13:02
- success: True
- trace_id: 11914239288247961108
- attributes:
{ "AspNetUser_Id": "string", "Friday": "string", "FridayEnd": "string", "FridayStart": "string", "Id": "string", "Monday": "string", "MondayEnd": "string", "MondayStart": "string", "Saturday": "string", "SaturdayEnd": "string", "SaturdayStart": "string", "Sunday": "string", "SundayEnd": "string", "SundayStart": "string", "Thursday": "string", "ThursdayEnd": "string", "ThursdayStart": "string", "Tuesday": "string", "TuesdayEnd": "string", "TuesdayStart": "string", "Wednesday": "string", "WednesdayEnd": "string", "WednesdayStart": "string" } - created: 2026-04-17 03:13:10
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset" }
- 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 02:01:58",
"disabled": false,
"format": "raw",
"id": 1785,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molotechniciancalendarsettingsset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"AspNetUser_Id": "string",
"Friday": "string",
"FridayEnd": "string",
"FridayStart": "string",
"Id": "string",
"Monday": "string",
"MondayEnd": "string",
"MondayStart": "string",
"Saturday": "string",
"SaturdayEnd": "string",
"SaturdayStart": "string",
"Sunday": "string",
"SundayEnd": "string",
"SundayStart": "string",
"Thursday": "string",
"ThursdayEnd": "string",
"ThursdayStart": "string",
"Tuesday": "string",
"TuesdayEnd": "string",
"TuesdayStart": "string",
"Wednesday": "string",
"WednesdayEnd": "string",
"WednesdayStart": "string"
},
"created": "2026-04-17 03:13:10",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`\n(\n `Id` string , `Monday` string , `Tuesday` string , `Wednesday` string , `Thursday` string , `Friday` string , `Saturday` string , `Sunday` string , `MondayStart` string , `MondayEnd` string , `TuesdayStart` string , `TuesdayEnd` string , `WednesdayStart` string , `WednesdayEnd` string , `ThursdayStart` string , `ThursdayEnd` string , `FridayStart` string , `FridayEnd` string , `SaturdayStart` string , `SaturdayEnd` string , `SundayStart` string , `SundayEnd` string , `AspNetUser_Id` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTechnicianCalendarSettingsSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotechniciancalendarsettingsset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}