Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloofferlengthoverrideset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717627

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-17/1776412806
id: 1717627
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 162167532
updated: 2026-04-17 03:04:13

Version 1716366

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-16/1776326561'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-16/1776326561
id: 1716366
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 162111759
updated: 2026-04-16 03:06:21

Version 1715250

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-15/1776240031'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-15/1776240031
id: 1715250
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 162055989
updated: 2026-04-15 03:07:02

Version 1714028

created: 2026-04-14 03:06:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-14/1776153759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-14/1776153759
id: 1714028
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 162000511
updated: 2026-04-14 03:06:42

Version 1712808

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-13/1776066953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-13/1776066953
id: 1712808
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161941767
updated: 2026-04-13 02:59:41

Version 1711594

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-12/1775980666'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-12/1775980666
id: 1711594
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161892678
updated: 2026-04-12 03:01:06

Version 1710477

created: 2026-04-11 03:07:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-11/1775894427'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-11/1775894427
id: 1710477
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161841266
updated: 2026-04-11 03:07:48

Version 1709221

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-10/1775808184'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-10/1775808184
id: 1709221
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161785903
updated: 2026-04-10 03:05:23

Version 1708089

created: 2026-04-09 03:02:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-09/1775721524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-09/1775721524
id: 1708089
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161730119
updated: 2026-04-09 03:02:14

Version 1706904

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-08/1775635355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-08/1775635355
id: 1706904
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161675523
updated: 2026-04-08 03:05:49

Version 1705694

created: 2026-04-07 02:56:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-07/1775548502'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-07/1775548502
id: 1705694
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161618392
updated: 2026-04-07 02:56:55

Version 1704580

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-06/1775462468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-06/1775462468
id: 1704580
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161561718
updated: 2026-04-06 03:09:38

Version 1703275

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-05/1775376095'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-05/1775376095
id: 1703275
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161514853
updated: 2026-04-05 03:04:21

Version 1702110

created: 2026-04-04 03:03:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-04/1775289577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-04/1775289577
id: 1702110
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161460235
updated: 2026-04-04 03:03:33

Version 1700927

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-03/1775203350'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-03/1775203350
id: 1700927
processed: 1

raw_data:

{
    "CreationAspNetUser_Id": 9,
    "CreationDateTime": 5,
    "DeletionAspNetUser_Id": 10,
    "DeletionDateTime": 6,
    "EndArrivalDate": 2,
    "Id": 0,
    "Offers_Id": 7,
    "OverrideMaxNights": 4,
    "OverrideMinNights": 3,
    "RecordStatus_Id": 8,
    "StartArrivalDate": 1
}

schema_attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

schema_name_id: 1624
schema_scan_id: 161401881
updated: 2026-04-03 03:09:29

Schema Scans: 15

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

Scan 162167532

duration: 0:00:16.924141

exit_message:

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

id: 162167532

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_moloOfferLengthOverrideSet/2026-04-17/1776412806",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-17/1776412806/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7227402031933062447,
        "service_name": "drive-thru",
        "span_id": 9369632202496262814,
        "trace_id": 1484177938500139293
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-17 03:03:56
success: True
trace_id: 1484177938500139293

Scan 162111759

duration: 0:00:14.180763

exit_message:

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

id: 162111759

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_moloOfferLengthOverrideSet/2026-04-16/1776326561",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-16/1776326561/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2718152623003413623,
        "service_name": "drive-thru",
        "span_id": 17674856843695021453,
        "trace_id": 356073920205986407
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-16 03:06:07
success: True
trace_id: 356073920205986407

Scan 162055989

duration: 0:00:14.359900

exit_message:

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

id: 162055989

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_moloOfferLengthOverrideSet/2026-04-15/1776240031",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-15/1776240031/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13966817672251839219,
        "service_name": "drive-thru",
        "span_id": 8678985300682031112,
        "trace_id": 12164412179981766976
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-15 03:06:47
success: True
trace_id: 12164412179981766976

Scan 162000511

duration: 0:00:14.229779

exit_message:

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

id: 162000511

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_moloOfferLengthOverrideSet/2026-04-14/1776153759",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-14/1776153759/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6057844566919319690,
        "service_name": "drive-thru",
        "span_id": 3360067658177973454,
        "trace_id": 11752612405503676639
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-14 03:06:28
success: True
trace_id: 11752612405503676639

Scan 161941767

duration: 0:00:11.724498

exit_message:

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

id: 161941767

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_moloOfferLengthOverrideSet/2026-04-13/1776066953",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-13/1776066953/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3563419952854447709,
        "service_name": "drive-thru",
        "span_id": 14976235276628730920,
        "trace_id": 1259642756318606721
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-13 02:59:29
success: True
trace_id: 1259642756318606721

Scan 161892678

duration: 0:00:11.838496

exit_message:

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

id: 161892678

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_moloOfferLengthOverrideSet/2026-04-12/1775980666",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-12/1775980666/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6479090842356742329,
        "service_name": "drive-thru",
        "span_id": 15966019805216148811,
        "trace_id": 5189759482461098983
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-12 03:00:55
success: True
trace_id: 5189759482461098983

Scan 161841266

duration: 0:00:14.195458

exit_message:

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

id: 161841266

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_moloOfferLengthOverrideSet/2026-04-11/1775894427",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-11/1775894427/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9999459317545665679,
        "service_name": "drive-thru",
        "span_id": 10706611646153285487,
        "trace_id": 7229736438912665351
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-11 03:07:34
success: True
trace_id: 7229736438912665351

Scan 161785903

duration: 0:00:11.951588

exit_message:

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

id: 161785903

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_moloOfferLengthOverrideSet/2026-04-10/1775808184",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-10/1775808184/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5239642081192067996,
        "service_name": "drive-thru",
        "span_id": 10382502485119178606,
        "trace_id": 11738459569299644561
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-10 03:05:11
success: True
trace_id: 11738459569299644561

Scan 161730119

duration: 0:00:14.456859

exit_message:

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

id: 161730119

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_moloOfferLengthOverrideSet/2026-04-09/1775721524",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-09/1775721524/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5202597299073260235,
        "service_name": "drive-thru",
        "span_id": 4176059389994713785,
        "trace_id": 18249062077107073293
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-09 03:01:59
success: True
trace_id: 18249062077107073293

Scan 161675523

duration: 0:00:14.276339

exit_message:

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

id: 161675523

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_moloOfferLengthOverrideSet/2026-04-08/1775635355",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-08/1775635355/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17488068562828607579,
        "service_name": "drive-thru",
        "span_id": 10315570980811878379,
        "trace_id": 4106987844503288366
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-08 03:05:34
success: True
trace_id: 4106987844503288366

Scan 161618392

duration: 0:00:14.360382

exit_message:

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

id: 161618392

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_moloOfferLengthOverrideSet/2026-04-07/1775548502",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-07/1775548502/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7210126326332355027,
        "service_name": "drive-thru",
        "span_id": 7149445364818482151,
        "trace_id": 3477277528457442128
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-07 02:56:40
success: True
trace_id: 3477277528457442128

Scan 161561718

duration: 0:00:14.227903

exit_message:

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

id: 161561718

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_moloOfferLengthOverrideSet/2026-04-06/1775462468",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-06/1775462468/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15234919484563354377,
        "service_name": "drive-thru",
        "span_id": 12501995128943782374,
        "trace_id": 10674963282496595008
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-06 03:09:24
success: True
trace_id: 10674963282496595008

Scan 161514853

duration: 0:00:14.424814

exit_message:

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

id: 161514853

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_moloOfferLengthOverrideSet/2026-04-05/1775376095",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-05/1775376095/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10112575846538587945,
        "service_name": "drive-thru",
        "span_id": 9816449455136016362,
        "trace_id": 3223683376902141728
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-05 03:04:06
success: True
trace_id: 3223683376902141728

Scan 161460235

duration: 0:00:14.415982

exit_message:

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

id: 161460235

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_moloOfferLengthOverrideSet/2026-04-04/1775289577",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-04/1775289577/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5353499355904416046,
        "service_name": "drive-thru",
        "span_id": 4303901326828542238,
        "trace_id": 9675274645166244701
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-04 03:03:19
success: True
trace_id: 9675274645166244701

Scan 161401881

duration: 0:00:14.335957

exit_message:

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

id: 161401881

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_moloOfferLengthOverrideSet/2026-04-03/1775203350",
        "key": "raw/molo_moloOfferLengthOverrideSet/2026-04-03/1775203350/OfferLengthOverrideSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferLengthOverrideSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5612432803759749133,
        "service_name": "drive-thru",
        "span_id": 6747295172528278623,
        "trace_id": 751120573072804148
    }
}

running: False
schema_name_id: 1624
start_time: 2026-04-03 03:09:15
success: True
trace_id: 751120573072804148

Partitions:

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

Schema:

attributes:

{
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "EndArrivalDate": "string",
    "Id": "string",
    "Offers_Id": "string",
    "OverrideMaxNights": "string",
    "OverrideMinNights": "string",
    "RecordStatus_Id": "string",
    "StartArrivalDate": "string"
}

created: 2026-04-17 03:03: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_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:56:13",
        "disabled": false,
        "format": "raw",
        "id": 1624,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloofferlengthoverrideset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreationAspNetUser_Id": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUser_Id": "string",
            "DeletionDateTime": "string",
            "EndArrivalDate": "string",
            "Id": "string",
            "Offers_Id": "string",
            "OverrideMaxNights": "string",
            "OverrideMinNights": "string",
            "RecordStatus_Id": "string",
            "StartArrivalDate": "string"
        },
        "created": "2026-04-17 03:03: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_moloofferlengthoverrideset`\n(\n `Id`  string , `StartArrivalDate`  string , `EndArrivalDate`  string , `OverrideMinNights`  string , `OverrideMaxNights`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `Offers_Id`  string , `RecordStatus_Id`  string , `CreationAspNetUser_Id`  string , `DeletionAspNetUser_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferLengthOverrideSet/2026-04-17/1776412806'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloofferlengthoverrideset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloofferlengthoverrideset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}