Schema Info

Schema Name: sfdl_prod_drivethru.molo_molobusinesshoursset

created: 2023-10-17 01:56:18
disabled: False
format: raw
id: 1626
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "molo_molobusinesshoursset"
}

type: drivethrucsv

Schema Versions: 15

Version 1717557

created: 2026-04-17 02:59:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-17/1776412694
id: 1717557
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 162167153
updated: 2026-04-17 02:59:50

Version 1716439

created: 2026-04-16 03:09:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-16/1776326458'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-16/1776326458
id: 1716439
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 162111873
updated: 2026-04-16 03:09:26

Version 1715125

created: 2026-04-15 03:00:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-15/1776239928'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-15/1776239928
id: 1715125
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 162055633
updated: 2026-04-15 03:00:40

Version 1713967

created: 2026-04-14 03:03:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-14/1776153653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-14/1776153653
id: 1713967
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 162000397
updated: 2026-04-14 03:04:02

Version 1712702

created: 2026-04-13 02:55:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-13/1776066846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-13/1776066846
id: 1712702
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161941467
updated: 2026-04-13 02:55:21

Version 1711500

created: 2026-04-12 02:56:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-12/1775980562'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-12/1775980562
id: 1711500
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161892255
updated: 2026-04-12 02:56:35

Version 1710337

created: 2026-04-11 03:01:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-11/1775894322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-11/1775894322
id: 1710337
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161841011
updated: 2026-04-11 03:01:50

Version 1709142

created: 2026-04-10 03:01:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-10/1775808079'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-10/1775808079
id: 1709142
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161785771
updated: 2026-04-10 03:01:55

Version 1708027

created: 2026-04-09 02:59:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-09/1775721418'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-09/1775721418
id: 1708027
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161729816
updated: 2026-04-09 02:59:19

Version 1706797

created: 2026-04-08 03:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-08/1775635225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-08/1775635225
id: 1706797
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161675286
updated: 2026-04-08 03:01:06

Version 1705626

created: 2026-04-07 02:54:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-07/1775548398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-07/1775548398
id: 1705626
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161618303
updated: 2026-04-07 02:54:17

Version 1704404

created: 2026-04-06 03:01:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-06/1775462361'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-06/1775462361
id: 1704404
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161561381
updated: 2026-04-06 03:01:53

Version 1703182

created: 2026-04-05 03:00:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-05/1775375990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-05/1775375990
id: 1703182
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161514707
updated: 2026-04-05 03:00:31

Version 1702017

created: 2026-04-04 02:59:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-04/1775289475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-04/1775289475
id: 1702017
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161459750
updated: 2026-04-04 02:59:16

Version 1700824

created: 2026-04-03 03:04:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-03/1775203247'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBusinessHoursSet/2026-04-03/1775203247
id: 1700824
processed: 1

raw_data:

{
    "EffectiveDate": 1,
    "FridayEnd": 15,
    "FridayOpen": 16,
    "FridayStart": 14,
    "Id": 0,
    "MarinaLocation_Id": 23,
    "MondayEnd": 3,
    "MondayOpen": 4,
    "MondayStart": 2,
    "RecordStatus_Id": 24,
    "SaturdayEnd": 18,
    "SaturdayOpen": 19,
    "SaturdayStart": 17,
    "SundayEnd": 21,
    "SundayOpen": 22,
    "SundayStart": 20,
    "ThursdayEnd": 12,
    "ThursdayOpen": 13,
    "ThursdayStart": 11,
    "TuesdayEnd": 6,
    "TuesdayOpen": 7,
    "TuesdayStart": 5,
    "WednesdayEnd": 9,
    "WednesdayOpen": 10,
    "WednesdayStart": 8
}

schema_attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

schema_name_id: 1626
schema_scan_id: 161401685
updated: 2026-04-03 03:04:19

Schema Scans: 15

Last at 2026-04-17 02:59:38

Scan 162167153

duration: 0:00:12.087462

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162167153

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_moloBusinessHoursSet/2026-04-17/1776412694",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-17/1776412694/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1775987259962864353,
        "service_name": "drive-thru",
        "span_id": 8374217350244449586,
        "trace_id": 16961825543670813294
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-17 02:59:38
success: True
trace_id: 16961825543670813294

Scan 162111873

duration: 0:00:12.229587

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162111873

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_moloBusinessHoursSet/2026-04-16/1776326458",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-16/1776326458/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16681572440667071871,
        "service_name": "drive-thru",
        "span_id": 17712472193337946123,
        "trace_id": 1035940175501066717
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-16 03:09:14
success: True
trace_id: 1035940175501066717

Scan 162055633

duration: 0:00:12.210227

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162055633

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_moloBusinessHoursSet/2026-04-15/1776239928",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-15/1776239928/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3473870175702931705,
        "service_name": "drive-thru",
        "span_id": 12308749501950163445,
        "trace_id": 2656389334585946725
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-15 03:00:28
success: True
trace_id: 2656389334585946725

Scan 162000397

duration: 0:00:14.728846

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162000397

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_moloBusinessHoursSet/2026-04-14/1776153653",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-14/1776153653/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1006264552508996150,
        "service_name": "drive-thru",
        "span_id": 4329720500412616237,
        "trace_id": 8641984784440137735
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-14 03:03:48
success: True
trace_id: 8641984784440137735

Scan 161941467

duration: 0:00:14.645801

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161941467

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_moloBusinessHoursSet/2026-04-13/1776066846",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-13/1776066846/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3424287394852063416,
        "service_name": "drive-thru",
        "span_id": 7365378533721009257,
        "trace_id": 3394678952819728064
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-13 02:55:07
success: True
trace_id: 3394678952819728064

Scan 161892255

duration: 0:00:12.166249

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161892255

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_moloBusinessHoursSet/2026-04-12/1775980562",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-12/1775980562/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10211815819163895248,
        "service_name": "drive-thru",
        "span_id": 13364337364010862312,
        "trace_id": 10003535867443550687
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-12 02:56:23
success: True
trace_id: 10003535867443550687

Scan 161841011

duration: 0:00:12.015672

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161841011

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_moloBusinessHoursSet/2026-04-11/1775894322",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-11/1775894322/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10878843794443870154,
        "service_name": "drive-thru",
        "span_id": 11071511993056691609,
        "trace_id": 9171698996962088249
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-11 03:01:38
success: True
trace_id: 9171698996962088249

Scan 161785771

duration: 0:00:12.223993

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161785771

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_moloBusinessHoursSet/2026-04-10/1775808079",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-10/1775808079/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10720637785727614774,
        "service_name": "drive-thru",
        "span_id": 1784437467969351683,
        "trace_id": 9518672839040100184
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-10 03:01:43
success: True
trace_id: 9518672839040100184

Scan 161729816

duration: 0:00:12.159558

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161729816

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_moloBusinessHoursSet/2026-04-09/1775721418",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-09/1775721418/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4403657006765147060,
        "service_name": "drive-thru",
        "span_id": 14745628028815805490,
        "trace_id": 14779353353706114166
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-09 02:59:07
success: True
trace_id: 14779353353706114166

Scan 161675286

duration: 0:00:12.209975

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161675286

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_moloBusinessHoursSet/2026-04-08/1775635225",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-08/1775635225/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12142058787417094758,
        "service_name": "drive-thru",
        "span_id": 14520891660548341703,
        "trace_id": 11018667370262632652
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-08 03:00:54
success: True
trace_id: 11018667370262632652

Scan 161618303

duration: 0:00:14.656144

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161618303

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_moloBusinessHoursSet/2026-04-07/1775548398",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-07/1775548398/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13326421918722035481,
        "service_name": "drive-thru",
        "span_id": 10812363386997398224,
        "trace_id": 14658151199574129443
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-07 02:54:02
success: True
trace_id: 14658151199574129443

Scan 161561381

duration: 0:00:14.772965

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161561381

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_moloBusinessHoursSet/2026-04-06/1775462361",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-06/1775462361/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15265541384552328012,
        "service_name": "drive-thru",
        "span_id": 962486702724049841,
        "trace_id": 1992053635953479397
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-06 03:01:38
success: True
trace_id: 1992053635953479397

Scan 161514707

duration: 0:00:14.764334

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161514707

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_moloBusinessHoursSet/2026-04-05/1775375990",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-05/1775375990/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16915679997526389134,
        "service_name": "drive-thru",
        "span_id": 7534192387863151546,
        "trace_id": 7952254406102763827
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-05 03:00:16
success: True
trace_id: 7952254406102763827

Scan 161459750

duration: 0:00:12.329512

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161459750

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_moloBusinessHoursSet/2026-04-04/1775289475",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-04/1775289475/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12277856714896647411,
        "service_name": "drive-thru",
        "span_id": 18341953505970063950,
        "trace_id": 14188373366376000413
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-04 02:59:03
success: True
trace_id: 14188373366376000413

Scan 161401685

duration: 0:00:12.290043

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161401685

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_moloBusinessHoursSet/2026-04-03/1775203247",
        "key": "raw/molo_moloBusinessHoursSet/2026-04-03/1775203247/BusinessHoursSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBusinessHoursSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2151497161068135893,
        "service_name": "drive-thru",
        "span_id": 11294097265675537077,
        "trace_id": 627650931033193527
    }
}

running: False
schema_name_id: 1626
start_time: 2026-04-03 03:04:07
success: True
trace_id: 627650931033193527

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "EffectiveDate": "string",
    "FridayEnd": "string",
    "FridayOpen": "string",
    "FridayStart": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "MondayEnd": "string",
    "MondayOpen": "string",
    "MondayStart": "string",
    "RecordStatus_Id": "string",
    "SaturdayEnd": "string",
    "SaturdayOpen": "string",
    "SaturdayStart": "string",
    "SundayEnd": "string",
    "SundayOpen": "string",
    "SundayStart": "string",
    "ThursdayEnd": "string",
    "ThursdayOpen": "string",
    "ThursdayStart": "string",
    "TuesdayEnd": "string",
    "TuesdayOpen": "string",
    "TuesdayStart": "string",
    "WednesdayEnd": "string",
    "WednesdayOpen": "string",
    "WednesdayStart": "string"
}

created: 2026-04-17 02:59:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-10-17 01:56:18",
        "disabled": false,
        "format": "raw",
        "id": 1626,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molobusinesshoursset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "EffectiveDate": "string",
            "FridayEnd": "string",
            "FridayOpen": "string",
            "FridayStart": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "MondayEnd": "string",
            "MondayOpen": "string",
            "MondayStart": "string",
            "RecordStatus_Id": "string",
            "SaturdayEnd": "string",
            "SaturdayOpen": "string",
            "SaturdayStart": "string",
            "SundayEnd": "string",
            "SundayOpen": "string",
            "SundayStart": "string",
            "ThursdayEnd": "string",
            "ThursdayOpen": "string",
            "ThursdayStart": "string",
            "TuesdayEnd": "string",
            "TuesdayOpen": "string",
            "TuesdayStart": "string",
            "WednesdayEnd": "string",
            "WednesdayOpen": "string",
            "WednesdayStart": "string"
        },
        "created": "2026-04-17 02:59:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobusinesshoursset`\n(\n `Id`  string , `EffectiveDate`  string , `MondayStart`  string , `MondayEnd`  string , `MondayOpen`  string , `TuesdayStart`  string , `TuesdayEnd`  string , `TuesdayOpen`  string , `WednesdayStart`  string , `WednesdayEnd`  string , `WednesdayOpen`  string , `ThursdayStart`  string , `ThursdayEnd`  string , `ThursdayOpen`  string , `FridayStart`  string , `FridayEnd`  string , `FridayOpen`  string , `SaturdayStart`  string , `SaturdayEnd`  string , `SaturdayOpen`  string , `SundayStart`  string , `SundayEnd`  string , `SundayOpen`  string , `MarinaLocation_Id`  string , `RecordStatus_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_moloBusinessHoursSet/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobusinesshoursset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobusinesshoursset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}