Schema Info

Schema Name: sfdl_prod_drivethru.molo_molocustomfieldset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717570

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-17/1776412700
id: 1717570
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 162167190
updated: 2026-04-17 03:00:28

Version 1716353

created: 2026-04-16 03:05:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-16/1776326464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-16/1776326464
id: 1716353
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 162111734
updated: 2026-04-16 03:05:41

Version 1715158

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-15/1776239934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-15/1776239934
id: 1715158
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 162055726
updated: 2026-04-15 03:02:21

Version 1713973

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-14/1776153659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-14/1776153659
id: 1713973
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 162000403
updated: 2026-04-14 03:04:18

Version 1712730

created: 2026-04-13 02:56:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-13/1776066851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-13/1776066851
id: 1712730
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161941509
updated: 2026-04-13 02:56:25

Version 1711538

created: 2026-04-12 02:58:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-12/1775980568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-12/1775980568
id: 1711538
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161892343
updated: 2026-04-12 02:58:22

Version 1710314

created: 2026-04-11 03:00:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-11/1775894328'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-11/1775894328
id: 1710314
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161840921
updated: 2026-04-11 03:00:41

Version 1709257

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-10/1775808084'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-10/1775808084
id: 1709257
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161785944
updated: 2026-04-10 03:06:47

Version 1708032

created: 2026-04-09 02:59:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-09/1775721423'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-09/1775721423
id: 1708032
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161729829
updated: 2026-04-09 02:59:33

Version 1706862

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-08/1775635231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-08/1775635231
id: 1706862
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161675443
updated: 2026-04-08 03:03:55

Version 1705634

created: 2026-04-07 02:54:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-07/1775548405'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-07/1775548405
id: 1705634
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161618311
updated: 2026-04-07 02:54:39

Version 1704382

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-06/1775462367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-06/1775462367
id: 1704382
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161561253
updated: 2026-04-06 03:00:23

Version 1703210

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-05/1775375995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-05/1775375995
id: 1703210
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161514770
updated: 2026-04-05 03:01:42

Version 1702068

created: 2026-04-04 03:01:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-04/1775289479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-04/1775289479
id: 1702068
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161459923
updated: 2026-04-04 03:01:29

Version 1700812

created: 2026-04-03 03:02:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-03/1775203252'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloCustomFieldSet/2026-04-03/1775203252
id: 1700812
processed: 1

raw_data:

{
    "AvailableForOffers": 11,
    "AvailableForResourceOffers": 12,
    "CreationAspNetUserId": 3,
    "CreationDateTime": 2,
    "CustomFieldCustomerFacingName": 5,
    "CustomFieldInternalName": 4,
    "CustomFieldType_Id": 14,
    "DeletionAspNetUser": 10,
    "DeletionDateTime": 9,
    "EnabledForBoats": 7,
    "EnabledForContacts": 6,
    "HashId": 1,
    "Id": 0,
    "MarinaLocation_Id": 13,
    "RecordStatus_Id": 15,
    "Required": 8,
    "WebAppCustomField": 16
}

schema_attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

schema_name_id: 1588
schema_scan_id: 161401604
updated: 2026-04-03 03:03:08

Schema Scans: 15

Last at 2026-04-17 03:00:14

Scan 162167190

duration: 0:00:14.591204

exit_message:

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

id: 162167190

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_moloCustomFieldSet/2026-04-17/1776412700",
        "key": "raw/molo_moloCustomFieldSet/2026-04-17/1776412700/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10472464097943338711,
        "service_name": "drive-thru",
        "span_id": 16145639139761195041,
        "trace_id": 10947672600519842157
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-17 03:00:14
success: True
trace_id: 10947672600519842157

Scan 162111734

duration: 0:00:11.937126

exit_message:

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

id: 162111734

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_moloCustomFieldSet/2026-04-16/1776326464",
        "key": "raw/molo_moloCustomFieldSet/2026-04-16/1776326464/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4670164726986000552,
        "service_name": "drive-thru",
        "span_id": 7843487534296443370,
        "trace_id": 952983497864193493
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-16 03:05:29
success: True
trace_id: 952983497864193493

Scan 162055726

duration: 0:00:14.476500

exit_message:

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

id: 162055726

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_moloCustomFieldSet/2026-04-15/1776239934",
        "key": "raw/molo_moloCustomFieldSet/2026-04-15/1776239934/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7879555153324998345,
        "service_name": "drive-thru",
        "span_id": 15240358850623650833,
        "trace_id": 11605420825778269269
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-15 03:02:07
success: True
trace_id: 11605420825778269269

Scan 162000403

duration: 0:00:11.882787

exit_message:

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

id: 162000403

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_moloCustomFieldSet/2026-04-14/1776153659",
        "key": "raw/molo_moloCustomFieldSet/2026-04-14/1776153659/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5678628215558680119,
        "service_name": "drive-thru",
        "span_id": 7584537569036927523,
        "trace_id": 4770332653281257714
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-14 03:04:06
success: True
trace_id: 4770332653281257714

Scan 161941509

duration: 0:00:14.383261

exit_message:

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

id: 161941509

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_moloCustomFieldSet/2026-04-13/1776066851",
        "key": "raw/molo_moloCustomFieldSet/2026-04-13/1776066851/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12669890394831219158,
        "service_name": "drive-thru",
        "span_id": 1385420858937840370,
        "trace_id": 2666150960871724195
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-13 02:56:11
success: True
trace_id: 2666150960871724195

Scan 161892343

duration: 0:00:11.798772

exit_message:

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

id: 161892343

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_moloCustomFieldSet/2026-04-12/1775980568",
        "key": "raw/molo_moloCustomFieldSet/2026-04-12/1775980568/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10073112640424321350,
        "service_name": "drive-thru",
        "span_id": 2933777337810172378,
        "trace_id": 10863476997809175472
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-12 02:58:10
success: True
trace_id: 10863476997809175472

Scan 161840921

duration: 0:00:14.441844

exit_message:

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

id: 161840921

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_moloCustomFieldSet/2026-04-11/1775894328",
        "key": "raw/molo_moloCustomFieldSet/2026-04-11/1775894328/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 458039663229679033,
        "service_name": "drive-thru",
        "span_id": 3642437935424901138,
        "trace_id": 18419885133402681055
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-11 03:00:27
success: True
trace_id: 18419885133402681055

Scan 161785944

duration: 0:00:14.750937

exit_message:

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

id: 161785944

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_moloCustomFieldSet/2026-04-10/1775808084",
        "key": "raw/molo_moloCustomFieldSet/2026-04-10/1775808084/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6759378237856167874,
        "service_name": "drive-thru",
        "span_id": 840678477774606893,
        "trace_id": 12435239450237695408
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-10 03:06:33
success: True
trace_id: 12435239450237695408

Scan 161729829

duration: 0:00:14.468302

exit_message:

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

id: 161729829

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_moloCustomFieldSet/2026-04-09/1775721423",
        "key": "raw/molo_moloCustomFieldSet/2026-04-09/1775721423/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9221717932994970759,
        "service_name": "drive-thru",
        "span_id": 1173712779668466703,
        "trace_id": 10177926679169029722
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-09 02:59:19
success: True
trace_id: 10177926679169029722

Scan 161675443

duration: 0:00:12.094518

exit_message:

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

id: 161675443

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_moloCustomFieldSet/2026-04-08/1775635231",
        "key": "raw/molo_moloCustomFieldSet/2026-04-08/1775635231/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13302541460002802440,
        "service_name": "drive-thru",
        "span_id": 8711925588409129093,
        "trace_id": 8757692783635797741
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-08 03:03:43
success: True
trace_id: 8757692783635797741

Scan 161618311

duration: 0:00:14.462173

exit_message:

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

id: 161618311

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_moloCustomFieldSet/2026-04-07/1775548405",
        "key": "raw/molo_moloCustomFieldSet/2026-04-07/1775548405/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8738573413476387868,
        "service_name": "drive-thru",
        "span_id": 9759548972457914830,
        "trace_id": 16546911817454937190
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-07 02:54:24
success: True
trace_id: 16546911817454937190

Scan 161561253

duration: 0:00:12.049053

exit_message:

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

id: 161561253

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_moloCustomFieldSet/2026-04-06/1775462367",
        "key": "raw/molo_moloCustomFieldSet/2026-04-06/1775462367/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16108024868143448352,
        "service_name": "drive-thru",
        "span_id": 11195027679107029269,
        "trace_id": 6808651866384772478
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-06 03:00:11
success: True
trace_id: 6808651866384772478

Scan 161514770

duration: 0:00:11.913399

exit_message:

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

id: 161514770

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_moloCustomFieldSet/2026-04-05/1775375995",
        "key": "raw/molo_moloCustomFieldSet/2026-04-05/1775375995/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7554501444302466041,
        "service_name": "drive-thru",
        "span_id": 12715762290464959986,
        "trace_id": 3178360882902589277
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-05 03:01:30
success: True
trace_id: 3178360882902589277

Scan 161459923

duration: 0:00:12.224012

exit_message:

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

id: 161459923

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_moloCustomFieldSet/2026-04-04/1775289479",
        "key": "raw/molo_moloCustomFieldSet/2026-04-04/1775289479/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3614668535465479491,
        "service_name": "drive-thru",
        "span_id": 7335256556917745037,
        "trace_id": 14810795765040154538
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-04 03:01:17
success: True
trace_id: 14810795765040154538

Scan 161401604

duration: 0:00:14.606478

exit_message:

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

id: 161401604

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_moloCustomFieldSet/2026-04-03/1775203252",
        "key": "raw/molo_moloCustomFieldSet/2026-04-03/1775203252/CustomFieldSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloCustomFieldSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2484555829889985920,
        "service_name": "drive-thru",
        "span_id": 7897332180327610499,
        "trace_id": 18333410845086474673
    }
}

running: False
schema_name_id: 1588
start_time: 2026-04-03 03:02:53
success: True
trace_id: 18333410845086474673

Partitions:

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

Schema:

attributes:

{
    "AvailableForOffers": "string",
    "AvailableForResourceOffers": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "CustomFieldCustomerFacingName": "string",
    "CustomFieldInternalName": "string",
    "CustomFieldType_Id": "string",
    "DeletionAspNetUser": "string",
    "DeletionDateTime": "string",
    "EnabledForBoats": "string",
    "EnabledForContacts": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "RecordStatus_Id": "string",
    "Required": "string",
    "WebAppCustomField": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
}

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:54:55",
        "disabled": false,
        "format": "raw",
        "id": 1588,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molocustomfieldset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AvailableForOffers": "string",
            "AvailableForResourceOffers": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "CustomFieldCustomerFacingName": "string",
            "CustomFieldInternalName": "string",
            "CustomFieldType_Id": "string",
            "DeletionAspNetUser": "string",
            "DeletionDateTime": "string",
            "EnabledForBoats": "string",
            "EnabledForContacts": "string",
            "HashId": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "RecordStatus_Id": "string",
            "Required": "string",
            "WebAppCustomField": "string"
        },
        "created": "2026-04-17 03:00:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molocustomfieldset`\n(\n `Id`  string , `HashId`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `CustomFieldInternalName`  string , `CustomFieldCustomerFacingName`  string , `EnabledForContacts`  string , `EnabledForBoats`  string , `Required`  string , `DeletionDateTime`  string , `DeletionAspNetUser`  string , `AvailableForOffers`  string , `AvailableForResourceOffers`  string , `MarinaLocation_Id`  string , `CustomFieldType_Id`  string , `RecordStatus_Id`  string , `WebAppCustomField`  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_moloCustomFieldSet/2026-04-17/1776412700'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molocustomfieldset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molocustomfieldset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}