Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_workorderlocationset

created: 2023-10-17 02:00:46
disabled: False
format: raw
id: 1754
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717718

created: 2026-04-17 03:08:13

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 162167718
updated: 2026-04-17 03:08:24

Version 1716577

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-16/1776326732'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-16/1776326732
id: 1716577
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 162112040
updated: 2026-04-16 03:14:45

Version 1715289

created: 2026-04-15 03:08:21

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 162056047
updated: 2026-04-15 03:08:33

Version 1714166

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-14/1776154165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-14/1776154165
id: 1714166
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 162000689
updated: 2026-04-14 03:12:02

Version 1712929

created: 2026-04-13 03:05:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-13/1776067159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-13/1776067159
id: 1712929
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161942688
updated: 2026-04-13 03:05:15

Version 1711720

created: 2026-04-12 03:06:35

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161893388
updated: 2026-04-12 03:06:46

Version 1710463

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

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161841252
updated: 2026-04-11 03:07:14

Version 1709306

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-10/1775808389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-10/1775808389
id: 1709306
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161786002
updated: 2026-04-10 03:08:42

Version 1708212

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-09/1775721719'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-09/1775721719
id: 1708212
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161730461
updated: 2026-04-09 03:07:36

Version 1707050

created: 2026-04-08 03:11:38

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161675718
updated: 2026-04-08 03:11:52

Version 1705876

created: 2026-04-07 03:04:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-07/1775548711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-07/1775548711
id: 1705876
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161619455
updated: 2026-04-07 03:05:05

Version 1704657

created: 2026-04-06 03:12:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-06/1775462661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-06/1775462661
id: 1704657
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161561809
updated: 2026-04-06 03:12:32

Version 1703347

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-05/1775376292'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderLocationSet/2026-04-05/1775376292
id: 1703347
processed: 1

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161514928
updated: 2026-04-05 03:07:20

Version 1702298

created: 2026-04-04 03:12:02

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161460627
updated: 2026-04-04 03:12:16

Version 1701000

created: 2026-04-03 03:12:14

ddl:

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

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

raw_data:

{
    "Default": 3,
    "Id": 0,
    "MarinaLocation_Id": 2,
    "Name": 1
}

schema_attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

schema_name_id: 1754
schema_scan_id: 161401973
updated: 2026-04-03 03:12:28

Schema Scans: 15

Last at 2026-04-17 03:08:13

Scan 162167718

duration: 0:00:11.545242

exit_message:

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

id: 162167718

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_WorkOrderLocationSet/2026-04-17/1776413128",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-17/1776413128/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16019077051988829583,
        "service_name": "drive-thru",
        "span_id": 9855543519034614544,
        "trace_id": 286527754745163605
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-17 03:08:13
success: True
trace_id: 286527754745163605

Scan 162112040

duration: 0:00:14.230923

exit_message:

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

id: 162112040

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_WorkOrderLocationSet/2026-04-16/1776326732",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-16/1776326732/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4680483559428840482,
        "service_name": "drive-thru",
        "span_id": 6634496376477928652,
        "trace_id": 8306578229539906856
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-16 03:14:31
success: True
trace_id: 8306578229539906856

Scan 162056047

duration: 0:00:11.565336

exit_message:

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

id: 162056047

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_WorkOrderLocationSet/2026-04-15/1776240198",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-15/1776240198/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4679455411017119163,
        "service_name": "drive-thru",
        "span_id": 428829036521770019,
        "trace_id": 8907989568024720479
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-15 03:08:21
success: True
trace_id: 8907989568024720479

Scan 162000689

duration: 0:00:11.593748

exit_message:

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

id: 162000689

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_WorkOrderLocationSet/2026-04-14/1776154165",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-14/1776154165/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16394746868794883517,
        "service_name": "drive-thru",
        "span_id": 13467099884501428851,
        "trace_id": 904913023179494182
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-14 03:11:50
success: True
trace_id: 904913023179494182

Scan 161942688

duration: 0:00:11.609993

exit_message:

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

id: 161942688

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_WorkOrderLocationSet/2026-04-13/1776067159",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-13/1776067159/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8400614216365850841,
        "service_name": "drive-thru",
        "span_id": 16756272067558639540,
        "trace_id": 347998826513674950
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-13 03:05:04
success: True
trace_id: 347998826513674950

Scan 161893388

duration: 0:00:11.520432

exit_message:

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

id: 161893388

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_WorkOrderLocationSet/2026-04-12/1775980859",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-12/1775980859/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1538482420062634343,
        "service_name": "drive-thru",
        "span_id": 16520861297098670524,
        "trace_id": 13728989402022697250
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-12 03:06:35
success: True
trace_id: 13728989402022697250

Scan 161841252

duration: 0:00:14.181520

exit_message:

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

id: 161841252

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_WorkOrderLocationSet/2026-04-11/1775894627",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-11/1775894627/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14565841891679545202,
        "service_name": "drive-thru",
        "span_id": 15689456904130595841,
        "trace_id": 16804007510488782973
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-11 03:06:59
success: True
trace_id: 16804007510488782973

Scan 161786002

duration: 0:00:14.223044

exit_message:

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

id: 161786002

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_WorkOrderLocationSet/2026-04-10/1775808389",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-10/1775808389/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15491610152963821565,
        "service_name": "drive-thru",
        "span_id": 6231734321873781550,
        "trace_id": 14471155031129095895
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-10 03:08:28
success: True
trace_id: 14471155031129095895

Scan 161730461

duration: 0:00:11.747017

exit_message:

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

id: 161730461

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_WorkOrderLocationSet/2026-04-09/1775721719",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-09/1775721719/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17799960020375839061,
        "service_name": "drive-thru",
        "span_id": 12114438719154593671,
        "trace_id": 3720852214635468908
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-09 03:07:25
success: True
trace_id: 3720852214635468908

Scan 161675718

duration: 0:00:14.237393

exit_message:

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

id: 161675718

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_WorkOrderLocationSet/2026-04-08/1775635549",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-08/1775635549/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13387531226480242287,
        "service_name": "drive-thru",
        "span_id": 134328263078193539,
        "trace_id": 15954199405078860081
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-08 03:11:37
success: True
trace_id: 15954199405078860081

Scan 161619455

duration: 0:00:11.604695

exit_message:

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

id: 161619455

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_WorkOrderLocationSet/2026-04-07/1775548711",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-07/1775548711/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1967717310049314158,
        "service_name": "drive-thru",
        "span_id": 4705540284709300078,
        "trace_id": 8275572281421595597
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-07 03:04:53
success: True
trace_id: 8275572281421595597

Scan 161561809

duration: 0:00:11.662735

exit_message:

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

id: 161561809

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_WorkOrderLocationSet/2026-04-06/1775462661",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-06/1775462661/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3149228226970037932,
        "service_name": "drive-thru",
        "span_id": 496222808700333816,
        "trace_id": 5228965958019091030
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-06 03:12:20
success: True
trace_id: 5228965958019091030

Scan 161514928

duration: 0:00:14.188917

exit_message:

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

id: 161514928

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_WorkOrderLocationSet/2026-04-05/1775376292",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-05/1775376292/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13644677199133531086,
        "service_name": "drive-thru",
        "span_id": 16967388666108797447,
        "trace_id": 15833938529007080816
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-05 03:07:05
success: True
trace_id: 15833938529007080816

Scan 161460627

duration: 0:00:14.161154

exit_message:

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

id: 161460627

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_WorkOrderLocationSet/2026-04-04/1775289774",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-04/1775289774/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9037809738840556609,
        "service_name": "drive-thru",
        "span_id": 16857373862106657452,
        "trace_id": 5267847779397586941
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-04 03:12:01
success: True
trace_id: 5267847779397586941

Scan 161401973

duration: 0:00:14.152672

exit_message:

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

id: 161401973

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_WorkOrderLocationSet/2026-04-03/1775203540",
        "key": "raw/molo_moloSV_WorkOrderLocationSet/2026-04-03/1775203540/SV_WorkOrderLocationSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderLocationSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4776020804451717042,
        "service_name": "drive-thru",
        "span_id": 10833077866517680588,
        "trace_id": 10150350993001718628
    }
}

running: False
schema_name_id: 1754
start_time: 2026-04-03 03:12:14
success: True
trace_id: 10150350993001718628

Partitions:

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

Schema:

attributes:

{
    "Default": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "Name": "string"
}

created: 2026-04-17 03:08:13

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_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-17/1776413128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
}

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 02:00:46",
        "disabled": false,
        "format": "raw",
        "id": 1754,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_workorderlocationset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Default": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "Name": "string"
        },
        "created": "2026-04-17 03:08:13",
        "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_workorderlocationset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  string , `Default`  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_WorkOrderLocationSet/2026-04-17/1776413128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderlocationset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderlocationset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}