Schema Info
Schema Name: sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate
- created: 2023-10-17 01:58:51
- disabled: False
- format: raw
- id: 1699
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molosv_equipmentsv_estimate" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717708
- created: 2026-04-17 03:07:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-17/1776412997'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-17/1776412997
- id: 1717708
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 162167708
- updated: 2026-04-17 03:08:02
-
Version 1716478
- created: 2026-04-16 03:10:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-16/1776326696'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-16/1776326696
- id: 1716478
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 162111917
- updated: 2026-04-16 03:10:56
-
Version 1715339
- created: 2026-04-15 03:10:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-15/1776240185'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-15/1776240185
- id: 1715339
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 162056131
- updated: 2026-04-15 03:11:09
-
Version 1714113
- created: 2026-04-14 03:09:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-14/1776154138'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-14/1776154138
- id: 1714113
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 162000626
- updated: 2026-04-14 03:10:02
-
Version 1712914
- created: 2026-04-13 03:04:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-13/1776067134'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-13/1776067134
- id: 1712914
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161942617
- updated: 2026-04-13 03:04:27
-
Version 1711709
- created: 2026-04-12 03:06:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-12/1775980828'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-12/1775980828
- id: 1711709
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161893370
- updated: 2026-04-12 03:06:17
-
Version 1710559
- created: 2026-04-11 03:10:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-11/1775894599'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-11/1775894599
- id: 1710559
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161841367
- updated: 2026-04-11 03:11:07
-
Version 1709281
- created: 2026-04-10 03:07:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-10/1775808361'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-10/1775808361
- id: 1709281
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161785976
- updated: 2026-04-10 03:07:44
-
Version 1708240
- created: 2026-04-09 03:08:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-09/1775721688'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-09/1775721688
- id: 1708240
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161730507
- updated: 2026-04-09 03:08:47
-
Version 1706934
- created: 2026-04-08 03:06:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-08/1775635523'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-08/1775635523
- id: 1706934
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161675573
- updated: 2026-04-08 03:07:05
-
Version 1705850
- created: 2026-04-07 03:03:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-07/1775548686'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-07/1775548686
- id: 1705850
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161619350
- updated: 2026-04-07 03:03:37
-
Version 1704638
- created: 2026-04-06 03:11:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-06/1775462636'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-06/1775462636
- id: 1704638
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161561787
- updated: 2026-04-06 03:11:49
-
Version 1703425
- created: 2026-04-05 03:10:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-05/1775376268'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-05/1775376268
- id: 1703425
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161515013
- updated: 2026-04-05 03:10:13
-
Version 1702270
- created: 2026-04-04 03:10:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-04/1775289748'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-04/1775289748
- id: 1702270
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161460577
- updated: 2026-04-04 03:10:43
-
Version 1700876
- created: 2026-04-03 03:07:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-03/1775203515'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_EquipmentSV_Estimate/2026-04-03/1775203515
- id: 1700876
- processed: 1
- raw_data:
{ "SV_Equipment_Id": 0, "SV_Estimate_Id": 1 } - schema_attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - schema_name_id: 1699
- schema_scan_id: 161401804
- updated: 2026-04-03 03:07:14
Schema Scans: 15
Last at 2026-04-17 03:07:48
-
Scan 162167708
- duration: 0:00:14.101291
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167708
- 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_EquipmentSV_Estimate/2026-04-17/1776412997", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-17/1776412997/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17115688815086840625, "service_name": "drive-thru", "span_id": 2494840388302074167, "trace_id": 16178329829075923653 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-17 03:07:48
- success: True
- trace_id: 16178329829075923653
-
Scan 162111917
- duration: 0:00:14.080616
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111917
- 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_EquipmentSV_Estimate/2026-04-16/1776326696", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-16/1776326696/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5665423197773931142, "service_name": "drive-thru", "span_id": 9335945981901327656, "trace_id": 13069976382485685798 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-16 03:10:42
- success: True
- trace_id: 13069976382485685798
-
Scan 162056131
- duration: 0:00:11.543501
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056131
- 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_EquipmentSV_Estimate/2026-04-15/1776240185", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-15/1776240185/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16813466006622570466, "service_name": "drive-thru", "span_id": 16269595652839885268, "trace_id": 8687254216344749465 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-15 03:10:58
- success: True
- trace_id: 8687254216344749465
-
Scan 162000626
- duration: 0:00:11.547578
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000626
- 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_EquipmentSV_Estimate/2026-04-14/1776154138", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-14/1776154138/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16637141755234738576, "service_name": "drive-thru", "span_id": 5158787041897758909, "trace_id": 15522120142740393299 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-14 03:09:50
- success: True
- trace_id: 15522120142740393299
-
Scan 161942617
- duration: 0:00:14.046904
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942617
- 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_EquipmentSV_Estimate/2026-04-13/1776067134", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-13/1776067134/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10331307438222913729, "service_name": "drive-thru", "span_id": 11001978082715803423, "trace_id": 7193960872469028781 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-13 03:04:13
- success: True
- trace_id: 7193960872469028781
-
Scan 161893370
- duration: 0:00:14.048669
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893370
- 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_EquipmentSV_Estimate/2026-04-12/1775980828", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-12/1775980828/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12256755662616878578, "service_name": "drive-thru", "span_id": 14724090575412213645, "trace_id": 11169072794156540560 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-12 03:06:03
- success: True
- trace_id: 11169072794156540560
-
Scan 161841367
- duration: 0:00:11.524114
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841367
- 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_EquipmentSV_Estimate/2026-04-11/1775894599", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-11/1775894599/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12114069272488304411, "service_name": "drive-thru", "span_id": 8891000062511834949, "trace_id": 2605703718562049749 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-11 03:10:55
- success: True
- trace_id: 2605703718562049749
-
Scan 161785976
- duration: 0:00:14.005257
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785976
- 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_EquipmentSV_Estimate/2026-04-10/1775808361", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-10/1775808361/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15702311217078823731, "service_name": "drive-thru", "span_id": 17985912832475442030, "trace_id": 7752175745748502284 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-10 03:07:30
- success: True
- trace_id: 7752175745748502284
-
Scan 161730507
- duration: 0:00:11.629596
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730507
- 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_EquipmentSV_Estimate/2026-04-09/1775721688", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-09/1775721688/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17647577924658130756, "service_name": "drive-thru", "span_id": 11858655859985958771, "trace_id": 15580478406185160522 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-09 03:08:36
- success: True
- trace_id: 15580478406185160522
-
Scan 161675573
- duration: 0:00:14.180965
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675573
- 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_EquipmentSV_Estimate/2026-04-08/1775635523", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-08/1775635523/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14956042271583392634, "service_name": "drive-thru", "span_id": 2623452687640138224, "trace_id": 1210261203637858611 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-08 03:06:51
- success: True
- trace_id: 1210261203637858611
-
Scan 161619350
- duration: 0:00:11.521938
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619350
- 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_EquipmentSV_Estimate/2026-04-07/1775548686", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-07/1775548686/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11957709430067702005, "service_name": "drive-thru", "span_id": 9193433992430789000, "trace_id": 14254331953990583941 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-07 03:03:25
- success: True
- trace_id: 14254331953990583941
-
Scan 161561787
- duration: 0:00:14.089712
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561787
- 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_EquipmentSV_Estimate/2026-04-06/1775462636", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-06/1775462636/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9041347304667059403, "service_name": "drive-thru", "span_id": 11242888668591823598, "trace_id": 13767712972089213853 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-06 03:11:35
- success: True
- trace_id: 13767712972089213853
-
Scan 161515013
- duration: 0:00:11.518961
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161515013
- 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_EquipmentSV_Estimate/2026-04-05/1775376268", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-05/1775376268/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9161758976576984735, "service_name": "drive-thru", "span_id": 310491039287997415, "trace_id": 7577715249042324495 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-05 03:10:02
- success: True
- trace_id: 7577715249042324495
-
Scan 161460577
- duration: 0:00:11.678241
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460577
- 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_EquipmentSV_Estimate/2026-04-04/1775289748", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-04/1775289748/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9900457494089019405, "service_name": "drive-thru", "span_id": 9044798089205190867, "trace_id": 10694309476562287911 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-04 03:10:31
- success: True
- trace_id: 10694309476562287911
-
Scan 161401804
- duration: 0:00:11.523427
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401804
- 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_EquipmentSV_Estimate/2026-04-03/1775203515", "key": "raw/molo_moloSV_EquipmentSV_Estimate/2026-04-03/1775203515/SV_EquipmentSV_Estimate.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSV_EquipmentSV_Estimate", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16278791645006555984, "service_name": "drive-thru", "span_id": 676386902849902683, "trace_id": 15693974080841824247 } } - running: False
- schema_name_id: 1699
- start_time: 2026-04-03 03:07:03
- success: True
- trace_id: 15693974080841824247
- attributes:
{ "SV_Equipment_Id": "string", "SV_Estimate_Id": "string" } - created: 2026-04-17 03:07:49
- 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_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-17/1776412997'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate" }
- 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:58:51",
"disabled": false,
"format": "raw",
"id": 1699,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molosv_equipmentsv_estimate"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"SV_Equipment_Id": "string",
"SV_Estimate_Id": "string"
},
"created": "2026-04-17 03:07:49",
"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_equipmentsv_estimate`\n(\n `SV_Equipment_Id` string , `SV_Estimate_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_EquipmentSV_Estimate/2026-04-17/1776412997'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_equipmentsv_estimate"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}