Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloequipmentboatset
- created: 2023-10-17 01:55:31
- disabled: False
- format: raw
- id: 1604
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloequipmentboatset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717599
- created: 2026-04-17 03:02:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-17/1776412729
- id: 1717599
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 162167359
- updated: 2026-04-17 03:02:13
-
Version 1716387
- created: 2026-04-16 03:07:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-16/1776326487'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-16/1776326487
- id: 1716387
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 162111807
- updated: 2026-04-16 03:07:33
-
Version 1715182
- created: 2026-04-15 03:03:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-15/1776239957'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-15/1776239957
- id: 1715182
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 162055863
- updated: 2026-04-15 03:03:52
-
Version 1713956
- created: 2026-04-14 03:03:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-14/1776153682'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-14/1776153682
- id: 1713956
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 162000382
- updated: 2026-04-14 03:03:30
-
Version 1712739
- created: 2026-04-13 02:56:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-13/1776066877'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-13/1776066877
- id: 1712739
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161941523
- updated: 2026-04-13 02:56:46
-
Version 1711546
- created: 2026-04-12 02:58:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-12/1775980591'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-12/1775980591
- id: 1711546
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161892395
- updated: 2026-04-12 02:59:00
-
Version 1710400
- created: 2026-04-11 03:04:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-11/1775894352'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-11/1775894352
- id: 1710400
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161841168
- updated: 2026-04-11 03:04:46
-
Version 1709299
- created: 2026-04-10 03:08:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-10/1775808107'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-10/1775808107
- id: 1709299
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161785994
- updated: 2026-04-10 03:08:20
-
Version 1708041
- created: 2026-04-09 02:59:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-09/1775721446'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-09/1775721446
- id: 1708041
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161729884
- updated: 2026-04-09 03:00:09
-
Version 1706907
- created: 2026-04-08 03:05:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-08/1775635255'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-08/1775635255
- id: 1706907
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161675528
- updated: 2026-04-08 03:05:56
-
Version 1705647
- created: 2026-04-07 02:54:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-07/1775548427'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-07/1775548427
- id: 1705647
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161618325
- updated: 2026-04-07 02:55:06
-
Version 1704425
- created: 2026-04-06 03:02:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-06/1775462395'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-06/1775462395
- id: 1704425
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161561439
- updated: 2026-04-06 03:02:52
-
Version 1703200
- created: 2026-04-05 03:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-05/1775376018'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-05/1775376018
- id: 1703200
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161514757
- updated: 2026-04-05 03:01:18
-
Version 1702080
- created: 2026-04-04 03:01:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-04/1775289502'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-04/1775289502
- id: 1702080
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161460000
- updated: 2026-04-04 03:02:01
-
Version 1700985
- created: 2026-04-03 03:11:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-03/1775203276'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEquipmentBoatSet/2026-04-03/1775203276
- id: 1700985
- processed: 1
- raw_data:
{ "BoatId": 2, "EquipmentId": 1, "Id": 0, "RecordStatus_Id": 3 } - schema_attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - schema_name_id: 1604
- schema_scan_id: 161401957
- updated: 2026-04-03 03:11:48
Schema Scans: 15
Last at 2026-04-17 03:02:02
-
Scan 162167359
- duration: 0:00:11.796340
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167359
- 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_moloEquipmentBoatSet/2026-04-17/1776412729", "key": "raw/molo_moloEquipmentBoatSet/2026-04-17/1776412729/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15078833799705354027, "service_name": "drive-thru", "span_id": 11292775802585348684, "trace_id": 230082755587858591 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-17 03:02:02
- success: True
- trace_id: 230082755587858591
-
Scan 162111807
- duration: 0:00:14.339069
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111807
- 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_moloEquipmentBoatSet/2026-04-16/1776326487", "key": "raw/molo_moloEquipmentBoatSet/2026-04-16/1776326487/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3753665792497032668, "service_name": "drive-thru", "span_id": 9762765512586623634, "trace_id": 1008569682934558628 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-16 03:07:18
- success: True
- trace_id: 1008569682934558628
-
Scan 162055863
- duration: 0:00:11.692875
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055863
- 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_moloEquipmentBoatSet/2026-04-15/1776239957", "key": "raw/molo_moloEquipmentBoatSet/2026-04-15/1776239957/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13194622732579226402, "service_name": "drive-thru", "span_id": 11284746212974779089, "trace_id": 10908233533244970043 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-15 03:03:41
- success: True
- trace_id: 10908233533244970043
-
Scan 162000382
- duration: 0:00:11.715325
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000382
- 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_moloEquipmentBoatSet/2026-04-14/1776153682", "key": "raw/molo_moloEquipmentBoatSet/2026-04-14/1776153682/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17294999733441407021, "service_name": "drive-thru", "span_id": 13754423855234513577, "trace_id": 12406892862960980983 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-14 03:03:19
- success: True
- trace_id: 12406892862960980983
-
Scan 161941523
- duration: 0:00:11.643311
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941523
- 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_moloEquipmentBoatSet/2026-04-13/1776066877", "key": "raw/molo_moloEquipmentBoatSet/2026-04-13/1776066877/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17941528620336087204, "service_name": "drive-thru", "span_id": 113243652607062961, "trace_id": 1002379293744650507 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-13 02:56:34
- success: True
- trace_id: 1002379293744650507
-
Scan 161892395
- duration: 0:00:11.611969
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892395
- 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_moloEquipmentBoatSet/2026-04-12/1775980591", "key": "raw/molo_moloEquipmentBoatSet/2026-04-12/1775980591/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11719357477563894421, "service_name": "drive-thru", "span_id": 16063667627982237244, "trace_id": 14954350148161477647 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-12 02:58:49
- success: True
- trace_id: 14954350148161477647
-
Scan 161841168
- duration: 0:00:14.305035
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841168
- 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_moloEquipmentBoatSet/2026-04-11/1775894352", "key": "raw/molo_moloEquipmentBoatSet/2026-04-11/1775894352/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15542022244169433945, "service_name": "drive-thru", "span_id": 13231818506044692647, "trace_id": 14475880040821209706 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-11 03:04:32
- success: True
- trace_id: 14475880040821209706
-
Scan 161785994
- duration: 0:00:14.208080
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785994
- 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_moloEquipmentBoatSet/2026-04-10/1775808107", "key": "raw/molo_moloEquipmentBoatSet/2026-04-10/1775808107/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2781173065244481787, "service_name": "drive-thru", "span_id": 12710537008616103682, "trace_id": 8074725071646622884 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-10 03:08:06
- success: True
- trace_id: 8074725071646622884
-
Scan 161729884
- duration: 0:00:11.780743
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161729884
- 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_moloEquipmentBoatSet/2026-04-09/1775721446", "key": "raw/molo_moloEquipmentBoatSet/2026-04-09/1775721446/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13752001944959179456, "service_name": "drive-thru", "span_id": 8843407242946844498, "trace_id": 16116075222973346036 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-09 02:59:57
- success: True
- trace_id: 16116075222973346036
-
Scan 161675528
- duration: 0:00:14.352132
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675528
- 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_moloEquipmentBoatSet/2026-04-08/1775635255", "key": "raw/molo_moloEquipmentBoatSet/2026-04-08/1775635255/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13843203447286173135, "service_name": "drive-thru", "span_id": 2558515360769191595, "trace_id": 10718239204873311601 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-08 03:05:42
- success: True
- trace_id: 10718239204873311601
-
Scan 161618325
- duration: 0:00:14.116787
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618325
- 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_moloEquipmentBoatSet/2026-04-07/1775548427", "key": "raw/molo_moloEquipmentBoatSet/2026-04-07/1775548427/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4043908980424132606, "service_name": "drive-thru", "span_id": 6134149621499366234, "trace_id": 10859917820835683778 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-07 02:54:51
- success: True
- trace_id: 10859917820835683778
-
Scan 161561439
- duration: 0:00:14.162975
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561439
- 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_moloEquipmentBoatSet/2026-04-06/1775462395", "key": "raw/molo_moloEquipmentBoatSet/2026-04-06/1775462395/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7210842442007690373, "service_name": "drive-thru", "span_id": 54907574482279516, "trace_id": 14433630496456519656 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-06 03:02:38
- success: True
- trace_id: 14433630496456519656
-
Scan 161514757
- duration: 0:00:14.167378
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514757
- 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_moloEquipmentBoatSet/2026-04-05/1775376018", "key": "raw/molo_moloEquipmentBoatSet/2026-04-05/1775376018/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6307170541920406361, "service_name": "drive-thru", "span_id": 14568774234330909612, "trace_id": 18007083372003157897 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-05 03:01:03
- success: True
- trace_id: 18007083372003157897
-
Scan 161460000
- duration: 0:00:11.657851
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460000
- 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_moloEquipmentBoatSet/2026-04-04/1775289502", "key": "raw/molo_moloEquipmentBoatSet/2026-04-04/1775289502/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6039529183288799531, "service_name": "drive-thru", "span_id": 4800864472273921637, "trace_id": 6128680173460372006 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-04 03:01:50
- success: True
- trace_id: 6128680173460372006
-
Scan 161401957
- duration: 0:00:14.173691
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401957
- 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_moloEquipmentBoatSet/2026-04-03/1775203276", "key": "raw/molo_moloEquipmentBoatSet/2026-04-03/1775203276/EquipmentBoatSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEquipmentBoatSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17979168079374402143, "service_name": "drive-thru", "span_id": 3186343970746032634, "trace_id": 5134786699671559743 } } - running: False
- schema_name_id: 1604
- start_time: 2026-04-03 03:11:34
- success: True
- trace_id: 5134786699671559743
- attributes:
{ "BoatId": "string", "EquipmentId": "string", "Id": "string", "RecordStatus_Id": "string" } - created: 2026-04-17 03:02:02
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset" }
- 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 01:55:31",
"disabled": false,
"format": "raw",
"id": 1604,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloequipmentboatset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"BoatId": "string",
"EquipmentId": "string",
"Id": "string",
"RecordStatus_Id": "string"
},
"created": "2026-04-17 03:02:02",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloequipmentboatset`\n(\n `Id` string , `EquipmentId` string , `BoatId` string , `RecordStatus_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_moloEquipmentBoatSet/2026-04-17/1776412729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloequipmentboatset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloequipmentboatset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}