Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_workorderequipment

created: 2023-10-17 01:59:55
disabled: False
format: raw
id: 1730
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717780

created: 2026-04-17 03:10:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-17/1776413128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-17/1776413128
id: 1717780
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 162167806
updated: 2026-04-17 03:11:06

Version 1716543

created: 2026-04-16 03:13:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-16/1776326731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-16/1776326731
id: 1716543
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 162111996
updated: 2026-04-16 03:13:25

Version 1715332

created: 2026-04-15 03:10:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-15/1776240198'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-15/1776240198
id: 1715332
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 162056124
updated: 2026-04-15 03:10:47

Version 1714162

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-14/1776154164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-14/1776154164
id: 1714162
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 162000684
updated: 2026-04-14 03:11:58

Version 1712895

created: 2026-04-13 03:03:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-13/1776067160'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-13/1776067160
id: 1712895
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161942577
updated: 2026-04-13 03:03:42

Version 1711777

created: 2026-04-12 03:09:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-12/1775980859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-12/1775980859
id: 1711777
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161893510
updated: 2026-04-12 03:09:40

Version 1710519

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-11/1775894627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-11/1775894627
id: 1710519
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161841310
updated: 2026-04-11 03:09:21

Version 1709307

created: 2026-04-10 03:08:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-10/1775808388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-10/1775808388
id: 1709307
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161786004
updated: 2026-04-10 03:08:43

Version 1708277

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-09/1775721718'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-09/1775721718
id: 1708277
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161730571
updated: 2026-04-09 03:10:27

Version 1707025

created: 2026-04-08 03:10:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-08/1775635549'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-08/1775635549
id: 1707025
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161675690
updated: 2026-04-08 03:10:37

Version 1705878

created: 2026-04-07 03:05:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-07/1775548710'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-07/1775548710
id: 1705878
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161619464
updated: 2026-04-07 03:05:15

Version 1704642

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-06/1775462660'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-06/1775462660
id: 1704642
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161561791
updated: 2026-04-06 03:11:58

Version 1703373

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_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-05/1775376291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-05/1775376291
id: 1703373
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161514956
updated: 2026-04-05 03:08:16

Version 1702249

created: 2026-04-04 03:09:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-04/1775289774'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-04/1775289774
id: 1702249
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161460547
updated: 2026-04-04 03:09:52

Version 1701004

created: 2026-04-03 03:12:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-03/1775203540'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderEquipment/2026-04-03/1775203540
id: 1701004
processed: 1

raw_data:

{
    "Equipment_Id": 1,
    "SV_WorkOrder_Id": 0
}

schema_attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

schema_name_id: 1730
schema_scan_id: 161401978
updated: 2026-04-03 03:12:32

Schema Scans: 15

Last at 2026-04-17 03:10:52

Scan 162167806

duration: 0:00:14.188651

exit_message:

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

id: 162167806

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_WorkOrderEquipment/2026-04-17/1776413128",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-17/1776413128/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7933400137263892807,
        "service_name": "drive-thru",
        "span_id": 5256927345923883966,
        "trace_id": 5090623984169993831
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-17 03:10:52
success: True
trace_id: 5090623984169993831

Scan 162111996

duration: 0:00:11.718016

exit_message:

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

id: 162111996

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_WorkOrderEquipment/2026-04-16/1776326731",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-16/1776326731/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15224529436903938692,
        "service_name": "drive-thru",
        "span_id": 559354526705196974,
        "trace_id": 5721913931431743298
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-16 03:13:13
success: True
trace_id: 5721913931431743298

Scan 162056124

duration: 0:00:11.708609

exit_message:

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

id: 162056124

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_WorkOrderEquipment/2026-04-15/1776240198",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-15/1776240198/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15267618798596443526,
        "service_name": "drive-thru",
        "span_id": 4951068844272951774,
        "trace_id": 6542878738804223279
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-15 03:10:35
success: True
trace_id: 6542878738804223279

Scan 162000684

duration: 0:00:14.102201

exit_message:

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

id: 162000684

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_WorkOrderEquipment/2026-04-14/1776154164",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-14/1776154164/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 425921295410957639,
        "service_name": "drive-thru",
        "span_id": 13215130205852580912,
        "trace_id": 18405919446381788506
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-14 03:11:44
success: True
trace_id: 18405919446381788506

Scan 161942577

duration: 0:00:14.044956

exit_message:

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

id: 161942577

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_WorkOrderEquipment/2026-04-13/1776067160",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-13/1776067160/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15322167097417649639,
        "service_name": "drive-thru",
        "span_id": 6631420376136707119,
        "trace_id": 3719909464067771968
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-13 03:03:28
success: True
trace_id: 3719909464067771968

Scan 161893510

duration: 0:00:11.625183

exit_message:

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

id: 161893510

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_WorkOrderEquipment/2026-04-12/1775980859",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-12/1775980859/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1226565875330776901,
        "service_name": "drive-thru",
        "span_id": 8840491418919312299,
        "trace_id": 5104901495817687964
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-12 03:09:28
success: True
trace_id: 5104901495817687964

Scan 161841310

duration: 0:00:14.176384

exit_message:

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

id: 161841310

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_WorkOrderEquipment/2026-04-11/1775894627",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-11/1775894627/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2929718623944082433,
        "service_name": "drive-thru",
        "span_id": 14567965879084589239,
        "trace_id": 13323988263418419220
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-11 03:09:07
success: True
trace_id: 13323988263418419220

Scan 161786004

duration: 0:00:14.162668

exit_message:

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

id: 161786004

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_WorkOrderEquipment/2026-04-10/1775808388",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-10/1775808388/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11031253056508822971,
        "service_name": "drive-thru",
        "span_id": 1618439488961778505,
        "trace_id": 14961304876496171254
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-10 03:08:29
success: True
trace_id: 14961304876496171254

Scan 161730571

duration: 0:00:14.233819

exit_message:

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

id: 161730571

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_WorkOrderEquipment/2026-04-09/1775721718",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-09/1775721718/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13606329180935538937,
        "service_name": "drive-thru",
        "span_id": 5558737334780892538,
        "trace_id": 15504649193879458078
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-09 03:10:13
success: True
trace_id: 15504649193879458078

Scan 161675690

duration: 0:00:11.573274

exit_message:

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

id: 161675690

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_WorkOrderEquipment/2026-04-08/1775635549",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-08/1775635549/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3790593415482747004,
        "service_name": "drive-thru",
        "span_id": 7419889333156876483,
        "trace_id": 16297104760835060655
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-08 03:10:25
success: True
trace_id: 16297104760835060655

Scan 161619464

duration: 0:00:14.299457

exit_message:

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

id: 161619464

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_WorkOrderEquipment/2026-04-07/1775548710",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-07/1775548710/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5267825373177113166,
        "service_name": "drive-thru",
        "span_id": 4538675106456243570,
        "trace_id": 16342290026271337612
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-07 03:05:01
success: True
trace_id: 16342290026271337612

Scan 161561791

duration: 0:00:14.068757

exit_message:

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

id: 161561791

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_WorkOrderEquipment/2026-04-06/1775462660",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-06/1775462660/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17784504504680891171,
        "service_name": "drive-thru",
        "span_id": 17831463582992416393,
        "trace_id": 13097599219599966780
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-06 03:11:44
success: True
trace_id: 13097599219599966780

Scan 161514956

duration: 0:00:14.123413

exit_message:

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

id: 161514956

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_WorkOrderEquipment/2026-04-05/1775376291",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-05/1775376291/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1601394145059690500,
        "service_name": "drive-thru",
        "span_id": 5101603540908663997,
        "trace_id": 5674858887475851789
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-05 03:08:02
success: True
trace_id: 5674858887475851789

Scan 161460547

duration: 0:00:11.838332

exit_message:

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

id: 161460547

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_WorkOrderEquipment/2026-04-04/1775289774",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-04/1775289774/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10591109391138018261,
        "service_name": "drive-thru",
        "span_id": 1938140106319675069,
        "trace_id": 13168005878320911817
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-04 03:09:40
success: True
trace_id: 13168005878320911817

Scan 161401978

duration: 0:00:11.691711

exit_message:

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

id: 161401978

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_WorkOrderEquipment/2026-04-03/1775203540",
        "key": "raw/molo_moloSV_WorkOrderEquipment/2026-04-03/1775203540/SV_WorkOrderEquipment.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderEquipment",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17119729960622397842,
        "service_name": "drive-thru",
        "span_id": 11134537731310548067,
        "trace_id": 7437106154759395570
    }
}

running: False
schema_name_id: 1730
start_time: 2026-04-03 03:12:20
success: True
trace_id: 7437106154759395570

Partitions:

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

Schema:

attributes:

{
    "Equipment_Id": "string",
    "SV_WorkOrder_Id": "string"
}

created: 2026-04-17 03:10:52

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_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-17/1776413128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-10-17 01:59:55",
        "disabled": false,
        "format": "raw",
        "id": 1730,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_workorderequipment"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Equipment_Id": "string",
            "SV_WorkOrder_Id": "string"
        },
        "created": "2026-04-17 03:10:52",
        "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_workorderequipment`\n(\n `SV_WorkOrder_Id`  string , `Equipment_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_WorkOrderEquipment/2026-04-17/1776413128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderequipment`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderequipment"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}