Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourcepostlogset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717652

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-17/1776412847
id: 1717652
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 162167615
updated: 2026-04-17 03:05:32

Version 1716494

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-16/1776326601'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-16/1776326601
id: 1716494
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 162111936
updated: 2026-04-16 03:11:31

Version 1715227

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-15/1776240071'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-15/1776240071
id: 1715227
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 162055957
updated: 2026-04-15 03:06:03

Version 1714059

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-14/1776153835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-14/1776153835
id: 1714059
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 162000559
updated: 2026-04-14 03:07:59

Version 1712827

created: 2026-04-13 03:00:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-13/1776066995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-13/1776066995
id: 1712827
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161941835
updated: 2026-04-13 03:00:14

Version 1711620

created: 2026-04-12 03:01:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-12/1775980706'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-12/1775980706
id: 1711620
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161892778
updated: 2026-04-12 03:01:53

Version 1710527

created: 2026-04-11 03:09:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-11/1775894473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-11/1775894473
id: 1710527
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161841323
updated: 2026-04-11 03:09:38

Version 1709392

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-10/1775808231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-10/1775808231
id: 1709392
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161786095
updated: 2026-04-10 03:11:55

Version 1708233

created: 2026-04-09 03:08:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-09/1775721565'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-09/1775721565
id: 1708233
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161730499
updated: 2026-04-09 03:08:32

Version 1706885

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-08/1775635393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-08/1775635393
id: 1706885
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161675486
updated: 2026-04-08 03:04:55

Version 1705772

created: 2026-04-07 02:59:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-07/1775548549'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-07/1775548549
id: 1705772
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161618666
updated: 2026-04-07 02:59:54

Version 1704478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-06/1775462509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-06/1775462509
id: 1704478
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161561559
updated: 2026-04-06 03:05:24

Version 1703322

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-05/1775376135'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-05/1775376135
id: 1703322
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161514904
updated: 2026-04-05 03:06:20

Version 1702136

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-04/1775289618'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-04/1775289618
id: 1702136
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161460318
updated: 2026-04-04 03:04:35

Version 1700941

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-03/1775203391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourcePostLogSet/2026-04-03/1775203391
id: 1700941
processed: 1

raw_data:

{
    "DateTime": 2,
    "EndDate": 4,
    "GroupCode": 9,
    "HashId": 1,
    "IPAddress": 5,
    "Id": 0,
    "MarinaLocationId": 7,
    "NoAvailability": 12,
    "OnlineBooking": 11,
    "ResourceOfferHashId": 8,
    "SearchType": 10,
    "StartDate": 3,
    "UserAgentString": 6
}

schema_attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

schema_name_id: 1667
schema_scan_id: 161401898
updated: 2026-04-03 03:10:02

Schema Scans: 15

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

Scan 162167615

duration: 0:00:14.558657

exit_message:

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

id: 162167615

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_moloResourcePostLogSet/2026-04-17/1776412847",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-17/1776412847/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 972812271067058125,
        "service_name": "drive-thru",
        "span_id": 10161251628738534645,
        "trace_id": 242930459268045772
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-17 03:05:17
success: True
trace_id: 242930459268045772

Scan 162111936

duration: 0:00:12.086615

exit_message:

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

id: 162111936

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_moloResourcePostLogSet/2026-04-16/1776326601",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-16/1776326601/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2991344545546586957,
        "service_name": "drive-thru",
        "span_id": 218101999832989231,
        "trace_id": 13543012757171419913
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-16 03:11:19
success: True
trace_id: 13543012757171419913

Scan 162055957

duration: 0:00:14.560283

exit_message:

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

id: 162055957

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_moloResourcePostLogSet/2026-04-15/1776240071",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-15/1776240071/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12908841032352527084,
        "service_name": "drive-thru",
        "span_id": 13323096918360333771,
        "trace_id": 13388280564875754778
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-15 03:05:49
success: True
trace_id: 13388280564875754778

Scan 162000559

duration: 0:00:14.371631

exit_message:

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

id: 162000559

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_moloResourcePostLogSet/2026-04-14/1776153835",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-14/1776153835/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17983010077248671913,
        "service_name": "drive-thru",
        "span_id": 1622022541694599986,
        "trace_id": 3725714344159210039
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-14 03:07:45
success: True
trace_id: 3725714344159210039

Scan 161941835

duration: 0:00:12.142162

exit_message:

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

id: 161941835

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_moloResourcePostLogSet/2026-04-13/1776066995",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-13/1776066995/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15508881954489219862,
        "service_name": "drive-thru",
        "span_id": 5259375394793790351,
        "trace_id": 7532127708984141950
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-13 03:00:02
success: True
trace_id: 7532127708984141950

Scan 161892778

duration: 0:00:14.501644

exit_message:

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

id: 161892778

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_moloResourcePostLogSet/2026-04-12/1775980706",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-12/1775980706/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4737212728498225322,
        "service_name": "drive-thru",
        "span_id": 42460467596837803,
        "trace_id": 7267925268262397577
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-12 03:01:38
success: True
trace_id: 7267925268262397577

Scan 161841323

duration: 0:00:11.927153

exit_message:

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

id: 161841323

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_moloResourcePostLogSet/2026-04-11/1775894473",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-11/1775894473/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10535880710107778901,
        "service_name": "drive-thru",
        "span_id": 2293187346483178590,
        "trace_id": 3475885077904731791
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-11 03:09:26
success: True
trace_id: 3475885077904731791

Scan 161786095

duration: 0:00:11.974316

exit_message:

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

id: 161786095

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_moloResourcePostLogSet/2026-04-10/1775808231",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-10/1775808231/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9860397410879268392,
        "service_name": "drive-thru",
        "span_id": 14618078492255535331,
        "trace_id": 12643073708828252777
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-10 03:11:44
success: True
trace_id: 12643073708828252777

Scan 161730499

duration: 0:00:14.554429

exit_message:

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

id: 161730499

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_moloResourcePostLogSet/2026-04-09/1775721565",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-09/1775721565/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12093885641489874364,
        "service_name": "drive-thru",
        "span_id": 5634866173983047197,
        "trace_id": 14784640401276069196
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-09 03:08:17
success: True
trace_id: 14784640401276069196

Scan 161675486

duration: 0:00:11.957371

exit_message:

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

id: 161675486

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_moloResourcePostLogSet/2026-04-08/1775635393",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-08/1775635393/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14944558826111280413,
        "service_name": "drive-thru",
        "span_id": 4462843449776264207,
        "trace_id": 13792939494110406487
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-08 03:04:44
success: True
trace_id: 13792939494110406487

Scan 161618666

duration: 0:00:11.938275

exit_message:

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

id: 161618666

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_moloResourcePostLogSet/2026-04-07/1775548549",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-07/1775548549/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18211071765469419039,
        "service_name": "drive-thru",
        "span_id": 8595829202626934378,
        "trace_id": 4241064638096424823
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-07 02:59:43
success: True
trace_id: 4241064638096424823

Scan 161561559

duration: 0:00:11.957496

exit_message:

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

id: 161561559

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_moloResourcePostLogSet/2026-04-06/1775462509",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-06/1775462509/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16929306484796149655,
        "service_name": "drive-thru",
        "span_id": 7381669748609917281,
        "trace_id": 5770993466638449599
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-06 03:05:12
success: True
trace_id: 5770993466638449599

Scan 161514904

duration: 0:00:11.938758

exit_message:

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

id: 161514904

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_moloResourcePostLogSet/2026-04-05/1775376135",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-05/1775376135/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7266928578574298499,
        "service_name": "drive-thru",
        "span_id": 3109138655317097926,
        "trace_id": 7839628805014463025
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-05 03:06:08
success: True
trace_id: 7839628805014463025

Scan 161460318

duration: 0:00:14.641530

exit_message:

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

id: 161460318

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_moloResourcePostLogSet/2026-04-04/1775289618",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-04/1775289618/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13074489322344671797,
        "service_name": "drive-thru",
        "span_id": 17471176205562043204,
        "trace_id": 1127428983794716333
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-04 03:04:20
success: True
trace_id: 1127428983794716333

Scan 161401898

duration: 0:00:12.092380

exit_message:

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

id: 161401898

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_moloResourcePostLogSet/2026-04-03/1775203391",
        "key": "raw/molo_moloResourcePostLogSet/2026-04-03/1775203391/ResourcePostLogSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourcePostLogSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5934714604008670286,
        "service_name": "drive-thru",
        "span_id": 11522459498246179536,
        "trace_id": 3887236625046253078
    }
}

running: False
schema_name_id: 1667
start_time: 2026-04-03 03:09:49
success: True
trace_id: 3887236625046253078

Partitions:

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

Schema:

attributes:

{
    "DateTime": "string",
    "EndDate": "string",
    "GroupCode": "string",
    "HashId": "string",
    "IPAddress": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "NoAvailability": "string",
    "OnlineBooking": "string",
    "ResourceOfferHashId": "string",
    "SearchType": "string",
    "StartDate": "string",
    "UserAgentString": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 01:57:39",
        "disabled": false,
        "format": "raw",
        "id": 1667,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloresourcepostlogset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "DateTime": "string",
            "EndDate": "string",
            "GroupCode": "string",
            "HashId": "string",
            "IPAddress": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "NoAvailability": "string",
            "OnlineBooking": "string",
            "ResourceOfferHashId": "string",
            "SearchType": "string",
            "StartDate": "string",
            "UserAgentString": "string"
        },
        "created": "2026-04-17 03:05:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourcepostlogset`\n(\n `Id`  string , `HashId`  string , `DateTime`  string , `StartDate`  string , `EndDate`  string , `IPAddress`  string , `UserAgentString`  string , `MarinaLocationId`  string , `ResourceOfferHashId`  string , `GroupCode`  string , `SearchType`  string , `OnlineBooking`  string , `NoAvailability`  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_moloResourcePostLogSet/2026-04-17/1776412847'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourcepostlogset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourcepostlogset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}