Schema Info

Schema Name: sfdl_prod_drivethru.molo_molomessagetemplateset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717628

created: 2026-04-17 03:03:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-17/1776412808
id: 1717628
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 162167533
updated: 2026-04-17 03:04:11

Version 1716433

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-16/1776326559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-16/1776326559
id: 1716433
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 162111867
updated: 2026-04-16 03:09:14

Version 1715224

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-15/1776240029'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-15/1776240029
id: 1715224
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 162055953
updated: 2026-04-15 03:05:58

Version 1714046

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-14/1776153757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-14/1776153757
id: 1714046
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 162000532
updated: 2026-04-14 03:07:22

Version 1712774

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-13/1776066951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-13/1776066951
id: 1712774
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161941678
updated: 2026-04-13 02:58:39

Version 1711592

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-12/1775980665'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-12/1775980665
id: 1711592
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161892665
updated: 2026-04-12 03:01:04

Version 1710482

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-11/1775894425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-11/1775894425
id: 1710482
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161841271
updated: 2026-04-11 03:07:55

Version 1709372

created: 2026-04-10 03:10:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-10/1775808182'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-10/1775808182
id: 1709372
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161786072
updated: 2026-04-10 03:11:11

Version 1708125

created: 2026-04-09 03:03:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-09/1775721522'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-09/1775721522
id: 1708125
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161730267
updated: 2026-04-09 03:03:35

Version 1706897

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-08/1775635350'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-08/1775635350
id: 1706897
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161675516
updated: 2026-04-08 03:05:28

Version 1705695

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-07/1775548500'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-07/1775548500
id: 1705695
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161618393
updated: 2026-04-07 02:56:55

Version 1704583

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-06/1775462466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-06/1775462466
id: 1704583
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161561721
updated: 2026-04-06 03:09:43

Version 1703331

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-05/1775376093'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-05/1775376093
id: 1703331
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161514912
updated: 2026-04-05 03:06:42

Version 1702104

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-04/1775289575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-04/1775289575
id: 1702104
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161460212
updated: 2026-04-04 03:03:23

Version 1700912

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-03/1775203348'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMessageTemplateSet/2026-04-03/1775203348
id: 1700912
processed: 1

raw_data:

{
    "AvailableForEmails": 4,
    "AvailableForTextMessages": 3,
    "CreationAspNetUserId": 6,
    "CreationDateTime": 5,
    "DeletionAspNetUserId": 9,
    "DeletionDateTime": 8,
    "HashId": 11,
    "Id": 0,
    "MarinaLocationId": 10,
    "Message": 2,
    "RecordStatusId": 7,
    "Title": 1
}

schema_attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

schema_name_id: 1671
schema_scan_id: 161401863
updated: 2026-04-03 03:08:57

Schema Scans: 15

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

Scan 162167533

duration: 0:00:14.511386

exit_message:

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

id: 162167533

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_moloMessageTemplateSet/2026-04-17/1776412808",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-17/1776412808/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14206063772978748445,
        "service_name": "drive-thru",
        "span_id": 16612296892127183084,
        "trace_id": 15227501664989057639
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-17 03:03:57
success: True
trace_id: 15227501664989057639

Scan 162111867

duration: 0:00:11.987797

exit_message:

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

id: 162111867

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_moloMessageTemplateSet/2026-04-16/1776326559",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-16/1776326559/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5210464447628189101,
        "service_name": "drive-thru",
        "span_id": 9321661629736106030,
        "trace_id": 12372328678538705704
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-16 03:09:02
success: True
trace_id: 12372328678538705704

Scan 162055953

duration: 0:00:11.845450

exit_message:

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

id: 162055953

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_moloMessageTemplateSet/2026-04-15/1776240029",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-15/1776240029/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2545464751243889003,
        "service_name": "drive-thru",
        "span_id": 1175244626356177200,
        "trace_id": 11680211378865941951
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-15 03:05:46
success: True
trace_id: 11680211378865941951

Scan 162000532

duration: 0:00:11.997250

exit_message:

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

id: 162000532

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_moloMessageTemplateSet/2026-04-14/1776153757",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-14/1776153757/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17586595711554039019,
        "service_name": "drive-thru",
        "span_id": 14192169290080708968,
        "trace_id": 3776723307588402478
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-14 03:07:10
success: True
trace_id: 3776723307588402478

Scan 161941678

duration: 0:00:11.860567

exit_message:

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

id: 161941678

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_moloMessageTemplateSet/2026-04-13/1776066951",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-13/1776066951/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7418131187126480556,
        "service_name": "drive-thru",
        "span_id": 18117182279796879385,
        "trace_id": 9630568109040275348
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-13 02:58:27
success: True
trace_id: 9630568109040275348

Scan 161892665

duration: 0:00:14.471536

exit_message:

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

id: 161892665

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_moloMessageTemplateSet/2026-04-12/1775980665",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-12/1775980665/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 656670234296239097,
        "service_name": "drive-thru",
        "span_id": 9154614221298346705,
        "trace_id": 17649369912937857191
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-12 03:00:50
success: True
trace_id: 17649369912937857191

Scan 161841271

duration: 0:00:14.429191

exit_message:

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

id: 161841271

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_moloMessageTemplateSet/2026-04-11/1775894425",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-11/1775894425/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10498653803555523310,
        "service_name": "drive-thru",
        "span_id": 2745767829470112314,
        "trace_id": 12401279862284487233
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-11 03:07:41
success: True
trace_id: 12401279862284487233

Scan 161786072

duration: 0:00:14.577790

exit_message:

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

id: 161786072

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_moloMessageTemplateSet/2026-04-10/1775808182",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-10/1775808182/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12539422117728462347,
        "service_name": "drive-thru",
        "span_id": 5590379130865829185,
        "trace_id": 6189565902787182893
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-10 03:10:56
success: True
trace_id: 6189565902787182893

Scan 161730267

duration: 0:00:14.637193

exit_message:

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

id: 161730267

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_moloMessageTemplateSet/2026-04-09/1775721522",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-09/1775721522/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13625540089865084447,
        "service_name": "drive-thru",
        "span_id": 9405587979741519334,
        "trace_id": 5306282751413111612
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-09 03:03:20
success: True
trace_id: 5306282751413111612

Scan 161675516

duration: 0:00:12.003473

exit_message:

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

id: 161675516

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_moloMessageTemplateSet/2026-04-08/1775635350",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-08/1775635350/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15993633000503237499,
        "service_name": "drive-thru",
        "span_id": 8519230624675635792,
        "trace_id": 14771663404408130314
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-08 03:05:16
success: True
trace_id: 14771663404408130314

Scan 161618393

duration: 0:00:14.415785

exit_message:

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

id: 161618393

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_moloMessageTemplateSet/2026-04-07/1775548500",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-07/1775548500/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18130296881784249238,
        "service_name": "drive-thru",
        "span_id": 15792858536388427475,
        "trace_id": 583035386608995434
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-07 02:56:41
success: True
trace_id: 583035386608995434

Scan 161561721

duration: 0:00:12.033348

exit_message:

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

id: 161561721

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_moloMessageTemplateSet/2026-04-06/1775462466",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-06/1775462466/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8997000462240559784,
        "service_name": "drive-thru",
        "span_id": 2660242093752078044,
        "trace_id": 1089581067876595591
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-06 03:09:31
success: True
trace_id: 1089581067876595591

Scan 161514912

duration: 0:00:14.632912

exit_message:

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

id: 161514912

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_moloMessageTemplateSet/2026-04-05/1775376093",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-05/1775376093/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3451010806837730379,
        "service_name": "drive-thru",
        "span_id": 16906539743713833698,
        "trace_id": 5658049294872678246
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-05 03:06:28
success: True
trace_id: 5658049294872678246

Scan 161460212

duration: 0:00:14.426967

exit_message:

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

id: 161460212

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_moloMessageTemplateSet/2026-04-04/1775289575",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-04/1775289575/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11003564561509852069,
        "service_name": "drive-thru",
        "span_id": 16807215826676529793,
        "trace_id": 17805587314714749313
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-04 03:03:08
success: True
trace_id: 17805587314714749313

Scan 161401863

duration: 0:00:14.459396

exit_message:

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

id: 161401863

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_moloMessageTemplateSet/2026-04-03/1775203348",
        "key": "raw/molo_moloMessageTemplateSet/2026-04-03/1775203348/MessageTemplateSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMessageTemplateSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 615671399729303830,
        "service_name": "drive-thru",
        "span_id": 17014471942410325862,
        "trace_id": 10853018153350299592
    }
}

running: False
schema_name_id: 1671
start_time: 2026-04-03 03:08:43
success: True
trace_id: 10853018153350299592

Partitions:

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

Schema:

attributes:

{
    "AvailableForEmails": "string",
    "AvailableForTextMessages": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Message": "string",
    "RecordStatusId": "string",
    "Title": "string"
}

created: 2026-04-17 03:03:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
}

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:57:51",
        "disabled": false,
        "format": "raw",
        "id": 1671,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molomessagetemplateset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AvailableForEmails": "string",
            "AvailableForTextMessages": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUserId": "string",
            "DeletionDateTime": "string",
            "HashId": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "Message": "string",
            "RecordStatusId": "string",
            "Title": "string"
        },
        "created": "2026-04-17 03:03:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomessagetemplateset`\n(\n `Id`  string , `Title`  string , `Message`  string , `AvailableForTextMessages`  string , `AvailableForEmails`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `MarinaLocationId`  string , `HashId`  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_moloMessageTemplateSet/2026-04-17/1776412808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomessagetemplateset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomessagetemplateset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}