Schema Info

Schema Name: sfdl_prod_drivethru.molo_molobulkrenewal

created: 2025-07-11 02:12:11
disabled: False
format: raw
id: 4247
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717573

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 162167193
updated: 2026-04-17 03:00:29

Version 1716348

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-16/1776326458'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 162111724
updated: 2026-04-16 03:05:27

Version 1715134

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-15/1776239928'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 162055655
updated: 2026-04-15 03:01:13

Version 1713965

created: 2026-04-14 03:03:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-14/1776153653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 162000394
updated: 2026-04-14 03:03:59

Version 1712701

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-13/1776066846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161941466
updated: 2026-04-13 02:55:20

Version 1711511

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-12/1775980563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBulkRenewal/2026-04-12/1775980563
id: 1711511
processed: 1

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161892272
updated: 2026-04-12 02:57:03

Version 1710328

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-11/1775894322'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161840990
updated: 2026-04-11 03:01:29

Version 1709140

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-10/1775808079'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161785764
updated: 2026-04-10 03:01:45

Version 1707996

created: 2026-04-09 02:57:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-09/1775721417'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBulkRenewal/2026-04-09/1775721417
id: 1707996
processed: 1

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161729645
updated: 2026-04-09 02:57:28

Version 1706832

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-08/1775635224'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBulkRenewal/2026-04-08/1775635224
id: 1706832
processed: 1

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161675386
updated: 2026-04-08 03:02:47

Version 1705613

created: 2026-04-07 02:53:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-07/1775548398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161618289
updated: 2026-04-07 02:53:47

Version 1704390

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-06/1775462362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBulkRenewal/2026-04-06/1775462362
id: 1704390
processed: 1

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161561332
updated: 2026-04-06 03:01:08

Version 1703176

created: 2026-04-05 02:59:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-05/1775375990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161514683
updated: 2026-04-05 03:00:10

Version 1702038

created: 2026-04-04 03:00:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-04/1775289476'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloBulkRenewal/2026-04-04/1775289476
id: 1702038
processed: 1

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161459820
updated: 2026-04-04 03:00:18

Version 1700956

created: 2026-04-03 03:10:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-03/1775203247'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
]

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

raw_data:

{
    "BulkRenewalAuditSetId": 1,
    "CreationDateTime": 6,
    "FailureReason": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "PreviousReservationHashID": 8,
    "PreviousReservationId": 2,
    "ReservationHashID": 9,
    "ReservationId": 3,
    "Status": 4
}

schema_attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

schema_name_id: 4247
schema_scan_id: 161401916
updated: 2026-04-03 03:10:38

Schema Scans: 15

Last at 2026-04-17 03:00:17

Scan 162167193

duration: 0:00:11.781376

exit_message:

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

id: 162167193

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_moloBulkRenewal/2026-04-17/1776412694",
        "key": "raw/molo_moloBulkRenewal/2026-04-17/1776412694/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7374835620374316602,
        "service_name": "drive-thru",
        "span_id": 15850380357019783283,
        "trace_id": 14843367388256326149
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-17 03:00:17
success: True
trace_id: 14843367388256326149

Scan 162111724

duration: 0:00:14.465164

exit_message:

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

id: 162111724

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_moloBulkRenewal/2026-04-16/1776326458",
        "key": "raw/molo_moloBulkRenewal/2026-04-16/1776326458/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4680713126555873973,
        "service_name": "drive-thru",
        "span_id": 9705036837319011205,
        "trace_id": 2533229777963085549
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-16 03:05:13
success: True
trace_id: 2533229777963085549

Scan 162055655

duration: 0:00:14.483385

exit_message:

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

id: 162055655

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_moloBulkRenewal/2026-04-15/1776239928",
        "key": "raw/molo_moloBulkRenewal/2026-04-15/1776239928/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4599677076956766346,
        "service_name": "drive-thru",
        "span_id": 13615250540480716092,
        "trace_id": 5164692959649576271
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-15 03:00:59
success: True
trace_id: 5164692959649576271

Scan 162000394

duration: 0:00:14.456267

exit_message:

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

id: 162000394

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_moloBulkRenewal/2026-04-14/1776153653",
        "key": "raw/molo_moloBulkRenewal/2026-04-14/1776153653/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8975714631550497126,
        "service_name": "drive-thru",
        "span_id": 11846472821213224275,
        "trace_id": 15073254030015016670
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-14 03:03:45
success: True
trace_id: 15073254030015016670

Scan 161941466

duration: 0:00:14.402993

exit_message:

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

id: 161941466

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_moloBulkRenewal/2026-04-13/1776066846",
        "key": "raw/molo_moloBulkRenewal/2026-04-13/1776066846/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17577956021255517084,
        "service_name": "drive-thru",
        "span_id": 7703034135456382609,
        "trace_id": 9170023077958956638
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-13 02:55:05
success: True
trace_id: 9170023077958956638

Scan 161892272

duration: 0:00:11.746293

exit_message:

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

id: 161892272

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_moloBulkRenewal/2026-04-12/1775980563",
        "key": "raw/molo_moloBulkRenewal/2026-04-12/1775980563/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15946138444623512027,
        "service_name": "drive-thru",
        "span_id": 4664257652574589802,
        "trace_id": 13675534108711732230
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-12 02:56:51
success: True
trace_id: 13675534108711732230

Scan 161840990

duration: 0:00:14.406759

exit_message:

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

id: 161840990

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_moloBulkRenewal/2026-04-11/1775894322",
        "key": "raw/molo_moloBulkRenewal/2026-04-11/1775894322/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15366194332711988136,
        "service_name": "drive-thru",
        "span_id": 2469633107065530680,
        "trace_id": 10236373142413288003
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-11 03:01:15
success: True
trace_id: 10236373142413288003

Scan 161785764

duration: 0:00:14.600826

exit_message:

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

id: 161785764

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_moloBulkRenewal/2026-04-10/1775808079",
        "key": "raw/molo_moloBulkRenewal/2026-04-10/1775808079/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1546543572697647248,
        "service_name": "drive-thru",
        "span_id": 14947086329277987515,
        "trace_id": 4066009697229164297
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-10 03:01:31
success: True
trace_id: 4066009697229164297

Scan 161729645

duration: 0:00:14.367774

exit_message:

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

id: 161729645

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_moloBulkRenewal/2026-04-09/1775721417",
        "key": "raw/molo_moloBulkRenewal/2026-04-09/1775721417/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11471273093251593251,
        "service_name": "drive-thru",
        "span_id": 17449572326272912846,
        "trace_id": 17623363419293256872
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-09 02:57:13
success: True
trace_id: 17623363419293256872

Scan 161675386

duration: 0:00:14.397221

exit_message:

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

id: 161675386

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_moloBulkRenewal/2026-04-08/1775635224",
        "key": "raw/molo_moloBulkRenewal/2026-04-08/1775635224/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2165226709351599723,
        "service_name": "drive-thru",
        "span_id": 18327672943178415203,
        "trace_id": 1539422014121607568
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-08 03:02:33
success: True
trace_id: 1539422014121607568

Scan 161618289

duration: 0:00:11.966580

exit_message:

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

id: 161618289

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_moloBulkRenewal/2026-04-07/1775548398",
        "key": "raw/molo_moloBulkRenewal/2026-04-07/1775548398/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3195707646145182677,
        "service_name": "drive-thru",
        "span_id": 8710488337219596757,
        "trace_id": 13551577675559474288
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-07 02:53:35
success: True
trace_id: 13551577675559474288

Scan 161561332

duration: 0:00:14.388187

exit_message:

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

id: 161561332

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_moloBulkRenewal/2026-04-06/1775462362",
        "key": "raw/molo_moloBulkRenewal/2026-04-06/1775462362/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1689132901744052509,
        "service_name": "drive-thru",
        "span_id": 12332147441210309771,
        "trace_id": 890473412246651160
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-06 03:00:54
success: True
trace_id: 890473412246651160

Scan 161514683

duration: 0:00:14.354357

exit_message:

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

id: 161514683

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_moloBulkRenewal/2026-04-05/1775375990",
        "key": "raw/molo_moloBulkRenewal/2026-04-05/1775375990/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4091091674208867358,
        "service_name": "drive-thru",
        "span_id": 13490911201524546871,
        "trace_id": 5670629300940741295
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-05 02:59:56
success: True
trace_id: 5670629300940741295

Scan 161459820

duration: 0:00:14.454899

exit_message:

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

id: 161459820

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_moloBulkRenewal/2026-04-04/1775289476",
        "key": "raw/molo_moloBulkRenewal/2026-04-04/1775289476/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2705758479674468392,
        "service_name": "drive-thru",
        "span_id": 2014756957311353649,
        "trace_id": 8574069224156420603
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-04 03:00:04
success: True
trace_id: 8574069224156420603

Scan 161401916

duration: 0:00:14.536291

exit_message:

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

id: 161401916

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_moloBulkRenewal/2026-04-03/1775203247",
        "key": "raw/molo_moloBulkRenewal/2026-04-03/1775203247/BulkRenewal.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBulkRenewal",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11124212840882145353,
        "service_name": "drive-thru",
        "span_id": 3790036132294126855,
        "trace_id": 4484260877200773679
    }
}

running: False
schema_name_id: 4247
start_time: 2026-04-03 03:10:24
success: True
trace_id: 4484260877200773679

Partitions:

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

Schema:

attributes:

{
    "BulkRenewalAuditSetId": "string",
    "CreationDateTime": "string",
    "FailureReason": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "PreviousReservationHashID": "string",
    "PreviousReservationId": "string",
    "ReservationHashID": "string",
    "ReservationId": "string",
    "Status": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-07-11 02:12:11",
        "disabled": false,
        "format": "raw",
        "id": 4247,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molobulkrenewal"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "BulkRenewalAuditSetId": "string",
            "CreationDateTime": "string",
            "FailureReason": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "PreviousReservationHashID": "string",
            "PreviousReservationId": "string",
            "ReservationHashID": "string",
            "ReservationId": "string",
            "Status": "string"
        },
        "created": "2026-04-17 03:00:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molobulkrenewal`\n(\n `Id`  string , `BulkRenewalAuditSetId`  string , `PreviousReservationId`  string , `ReservationId`  string , `Status`  string , `FailureReason`  string , `CreationDateTime`  string , `MarinaLocationId`  string , `PreviousReservationHashID`  string , `ReservationHashID`  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_moloBulkRenewal/2026-04-17/1776412694'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molobulkrenewal`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molobulkrenewal"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}