Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_serviceresourceset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717710

created: 2026-04-17 03:07:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-17/1776413127
id: 1717710
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 162167710
updated: 2026-04-17 03:08:02

Version 1716449

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-16/1776326731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-16/1776326731
id: 1716449
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 162111884
updated: 2026-04-16 03:09:54

Version 1715381

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-15/1776240197'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-15/1776240197
id: 1715381
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 162056187
updated: 2026-04-15 03:13:20

Version 1714154

created: 2026-04-14 03:11:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-14/1776154163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-14/1776154163
id: 1714154
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 162000674
updated: 2026-04-14 03:11:34

Version 1712945

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-13/1776067159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-13/1776067159
id: 1712945
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161942746
updated: 2026-04-13 03:06:05

Version 1711776

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-12/1775980858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-12/1775980858
id: 1711776
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161893507
updated: 2026-04-12 03:09:28

Version 1710518

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-11/1775894626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-11/1775894626
id: 1710518
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161841309
updated: 2026-04-11 03:09:17

Version 1709309

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-10/1775808387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-10/1775808387
id: 1709309
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161786006
updated: 2026-04-10 03:08:45

Version 1708257

created: 2026-04-09 03:09:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-09/1775721717'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-09/1775721717
id: 1708257
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161730536
updated: 2026-04-09 03:09:37

Version 1707041

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-08/1775635547'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-08/1775635547
id: 1707041
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161675707
updated: 2026-04-08 03:11:18

Version 1705835

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-07/1775548709'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-07/1775548709
id: 1705835
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161619305
updated: 2026-04-07 03:03:01

Version 1704599

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-06/1775462660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-06/1775462660
id: 1704599
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161561743
updated: 2026-04-06 03:10:17

Version 1703441

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-05/1775376292'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-05/1775376292
id: 1703441
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161515030
updated: 2026-04-05 03:10:51

Version 1702278

created: 2026-04-04 03:10:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-04/1775289773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-04/1775289773
id: 1702278
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161460588
updated: 2026-04-04 03:11:05

Version 1701054

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-03/1775203539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceSet/2026-04-03/1775203539
id: 1701054
processed: 1

raw_data:

{
    "Availability": 3,
    "CreationAspNetUserId": 5,
    "CreationDateTime": 4,
    "DeletionAspNetUserId": 10,
    "DeletionDateTime": 11,
    "Description": 7,
    "HashId": 8,
    "Id": 0,
    "MarinaLocationId": 1,
    "Name": 2,
    "RecordStatusId": 6,
    "SV_ServiceResourceType_Id": 9
}

schema_attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

schema_name_id: 1724
schema_scan_id: 161402043
updated: 2026-04-03 03:15:16

Schema Scans: 15

Last at 2026-04-17 03:07:51

Scan 162167710

duration: 0:00:11.720008

exit_message:

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

id: 162167710

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_moloSV_ServiceResourceSet/2026-04-17/1776413127",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-17/1776413127/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13544820354394819030,
        "service_name": "drive-thru",
        "span_id": 17384571287180713120,
        "trace_id": 15920463361131425368
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-17 03:07:51
success: True
trace_id: 15920463361131425368

Scan 162111884

duration: 0:00:14.283605

exit_message:

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

id: 162111884

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_moloSV_ServiceResourceSet/2026-04-16/1776326731",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-16/1776326731/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5735745606109807601,
        "service_name": "drive-thru",
        "span_id": 9017998651418385981,
        "trace_id": 10376439863059120409
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-16 03:09:39
success: True
trace_id: 10376439863059120409

Scan 162056187

duration: 0:00:14.245395

exit_message:

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

id: 162056187

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_moloSV_ServiceResourceSet/2026-04-15/1776240197",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-15/1776240197/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14602210126210559723,
        "service_name": "drive-thru",
        "span_id": 7104462913059705329,
        "trace_id": 15865202344356160210
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-15 03:13:06
success: True
trace_id: 15865202344356160210

Scan 162000674

duration: 0:00:11.816681

exit_message:

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

id: 162000674

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_moloSV_ServiceResourceSet/2026-04-14/1776154163",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-14/1776154163/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4376786202874691019,
        "service_name": "drive-thru",
        "span_id": 10442393865084062335,
        "trace_id": 11563178464461039061
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-14 03:11:22
success: True
trace_id: 11563178464461039061

Scan 161942746

duration: 0:00:11.883983

exit_message:

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

id: 161942746

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_moloSV_ServiceResourceSet/2026-04-13/1776067159",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-13/1776067159/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9022895870040560237,
        "service_name": "drive-thru",
        "span_id": 9560015349014543893,
        "trace_id": 579755652491357488
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-13 03:05:53
success: True
trace_id: 579755652491357488

Scan 161893507

duration: 0:00:14.268366

exit_message:

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

id: 161893507

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_moloSV_ServiceResourceSet/2026-04-12/1775980858",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-12/1775980858/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10696527290040570619,
        "service_name": "drive-thru",
        "span_id": 8651081344619280251,
        "trace_id": 9657452675677806186
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-12 03:09:14
success: True
trace_id: 9657452675677806186

Scan 161841309

duration: 0:00:14.287119

exit_message:

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

id: 161841309

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_moloSV_ServiceResourceSet/2026-04-11/1775894626",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-11/1775894626/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16356768336905946819,
        "service_name": "drive-thru",
        "span_id": 16560095630693348098,
        "trace_id": 16569366175019383993
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-11 03:09:03
success: True
trace_id: 16569366175019383993

Scan 161786006

duration: 0:00:14.458302

exit_message:

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

id: 161786006

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_moloSV_ServiceResourceSet/2026-04-10/1775808387",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-10/1775808387/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3535580512123373025,
        "service_name": "drive-thru",
        "span_id": 13407824310303745990,
        "trace_id": 18105161923981634086
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-10 03:08:31
success: True
trace_id: 18105161923981634086

Scan 161730536

duration: 0:00:11.810713

exit_message:

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

id: 161730536

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_moloSV_ServiceResourceSet/2026-04-09/1775721717",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-09/1775721717/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12617731568153081522,
        "service_name": "drive-thru",
        "span_id": 11102169197211106292,
        "trace_id": 13556728096596775930
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-09 03:09:26
success: True
trace_id: 13556728096596775930

Scan 161675707

duration: 0:00:11.763108

exit_message:

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

id: 161675707

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_moloSV_ServiceResourceSet/2026-04-08/1775635547",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-08/1775635547/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7905356795611611252,
        "service_name": "drive-thru",
        "span_id": 3097495824856909948,
        "trace_id": 8459509026506851024
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-08 03:11:06
success: True
trace_id: 8459509026506851024

Scan 161619305

duration: 0:00:11.824877

exit_message:

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

id: 161619305

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_moloSV_ServiceResourceSet/2026-04-07/1775548709",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-07/1775548709/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9033235373356765958,
        "service_name": "drive-thru",
        "span_id": 13007028787795757260,
        "trace_id": 9583922189035435403
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-07 03:02:49
success: True
trace_id: 9583922189035435403

Scan 161561743

duration: 0:00:11.946112

exit_message:

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

id: 161561743

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_moloSV_ServiceResourceSet/2026-04-06/1775462660",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-06/1775462660/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18146971194698402244,
        "service_name": "drive-thru",
        "span_id": 12369187088502237624,
        "trace_id": 12914208853211242636
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-06 03:10:05
success: True
trace_id: 12914208853211242636

Scan 161515030

duration: 0:00:14.239086

exit_message:

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

id: 161515030

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_moloSV_ServiceResourceSet/2026-04-05/1775376292",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-05/1775376292/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13496041168755618945,
        "service_name": "drive-thru",
        "span_id": 11457334283866852153,
        "trace_id": 10511214124317176688
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-05 03:10:37
success: True
trace_id: 10511214124317176688

Scan 161460588

duration: 0:00:11.898036

exit_message:

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

id: 161460588

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_moloSV_ServiceResourceSet/2026-04-04/1775289773",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-04/1775289773/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16854235857895389586,
        "service_name": "drive-thru",
        "span_id": 1997970674188011039,
        "trace_id": 18174664946075549105
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-04 03:10:53
success: True
trace_id: 18174664946075549105

Scan 161402043

duration: 0:00:14.653019

exit_message:

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

id: 161402043

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_moloSV_ServiceResourceSet/2026-04-03/1775203539",
        "key": "raw/molo_moloSV_ServiceResourceSet/2026-04-03/1775203539/SV_ServiceResourceSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3125510413163782812,
        "service_name": "drive-thru",
        "span_id": 1507556239219711059,
        "trace_id": 1492142460659157915
    }
}

running: False
schema_name_id: 1724
start_time: 2026-04-03 03:15:01
success: True
trace_id: 1492142460659157915

Partitions:

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

Schema:

attributes:

{
    "Availability": "string",
    "CreationAspNetUserId": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUserId": "string",
    "DeletionDateTime": "string",
    "Description": "string",
    "HashId": "string",
    "Id": "string",
    "MarinaLocationId": "string",
    "Name": "string",
    "RecordStatusId": "string",
    "SV_ServiceResourceType_Id": "string"
}

created: 2026-04-17 03:07:51

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
}

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:59:41",
        "disabled": false,
        "format": "raw",
        "id": 1724,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_serviceresourceset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Availability": "string",
            "CreationAspNetUserId": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUserId": "string",
            "DeletionDateTime": "string",
            "Description": "string",
            "HashId": "string",
            "Id": "string",
            "MarinaLocationId": "string",
            "Name": "string",
            "RecordStatusId": "string",
            "SV_ServiceResourceType_Id": "string"
        },
        "created": "2026-04-17 03:07:51",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceset`\n(\n `Id`  string , `MarinaLocationId`  string , `Name`  string , `Availability`  string , `CreationDateTime`  string , `CreationAspNetUserId`  string , `RecordStatusId`  string , `Description`  string , `HashId`  string , `SV_ServiceResourceType_Id`  string , `DeletionAspNetUserId`  string , `DeletionDateTime`  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_moloSV_ServiceResourceSet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}