Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset

created: 2023-10-17 02:02:53
disabled: False
format: raw
id: 1806
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717752

created: 2026-04-17 03:09:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-17/1776412998
id: 1717752
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 162167762
updated: 2026-04-17 03:09:41

Version 1716448

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-16/1776326698'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-16/1776326698
id: 1716448
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 162111883
updated: 2026-04-16 03:09:49

Version 1715375

created: 2026-04-15 03:12:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-15/1776240185'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-15/1776240185
id: 1715375
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 162056178
updated: 2026-04-15 03:13:00

Version 1714148

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-14/1776154140'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-14/1776154140
id: 1714148
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 162000668
updated: 2026-04-14 03:11:22

Version 1712917

created: 2026-04-13 03:04:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-13/1776067135'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-13/1776067135
id: 1712917
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161942621
updated: 2026-04-13 03:04:33

Version 1711770

created: 2026-04-12 03:08:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-12/1775980830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-12/1775980830
id: 1711770
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161893476
updated: 2026-04-12 03:09:00

Version 1710562

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-11/1775894601'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-11/1775894601
id: 1710562
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161841369
updated: 2026-04-11 03:11:12

Version 1709339

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-10/1775808364'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-10/1775808364
id: 1709339
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161786038
updated: 2026-04-10 03:09:54

Version 1708255

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-09/1775721690'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-09/1775721690
id: 1708255
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161730528
updated: 2026-04-09 03:09:32

Version 1706949

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-08/1775635525'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-08/1775635525
id: 1706949
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161675595
updated: 2026-04-08 03:07:46

Version 1705795

created: 2026-04-07 03:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-07/1775548688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-07/1775548688
id: 1705795
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161618955
updated: 2026-04-07 03:01:06

Version 1704644

created: 2026-04-06 03:11:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-06/1775462638'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-06/1775462638
id: 1704644
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161561793
updated: 2026-04-06 03:12:01

Version 1703417

created: 2026-04-05 03:09:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-05/1775376270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-05/1775376270
id: 1703417
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161515002
updated: 2026-04-05 03:10:00

Version 1702230

created: 2026-04-04 03:08:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-04/1775289751'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-04/1775289751
id: 1702230
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161460519
updated: 2026-04-04 03:09:11

Version 1700994

created: 2026-04-03 03:11:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-03/1775203518'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventorySubCategorySet/2026-04-03/1775203518
id: 1700994
processed: 1

raw_data:

{
    "Id": 0,
    "MarinaLocation_Id": 3,
    "Name": 1,
    "SV_InventoryCategoryId": 2
}

schema_attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

schema_name_id: 1806
schema_scan_id: 161401967
updated: 2026-04-03 03:12:03

Schema Scans: 15

Last at 2026-04-17 03:09:29

Scan 162167762

duration: 0:00:11.593544

exit_message:

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

id: 162167762

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_InventorySubCategorySet/2026-04-17/1776412998",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-17/1776412998/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3575767299703318052,
        "service_name": "drive-thru",
        "span_id": 7141857731639023829,
        "trace_id": 6011665667248877845
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-17 03:09:29
success: True
trace_id: 6011665667248877845

Scan 162111883

duration: 0:00:11.560359

exit_message:

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

id: 162111883

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_InventorySubCategorySet/2026-04-16/1776326698",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-16/1776326698/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17603059218756249058,
        "service_name": "drive-thru",
        "span_id": 18316288437856739334,
        "trace_id": 14566368193926043026
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-16 03:09:37
success: True
trace_id: 14566368193926043026

Scan 162056178

duration: 0:00:11.775568

exit_message:

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

id: 162056178

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_InventorySubCategorySet/2026-04-15/1776240185",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-15/1776240185/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7336832639632046686,
        "service_name": "drive-thru",
        "span_id": 8023097056577890228,
        "trace_id": 12633378592844009965
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-15 03:12:48
success: True
trace_id: 12633378592844009965

Scan 162000668

duration: 0:00:14.118921

exit_message:

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

id: 162000668

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_InventorySubCategorySet/2026-04-14/1776154140",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-14/1776154140/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1612161262136416335,
        "service_name": "drive-thru",
        "span_id": 11430649551836431581,
        "trace_id": 3245214125094195596
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-14 03:11:08
success: True
trace_id: 3245214125094195596

Scan 161942621

duration: 0:00:14.174427

exit_message:

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

id: 161942621

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_InventorySubCategorySet/2026-04-13/1776067135",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-13/1776067135/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3550154527106197356,
        "service_name": "drive-thru",
        "span_id": 9739965354487288713,
        "trace_id": 6658708074218225902
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-13 03:04:18
success: True
trace_id: 6658708074218225902

Scan 161893476

duration: 0:00:14.060199

exit_message:

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

id: 161893476

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_InventorySubCategorySet/2026-04-12/1775980830",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-12/1775980830/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1666633959396634064,
        "service_name": "drive-thru",
        "span_id": 15381693105270470959,
        "trace_id": 16817659812665143593
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-12 03:08:46
success: True
trace_id: 16817659812665143593

Scan 161841369

duration: 0:00:14.421436

exit_message:

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

id: 161841369

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_InventorySubCategorySet/2026-04-11/1775894601",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-11/1775894601/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15035288296474723871,
        "service_name": "drive-thru",
        "span_id": 306903261275355242,
        "trace_id": 5683867273822002710
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-11 03:10:57
success: True
trace_id: 5683867273822002710

Scan 161786038

duration: 0:00:14.137928

exit_message:

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

id: 161786038

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_InventorySubCategorySet/2026-04-10/1775808364",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-10/1775808364/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11044552854424564204,
        "service_name": "drive-thru",
        "span_id": 15638782474707693671,
        "trace_id": 6362867905140086393
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-10 03:09:40
success: True
trace_id: 6362867905140086393

Scan 161730528

duration: 0:00:14.174144

exit_message:

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

id: 161730528

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_InventorySubCategorySet/2026-04-09/1775721690",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-09/1775721690/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17008328532536014332,
        "service_name": "drive-thru",
        "span_id": 4901061075941252514,
        "trace_id": 4682141553879184436
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-09 03:09:18
success: True
trace_id: 4682141553879184436

Scan 161675595

duration: 0:00:14.361775

exit_message:

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

id: 161675595

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_InventorySubCategorySet/2026-04-08/1775635525",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-08/1775635525/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7999777752581175512,
        "service_name": "drive-thru",
        "span_id": 13221579418818505714,
        "trace_id": 1157212803490531734
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-08 03:07:32
success: True
trace_id: 1157212803490531734

Scan 161618955

duration: 0:00:11.886868

exit_message:

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

id: 161618955

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_InventorySubCategorySet/2026-04-07/1775548688",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-07/1775548688/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10575130568838322966,
        "service_name": "drive-thru",
        "span_id": 4623716843526318013,
        "trace_id": 14497183129042021083
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-07 03:00:54
success: True
trace_id: 14497183129042021083

Scan 161561793

duration: 0:00:11.716646

exit_message:

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

id: 161561793

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_InventorySubCategorySet/2026-04-06/1775462638",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-06/1775462638/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11083761585446405420,
        "service_name": "drive-thru",
        "span_id": 1498980098348618447,
        "trace_id": 938752009317773267
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-06 03:11:50
success: True
trace_id: 938752009317773267

Scan 161515002

duration: 0:00:14.107468

exit_message:

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

id: 161515002

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_InventorySubCategorySet/2026-04-05/1775376270",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-05/1775376270/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2394323853459858368,
        "service_name": "drive-thru",
        "span_id": 17633973663929722490,
        "trace_id": 6568014571277526468
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-05 03:09:46
success: True
trace_id: 6568014571277526468

Scan 161460519

duration: 0:00:14.132929

exit_message:

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

id: 161460519

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_InventorySubCategorySet/2026-04-04/1775289751",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-04/1775289751/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8518044134376293759,
        "service_name": "drive-thru",
        "span_id": 4348218419820226340,
        "trace_id": 126942125345124225
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-04 03:08:57
success: True
trace_id: 126942125345124225

Scan 161401967

duration: 0:00:11.629305

exit_message:

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

id: 161401967

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_InventorySubCategorySet/2026-04-03/1775203518",
        "key": "raw/molo_moloSV_InventorySubCategorySet/2026-04-03/1775203518/SV_InventorySubCategorySet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventorySubCategorySet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 779241125050270543,
        "service_name": "drive-thru",
        "span_id": 16301082879497735199,
        "trace_id": 1131487571473403793
    }
}

running: False
schema_name_id: 1806
start_time: 2026-04-03 03:11:51
success: True
trace_id: 1131487571473403793

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string",
    "SV_InventoryCategoryId": "string"
}

created: 2026-04-17 03:09:29

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_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
}

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 02:02:53",
        "disabled": false,
        "format": "raw",
        "id": 1806,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_inventorysubcategoryset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "MarinaLocation_Id": "string",
            "Name": "string",
            "SV_InventoryCategoryId": "string"
        },
        "created": "2026-04-17 03:09:29",
        "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_inventorysubcategoryset`\n(\n `Id`  string , `Name`  string , `SV_InventoryCategoryId`  string , `MarinaLocation_Id`  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_InventorySubCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorysubcategoryset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}