Schema Info

Schema Name: sfdl_prod_drivethru.molo_molotagset

created: 2023-10-17 02:00:08
disabled: False
format: raw
id: 1736
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717762

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-17/1776413131
id: 1717762
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 162167780
updated: 2026-04-17 03:10:11

Version 1716498

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-16/1776326733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-16/1776326733
id: 1716498
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 162111940
updated: 2026-04-16 03:11:46

Version 1715291

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-15/1776240199'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-15/1776240199
id: 1715291
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 162056053
updated: 2026-04-15 03:08:47

Version 1714184

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-14/1776154165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-14/1776154165
id: 1714184
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 162000708
updated: 2026-04-14 03:12:43

Version 1712891

created: 2026-04-13 03:03:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-13/1776067161'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-13/1776067161
id: 1712891
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161942565
updated: 2026-04-13 03:03:34

Version 1711703

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-12/1775980861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-12/1775980861
id: 1711703
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161893357
updated: 2026-04-12 03:05:58

Version 1710434

created: 2026-04-11 03:05:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-11/1775894629'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-11/1775894629
id: 1710434
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161841218
updated: 2026-04-11 03:06:07

Version 1709310

created: 2026-04-10 03:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-10/1775808390'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-10/1775808390
id: 1709310
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161786007
updated: 2026-04-10 03:08:46

Version 1708134

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-09/1775721719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-09/1775721719
id: 1708134
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161730289
updated: 2026-04-09 03:03:57

Version 1707055

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-08/1775635550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-08/1775635550
id: 1707055
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161675725
updated: 2026-04-08 03:12:07

Version 1705881

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-07/1775548712'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-07/1775548712
id: 1705881
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161619480
updated: 2026-04-07 03:05:29

Version 1704560

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-06/1775462662'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-06/1775462662
id: 1704560
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161561676
updated: 2026-04-06 03:08:47

Version 1703395

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-05/1775376293'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-05/1775376293
id: 1703395
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161514979
updated: 2026-04-05 03:09:08

Version 1702248

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-04/1775289774'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-04/1775289774
id: 1702248
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161460545
updated: 2026-04-04 03:09:52

Version 1701057

created: 2026-04-03 03:15:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-03/1775203541'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloTagSet/2026-04-03/1775203541
id: 1701057
processed: 1

raw_data:

{
    "BackgroundColor": 9,
    "CreationDateTime": 2,
    "CreationUser_Id": 6,
    "DeletionDateTime": 3,
    "DeletionUser_Id": 7,
    "HashId": 8,
    "Id": 0,
    "IsUniversal": 14,
    "LastEditDateTime": 12,
    "LastEditUser_Id": 13,
    "MarinaLocation_Id": 4,
    "RecordStatus_Id": 5,
    "TagName": 1,
    "TextColor": 10,
    "UsedForCalendar": 11
}

schema_attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

schema_name_id: 1736
schema_scan_id: 161402046
updated: 2026-04-03 03:15:30

Schema Scans: 15

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

Scan 162167780

duration: 0:00:14.612944

exit_message:

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

id: 162167780

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_moloTagSet/2026-04-17/1776413131",
        "key": "raw/molo_moloTagSet/2026-04-17/1776413131/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11581152469994561077,
        "service_name": "drive-thru",
        "span_id": 1792653964789528190,
        "trace_id": 7239605833319958554
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-17 03:09:57
success: True
trace_id: 7239605833319958554

Scan 162111940

duration: 0:00:14.518151

exit_message:

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

id: 162111940

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_moloTagSet/2026-04-16/1776326733",
        "key": "raw/molo_moloTagSet/2026-04-16/1776326733/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 525697514427642141,
        "service_name": "drive-thru",
        "span_id": 9343250601353067250,
        "trace_id": 17615940709479102908
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-16 03:11:31
success: True
trace_id: 17615940709479102908

Scan 162056053

duration: 0:00:14.521249

exit_message:

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

id: 162056053

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_moloTagSet/2026-04-15/1776240199",
        "key": "raw/molo_moloTagSet/2026-04-15/1776240199/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1123045892295328358,
        "service_name": "drive-thru",
        "span_id": 1091143644776319393,
        "trace_id": 18280531001186860707
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-15 03:08:33
success: True
trace_id: 18280531001186860707

Scan 162000708

duration: 0:00:14.496802

exit_message:

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

id: 162000708

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_moloTagSet/2026-04-14/1776154165",
        "key": "raw/molo_moloTagSet/2026-04-14/1776154165/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15694507278800287933,
        "service_name": "drive-thru",
        "span_id": 2968449379700007289,
        "trace_id": 8980903295336226717
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-14 03:12:28
success: True
trace_id: 8980903295336226717

Scan 161942565

duration: 0:00:14.576088

exit_message:

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

id: 161942565

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_moloTagSet/2026-04-13/1776067161",
        "key": "raw/molo_moloTagSet/2026-04-13/1776067161/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6309952043584739740,
        "service_name": "drive-thru",
        "span_id": 11941617372226363580,
        "trace_id": 1491063979161389533
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-13 03:03:20
success: True
trace_id: 1491063979161389533

Scan 161893357

duration: 0:00:11.937382

exit_message:

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

id: 161893357

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_moloTagSet/2026-04-12/1775980861",
        "key": "raw/molo_moloTagSet/2026-04-12/1775980861/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15538488903428083402,
        "service_name": "drive-thru",
        "span_id": 1363604966430994659,
        "trace_id": 13771249449328782485
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-12 03:05:46
success: True
trace_id: 13771249449328782485

Scan 161841218

duration: 0:00:12.076104

exit_message:

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

id: 161841218

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_moloTagSet/2026-04-11/1775894629",
        "key": "raw/molo_moloTagSet/2026-04-11/1775894629/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11996087082460941350,
        "service_name": "drive-thru",
        "span_id": 2070077014902093332,
        "trace_id": 4407101967818126129
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-11 03:05:55
success: True
trace_id: 4407101967818126129

Scan 161786007

duration: 0:00:14.534950

exit_message:

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

id: 161786007

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_moloTagSet/2026-04-10/1775808390",
        "key": "raw/molo_moloTagSet/2026-04-10/1775808390/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11634649230695523362,
        "service_name": "drive-thru",
        "span_id": 15221850729827122841,
        "trace_id": 16538179951707255004
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-10 03:08:31
success: True
trace_id: 16538179951707255004

Scan 161730289

duration: 0:00:11.964771

exit_message:

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

id: 161730289

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_moloTagSet/2026-04-09/1775721719",
        "key": "raw/molo_moloTagSet/2026-04-09/1775721719/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5665693445265428103,
        "service_name": "drive-thru",
        "span_id": 16299007593458407362,
        "trace_id": 11496046799517977530
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-09 03:03:45
success: True
trace_id: 11496046799517977530

Scan 161675725

duration: 0:00:14.677480

exit_message:

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

id: 161675725

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_moloTagSet/2026-04-08/1775635550",
        "key": "raw/molo_moloTagSet/2026-04-08/1775635550/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12731155395862029134,
        "service_name": "drive-thru",
        "span_id": 15714191679234018048,
        "trace_id": 2560145262256966359
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-08 03:11:53
success: True
trace_id: 2560145262256966359

Scan 161619480

duration: 0:00:14.715378

exit_message:

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

id: 161619480

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_moloTagSet/2026-04-07/1775548712",
        "key": "raw/molo_moloTagSet/2026-04-07/1775548712/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9321138742630660543,
        "service_name": "drive-thru",
        "span_id": 10646635742889924306,
        "trace_id": 15692640042868669005
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-07 03:05:14
success: True
trace_id: 15692640042868669005

Scan 161561676

duration: 0:00:14.501669

exit_message:

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

id: 161561676

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_moloTagSet/2026-04-06/1775462662",
        "key": "raw/molo_moloTagSet/2026-04-06/1775462662/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9949018829222955412,
        "service_name": "drive-thru",
        "span_id": 2907789286036812734,
        "trace_id": 1381251352552494420
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-06 03:08:33
success: True
trace_id: 1381251352552494420

Scan 161514979

duration: 0:00:14.529248

exit_message:

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

id: 161514979

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_moloTagSet/2026-04-05/1775376293",
        "key": "raw/molo_moloTagSet/2026-04-05/1775376293/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16024359632280496507,
        "service_name": "drive-thru",
        "span_id": 11734826851148755678,
        "trace_id": 12799684644463640473
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-05 03:08:53
success: True
trace_id: 12799684644463640473

Scan 161460545

duration: 0:00:14.655066

exit_message:

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

id: 161460545

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_moloTagSet/2026-04-04/1775289774",
        "key": "raw/molo_moloTagSet/2026-04-04/1775289774/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1039705445490235814,
        "service_name": "drive-thru",
        "span_id": 8882215611346225639,
        "trace_id": 7433913849589023465
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-04 03:09:38
success: True
trace_id: 7433913849589023465

Scan 161402046

duration: 0:00:14.559954

exit_message:

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

id: 161402046

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_moloTagSet/2026-04-03/1775203541",
        "key": "raw/molo_moloTagSet/2026-04-03/1775203541/TagSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloTagSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7061752799493527369,
        "service_name": "drive-thru",
        "span_id": 9637003137273509856,
        "trace_id": 15916370748616277806
    }
}

running: False
schema_name_id: 1736
start_time: 2026-04-03 03:15:16
success: True
trace_id: 15916370748616277806

Partitions:

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

Schema:

attributes:

{
    "BackgroundColor": "string",
    "CreationDateTime": "string",
    "CreationUser_Id": "string",
    "DeletionDateTime": "string",
    "DeletionUser_Id": "string",
    "HashId": "string",
    "Id": "string",
    "IsUniversal": "string",
    "LastEditDateTime": "string",
    "LastEditUser_Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "TagName": "string",
    "TextColor": "string",
    "UsedForCalendar": "string"
}

created: 2026-04-17 03:09: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_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:00:08",
        "disabled": false,
        "format": "raw",
        "id": 1736,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molotagset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "BackgroundColor": "string",
            "CreationDateTime": "string",
            "CreationUser_Id": "string",
            "DeletionDateTime": "string",
            "DeletionUser_Id": "string",
            "HashId": "string",
            "Id": "string",
            "IsUniversal": "string",
            "LastEditDateTime": "string",
            "LastEditUser_Id": "string",
            "MarinaLocation_Id": "string",
            "RecordStatus_Id": "string",
            "TagName": "string",
            "TextColor": "string",
            "UsedForCalendar": "string"
        },
        "created": "2026-04-17 03:09: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_molotagset`\n(\n `Id`  string , `TagName`  string , `CreationDateTime`  string , `DeletionDateTime`  string , `MarinaLocation_Id`  string , `RecordStatus_Id`  string , `CreationUser_Id`  string , `DeletionUser_Id`  string , `HashId`  string , `BackgroundColor`  string , `TextColor`  string , `UsedForCalendar`  string , `LastEditDateTime`  string , `LastEditUser_Id`  string , `IsUniversal`  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_moloTagSet/2026-04-17/1776413131'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molotagset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molotagset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}