Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloresourceassignmentset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717643

created: 2026-04-17 03:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-17/1776412846
id: 1717643
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 162167601
updated: 2026-04-17 03:05:02

Version 1716450

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-16/1776326600'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-16/1776326600
id: 1716450
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 162111885
updated: 2026-04-16 03:09:54

Version 1715292

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-15/1776240069'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-15/1776240069
id: 1715292
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 162056054
updated: 2026-04-15 03:08:45

Version 1714060

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-14/1776153834'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-14/1776153834
id: 1714060
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 162000558
updated: 2026-04-14 03:07:59

Version 1712848

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-13/1776066993'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-13/1776066993
id: 1712848
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161941922
updated: 2026-04-13 03:00:49

Version 1711654

created: 2026-04-12 03:02:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-12/1775980705'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-12/1775980705
id: 1711654
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161892983
updated: 2026-04-12 03:03:07

Version 1710533

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-11/1775894473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

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

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161841332
updated: 2026-04-11 03:09:56

Version 1709239

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-10/1775808231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

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

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161785924
updated: 2026-04-10 03:06:09

Version 1708108

created: 2026-04-09 03:02:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-09/1775721563'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-09/1775721563
id: 1708108
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161730207
updated: 2026-04-09 03:02:53

Version 1706963

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-08/1775635391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-08/1775635391
id: 1706963
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161675615
updated: 2026-04-08 03:08:17

Version 1705760

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-07/1775548548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-07/1775548548
id: 1705760
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161618582
updated: 2026-04-07 02:59:28

Version 1704467

created: 2026-04-06 03:04:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-06/1775462507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-06/1775462507
id: 1704467
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161561539
updated: 2026-04-06 03:04:49

Version 1703299

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-05/1775376134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-05/1775376134
id: 1703299
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161514876
updated: 2026-04-05 03:05:15

Version 1702198

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-04/1775289617'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-04/1775289617
id: 1702198
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161460470
updated: 2026-04-04 03:07:27

Version 1700863

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-03/1775203389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloResourceAssignmentSet/2026-04-03/1775203389
id: 1700863
processed: 1

raw_data:

{
    "CreationAspNetUserId": 2,
    "CreationDateTime": 1,
    "DeletionAspNetUserId": 13,
    "DeletionDateTime": 12,
    "EndDate": 7,
    "ExpirationDateTime": 8,
    "GroupCode": 16,
    "HashId": 14,
    "Hours": 20,
    "Id": 0,
    "IsTempHold": 9,
    "MarinaLocationId": 5,
    "MaximumHours": 19,
    "MinimumHours": 18,
    "OfferId": 17,
    "OnlineBooking": 10,
    "RecordStatusId": 11,
    "ResourceAssignmentBlockId": 15,
    "ResourceBookingId": 3,
    "ResourceId": 4,
    "StartDate": 6
}

schema_attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

schema_name_id: 1658
schema_scan_id: 161401776
updated: 2026-04-03 03:06:39

Schema Scans: 15

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

Scan 162167601

duration: 0:00:14.644161

exit_message:

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

id: 162167601

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_moloResourceAssignmentSet/2026-04-17/1776412846",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-17/1776412846/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16415611778221353872,
        "service_name": "drive-thru",
        "span_id": 12037984982950990290,
        "trace_id": 5531934718098914246
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-17 03:04:47
success: True
trace_id: 5531934718098914246

Scan 162111885

duration: 0:00:14.768310

exit_message:

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

id: 162111885

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_moloResourceAssignmentSet/2026-04-16/1776326600",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-16/1776326600/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10982546183463606577,
        "service_name": "drive-thru",
        "span_id": 3321951017279981511,
        "trace_id": 16254728834026677178
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-16 03:09:40
success: True
trace_id: 16254728834026677178

Scan 162056054

duration: 0:00:12.171754

exit_message:

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

id: 162056054

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_moloResourceAssignmentSet/2026-04-15/1776240069",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-15/1776240069/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9859799670366982084,
        "service_name": "drive-thru",
        "span_id": 15998140398287011137,
        "trace_id": 9451484329397440468
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-15 03:08:33
success: True
trace_id: 9451484329397440468

Scan 162000558

duration: 0:00:14.801262

exit_message:

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

id: 162000558

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_moloResourceAssignmentSet/2026-04-14/1776153834",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-14/1776153834/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8367957147929252759,
        "service_name": "drive-thru",
        "span_id": 12943772362507250800,
        "trace_id": 18364418351168356386
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-14 03:07:45
success: True
trace_id: 18364418351168356386

Scan 161941922

duration: 0:00:12.181517

exit_message:

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

id: 161941922

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_moloResourceAssignmentSet/2026-04-13/1776066993",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-13/1776066993/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16823066558719081752,
        "service_name": "drive-thru",
        "span_id": 17810027997721740858,
        "trace_id": 8591399052238532417
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-13 03:00:37
success: True
trace_id: 8591399052238532417

Scan 161892983

duration: 0:00:14.728504

exit_message:

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

id: 161892983

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_moloResourceAssignmentSet/2026-04-12/1775980705",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-12/1775980705/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11800317475923096029,
        "service_name": "drive-thru",
        "span_id": 16326424589474723277,
        "trace_id": 999248446175208939
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-12 03:02:52
success: True
trace_id: 999248446175208939

Scan 161841332

duration: 0:00:12.128130

exit_message:

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

id: 161841332

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_moloResourceAssignmentSet/2026-04-11/1775894473",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-11/1775894473/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6334369635818658957,
        "service_name": "drive-thru",
        "span_id": 9843518340259698008,
        "trace_id": 15296263206992557908
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-11 03:09:44
success: True
trace_id: 15296263206992557908

Scan 161785924

duration: 0:00:14.781258

exit_message:

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

id: 161785924

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_moloResourceAssignmentSet/2026-04-10/1775808231",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-10/1775808231/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5436752353582620747,
        "service_name": "drive-thru",
        "span_id": 10020803509715171038,
        "trace_id": 93134839098808206
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-10 03:05:54
success: True
trace_id: 93134839098808206

Scan 161730207

duration: 0:00:12.195328

exit_message:

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

id: 161730207

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_moloResourceAssignmentSet/2026-04-09/1775721563",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-09/1775721563/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10899898464712324759,
        "service_name": "drive-thru",
        "span_id": 526016344903674703,
        "trace_id": 16658201542551074427
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-09 03:02:41
success: True
trace_id: 16658201542551074427

Scan 161675615

duration: 0:00:12.239282

exit_message:

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

id: 161675615

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_moloResourceAssignmentSet/2026-04-08/1775635391",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-08/1775635391/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9356063498114836297,
        "service_name": "drive-thru",
        "span_id": 11895330539462212251,
        "trace_id": 636492313413036826
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-08 03:08:05
success: True
trace_id: 636492313413036826

Scan 161618582

duration: 0:00:12.219520

exit_message:

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

id: 161618582

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_moloResourceAssignmentSet/2026-04-07/1775548548",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-07/1775548548/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11690421249505392668,
        "service_name": "drive-thru",
        "span_id": 3065137864383631518,
        "trace_id": 14413310814586461120
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-07 02:59:16
success: True
trace_id: 14413310814586461120

Scan 161561539

duration: 0:00:12.266048

exit_message:

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

id: 161561539

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_moloResourceAssignmentSet/2026-04-06/1775462507",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-06/1775462507/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1399346619850255268,
        "service_name": "drive-thru",
        "span_id": 3093018410498850567,
        "trace_id": 7966430797999963468
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-06 03:04:36
success: True
trace_id: 7966430797999963468

Scan 161514876

duration: 0:00:14.765968

exit_message:

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

id: 161514876

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_moloResourceAssignmentSet/2026-04-05/1775376134",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-05/1775376134/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13572117617982783914,
        "service_name": "drive-thru",
        "span_id": 2234528110974514826,
        "trace_id": 10155456929324721793
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-05 03:05:00
success: True
trace_id: 10155456929324721793

Scan 161460470

duration: 0:00:12.397009

exit_message:

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

id: 161460470

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_moloResourceAssignmentSet/2026-04-04/1775289617",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-04/1775289617/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 958874401229656123,
        "service_name": "drive-thru",
        "span_id": 15209092121964202542,
        "trace_id": 12754325918744975471
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-04 03:07:14
success: True
trace_id: 12754325918744975471

Scan 161401776

duration: 0:00:12.286876

exit_message:

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

id: 161401776

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_moloResourceAssignmentSet/2026-04-03/1775203389",
        "key": "raw/molo_moloResourceAssignmentSet/2026-04-03/1775203389/ResourceAssignmentSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloResourceAssignmentSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1586946287003010670,
        "service_name": "drive-thru",
        "span_id": 9120554936439622741,
        "trace_id": 17699924524383199218
    }
}

running: False
schema_name_id: 1658
start_time: 2026-04-03 03:06:27
success: True
trace_id: 17699924524383199218

Partitions:

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

Schema:

attributes:

{
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "EndDate": "string",
    "ExpirationDateTime": "string",
    "GroupCode": "string",
    "HashId": "string",
    "Hours": "string",
    "Id": "string",
    "IsTempHold": "string",
    "MarinaLocationId": "string",
    "MaximumHours": "string",
    "MinimumHours": "string",
    "OfferId": "string",
    "OnlineBooking": "string",
    "RecordStatusId": "string",
    "ResourceAssignmentBlockId": "string",
    "ResourceBookingId": "string",
    "ResourceId": "string",
    "StartDate": "string"
}

created: 2026-04-17 03:04:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
}

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:25",
        "disabled": false,
        "format": "raw",
        "id": 1658,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloresourceassignmentset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUserId": "string",
            "DeletionDateTime": "string",
            "EndDate": "string",
            "ExpirationDateTime": "string",
            "GroupCode": "string",
            "HashId": "string",
            "Hours": "string",
            "Id": "string",
            "IsTempHold": "string",
            "MarinaLocationId": "string",
            "MaximumHours": "string",
            "MinimumHours": "string",
            "OfferId": "string",
            "OnlineBooking": "string",
            "RecordStatusId": "string",
            "ResourceAssignmentBlockId": "string",
            "ResourceBookingId": "string",
            "ResourceId": "string",
            "StartDate": "string"
        },
        "created": "2026-04-17 03:04:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloresourceassignmentset`\n(\n `Id`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `ResourceBookingId`  string , `ResourceId`  string , `MarinaLocationId`  string , `StartDate`  string , `EndDate`  string , `ExpirationDateTime`  string , `IsTempHold`  string , `OnlineBooking`  string , `RecordStatusId`  string , `DeletionDateTime`  string , `DeletionAspNetUserId`  string , `HashId`  string , `ResourceAssignmentBlockId`  string , `GroupCode`  string , `OfferId`  string , `MinimumHours`  string , `MaximumHours`  string , `Hours`  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_moloResourceAssignmentSet/2026-04-17/1776412846'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloresourceassignmentset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloresourceassignmentset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}