Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_estimateset

created: 2023-10-17 01:58:20
disabled: False
format: raw
id: 1686
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717796

created: 2026-04-17 03:11:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-17/1776412996'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-17/1776412996
id: 1717796
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 162167831
updated: 2026-04-17 03:12:02

Version 1716585

created: 2026-04-16 03:14:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-16/1776326698'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-16/1776326698
id: 1716585
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 162112047
updated: 2026-04-16 03:14:58

Version 1715322

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-15/1776240186'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-15/1776240186
id: 1715322
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 162056112
updated: 2026-04-15 03:10:20

Version 1714123

created: 2026-04-14 03:10:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-14/1776154139'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-14/1776154139
id: 1714123
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 162000640
updated: 2026-04-14 03:10:25

Version 1712916

created: 2026-04-13 03:04:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-13/1776067134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-13/1776067134
id: 1712916
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161942618
updated: 2026-04-13 03:04:28

Version 1711691

created: 2026-04-12 03:04:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-12/1775980828'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-12/1775980828
id: 1711691
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161893302
updated: 2026-04-12 03:05:08

Version 1710563

created: 2026-04-11 03:11:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-11/1775894602'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-11/1775894602
id: 1710563
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161841370
updated: 2026-04-11 03:11:13

Version 1709333

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-10/1775808363'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-10/1775808363
id: 1709333
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161786031
updated: 2026-04-10 03:09:39

Version 1708247

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-09/1775721688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-09/1775721688
id: 1708247
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161730515
updated: 2026-04-09 03:09:09

Version 1707035

created: 2026-04-08 03:10:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-08/1775635524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-08/1775635524
id: 1707035
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161675699
updated: 2026-04-08 03:11:01

Version 1705816

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-07/1775548687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-07/1775548687
id: 1705816
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161619201
updated: 2026-04-07 03:02:15

Version 1704636

created: 2026-04-06 03:11:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-06/1775462637'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-06/1775462637
id: 1704636
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161561785
updated: 2026-04-06 03:11:44

Version 1703365

created: 2026-04-05 03:07:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-05/1775376269'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-05/1775376269
id: 1703365
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161514947
updated: 2026-04-05 03:08:01

Version 1702224

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-04/1775289749'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-04/1775289749
id: 1702224
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161460510
updated: 2026-04-04 03:08:56

Version 1700983

created: 2026-04-03 03:11:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-03/1775203517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EstimateSet/2026-04-03/1775203517
id: 1700983
processed: 1

raw_data:

{
    "Boat_Id": 18,
    "Contact_Id": 17,
    "CreationDateTime": 1,
    "CreationUserId": 2,
    "DeletionDateTime": 23,
    "DeletionUser_Id": 25,
    "EstimateCustomerFacingComments": 5,
    "EstimateCustomerFacingCommentsDateTime": 13,
    "EstimateCustomerFacingCommentsUser": 12,
    "EstimateInternalComments": 4,
    "EstimateInternalCommentsDateTime": 11,
    "EstimateInternalCommentsUser": 10,
    "EstimatedEndDate": 8,
    "EstimatedStartDate": 7,
    "Id": 0,
    "LinkedEstimate": 14,
    "MarinaLocation_Id": 22,
    "Name": 3,
    "OverrideTaxRate": 26,
    "RecordStatus_Id": 24,
    "SV_EstimateStatus_Id": 16,
    "SV_TermsAndConditionsHTML_Id": 19,
    "SV_WorkOrderCategory_Id": 20,
    "SV_WorkOrderLocation_Id": 21,
    "ScheduledHaulDate": 6,
    "ScheduledLaunchDate": 9,
    "UpdateHash": 15
}

schema_attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

schema_name_id: 1686
schema_scan_id: 161401953
updated: 2026-04-03 03:11:41

Schema Scans: 15

Last at 2026-04-17 03:11:47

Scan 162167831

duration: 0:00:14.961177

exit_message:

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

id: 162167831

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_moloSV_EstimateSet/2026-04-17/1776412996",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-17/1776412996/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8258614102448946901,
        "service_name": "drive-thru",
        "span_id": 12364785227302332154,
        "trace_id": 2864290734331800448
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-17 03:11:47
success: True
trace_id: 2864290734331800448

Scan 162112047

duration: 0:00:12.447354

exit_message:

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

id: 162112047

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_moloSV_EstimateSet/2026-04-16/1776326698",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-16/1776326698/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14487590160564847299,
        "service_name": "drive-thru",
        "span_id": 3541497133641154338,
        "trace_id": 4590887223122969818
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-16 03:14:45
success: True
trace_id: 4590887223122969818

Scan 162056112

duration: 0:00:12.399117

exit_message:

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

id: 162056112

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_moloSV_EstimateSet/2026-04-15/1776240186",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-15/1776240186/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12432167768929318381,
        "service_name": "drive-thru",
        "span_id": 9194307376134528845,
        "trace_id": 13631741740309353395
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-15 03:10:08
success: True
trace_id: 13631741740309353395

Scan 162000640

duration: 0:00:12.375279

exit_message:

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

id: 162000640

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_moloSV_EstimateSet/2026-04-14/1776154139",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-14/1776154139/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9671349126241365471,
        "service_name": "drive-thru",
        "span_id": 18372285656093876358,
        "trace_id": 15911303614484945483
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-14 03:10:13
success: True
trace_id: 15911303614484945483

Scan 161942618

duration: 0:00:14.816601

exit_message:

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

id: 161942618

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_moloSV_EstimateSet/2026-04-13/1776067134",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-13/1776067134/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4812389021077899776,
        "service_name": "drive-thru",
        "span_id": 5360639989612900572,
        "trace_id": 6195704810986836571
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-13 03:04:13
success: True
trace_id: 6195704810986836571

Scan 161893302

duration: 0:00:14.825735

exit_message:

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

id: 161893302

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_moloSV_EstimateSet/2026-04-12/1775980828",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-12/1775980828/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12944607030066604344,
        "service_name": "drive-thru",
        "span_id": 15267237957477956882,
        "trace_id": 8343056893075893339
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-12 03:04:53
success: True
trace_id: 8343056893075893339

Scan 161841370

duration: 0:00:12.374767

exit_message:

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

id: 161841370

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_moloSV_EstimateSet/2026-04-11/1775894602",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-11/1775894602/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2725327512279149300,
        "service_name": "drive-thru",
        "span_id": 199696057381939467,
        "trace_id": 10228899860467779
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-11 03:11:01
success: True
trace_id: 10228899860467779

Scan 161786031

duration: 0:00:12.388939

exit_message:

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

id: 161786031

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_moloSV_EstimateSet/2026-04-10/1775808363",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-10/1775808363/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1202576645986982630,
        "service_name": "drive-thru",
        "span_id": 9891136461630184820,
        "trace_id": 4069001235110656018
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-10 03:09:27
success: True
trace_id: 4069001235110656018

Scan 161730515

duration: 0:00:12.406690

exit_message:

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

id: 161730515

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_moloSV_EstimateSet/2026-04-09/1775721688",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-09/1775721688/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7732325018797456521,
        "service_name": "drive-thru",
        "span_id": 5340000072905865691,
        "trace_id": 17591066557047160019
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-09 03:08:57
success: True
trace_id: 17591066557047160019

Scan 161675699

duration: 0:00:12.271795

exit_message:

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

id: 161675699

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_moloSV_EstimateSet/2026-04-08/1775635524",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-08/1775635524/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1073113265633479715,
        "service_name": "drive-thru",
        "span_id": 10644752056715715404,
        "trace_id": 12364883878289351273
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-08 03:10:48
success: True
trace_id: 12364883878289351273

Scan 161619201

duration: 0:00:15.021307

exit_message:

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

id: 161619201

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_moloSV_EstimateSet/2026-04-07/1775548687",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-07/1775548687/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1672872794439138664,
        "service_name": "drive-thru",
        "span_id": 7393184356452273892,
        "trace_id": 8537144012655656743
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-07 03:02:00
success: True
trace_id: 8537144012655656743

Scan 161561785

duration: 0:00:12.338999

exit_message:

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

id: 161561785

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_moloSV_EstimateSet/2026-04-06/1775462637",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-06/1775462637/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5352430196970850776,
        "service_name": "drive-thru",
        "span_id": 9023490042281052146,
        "trace_id": 1639464076287166909
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-06 03:11:32
success: True
trace_id: 1639464076287166909

Scan 161514947

duration: 0:00:14.872977

exit_message:

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

id: 161514947

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_moloSV_EstimateSet/2026-04-05/1775376269",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-05/1775376269/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7027867037143996996,
        "service_name": "drive-thru",
        "span_id": 16067997552815967279,
        "trace_id": 5070610603164475974
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-05 03:07:46
success: True
trace_id: 5070610603164475974

Scan 161460510

duration: 0:00:15.088335

exit_message:

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

id: 161460510

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_moloSV_EstimateSet/2026-04-04/1775289749",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-04/1775289749/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2730294203784195023,
        "service_name": "drive-thru",
        "span_id": 16064556455944128719,
        "trace_id": 9422392947785145667
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-04 03:08:41
success: True
trace_id: 9422392947785145667

Scan 161401953

duration: 0:00:14.894473

exit_message:

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

id: 161401953

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_moloSV_EstimateSet/2026-04-03/1775203517",
        "key": "raw/molo_moloSV_EstimateSet/2026-04-03/1775203517/SV_EstimateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_EstimateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3164589504826821426,
        "service_name": "drive-thru",
        "span_id": 15463369945380577792,
        "trace_id": 7868453530691535150
    }
}

running: False
schema_name_id: 1686
start_time: 2026-04-03 03:11:26
success: True
trace_id: 7868453530691535150

Partitions:

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

Schema:

attributes:

{
    "Boat_Id": "string",
    "Contact_Id": "string",
    "CreationDateTime": "string",
    "CreationUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "EstimateCustomerFacingComments": "string",
    "EstimateCustomerFacingCommentsDateTime": "string",
    "EstimateCustomerFacingCommentsUser": "string",
    "EstimateInternalComments": "string",
    "EstimateInternalCommentsDateTime": "string",
    "EstimateInternalCommentsUser": "string",
    "EstimatedEndDate": "string",
    "EstimatedStartDate": "string",
    "Id": "string",
    "LinkedEstimate": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "OverrideTaxRate": "string",
    "RecordStatus_Id": "string",
    "SV_EstimateStatus_Id": "string",
    "SV_TermsAndConditionsHTML_Id": "string",
    "SV_WorkOrderCategory_Id": "string",
    "SV_WorkOrderLocation_Id": "string",
    "ScheduledHaulDate": "string",
    "ScheduledLaunchDate": "string",
    "UpdateHash": "string"
}

created: 2026-04-17 03:11:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-17/1776412996'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
}

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:58:20",
        "disabled": false,
        "format": "raw",
        "id": 1686,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_estimateset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Boat_Id": "string",
            "Contact_Id": "string",
            "CreationDateTime": "string",
            "CreationUserId": "string",
            "DeletionDateTime": "string",
            "DeletionUser_Id": "string",
            "EstimateCustomerFacingComments": "string",
            "EstimateCustomerFacingCommentsDateTime": "string",
            "EstimateCustomerFacingCommentsUser": "string",
            "EstimateInternalComments": "string",
            "EstimateInternalCommentsDateTime": "string",
            "EstimateInternalCommentsUser": "string",
            "EstimatedEndDate": "string",
            "EstimatedStartDate": "string",
            "Id": "string",
            "LinkedEstimate": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "OverrideTaxRate": "string",
            "RecordStatus_Id": "string",
            "SV_EstimateStatus_Id": "string",
            "SV_TermsAndConditionsHTML_Id": "string",
            "SV_WorkOrderCategory_Id": "string",
            "SV_WorkOrderLocation_Id": "string",
            "ScheduledHaulDate": "string",
            "ScheduledLaunchDate": "string",
            "UpdateHash": "string"
        },
        "created": "2026-04-17 03:11:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_estimateset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationUserId`  string , `Name`  string , `EstimateInternalComments`  string , `EstimateCustomerFacingComments`  string , `ScheduledHaulDate`  string , `EstimatedStartDate`  string , `EstimatedEndDate`  string , `ScheduledLaunchDate`  string , `EstimateInternalCommentsUser`  string , `EstimateInternalCommentsDateTime`  string , `EstimateCustomerFacingCommentsUser`  string , `EstimateCustomerFacingCommentsDateTime`  string , `LinkedEstimate`  string , `UpdateHash`  string , `SV_EstimateStatus_Id`  string , `Contact_Id`  string , `Boat_Id`  string , `SV_TermsAndConditionsHTML_Id`  string , `SV_WorkOrderCategory_Id`  string , `SV_WorkOrderLocation_Id`  string , `MarinaLocation_Id`  string , `DeletionDateTime`  string , `RecordStatus_Id`  string , `DeletionUser_Id`  string , `OverrideTaxRate`  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_moloSV_EstimateSet/2026-04-17/1776412996'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_estimateset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_estimateset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}