Schema Info
Schema Name: sfdl_prod_drivethru.molo_molosv_inventorycategoryset
- created: 2023-10-17 02:02:27
- disabled: False
- format: raw
- id: 1796
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molosv_inventorycategoryset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717707
- created: 2026-04-17 03:07:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-17/1776412998
- id: 1717707
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 162167706
- updated: 2026-04-17 03:08:00
-
Version 1716490
- created: 2026-04-16 03:11:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-16/1776326697'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-16/1776326697
- id: 1716490
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 162111932
- updated: 2026-04-16 03:11:25
-
Version 1715315
- created: 2026-04-15 03:09:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-15/1776240184'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-15/1776240184
- id: 1715315
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 162056102
- updated: 2026-04-15 03:09:57
-
Version 1714180
- created: 2026-04-14 03:12:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-14/1776154139'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-14/1776154139
- id: 1714180
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 162000704
- updated: 2026-04-14 03:12:37
-
Version 1712931
- created: 2026-04-13 03:05:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-13/1776067135'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-13/1776067135
- id: 1712931
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161942696
- updated: 2026-04-13 03:05:24
-
Version 1711675
- created: 2026-04-12 03:03:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-12/1775980830'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-12/1775980830
- id: 1711675
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161893167
- updated: 2026-04-12 03:04:09
-
Version 1710446
- created: 2026-04-11 03:06:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-11/1775894600'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-11/1775894600
- id: 1710446
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161841233
- updated: 2026-04-11 03:06:37
-
Version 1709407
- created: 2026-04-10 03:12:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-10/1775808363'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-10/1775808363
- id: 1709407
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161786111
- updated: 2026-04-10 03:12:36
-
Version 1708176
- created: 2026-04-09 03:05:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-09/1775721689'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-09/1775721689
- id: 1708176
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161730395
- updated: 2026-04-09 03:06:06
-
Version 1706938
- created: 2026-04-08 03:07:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-08/1775635524'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-08/1775635524
- id: 1706938
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161675580
- updated: 2026-04-08 03:07:19
-
Version 1705800
- created: 2026-04-07 03:01:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-07/1775548687'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-07/1775548687
- id: 1705800
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161619080
- updated: 2026-04-07 03:01:34
-
Version 1704632
- created: 2026-04-06 03:11:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-06/1775462637'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-06/1775462637
- id: 1704632
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161561781
- updated: 2026-04-06 03:11:35
-
Version 1703416
- created: 2026-04-05 03:09:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-05/1775376269'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-05/1775376269
- id: 1703416
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161515001
- updated: 2026-04-05 03:09:50
-
Version 1702229
- created: 2026-04-04 03:08:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-04/1775289750'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-04/1775289750
- id: 1702229
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161460517
- updated: 2026-04-04 03:09:05
-
Version 1701085
- created: 2026-04-03 03:18:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-03/1775203517'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryCategorySet/2026-04-03/1775203517
- id: 1701085
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1796
- schema_scan_id: 161402087
- updated: 2026-04-03 03:18:32
Schema Scans: 15
Last at 2026-04-17 03:07:46
-
Scan 162167706
- duration: 0:00:14.214577
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167706
- 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_InventoryCategorySet/2026-04-17/1776412998", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-17/1776412998/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5069743122839877475, "service_name": "drive-thru", "span_id": 10154308886281912476, "trace_id": 1659468392792746671 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-17 03:07:46
- success: True
- trace_id: 1659468392792746671
-
Scan 162111932
- duration: 0:00:14.307430
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111932
- 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_InventoryCategorySet/2026-04-16/1776326697", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-16/1776326697/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6703466779795235368, "service_name": "drive-thru", "span_id": 5258076279098286422, "trace_id": 16745443523466017876 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-16 03:11:11
- success: True
- trace_id: 16745443523466017876
-
Scan 162056102
- duration: 0:00:14.201945
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056102
- 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_InventoryCategorySet/2026-04-15/1776240184", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-15/1776240184/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 185767127221745613, "service_name": "drive-thru", "span_id": 5354117739449226399, "trace_id": 5314608856505465734 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-15 03:09:43
- success: True
- trace_id: 5314608856505465734
-
Scan 162000704
- duration: 0:00:11.618296
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000704
- 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_InventoryCategorySet/2026-04-14/1776154139", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-14/1776154139/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12949283176816023426, "service_name": "drive-thru", "span_id": 14370893908886519809, "trace_id": 7003234116369623923 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-14 03:12:26
- success: True
- trace_id: 7003234116369623923
-
Scan 161942696
- duration: 0:00:14.234288
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942696
- 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_InventoryCategorySet/2026-04-13/1776067135", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-13/1776067135/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14115945957526556743, "service_name": "drive-thru", "span_id": 232905898756345768, "trace_id": 14130474815810965810 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-13 03:05:09
- success: True
- trace_id: 14130474815810965810
-
Scan 161893167
- duration: 0:00:14.098590
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893167
- 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_InventoryCategorySet/2026-04-12/1775980830", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-12/1775980830/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3618618258373009747, "service_name": "drive-thru", "span_id": 2193411404624871922, "trace_id": 14502831068500102683 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-12 03:03:55
- success: True
- trace_id: 14502831068500102683
-
Scan 161841233
- duration: 0:00:14.125581
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841233
- 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_InventoryCategorySet/2026-04-11/1775894600", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-11/1775894600/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17295633186455480711, "service_name": "drive-thru", "span_id": 3634663985482725178, "trace_id": 7297642297100414595 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-11 03:06:23
- success: True
- trace_id: 7297642297100414595
-
Scan 161786111
- duration: 0:00:14.504966
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786111
- 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_InventoryCategorySet/2026-04-10/1775808363", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-10/1775808363/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9592335542167976756, "service_name": "drive-thru", "span_id": 3068124829583581468, "trace_id": 13048514141153517137 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-10 03:12:22
- success: True
- trace_id: 13048514141153517137
-
Scan 161730395
- duration: 0:00:14.170299
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730395
- 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_InventoryCategorySet/2026-04-09/1775721689", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-09/1775721689/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14087017245594988698, "service_name": "drive-thru", "span_id": 13462237747736531531, "trace_id": 14850904224567998366 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-09 03:05:52
- success: True
- trace_id: 14850904224567998366
-
Scan 161675580
- duration: 0:00:14.137049
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675580
- 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_InventoryCategorySet/2026-04-08/1775635524", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-08/1775635524/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14933785873282389209, "service_name": "drive-thru", "span_id": 13156636627792717889, "trace_id": 9764563291183637957 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-08 03:07:05
- success: True
- trace_id: 9764563291183637957
-
Scan 161619080
- duration: 0:00:14.152046
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619080
- 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_InventoryCategorySet/2026-04-07/1775548687", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-07/1775548687/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12640593242940163270, "service_name": "drive-thru", "span_id": 11840331262690175967, "trace_id": 11993917694908343795 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-07 03:01:20
- success: True
- trace_id: 11993917694908343795
-
Scan 161561781
- duration: 0:00:14.059228
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561781
- 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_InventoryCategorySet/2026-04-06/1775462637", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-06/1775462637/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12716659891855639664, "service_name": "drive-thru", "span_id": 11821608264697899011, "trace_id": 1361940488774065455 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-06 03:11:21
- success: True
- trace_id: 1361940488774065455
-
Scan 161515001
- duration: 0:00:11.691992
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161515001
- 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_InventoryCategorySet/2026-04-05/1775376269", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-05/1775376269/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18257669597591628680, "service_name": "drive-thru", "span_id": 6015034395045268281, "trace_id": 11143808239721936334 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-05 03:09:38
- success: True
- trace_id: 11143808239721936334
-
Scan 161460517
- duration: 0:00:14.297792
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460517
- 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_InventoryCategorySet/2026-04-04/1775289750", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-04/1775289750/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 256728701160704871, "service_name": "drive-thru", "span_id": 2042045051766515344, "trace_id": 14472341649431526068 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-04 03:08:51
- success: True
- trace_id: 14472341649431526068
-
Scan 161402087
- duration: 0:00:14.252393
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402087
- 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_InventoryCategorySet/2026-04-03/1775203517", "key": "raw/molo_moloSV_InventoryCategorySet/2026-04-03/1775203517/SV_InventoryCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_InventoryCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13676340339000976754, "service_name": "drive-thru", "span_id": 11738274926714041552, "trace_id": 12153570049406937965 } } - running: False
- schema_name_id: 1796
- start_time: 2026-04-03 03:18:18
- success: True
- trace_id: 12153570049406937965
- attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - created: 2026-04-17 03:07:47
- 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_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 02:02:27",
"disabled": false,
"format": "raw",
"id": 1796,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molosv_inventorycategoryset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"MarinaLocation_Id": "string",
"Name": "string"
},
"created": "2026-04-17 03:07:47",
"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_inventorycategoryset`\n(\n `Id` string , `Name` 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_InventoryCategorySet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventorycategoryset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventorycategoryset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}