Schema Info
Schema Name: sfdl_prod_drivethru.molo_molosv_workordercategoryset
- created: 2023-10-17 02:02:59
- disabled: False
- format: raw
- id: 1809
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molosv_workordercategoryset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717717
- created: 2026-04-17 03:08:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-17/1776413127
- id: 1717717
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 162167717
- updated: 2026-04-17 03:08:22
-
Version 1716453
- created: 2026-04-16 03:09:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-16/1776326731'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-16/1776326731
- id: 1716453
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 162111888
- updated: 2026-04-16 03:10:00
-
Version 1715287
- created: 2026-04-15 03:08:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-15/1776240198'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-15/1776240198
- id: 1715287
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 162056044
- updated: 2026-04-15 03:08:33
-
Version 1714183
- created: 2026-04-14 03:12:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-14/1776154164'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-14/1776154164
- id: 1714183
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 162000707
- updated: 2026-04-14 03:12:42
-
Version 1712888
- created: 2026-04-13 03:03:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-13/1776067158'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-13/1776067158
- id: 1712888
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161942561
- updated: 2026-04-13 03:03:33
-
Version 1711712
- created: 2026-04-12 03:06:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-12/1775980859'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-12/1775980859
- id: 1711712
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161893375
- updated: 2026-04-12 03:06:24
-
Version 1710576
- created: 2026-04-11 03:11:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-11/1775894627'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-11/1775894627
- id: 1710576
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161841384
- updated: 2026-04-11 03:11:51
-
Version 1709314
- created: 2026-04-10 03:08:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-10/1775808388'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-10/1775808388
- id: 1709314
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161786012
- updated: 2026-04-10 03:08:56
-
Version 1708248
- created: 2026-04-09 03:08:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-09/1775721717'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-09/1775721717
- id: 1708248
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161730516
- updated: 2026-04-09 03:09:12
-
Version 1706916
- created: 2026-04-08 03:06:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-08/1775635549'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-08/1775635549
- id: 1706916
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161675548
- updated: 2026-04-08 03:06:22
-
Version 1705832
- created: 2026-04-07 03:02:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-07/1775548710'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-07/1775548710
- id: 1705832
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161619273
- updated: 2026-04-07 03:02:52
-
Version 1704655
- created: 2026-04-06 03:12:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-06/1775462660'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-06/1775462660
- id: 1704655
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161561804
- updated: 2026-04-06 03:12:25
-
Version 1703371
- created: 2026-04-05 03:08:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-05/1775376291'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-05/1775376291
- id: 1703371
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161514954
- updated: 2026-04-05 03:08:15
-
Version 1702236
- created: 2026-04-04 03:09:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-04/1775289773'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-04/1775289773
- id: 1702236
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161460527
- updated: 2026-04-04 03:09:23
-
Version 1701007
- created: 2026-04-03 03:12:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workordercategoryset`\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_WorkOrderCategorySet/2026-04-03/1775203540'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderCategorySet/2026-04-03/1775203540
- id: 1701007
- processed: 1
- raw_data:
{ "Id": 0, "MarinaLocation_Id": 2, "Name": 1 } - schema_attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1809
- schema_scan_id: 161401981
- updated: 2026-04-03 03:12:40
Schema Scans: 15
Last at 2026-04-17 03:08:08
-
Scan 162167717
- duration: 0:00:14.116058
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167717
- 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_WorkOrderCategorySet/2026-04-17/1776413127", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-17/1776413127/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12231577232177796312, "service_name": "drive-thru", "span_id": 9086503637191375865, "trace_id": 10983510013790516454 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-17 03:08:08
- success: True
- trace_id: 10983510013790516454
-
Scan 162111888
- duration: 0:00:14.074502
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111888
- 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_WorkOrderCategorySet/2026-04-16/1776326731", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-16/1776326731/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5935380076450780660, "service_name": "drive-thru", "span_id": 8829191007975883215, "trace_id": 8154935546566529768 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-16 03:09:46
- success: True
- trace_id: 8154935546566529768
-
Scan 162056044
- duration: 0:00:14.089404
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056044
- 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_WorkOrderCategorySet/2026-04-15/1776240198", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-15/1776240198/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10373809809594330709, "service_name": "drive-thru", "span_id": 18150919580428305010, "trace_id": 1113065349304709268 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-15 03:08:19
- success: True
- trace_id: 1113065349304709268
-
Scan 162000707
- duration: 0:00:13.954381
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000707
- 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_WorkOrderCategorySet/2026-04-14/1776154164", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-14/1776154164/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15896169601347434440, "service_name": "drive-thru", "span_id": 82131990067663755, "trace_id": 16798716887226372376 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-14 03:12:28
- success: True
- trace_id: 16798716887226372376
-
Scan 161942561
- duration: 0:00:14.090446
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942561
- 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_WorkOrderCategorySet/2026-04-13/1776067158", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-13/1776067158/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6829484551056737326, "service_name": "drive-thru", "span_id": 2350714668369276851, "trace_id": 2459504278022725400 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-13 03:03:19
- success: True
- trace_id: 2459504278022725400
-
Scan 161893375
- duration: 0:00:11.483089
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893375
- 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_WorkOrderCategorySet/2026-04-12/1775980859", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-12/1775980859/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18378856452969971109, "service_name": "drive-thru", "span_id": 12832557847828541935, "trace_id": 11288656522845964470 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-12 03:06:12
- success: True
- trace_id: 11288656522845964470
-
Scan 161841384
- duration: 0:00:11.596986
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841384
- 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_WorkOrderCategorySet/2026-04-11/1775894627", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-11/1775894627/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3039019882588854422, "service_name": "drive-thru", "span_id": 17155249223122960004, "trace_id": 1494872828688526208 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-11 03:11:39
- success: True
- trace_id: 1494872828688526208
-
Scan 161786012
- duration: 0:00:11.696524
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786012
- 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_WorkOrderCategorySet/2026-04-10/1775808388", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-10/1775808388/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9204113177148852695, "service_name": "drive-thru", "span_id": 1461153112373866034, "trace_id": 13936931045005921811 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-10 03:08:45
- success: True
- trace_id: 13936931045005921811
-
Scan 161730516
- duration: 0:00:14.053743
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730516
- 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_WorkOrderCategorySet/2026-04-09/1775721717", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-09/1775721717/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14973278171387044680, "service_name": "drive-thru", "span_id": 721256633573350255, "trace_id": 13618913343403035110 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-09 03:08:58
- success: True
- trace_id: 13618913343403035110
-
Scan 161675548
- duration: 0:00:11.644084
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675548
- 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_WorkOrderCategorySet/2026-04-08/1775635549", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-08/1775635549/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18352778011648825835, "service_name": "drive-thru", "span_id": 13209368184981461350, "trace_id": 11829954360301228202 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-08 03:06:10
- success: True
- trace_id: 11829954360301228202
-
Scan 161619273
- duration: 0:00:14.100700
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619273
- 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_WorkOrderCategorySet/2026-04-07/1775548710", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-07/1775548710/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18212919096922362547, "service_name": "drive-thru", "span_id": 11374605636204528671, "trace_id": 8405076957088213271 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-07 03:02:38
- success: True
- trace_id: 8405076957088213271
-
Scan 161561804
- duration: 0:00:11.594759
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561804
- 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_WorkOrderCategorySet/2026-04-06/1775462660", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-06/1775462660/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10070033872808201354, "service_name": "drive-thru", "span_id": 10423439781159551615, "trace_id": 3316931956322532589 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-06 03:12:14
- success: True
- trace_id: 3316931956322532589
-
Scan 161514954
- duration: 0:00:14.091573
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514954
- 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_WorkOrderCategorySet/2026-04-05/1775376291", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-05/1775376291/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1263358452838930648, "service_name": "drive-thru", "span_id": 14739489322961743575, "trace_id": 7582252191519737641 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-05 03:08:01
- success: True
- trace_id: 7582252191519737641
-
Scan 161460527
- duration: 0:00:11.666307
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460527
- 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_WorkOrderCategorySet/2026-04-04/1775289773", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-04/1775289773/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17946685582440562147, "service_name": "drive-thru", "span_id": 423531570942126594, "trace_id": 1306552518195776196 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-04 03:09:12
- success: True
- trace_id: 1306552518195776196
-
Scan 161401981
- duration: 0:00:11.768539
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401981
- 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_WorkOrderCategorySet/2026-04-03/1775203540", "key": "raw/molo_moloSV_WorkOrderCategorySet/2026-04-03/1775203540/SV_WorkOrderCategorySet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderCategorySet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4525029924076456222, "service_name": "drive-thru", "span_id": 13215605529191533777, "trace_id": 8299262957961602079 } } - running: False
- schema_name_id: 1809
- start_time: 2026-04-03 03:12:29
- success: True
- trace_id: 8299262957961602079
- attributes:
{ "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - created: 2026-04-17 03:08:09
- 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_workordercategoryset`\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_WorkOrderCategorySet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset" }
- 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:59",
"disabled": false,
"format": "raw",
"id": 1809,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molosv_workordercategoryset"
},
"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:08:09",
"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_workordercategoryset`\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_WorkOrderCategorySet/2026-04-17/1776413127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workordercategoryset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workordercategoryset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}