Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloslipplacementset

created: 2023-10-17 01:59:24
disabled: False
format: raw
id: 1715
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717736

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-17/1776412851
id: 1717736
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 162167738
updated: 2026-04-17 03:09:06

Version 1716477

created: 2026-04-16 03:10:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-16/1776326605'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-16/1776326605
id: 1716477
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 162111916
updated: 2026-04-16 03:10:56

Version 1715231

created: 2026-04-15 03:06:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-15/1776240075'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-15/1776240075
id: 1715231
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 162055961
updated: 2026-04-15 03:06:13

Version 1714150

created: 2026-04-14 03:11:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-14/1776153840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-14/1776153840
id: 1714150
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 162000670
updated: 2026-04-14 03:11:30

Version 1712864

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-13/1776067000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-13/1776067000
id: 1712864
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161942004
updated: 2026-04-13 03:01:25

Version 1711641

created: 2026-04-12 03:02:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-12/1775980710'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-12/1775980710
id: 1711641
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161892840
updated: 2026-04-12 03:02:23

Version 1710538

created: 2026-04-11 03:09:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-11/1775894478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-11/1775894478
id: 1710538
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161841337
updated: 2026-04-11 03:10:12

Version 1709220

created: 2026-04-10 03:05:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-10/1775808236'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-10/1775808236
id: 1709220
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161785902
updated: 2026-04-10 03:05:23

Version 1708205

created: 2026-04-09 03:07:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-09/1775721568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-09/1775721568
id: 1708205
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161730449
updated: 2026-04-09 03:07:17

Version 1706894

created: 2026-04-08 03:05:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-08/1775635397'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-08/1775635397
id: 1706894
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161675508
updated: 2026-04-08 03:05:20

Version 1705788

created: 2026-04-07 03:00:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-07/1775548553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-07/1775548553
id: 1705788
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161618744
updated: 2026-04-07 03:00:27

Version 1704556

created: 2026-04-06 03:08:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-06/1775462513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-06/1775462513
id: 1704556
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161561669
updated: 2026-04-06 03:08:32

Version 1703306

created: 2026-04-05 03:05:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-05/1775376139'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-05/1775376139
id: 1703306
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161514884
updated: 2026-04-05 03:05:37

Version 1702231

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-04/1775289622'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-04/1775289622
id: 1702231
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161460518
updated: 2026-04-04 03:09:11

Version 1700960

created: 2026-04-03 03:10:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-03/1775203395'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementSet/2026-04-03/1775203395
id: 1700960
processed: 1

raw_data:

{
    "BoatID": 27,
    "ContactID": 26,
    "CreationDateTime": 20,
    "CreationPartner": 21,
    "CreationUser": 19,
    "Dimensions": 10,
    "EndDate": 2,
    "ExpirationDateTime": 11,
    "GroupCode": 29,
    "HashID": 8,
    "Id": 0,
    "MarinaHashID": 9,
    "MoloOnlineBooking": 28,
    "Offers_Id": 7,
    "OnlineBookingNotes": 30,
    "Pedestal1": 13,
    "Pedestal2": 14,
    "Pedestal3": 15,
    "Pedestal4": 16,
    "Pedestal5": 17,
    "Reservation_Id": 18,
    "SlipBlockSetId": 25,
    "SlipId": 12,
    "SlipPlacementStatus_Id": 3,
    "StartDate": 1,
    "UpdateDateTime": 23,
    "UpdatePartner": 24,
    "UpdateUser": 22,
    "VesselBeam": 5,
    "VesselDraft": 6,
    "VesselLoa": 4
}

schema_attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

schema_name_id: 1715
schema_scan_id: 161401922
updated: 2026-04-03 03:10:50

Schema Scans: 15

Last at 2026-04-17 03:08:53

Scan 162167738

duration: 0:00:12.563699

exit_message:

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

id: 162167738

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_moloSlipPlacementSet/2026-04-17/1776412851",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-17/1776412851/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4279559882034222060,
        "service_name": "drive-thru",
        "span_id": 2395016004378456946,
        "trace_id": 3229316717926462040
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-17 03:08:53
success: True
trace_id: 3229316717926462040

Scan 162111916

duration: 0:00:15.168770

exit_message:

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

id: 162111916

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_moloSlipPlacementSet/2026-04-16/1776326605",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-16/1776326605/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 224574927017678152,
        "service_name": "drive-thru",
        "span_id": 8125000952482781510,
        "trace_id": 15825287903461393094
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-16 03:10:41
success: True
trace_id: 15825287903461393094

Scan 162055961

duration: 0:00:12.601494

exit_message:

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

id: 162055961

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_moloSlipPlacementSet/2026-04-15/1776240075",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-15/1776240075/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3942539726608632172,
        "service_name": "drive-thru",
        "span_id": 15884401238724500732,
        "trace_id": 6681514116640412384
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-15 03:06:01
success: True
trace_id: 6681514116640412384

Scan 162000670

duration: 0:00:12.383691

exit_message:

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

id: 162000670

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_moloSlipPlacementSet/2026-04-14/1776153840",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-14/1776153840/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11701993356298846600,
        "service_name": "drive-thru",
        "span_id": 11810609850186854691,
        "trace_id": 1989646569794726762
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-14 03:11:17
success: True
trace_id: 1989646569794726762

Scan 161942004

duration: 0:00:15.014383

exit_message:

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

id: 161942004

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_moloSlipPlacementSet/2026-04-13/1776067000",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-13/1776067000/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9484351976558785795,
        "service_name": "drive-thru",
        "span_id": 3808517227146488488,
        "trace_id": 290805974977377117
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-13 03:01:10
success: True
trace_id: 290805974977377117

Scan 161892840

duration: 0:00:12.514623

exit_message:

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

id: 161892840

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_moloSlipPlacementSet/2026-04-12/1775980710",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-12/1775980710/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12578677404533903054,
        "service_name": "drive-thru",
        "span_id": 2788869836529738276,
        "trace_id": 4542190099899914367
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-12 03:02:11
success: True
trace_id: 4542190099899914367

Scan 161841337

duration: 0:00:15.036631

exit_message:

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

id: 161841337

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_moloSlipPlacementSet/2026-04-11/1775894478",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-11/1775894478/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9415707838513007120,
        "service_name": "drive-thru",
        "span_id": 2390299203740424827,
        "trace_id": 2349614831219542157
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-11 03:09:57
success: True
trace_id: 2349614831219542157

Scan 161785902

duration: 0:00:14.998686

exit_message:

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

id: 161785902

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_moloSlipPlacementSet/2026-04-10/1775808236",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-10/1775808236/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14452327801923584673,
        "service_name": "drive-thru",
        "span_id": 1427141723908956978,
        "trace_id": 9217123053003064144
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-10 03:05:08
success: True
trace_id: 9217123053003064144

Scan 161730449

duration: 0:00:12.617158

exit_message:

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

id: 161730449

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_moloSlipPlacementSet/2026-04-09/1775721568",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-09/1775721568/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9639536845641172615,
        "service_name": "drive-thru",
        "span_id": 1643352796869024350,
        "trace_id": 8708196756088515603
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-09 03:07:04
success: True
trace_id: 8708196756088515603

Scan 161675508

duration: 0:00:12.389123

exit_message:

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

id: 161675508

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_moloSlipPlacementSet/2026-04-08/1775635397",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-08/1775635397/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13261476027248429359,
        "service_name": "drive-thru",
        "span_id": 6903969867124829888,
        "trace_id": 8966454028931053514
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-08 03:05:08
success: True
trace_id: 8966454028931053514

Scan 161618744

duration: 0:00:15.255522

exit_message:

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

id: 161618744

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_moloSlipPlacementSet/2026-04-07/1775548553",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-07/1775548553/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4981705231774397969,
        "service_name": "drive-thru",
        "span_id": 5532209844578354381,
        "trace_id": 6276015053308214884
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-07 03:00:12
success: True
trace_id: 6276015053308214884

Scan 161561669

duration: 0:00:12.500365

exit_message:

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

id: 161561669

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_moloSlipPlacementSet/2026-04-06/1775462513",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-06/1775462513/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1486135557021277761,
        "service_name": "drive-thru",
        "span_id": 3739175178735718709,
        "trace_id": 17842261958745007086
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-06 03:08:20
success: True
trace_id: 17842261958745007086

Scan 161514884

duration: 0:00:14.991210

exit_message:

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

id: 161514884

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_moloSlipPlacementSet/2026-04-05/1775376139",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-05/1775376139/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6075451349835810694,
        "service_name": "drive-thru",
        "span_id": 2873644664313004920,
        "trace_id": 6362240504320393506
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-05 03:05:22
success: True
trace_id: 6362240504320393506

Scan 161460518

duration: 0:00:15.085213

exit_message:

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

id: 161460518

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_moloSlipPlacementSet/2026-04-04/1775289622",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-04/1775289622/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5897347099923226270,
        "service_name": "drive-thru",
        "span_id": 12009187204157390707,
        "trace_id": 8850587268973097455
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-04 03:08:56
success: True
trace_id: 8850587268973097455

Scan 161401922

duration: 0:00:15.034427

exit_message:

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

id: 161401922

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_moloSlipPlacementSet/2026-04-03/1775203395",
        "key": "raw/molo_moloSlipPlacementSet/2026-04-03/1775203395/SlipPlacementSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSlipPlacementSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14232462580919604311,
        "service_name": "drive-thru",
        "span_id": 16360178393850322480,
        "trace_id": 2365951247781634581
    }
}

running: False
schema_name_id: 1715
start_time: 2026-04-03 03:10:35
success: True
trace_id: 2365951247781634581

Partitions:

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

Schema:

attributes:

{
    "BoatID": "string",
    "ContactID": "string",
    "CreationDateTime": "string",
    "CreationPartner": "string",
    "CreationUser": "string",
    "Dimensions": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashID": "string",
    "Id": "string",
    "MarinaHashID": "string",
    "MoloOnlineBooking": "string",
    "Offers_Id": "string",
    "OnlineBookingNotes": "string",
    "Pedestal1": "string",
    "Pedestal2": "string",
    "Pedestal3": "string",
    "Pedestal4": "string",
    "Pedestal5": "string",
    "Reservation_Id": "string",
    "SlipBlockSetId": "string",
    "SlipId": "string",
    "SlipPlacementStatus_Id": "string",
    "StartDate": "string",
    "UpdateDateTime": "string",
    "UpdatePartner": "string",
    "UpdateUser": "string",
    "VesselBeam": "string",
    "VesselDraft": "string",
    "VesselLoa": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
}

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:59:24",
        "disabled": false,
        "format": "raw",
        "id": 1715,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloslipplacementset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "BoatID": "string",
            "ContactID": "string",
            "CreationDateTime": "string",
            "CreationPartner": "string",
            "CreationUser": "string",
            "Dimensions": "string",
            "EndDate": "string",
            "ExpirationDateTime": "string",
            "GroupCode": "string",
            "HashID": "string",
            "Id": "string",
            "MarinaHashID": "string",
            "MoloOnlineBooking": "string",
            "Offers_Id": "string",
            "OnlineBookingNotes": "string",
            "Pedestal1": "string",
            "Pedestal2": "string",
            "Pedestal3": "string",
            "Pedestal4": "string",
            "Pedestal5": "string",
            "Reservation_Id": "string",
            "SlipBlockSetId": "string",
            "SlipId": "string",
            "SlipPlacementStatus_Id": "string",
            "StartDate": "string",
            "UpdateDateTime": "string",
            "UpdatePartner": "string",
            "UpdateUser": "string",
            "VesselBeam": "string",
            "VesselDraft": "string",
            "VesselLoa": "string"
        },
        "created": "2026-04-17 03:08:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementset`\n(\n `Id`  string , `StartDate`  string , `EndDate`  string , `SlipPlacementStatus_Id`  string , `VesselLoa`  string , `VesselBeam`  string , `VesselDraft`  string , `Offers_Id`  string , `HashID`  string , `MarinaHashID`  string , `Dimensions`  string , `ExpirationDateTime`  string , `SlipId`  string , `Pedestal1`  string , `Pedestal2`  string , `Pedestal3`  string , `Pedestal4`  string , `Pedestal5`  string , `Reservation_Id`  string , `CreationUser`  string , `CreationDateTime`  string , `CreationPartner`  string , `UpdateUser`  string , `UpdateDateTime`  string , `UpdatePartner`  string , `SlipBlockSetId`  string , `ContactID`  string , `BoatID`  string , `MoloOnlineBooking`  string , `GroupCode`  string , `OnlineBookingNotes`  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_moloSlipPlacementSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}