Schema Info

Schema Name: sfdl_prod_drivethru.molo_molorecurringaddonset

created: 2023-10-17 02:01:12
disabled: False
format: raw
id: 1765
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717644

created: 2026-04-17 03:04:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-17/1776412822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-17/1776412822
id: 1717644
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 162167604
updated: 2026-04-17 03:05:06

Version 1716549

created: 2026-04-16 03:13:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-16/1776326577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-16/1776326577
id: 1716549
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 162112005
updated: 2026-04-16 03:13:37

Version 1715226

created: 2026-04-15 03:05:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-15/1776240046'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-15/1776240046
id: 1715226
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 162055955
updated: 2026-04-15 03:06:03

Version 1714098

created: 2026-04-14 03:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-14/1776153778'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-14/1776153778
id: 1714098
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 162000605
updated: 2026-04-14 03:09:25

Version 1712804

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-13/1776066969'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-13/1776066969
id: 1712804
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161941759
updated: 2026-04-13 02:59:39

Version 1711642

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-12/1775980682'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-12/1775980682
id: 1711642
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161892845
updated: 2026-04-12 03:02:25

Version 1710357

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-11/1775894448'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-11/1775894448
id: 1710357
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161841067
updated: 2026-04-11 03:02:49

Version 1709389

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-10/1775808202'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-10/1775808202
id: 1709389
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161786092
updated: 2026-04-10 03:11:48

Version 1708194

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-09/1775721539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-09/1775721539
id: 1708194
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161730434
updated: 2026-04-09 03:06:52

Version 1706877

created: 2026-04-08 03:04:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-08/1775635367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-08/1775635367
id: 1706877
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161675470
updated: 2026-04-08 03:04:34

Version 1705739

created: 2026-04-07 02:58:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-07/1775548517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-07/1775548517
id: 1705739
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161618476
updated: 2026-04-07 02:58:39

Version 1704454

created: 2026-04-06 03:03:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-06/1775462484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-06/1775462484
id: 1704454
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161561513
updated: 2026-04-06 03:04:12

Version 1703315

created: 2026-04-05 03:05:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-05/1775376110'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-05/1775376110
id: 1703315
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161514894
updated: 2026-04-05 03:06:03

Version 1702121

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-04/1775289593'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-04/1775289593
id: 1702121
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161460280
updated: 2026-04-04 03:03:59

Version 1700925

created: 2026-04-03 03:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-03/1775203366'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloRecurringAddOnSet/2026-04-03/1775203366
id: 1700925
processed: 1

raw_data:

{
    "Code": 12,
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "CreationUserName": 10,
    "DeletionAspNetUserId": 8,
    "DeletionDateTime": 7,
    "DeletionUserName": 11,
    "Id": 0,
    "ItemMasterId": 3,
    "Name": 9,
    "Price": 13,
    "Quantity": 4,
    "RecordStatusId": 6,
    "ReservationHashId": 5
}

schema_attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

schema_name_id: 1765
schema_scan_id: 161401879
updated: 2026-04-03 03:09:27

Schema Scans: 15

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

Scan 162167604

duration: 0:00:14.639100

exit_message:

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

id: 162167604

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_moloRecurringAddOnSet/2026-04-17/1776412822",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-17/1776412822/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8842233096086104855,
        "service_name": "drive-thru",
        "span_id": 16889879009043555269,
        "trace_id": 17102991730209684330
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-17 03:04:52
success: True
trace_id: 17102991730209684330

Scan 162112005

duration: 0:00:12.060912

exit_message:

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

id: 162112005

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_moloRecurringAddOnSet/2026-04-16/1776326577",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-16/1776326577/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6016990673749168934,
        "service_name": "drive-thru",
        "span_id": 12311138400792422001,
        "trace_id": 7497603615472958771
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-16 03:13:25
success: True
trace_id: 7497603615472958771

Scan 162055955

duration: 0:00:14.512385

exit_message:

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

id: 162055955

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_moloRecurringAddOnSet/2026-04-15/1776240046",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-15/1776240046/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10512336116093569744,
        "service_name": "drive-thru",
        "span_id": 15680349481621060364,
        "trace_id": 17279468134687904481
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-15 03:05:48
success: True
trace_id: 17279468134687904481

Scan 162000605

duration: 0:00:12.051249

exit_message:

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

id: 162000605

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_moloRecurringAddOnSet/2026-04-14/1776153778",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-14/1776153778/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17277133614030652814,
        "service_name": "drive-thru",
        "span_id": 10127776569258103295,
        "trace_id": 9619132733374781123
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-14 03:09:13
success: True
trace_id: 9619132733374781123

Scan 161941759

duration: 0:00:14.518756

exit_message:

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

id: 161941759

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_moloRecurringAddOnSet/2026-04-13/1776066969",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-13/1776066969/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16552283496551752431,
        "service_name": "drive-thru",
        "span_id": 9486380052483377849,
        "trace_id": 189358723180352894
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-13 02:59:24
success: True
trace_id: 189358723180352894

Scan 161892845

duration: 0:00:11.982309

exit_message:

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

id: 161892845

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_moloRecurringAddOnSet/2026-04-12/1775980682",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-12/1775980682/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17428959685268255623,
        "service_name": "drive-thru",
        "span_id": 5979725496019139172,
        "trace_id": 16307736646734720575
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-12 03:02:13
success: True
trace_id: 16307736646734720575

Scan 161841067

duration: 0:00:12.033570

exit_message:

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

id: 161841067

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_moloRecurringAddOnSet/2026-04-11/1775894448",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-11/1775894448/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2499292165485392749,
        "service_name": "drive-thru",
        "span_id": 17664260239527726330,
        "trace_id": 45430659830471686
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-11 03:02:37
success: True
trace_id: 45430659830471686

Scan 161786092

duration: 0:00:12.192490

exit_message:

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

id: 161786092

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_moloRecurringAddOnSet/2026-04-10/1775808202",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-10/1775808202/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3278371796688388587,
        "service_name": "drive-thru",
        "span_id": 17869404316173234064,
        "trace_id": 2008851988032277399
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-10 03:11:36
success: True
trace_id: 2008851988032277399

Scan 161730434

duration: 0:00:12.138712

exit_message:

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

id: 161730434

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_moloRecurringAddOnSet/2026-04-09/1775721539",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-09/1775721539/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5583284321474158048,
        "service_name": "drive-thru",
        "span_id": 1710957662145158062,
        "trace_id": 13252340392961760233
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-09 03:06:40
success: True
trace_id: 13252340392961760233

Scan 161675470

duration: 0:00:12.031606

exit_message:

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

id: 161675470

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_moloRecurringAddOnSet/2026-04-08/1775635367",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-08/1775635367/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4590152954496807612,
        "service_name": "drive-thru",
        "span_id": 17311084489798914380,
        "trace_id": 17385587457622878715
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-08 03:04:22
success: True
trace_id: 17385587457622878715

Scan 161618476

duration: 0:00:12.014011

exit_message:

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

id: 161618476

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_moloRecurringAddOnSet/2026-04-07/1775548517",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-07/1775548517/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16057645186126514294,
        "service_name": "drive-thru",
        "span_id": 10125528891957095940,
        "trace_id": 18244943742320384556
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-07 02:58:27
success: True
trace_id: 18244943742320384556

Scan 161561513

duration: 0:00:14.496325

exit_message:

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

id: 161561513

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_moloRecurringAddOnSet/2026-04-06/1775462484",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-06/1775462484/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16611067572556373674,
        "service_name": "drive-thru",
        "span_id": 18289657132980690220,
        "trace_id": 1574239507274080219
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-06 03:03:58
success: True
trace_id: 1574239507274080219

Scan 161514894

duration: 0:00:12.104292

exit_message:

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

id: 161514894

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_moloRecurringAddOnSet/2026-04-05/1775376110",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-05/1775376110/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4265377365478321691,
        "service_name": "drive-thru",
        "span_id": 17425070956142389717,
        "trace_id": 144191205929253896
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-05 03:05:51
success: True
trace_id: 144191205929253896

Scan 161460280

duration: 0:00:14.363353

exit_message:

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

id: 161460280

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_moloRecurringAddOnSet/2026-04-04/1775289593",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-04/1775289593/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11652682593587843069,
        "service_name": "drive-thru",
        "span_id": 10064849740174519488,
        "trace_id": 15210088236817760984
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-04 03:03:44
success: True
trace_id: 15210088236817760984

Scan 161401879

duration: 0:00:14.531283

exit_message:

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

id: 161401879

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_moloRecurringAddOnSet/2026-04-03/1775203366",
        "key": "raw/molo_moloRecurringAddOnSet/2026-04-03/1775203366/RecurringAddOnSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloRecurringAddOnSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12658311125243007229,
        "service_name": "drive-thru",
        "span_id": 4191261374341662057,
        "trace_id": 5291186905583870693
    }
}

running: False
schema_name_id: 1765
start_time: 2026-04-03 03:09:13
success: True
trace_id: 5291186905583870693

Partitions:

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

Schema:

attributes:

{
    "Code": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CreationUserName": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "DeletionUserName": "string",
    "Id": "string",
    "ItemMasterId": "string",
    "Name": "string",
    "Price": "string",
    "Quantity": "string",
    "RecordStatusId": "string",
    "ReservationHashId": "string"
}

created: 2026-04-17 03:04:53

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-17/1776412822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
}

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 02:01:12",
        "disabled": false,
        "format": "raw",
        "id": 1765,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molorecurringaddonset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Code": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "CreationUserName": "string",
            "DeletionAspNetUserId": "string",
            "DeletionDateTime": "string",
            "DeletionUserName": "string",
            "Id": "string",
            "ItemMasterId": "string",
            "Name": "string",
            "Price": "string",
            "Quantity": "string",
            "RecordStatusId": "string",
            "ReservationHashId": "string"
        },
        "created": "2026-04-17 03:04:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molorecurringaddonset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ItemMasterId`  string , `Quantity`  string , `ReservationHashId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `Name`  string , `CreationUserName`  string , `DeletionUserName`  string , `Code`  string , `Price`  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_moloRecurringAddOnSet/2026-04-17/1776412822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molorecurringaddonset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molorecurringaddonset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}