Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourcestatussettingsset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717761

created: 2026-04-17 03:09:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-17/1776412847
id: 1717761
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 162167779
updated: 2026-04-17 03:10:09

Version 1716422

created: 2026-04-16 03:08:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-16/1776326601'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-16/1776326601
id: 1716422
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 162111856
updated: 2026-04-16 03:08:50

Version 1715271

created: 2026-04-15 03:07:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-15/1776240071'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-15/1776240071
id: 1715271
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 162056016
updated: 2026-04-15 03:07:47

Version 1714086

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-14/1776153836'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-14/1776153836
id: 1714086
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 162000591
updated: 2026-04-14 03:09:00

Version 1712823

created: 2026-04-13 02:59:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-13/1776066996'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-13/1776066996
id: 1712823
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161941825
updated: 2026-04-13 03:00:08

Version 1711665

created: 2026-04-12 03:03:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-12/1775980707'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-12/1775980707
id: 1711665
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161893041
updated: 2026-04-12 03:03:24

Version 1710411

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-11/1775894474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-11/1775894474
id: 1710411
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161841184
updated: 2026-04-11 03:05:15

Version 1709394

created: 2026-04-10 03:11:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-10/1775808232'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-10/1775808232
id: 1709394
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161786097
updated: 2026-04-10 03:12:00

Version 1708188

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-09/1775721564'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-09/1775721564
id: 1708188
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161730426
updated: 2026-04-09 03:06:40

Version 1707007

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-08/1775635393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-08/1775635393
id: 1707007
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161675669
updated: 2026-04-08 03:09:59

Version 1705770

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-07/1775548549'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-07/1775548549
id: 1705770
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161618652
updated: 2026-04-07 02:59:53

Version 1704510

created: 2026-04-06 03:06:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-06/1775462509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-06/1775462509
id: 1704510
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161561603
updated: 2026-04-06 03:06:45

Version 1703323

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-05/1775376137'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-05/1775376137
id: 1703323
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161514903
updated: 2026-04-05 03:06:22

Version 1702211

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-04/1775289619'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-04/1775289619
id: 1702211
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161460497
updated: 2026-04-04 03:08:15

Version 1700951

created: 2026-04-03 03:10:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-03/1775203391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceStatusSettingsSet/2026-04-03/1775203391
id: 1700951
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocationId": 14,
    "MovableArrived": 3,
    "MovableArrivedText": 17,
    "MovableCancelled": 7,
    "MovableCancelledText": 21,
    "MovableComplete": 6,
    "MovableCompleteText": 20,
    "MovableConfirmed": 2,
    "MovableConfirmedText": 16,
    "MovableOut": 4,
    "MovableOutText": 18,
    "MovablePending": 1,
    "MovablePendingText": 15,
    "MovableReturned": 5,
    "MovableReturnedText": 19,
    "StationaryCancelled": 13,
    "StationaryCancelledText": 27,
    "StationaryCheckedIn": 10,
    "StationaryCheckedInText": 24,
    "StationaryCheckedOut": 12,
    "StationaryCheckedOutText": 26,
    "StationaryConfirmed": 9,
    "StationaryConfirmedText": 23,
    "StationaryOnLeave": 11,
    "StationaryOnLeaveText": 25,
    "StationaryPending": 8,
    "StationaryPendingText": 22
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

schema_name_id: 1710
schema_scan_id: 161401910
updated: 2026-04-03 03:10:22

Schema Scans: 15

Last at 2026-04-17 03:09:56

Scan 162167779

duration: 0:00:12.107975

exit_message:

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

id: 162167779

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_moloResourceStatusSettingsSet/2026-04-17/1776412847",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-17/1776412847/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3068143562406034411,
        "service_name": "drive-thru",
        "span_id": 8194441972226718,
        "trace_id": 10471295914987343938
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-17 03:09:56
success: True
trace_id: 10471295914987343938

Scan 162111856

duration: 0:00:12.349567

exit_message:

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

id: 162111856

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_moloResourceStatusSettingsSet/2026-04-16/1776326601",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-16/1776326601/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7045241157074045055,
        "service_name": "drive-thru",
        "span_id": 2971514253012381104,
        "trace_id": 9354160481182407317
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-16 03:08:38
success: True
trace_id: 9354160481182407317

Scan 162056016

duration: 0:00:12.140473

exit_message:

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

id: 162056016

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_moloResourceStatusSettingsSet/2026-04-15/1776240071",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-15/1776240071/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3983064044731892882,
        "service_name": "drive-thru",
        "span_id": 4985608961846371640,
        "trace_id": 14559266778903716760
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-15 03:07:35
success: True
trace_id: 14559266778903716760

Scan 162000591

duration: 0:00:12.169917

exit_message:

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

id: 162000591

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_moloResourceStatusSettingsSet/2026-04-14/1776153836",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-14/1776153836/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4074144005426825414,
        "service_name": "drive-thru",
        "span_id": 8681214340616456244,
        "trace_id": 8530789930364606293
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-14 03:08:48
success: True
trace_id: 8530789930364606293

Scan 161941825

duration: 0:00:14.937331

exit_message:

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

id: 161941825

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_moloResourceStatusSettingsSet/2026-04-13/1776066996",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-13/1776066996/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9104830902189996350,
        "service_name": "drive-thru",
        "span_id": 3966589920359074240,
        "trace_id": 16803144283434861258
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-13 02:59:53
success: True
trace_id: 16803144283434861258

Scan 161893041

duration: 0:00:12.193786

exit_message:

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

id: 161893041

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_moloResourceStatusSettingsSet/2026-04-12/1775980707",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-12/1775980707/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11090963401812355423,
        "service_name": "drive-thru",
        "span_id": 10064763248663982982,
        "trace_id": 632786495647616608
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-12 03:03:12
success: True
trace_id: 632786495647616608

Scan 161841184

duration: 0:00:14.749733

exit_message:

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

id: 161841184

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_moloResourceStatusSettingsSet/2026-04-11/1775894474",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-11/1775894474/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2445941498476558600,
        "service_name": "drive-thru",
        "span_id": 1550714672354106014,
        "trace_id": 3963361284838493082
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-11 03:05:00
success: True
trace_id: 3963361284838493082

Scan 161786097

duration: 0:00:12.420109

exit_message:

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

id: 161786097

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_moloResourceStatusSettingsSet/2026-04-10/1775808232",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-10/1775808232/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2827033026528866757,
        "service_name": "drive-thru",
        "span_id": 13176480071801428938,
        "trace_id": 4733274836790711512
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-10 03:11:48
success: True
trace_id: 4733274836790711512

Scan 161730426

duration: 0:00:14.760428

exit_message:

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

id: 161730426

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_moloResourceStatusSettingsSet/2026-04-09/1775721564",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-09/1775721564/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9259626985573224601,
        "service_name": "drive-thru",
        "span_id": 16835475700158222205,
        "trace_id": 14917892736570905472
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-09 03:06:25
success: True
trace_id: 14917892736570905472

Scan 161675669

duration: 0:00:14.784448

exit_message:

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

id: 161675669

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_moloResourceStatusSettingsSet/2026-04-08/1775635393",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-08/1775635393/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9157379722123607648,
        "service_name": "drive-thru",
        "span_id": 17525480930521272566,
        "trace_id": 119334233064029143
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-08 03:09:44
success: True
trace_id: 119334233064029143

Scan 161618652

duration: 0:00:14.741821

exit_message:

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

id: 161618652

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_moloResourceStatusSettingsSet/2026-04-07/1775548549",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-07/1775548549/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13607134665249375235,
        "service_name": "drive-thru",
        "span_id": 5523201902778007201,
        "trace_id": 14911099299030795790
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-07 02:59:38
success: True
trace_id: 14911099299030795790

Scan 161561603

duration: 0:00:12.192663

exit_message:

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

id: 161561603

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_moloResourceStatusSettingsSet/2026-04-06/1775462509",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-06/1775462509/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4873914746355707062,
        "service_name": "drive-thru",
        "span_id": 6191236144270662237,
        "trace_id": 7459819551029259267
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-06 03:06:33
success: True
trace_id: 7459819551029259267

Scan 161514903

duration: 0:00:14.704109

exit_message:

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

id: 161514903

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_moloResourceStatusSettingsSet/2026-04-05/1775376137",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-05/1775376137/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15679545676474270613,
        "service_name": "drive-thru",
        "span_id": 15643345089820150331,
        "trace_id": 12559870021338964739
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-05 03:06:07
success: True
trace_id: 12559870021338964739

Scan 161460497

duration: 0:00:14.778302

exit_message:

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

id: 161460497

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_moloResourceStatusSettingsSet/2026-04-04/1775289619",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-04/1775289619/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3074391587261338169,
        "service_name": "drive-thru",
        "span_id": 1868142238535806396,
        "trace_id": 11515530275289471191
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-04 03:08:01
success: True
trace_id: 11515530275289471191

Scan 161401910

duration: 0:00:12.340773

exit_message:

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

id: 161401910

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_moloResourceStatusSettingsSet/2026-04-03/1775203391",
        "key": "raw/molo_moloResourceStatusSettingsSet/2026-04-03/1775203391/ResourceStatusSettingsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceStatusSettingsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17806635653535100936,
        "service_name": "drive-thru",
        "span_id": 12458651499947036476,
        "trace_id": 6628216476895002841
    }
}

running: False
schema_name_id: 1710
start_time: 2026-04-03 03:10:10
success: True
trace_id: 6628216476895002841

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "MarinaLocationId": "string",
    "MovableArrived": "string",
    "MovableArrivedText": "string",
    "MovableCancelled": "string",
    "MovableCancelledText": "string",
    "MovableComplete": "string",
    "MovableCompleteText": "string",
    "MovableConfirmed": "string",
    "MovableConfirmedText": "string",
    "MovableOut": "string",
    "MovableOutText": "string",
    "MovablePending": "string",
    "MovablePendingText": "string",
    "MovableReturned": "string",
    "MovableReturnedText": "string",
    "StationaryCancelled": "string",
    "StationaryCancelledText": "string",
    "StationaryCheckedIn": "string",
    "StationaryCheckedInText": "string",
    "StationaryCheckedOut": "string",
    "StationaryCheckedOutText": "string",
    "StationaryConfirmed": "string",
    "StationaryConfirmedText": "string",
    "StationaryOnLeave": "string",
    "StationaryOnLeaveText": "string",
    "StationaryPending": "string",
    "StationaryPendingText": "string"
}

created: 2026-04-17 03:09:57

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
}

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:14",
        "disabled": false,
        "format": "raw",
        "id": 1710,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloresourcestatussettingsset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "MarinaLocationId": "string",
            "MovableArrived": "string",
            "MovableArrivedText": "string",
            "MovableCancelled": "string",
            "MovableCancelledText": "string",
            "MovableComplete": "string",
            "MovableCompleteText": "string",
            "MovableConfirmed": "string",
            "MovableConfirmedText": "string",
            "MovableOut": "string",
            "MovableOutText": "string",
            "MovablePending": "string",
            "MovablePendingText": "string",
            "MovableReturned": "string",
            "MovableReturnedText": "string",
            "StationaryCancelled": "string",
            "StationaryCancelledText": "string",
            "StationaryCheckedIn": "string",
            "StationaryCheckedInText": "string",
            "StationaryCheckedOut": "string",
            "StationaryCheckedOutText": "string",
            "StationaryConfirmed": "string",
            "StationaryConfirmedText": "string",
            "StationaryOnLeave": "string",
            "StationaryOnLeaveText": "string",
            "StationaryPending": "string",
            "StationaryPendingText": "string"
        },
        "created": "2026-04-17 03:09:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcestatussettingsset`\n(\n `Id`  string , `MovablePending`  string , `MovableConfirmed`  string , `MovableArrived`  string , `MovableOut`  string , `MovableReturned`  string , `MovableComplete`  string , `MovableCancelled`  string , `StationaryPending`  string , `StationaryConfirmed`  string , `StationaryCheckedIn`  string , `StationaryOnLeave`  string , `StationaryCheckedOut`  string , `StationaryCancelled`  string , `MarinaLocationId`  string , `MovablePendingText`  string , `MovableConfirmedText`  string , `MovableArrivedText`  string , `MovableOutText`  string , `MovableReturnedText`  string , `MovableCompleteText`  string , `MovableCancelledText`  string , `StationaryPendingText`  string , `StationaryConfirmedText`  string , `StationaryCheckedInText`  string , `StationaryOnLeaveText`  string , `StationaryCheckedOutText`  string , `StationaryCancelledText`  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_moloResourceStatusSettingsSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcestatussettingsset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcestatussettingsset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}