Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloemailplaceholdersset

created: 2023-10-17 01:54:57
disabled: False
format: raw
id: 1590
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717566

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-17/1776412700
id: 1717566
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 162167171
updated: 2026-04-17 03:00:14

Version 1716455

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-16/1776326465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-16/1776326465
id: 1716455
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 162111890
updated: 2026-04-16 03:10:07

Version 1715157

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-15/1776239934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-15/1776239934
id: 1715157
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 162055724
updated: 2026-04-15 03:02:21

Version 1713983

created: 2026-04-14 03:04:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-14/1776153659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-14/1776153659
id: 1713983
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 162000420
updated: 2026-04-14 03:04:46

Version 1712740

created: 2026-04-13 02:56:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-13/1776066853'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-13/1776066853
id: 1712740
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161941524
updated: 2026-04-13 02:56:47

Version 1711542

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-12/1775980569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-12/1775980569
id: 1711542
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161892366
updated: 2026-04-12 02:58:39

Version 1710313

created: 2026-04-11 03:00:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-11/1775894329'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-11/1775894329
id: 1710313
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161840920
updated: 2026-04-11 03:00:37

Version 1709227

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-10/1775808085'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-10/1775808085
id: 1709227
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161785909
updated: 2026-04-10 03:05:35

Version 1708053

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-09/1775721424'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-09/1775721424
id: 1708053
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161729928
updated: 2026-04-09 03:00:37

Version 1706846

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-08/1775635231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-08/1775635231
id: 1706846
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161675415
updated: 2026-04-08 03:03:18

Version 1705645

created: 2026-04-07 02:54:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-07/1775548406'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-07/1775548406
id: 1705645
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161618323
updated: 2026-04-07 02:54:58

Version 1704522

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-06/1775462368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-06/1775462368
id: 1704522
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161561621
updated: 2026-04-06 03:07:17

Version 1703270

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-05/1775375996'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-05/1775375996
id: 1703270
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161514844
updated: 2026-04-05 03:04:06

Version 1702063

created: 2026-04-04 03:01:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-04/1775289480'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-04/1775289480
id: 1702063
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161459909
updated: 2026-04-04 03:01:22

Version 1700899

created: 2026-04-03 03:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-03/1775203253'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailPlaceholdersSet/2026-04-03/1775203253
id: 1700899
processed: 1

raw_data:

{
    "Id": 0,
    "InternalInvoiceFooter": 10,
    "InvoiceOffers": 6,
    "MarinaBottomLogo": 2,
    "MarinaFooterLinks": 3,
    "MarinaFooterSocialLinks": 4,
    "MarinaLocation_Id": 7,
    "MarinaTopLogo": 1,
    "PrintedLogo": 8,
    "ReceiptFooterText": 9,
    "ReservationOffers": 5,
    "WebReceiptFooterStandaloneBalance": 12,
    "WebReceiptFooterText": 11,
    "WebReceiptFooterTextReservation": 13,
    "WebReceiptFooterTextWalkIn": 15,
    "WebReceiptFooterTextWalkInReservation": 16,
    "WebReceiptFooterTextWalkInWorkOrder": 17,
    "WebReceiptFooterTextWorkOrder": 14
}

schema_attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

schema_name_id: 1590
schema_scan_id: 161401840
updated: 2026-04-03 03:08:24

Schema Scans: 15

Last at 2026-04-17 02:59:59

Scan 162167171

duration: 0:00:15.075924

exit_message:

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

id: 162167171

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_moloEmailPlaceholdersSet/2026-04-17/1776412700",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-17/1776412700/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6687836872776555506,
        "service_name": "drive-thru",
        "span_id": 3783167001148456367,
        "trace_id": 10092882721672628681
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-17 02:59:59
success: True
trace_id: 10092882721672628681

Scan 162111890

duration: 0:00:14.654599

exit_message:

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

id: 162111890

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_moloEmailPlaceholdersSet/2026-04-16/1776326465",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-16/1776326465/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 828429345871344898,
        "service_name": "drive-thru",
        "span_id": 16327608581383214328,
        "trace_id": 17444354486149800115
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-16 03:09:53
success: True
trace_id: 17444354486149800115

Scan 162055724

duration: 0:00:14.705095

exit_message:

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

id: 162055724

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_moloEmailPlaceholdersSet/2026-04-15/1776239934",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-15/1776239934/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16451361800821697191,
        "service_name": "drive-thru",
        "span_id": 16961515095919490064,
        "trace_id": 1144005020806365941
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-15 03:02:06
success: True
trace_id: 1144005020806365941

Scan 162000420

duration: 0:00:14.583168

exit_message:

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

id: 162000420

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_moloEmailPlaceholdersSet/2026-04-14/1776153659",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-14/1776153659/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2049140954164230043,
        "service_name": "drive-thru",
        "span_id": 7074242854539255768,
        "trace_id": 12400010758182586627
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-14 03:04:32
success: True
trace_id: 12400010758182586627

Scan 161941524

duration: 0:00:12.047891

exit_message:

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

id: 161941524

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_moloEmailPlaceholdersSet/2026-04-13/1776066853",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-13/1776066853/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 870478084454810405,
        "service_name": "drive-thru",
        "span_id": 15267338422616625149,
        "trace_id": 7135295565599502854
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-13 02:56:35
success: True
trace_id: 7135295565599502854

Scan 161892366

duration: 0:00:11.926173

exit_message:

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

id: 161892366

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_moloEmailPlaceholdersSet/2026-04-12/1775980569",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-12/1775980569/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1995699088518195526,
        "service_name": "drive-thru",
        "span_id": 3609114356359598031,
        "trace_id": 14193293867571984587
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-12 02:58:27
success: True
trace_id: 14193293867571984587

Scan 161840920

duration: 0:00:12.071718

exit_message:

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

id: 161840920

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_moloEmailPlaceholdersSet/2026-04-11/1775894329",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-11/1775894329/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 338964238193658976,
        "service_name": "drive-thru",
        "span_id": 1943091676008006002,
        "trace_id": 15862991013695202178
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-11 03:00:25
success: True
trace_id: 15862991013695202178

Scan 161785909

duration: 0:00:12.158562

exit_message:

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

id: 161785909

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_moloEmailPlaceholdersSet/2026-04-10/1775808085",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-10/1775808085/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13785280540742501204,
        "service_name": "drive-thru",
        "span_id": 6795190363282477242,
        "trace_id": 14896083514055596388
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-10 03:05:23
success: True
trace_id: 14896083514055596388

Scan 161729928

duration: 0:00:12.143083

exit_message:

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

id: 161729928

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_moloEmailPlaceholdersSet/2026-04-09/1775721424",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-09/1775721424/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17879795971132878192,
        "service_name": "drive-thru",
        "span_id": 16016914475462974505,
        "trace_id": 13501441823478285105
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-09 03:00:25
success: True
trace_id: 13501441823478285105

Scan 161675415

duration: 0:00:14.612859

exit_message:

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

id: 161675415

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_moloEmailPlaceholdersSet/2026-04-08/1775635231",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-08/1775635231/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6995888044528255668,
        "service_name": "drive-thru",
        "span_id": 12786673280552603056,
        "trace_id": 5769521808446781471
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-08 03:03:03
success: True
trace_id: 5769521808446781471

Scan 161618323

duration: 0:00:12.120627

exit_message:

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

id: 161618323

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_moloEmailPlaceholdersSet/2026-04-07/1775548406",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-07/1775548406/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15111065235158559212,
        "service_name": "drive-thru",
        "span_id": 10755807701530289297,
        "trace_id": 7562805502931742058
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-07 02:54:46
success: True
trace_id: 7562805502931742058

Scan 161561621

duration: 0:00:14.723703

exit_message:

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

id: 161561621

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_moloEmailPlaceholdersSet/2026-04-06/1775462368",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-06/1775462368/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5665202528346469835,
        "service_name": "drive-thru",
        "span_id": 9047598109329417679,
        "trace_id": 4852492248342219829
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-06 03:07:02
success: True
trace_id: 4852492248342219829

Scan 161514844

duration: 0:00:14.691299

exit_message:

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

id: 161514844

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_moloEmailPlaceholdersSet/2026-04-05/1775375996",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-05/1775375996/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15643964584247485317,
        "service_name": "drive-thru",
        "span_id": 15980298070680814283,
        "trace_id": 11972846289588549578
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-05 03:03:52
success: True
trace_id: 11972846289588549578

Scan 161459909

duration: 0:00:14.538669

exit_message:

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

id: 161459909

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_moloEmailPlaceholdersSet/2026-04-04/1775289480",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-04/1775289480/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14501890140052510734,
        "service_name": "drive-thru",
        "span_id": 9186415919918425727,
        "trace_id": 9187738373070568826
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-04 03:01:08
success: True
trace_id: 9187738373070568826

Scan 161401840

duration: 0:00:14.576952

exit_message:

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

id: 161401840

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_moloEmailPlaceholdersSet/2026-04-03/1775203253",
        "key": "raw/molo_moloEmailPlaceholdersSet/2026-04-03/1775203253/EmailPlaceholdersSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEmailPlaceholdersSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16600225499059465225,
        "service_name": "drive-thru",
        "span_id": 14277219095813592985,
        "trace_id": 8353598604230206770
    }
}

running: False
schema_name_id: 1590
start_time: 2026-04-03 03:08:10
success: True
trace_id: 8353598604230206770

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "InternalInvoiceFooter": "string",
    "InvoiceOffers": "string",
    "MarinaBottomLogo": "string",
    "MarinaFooterLinks": "string",
    "MarinaFooterSocialLinks": "string",
    "MarinaLocation_Id": "string",
    "MarinaTopLogo": "string",
    "PrintedLogo": "string",
    "ReceiptFooterText": "string",
    "ReservationOffers": "string",
    "WebReceiptFooterStandaloneBalance": "string",
    "WebReceiptFooterText": "string",
    "WebReceiptFooterTextReservation": "string",
    "WebReceiptFooterTextWalkIn": "string",
    "WebReceiptFooterTextWalkInReservation": "string",
    "WebReceiptFooterTextWalkInWorkOrder": "string",
    "WebReceiptFooterTextWorkOrder": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
}

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:54:57",
        "disabled": false,
        "format": "raw",
        "id": 1590,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloemailplaceholdersset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "InternalInvoiceFooter": "string",
            "InvoiceOffers": "string",
            "MarinaBottomLogo": "string",
            "MarinaFooterLinks": "string",
            "MarinaFooterSocialLinks": "string",
            "MarinaLocation_Id": "string",
            "MarinaTopLogo": "string",
            "PrintedLogo": "string",
            "ReceiptFooterText": "string",
            "ReservationOffers": "string",
            "WebReceiptFooterStandaloneBalance": "string",
            "WebReceiptFooterText": "string",
            "WebReceiptFooterTextReservation": "string",
            "WebReceiptFooterTextWalkIn": "string",
            "WebReceiptFooterTextWalkInReservation": "string",
            "WebReceiptFooterTextWalkInWorkOrder": "string",
            "WebReceiptFooterTextWorkOrder": "string"
        },
        "created": "2026-04-17 03:00:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailplaceholdersset`\n(\n `Id`  string , `MarinaTopLogo`  string , `MarinaBottomLogo`  string , `MarinaFooterLinks`  string , `MarinaFooterSocialLinks`  string , `ReservationOffers`  string , `InvoiceOffers`  string , `MarinaLocation_Id`  string , `PrintedLogo`  string , `ReceiptFooterText`  string , `InternalInvoiceFooter`  string , `WebReceiptFooterText`  string , `WebReceiptFooterStandaloneBalance`  string , `WebReceiptFooterTextReservation`  string , `WebReceiptFooterTextWorkOrder`  string , `WebReceiptFooterTextWalkIn`  string , `WebReceiptFooterTextWalkInReservation`  string , `WebReceiptFooterTextWalkInWorkOrder`  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_moloEmailPlaceholdersSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailplaceholdersset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailplaceholdersset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}