Schema Info

Schema Name: sfdl_prod_drivethru.molo_molomarinatasks

created: 2023-10-17 01:55:59
disabled: False
format: raw
id: 1617
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717666

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-17/1776412805
id: 1717666
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 162167645
updated: 2026-04-17 03:06:10

Version 1716435

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-16/1776326560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-16/1776326560
id: 1716435
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 162111869
updated: 2026-04-16 03:09:20

Version 1715229

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-15/1776240028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-15/1776240028
id: 1715229
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 162055959
updated: 2026-04-15 03:06:10

Version 1714029

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-14/1776153756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-14/1776153756
id: 1714029
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 162000512
updated: 2026-04-14 03:06:46

Version 1712801

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-13/1776066952'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-13/1776066952
id: 1712801
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161941752
updated: 2026-04-13 02:59:35

Version 1711588

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-12/1775980664'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-12/1775980664
id: 1711588
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161892635
updated: 2026-04-12 03:00:52

Version 1710473

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-11/1775894425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

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

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161841260
updated: 2026-04-11 03:07:34

Version 1709182

created: 2026-04-10 03:03:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-10/1775808181'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-10/1775808181
id: 1709182
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161785859
updated: 2026-04-10 03:03:58

Version 1708153

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-09/1775721521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-09/1775721521
id: 1708153
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161730344
updated: 2026-04-09 03:04:58

Version 1706867

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-08/1775635351'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-08/1775635351
id: 1706867
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161675451
updated: 2026-04-08 03:04:07

Version 1705704

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-07/1775548499'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-07/1775548499
id: 1705704
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161618404
updated: 2026-04-07 02:57:14

Version 1704575

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-06/1775462466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

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

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161561702
updated: 2026-04-06 03:09:22

Version 1703217

created: 2026-04-05 03:01:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-05/1775376092'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-05/1775376092
id: 1703217
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161514778
updated: 2026-04-05 03:01:59

Version 1702106

created: 2026-04-04 03:03:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-04/1775289576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaTasks/2026-04-04/1775289576
id: 1702106
processed: 1

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161460222
updated: 2026-04-04 03:03:23

Version 1700891

created: 2026-04-03 03:07:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-03/1775203348'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
]

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

raw_data:

{
    "Completed": 2,
    "CompletedBy": 11,
    "CompletedOn": 3,
    "CreatedAt": 10,
    "CreatedBy": 12,
    "Description": 6,
    "DisplayTitle": 9,
    "EndDateTime": 5,
    "Id": 0,
    "ReservationId": 7,
    "StartDateTime": 4,
    "TaskTypeId": 8,
    "Title": 1
}

schema_attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

schema_name_id: 1617
schema_scan_id: 161401823
updated: 2026-04-03 03:07:58

Schema Scans: 15

Last at 2026-04-17 03:05:58

Scan 162167645

duration: 0:00:12.078223

exit_message:

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

id: 162167645

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_moloMarinaTasks/2026-04-17/1776412805",
        "key": "raw/molo_moloMarinaTasks/2026-04-17/1776412805/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5998541582153031070,
        "service_name": "drive-thru",
        "span_id": 12411622528779054855,
        "trace_id": 3888977709651019789
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-17 03:05:58
success: True
trace_id: 3888977709651019789

Scan 162111869

duration: 0:00:14.587662

exit_message:

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

id: 162111869

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_moloMarinaTasks/2026-04-16/1776326560",
        "key": "raw/molo_moloMarinaTasks/2026-04-16/1776326560/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17971014679516966787,
        "service_name": "drive-thru",
        "span_id": 11221118358083437983,
        "trace_id": 3295270801063549922
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-16 03:09:05
success: True
trace_id: 3295270801063549922

Scan 162055959

duration: 0:00:12.007272

exit_message:

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

id: 162055959

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_moloMarinaTasks/2026-04-15/1776240028",
        "key": "raw/molo_moloMarinaTasks/2026-04-15/1776240028/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7382779423103946307,
        "service_name": "drive-thru",
        "span_id": 2588496750752106874,
        "trace_id": 8759522608207530863
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-15 03:05:58
success: True
trace_id: 8759522608207530863

Scan 162000512

duration: 0:00:14.487564

exit_message:

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

id: 162000512

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_moloMarinaTasks/2026-04-14/1776153756",
        "key": "raw/molo_moloMarinaTasks/2026-04-14/1776153756/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 491976540629795058,
        "service_name": "drive-thru",
        "span_id": 4849969716006165677,
        "trace_id": 17731418251834244227
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-14 03:06:32
success: True
trace_id: 17731418251834244227

Scan 161941752

duration: 0:00:14.414427

exit_message:

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

id: 161941752

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_moloMarinaTasks/2026-04-13/1776066952",
        "key": "raw/molo_moloMarinaTasks/2026-04-13/1776066952/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4114579971919289938,
        "service_name": "drive-thru",
        "span_id": 12281648766417874946,
        "trace_id": 4936272198428404511
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-13 02:59:20
success: True
trace_id: 4936272198428404511

Scan 161892635

duration: 0:00:11.897286

exit_message:

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

id: 161892635

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_moloMarinaTasks/2026-04-12/1775980664",
        "key": "raw/molo_moloMarinaTasks/2026-04-12/1775980664/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11434092628771400309,
        "service_name": "drive-thru",
        "span_id": 12974573705396360576,
        "trace_id": 4133211808610332903
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-12 03:00:40
success: True
trace_id: 4133211808610332903

Scan 161841260

duration: 0:00:14.403966

exit_message:

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

id: 161841260

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_moloMarinaTasks/2026-04-11/1775894425",
        "key": "raw/molo_moloMarinaTasks/2026-04-11/1775894425/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9031414245865419890,
        "service_name": "drive-thru",
        "span_id": 18395401401022070248,
        "trace_id": 58873355269529264
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-11 03:07:20
success: True
trace_id: 58873355269529264

Scan 161785859

duration: 0:00:14.632065

exit_message:

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

id: 161785859

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_moloMarinaTasks/2026-04-10/1775808181",
        "key": "raw/molo_moloMarinaTasks/2026-04-10/1775808181/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13937229451829234387,
        "service_name": "drive-thru",
        "span_id": 14272424225432821629,
        "trace_id": 1189816084663976189
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-10 03:03:43
success: True
trace_id: 1189816084663976189

Scan 161730344

duration: 0:00:14.518052

exit_message:

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

id: 161730344

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_moloMarinaTasks/2026-04-09/1775721521",
        "key": "raw/molo_moloMarinaTasks/2026-04-09/1775721521/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4484977463228179007,
        "service_name": "drive-thru",
        "span_id": 10118182474029335408,
        "trace_id": 16510899616526548853
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-09 03:04:43
success: True
trace_id: 16510899616526548853

Scan 161675451

duration: 0:00:12.042104

exit_message:

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

id: 161675451

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_moloMarinaTasks/2026-04-08/1775635351",
        "key": "raw/molo_moloMarinaTasks/2026-04-08/1775635351/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5275478708137427630,
        "service_name": "drive-thru",
        "span_id": 10768170739687918755,
        "trace_id": 10797259835691854220
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-08 03:03:55
success: True
trace_id: 10797259835691854220

Scan 161618404

duration: 0:00:12.092382

exit_message:

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

id: 161618404

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_moloMarinaTasks/2026-04-07/1775548499",
        "key": "raw/molo_moloMarinaTasks/2026-04-07/1775548499/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10678646748489500179,
        "service_name": "drive-thru",
        "span_id": 8256351054966560021,
        "trace_id": 6701016230688677417
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-07 02:57:02
success: True
trace_id: 6701016230688677417

Scan 161561702

duration: 0:00:14.518469

exit_message:

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

id: 161561702

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_moloMarinaTasks/2026-04-06/1775462466",
        "key": "raw/molo_moloMarinaTasks/2026-04-06/1775462466/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13947099737180429246,
        "service_name": "drive-thru",
        "span_id": 13592637933193420335,
        "trace_id": 7727781602734810354
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-06 03:09:08
success: True
trace_id: 7727781602734810354

Scan 161514778

duration: 0:00:14.423876

exit_message:

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

id: 161514778

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_moloMarinaTasks/2026-04-05/1775376092",
        "key": "raw/molo_moloMarinaTasks/2026-04-05/1775376092/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13842460097517591458,
        "service_name": "drive-thru",
        "span_id": 4180751357117258110,
        "trace_id": 17733222552503293173
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-05 03:01:44
success: True
trace_id: 17733222552503293173

Scan 161460222

duration: 0:00:11.936016

exit_message:

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

id: 161460222

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_moloMarinaTasks/2026-04-04/1775289576",
        "key": "raw/molo_moloMarinaTasks/2026-04-04/1775289576/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3581961706074251425,
        "service_name": "drive-thru",
        "span_id": 7751937379226242111,
        "trace_id": 3229433348047115934
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-04 03:03:12
success: True
trace_id: 3229433348047115934

Scan 161401823

duration: 0:00:12.038671

exit_message:

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

id: 161401823

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_moloMarinaTasks/2026-04-03/1775203348",
        "key": "raw/molo_moloMarinaTasks/2026-04-03/1775203348/MarinaTasks.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloMarinaTasks",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3764371160436852879,
        "service_name": "drive-thru",
        "span_id": 6454921251771405300,
        "trace_id": 15978788973974484764
    }
}

running: False
schema_name_id: 1617
start_time: 2026-04-03 03:07:46
success: True
trace_id: 15978788973974484764

Partitions:

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

Schema:

attributes:

{
    "Completed": "string",
    "CompletedBy": "string",
    "CompletedOn": "string",
    "CreatedAt": "string",
    "CreatedBy": "string",
    "Description": "string",
    "DisplayTitle": "string",
    "EndDateTime": "string",
    "Id": "string",
    "ReservationId": "string",
    "StartDateTime": "string",
    "TaskTypeId": "string",
    "Title": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
}

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:55:59",
        "disabled": false,
        "format": "raw",
        "id": 1617,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molomarinatasks"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Completed": "string",
            "CompletedBy": "string",
            "CompletedOn": "string",
            "CreatedAt": "string",
            "CreatedBy": "string",
            "Description": "string",
            "DisplayTitle": "string",
            "EndDateTime": "string",
            "Id": "string",
            "ReservationId": "string",
            "StartDateTime": "string",
            "TaskTypeId": "string",
            "Title": "string"
        },
        "created": "2026-04-17 03:05:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinatasks`\n(\n `Id`  string , `Title`  string , `Completed`  string , `CompletedOn`  string , `StartDateTime`  string , `EndDateTime`  string , `Description`  string , `ReservationId`  string , `TaskTypeId`  string , `DisplayTitle`  string , `CreatedAt`  string , `CompletedBy`  string , `CreatedBy`  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_moloMarinaTasks/2026-04-17/1776412805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinatasks`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinatasks"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}