Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_workorderstatusset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717721

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-17/1776413130
id: 1717721
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 162167721
updated: 2026-04-17 03:08:31

Version 1716557

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-16/1776326732
id: 1716557
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 162112016
updated: 2026-04-16 03:14:00

Version 1715386

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-15/1776240199
id: 1715386
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 162056194
updated: 2026-04-15 03:13:34

Version 1714188

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-14/1776154165
id: 1714188
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 162000712
updated: 2026-04-14 03:12:55

Version 1712898

created: 2026-04-13 03:03:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-13/1776067160
id: 1712898
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161942583
updated: 2026-04-13 03:03:47

Version 1711730

created: 2026-04-12 03:07:03

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-12/1775980860
id: 1711730
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161893416
updated: 2026-04-12 03:07:17

Version 1710460

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-11/1775894628
id: 1710460
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161841249
updated: 2026-04-11 03:07:05

Version 1709402

created: 2026-04-10 03:12:10

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-10/1775808389
id: 1709402
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161786106
updated: 2026-04-10 03:12:22

Version 1708210

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-09/1775721718
id: 1708210
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161730459
updated: 2026-04-09 03:07:34

Version 1707031

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-08/1775635549
id: 1707031
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161675695
updated: 2026-04-08 03:10:51

Version 1705833

created: 2026-04-07 03:02:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-07/1775548711
id: 1705833
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161619291
updated: 2026-04-07 03:02:56

Version 1704561

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-06/1775462662
id: 1704561
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161561678
updated: 2026-04-06 03:08:49

Version 1703384

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-05/1775376293
id: 1703384
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161514968
updated: 2026-04-05 03:08:41

Version 1702253

created: 2026-04-04 03:09:53

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-04/1775289775
id: 1702253
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161460552
updated: 2026-04-04 03:10:04

Version 1700918

created: 2026-04-03 03:08:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_WorkOrderStatusSet/2026-04-03/1775203541
id: 1700918
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

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

schema_name_id: 1733
schema_scan_id: 161401872
updated: 2026-04-03 03:09:13

Schema Scans: 15

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

Scan 162167721

duration: 0:00:14.061065

exit_message:

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

id: 162167721

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_WorkOrderStatusSet/2026-04-17/1776413130",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-17/1776413130/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2703784557907728525,
        "service_name": "drive-thru",
        "span_id": 13129267787617136213,
        "trace_id": 12209467145165094116
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-17 03:08:17
success: True
trace_id: 12209467145165094116

Scan 162112016

duration: 0:00:11.584597

exit_message:

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

id: 162112016

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_WorkOrderStatusSet/2026-04-16/1776326732",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-16/1776326732/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1602853791859915825,
        "service_name": "drive-thru",
        "span_id": 16105876208744221956,
        "trace_id": 3142946898336502499
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-16 03:13:48
success: True
trace_id: 3142946898336502499

Scan 162056194

duration: 0:00:14.084778

exit_message:

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

id: 162056194

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_WorkOrderStatusSet/2026-04-15/1776240199",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-15/1776240199/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12572125863468034264,
        "service_name": "drive-thru",
        "span_id": 15406832485059526607,
        "trace_id": 10302378258305713039
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-15 03:13:20
success: True
trace_id: 10302378258305713039

Scan 162000712

duration: 0:00:14.089329

exit_message:

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

id: 162000712

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_WorkOrderStatusSet/2026-04-14/1776154165",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-14/1776154165/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14580043484157515368,
        "service_name": "drive-thru",
        "span_id": 16108433733934548948,
        "trace_id": 1701758291635985945
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-14 03:12:41
success: True
trace_id: 1701758291635985945

Scan 161942583

duration: 0:00:11.533151

exit_message:

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

id: 161942583

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_WorkOrderStatusSet/2026-04-13/1776067160",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-13/1776067160/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16387235494365919345,
        "service_name": "drive-thru",
        "span_id": 2055090466105080679,
        "trace_id": 12509851360612846292
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-13 03:03:35
success: True
trace_id: 12509851360612846292

Scan 161893416

duration: 0:00:14.041019

exit_message:

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

id: 161893416

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_WorkOrderStatusSet/2026-04-12/1775980860",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-12/1775980860/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14751337349185434159,
        "service_name": "drive-thru",
        "span_id": 8084097877905784644,
        "trace_id": 7889079765446466260
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-12 03:07:03
success: True
trace_id: 7889079765446466260

Scan 161841249

duration: 0:00:11.517216

exit_message:

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

id: 161841249

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_WorkOrderStatusSet/2026-04-11/1775894628",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-11/1775894628/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3116592704196766073,
        "service_name": "drive-thru",
        "span_id": 4869064260490902431,
        "trace_id": 18142321227890731628
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-11 03:06:54
success: True
trace_id: 18142321227890731628

Scan 161786106

duration: 0:00:11.698956

exit_message:

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

id: 161786106

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_WorkOrderStatusSet/2026-04-10/1775808389",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-10/1775808389/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14914378176917095309,
        "service_name": "drive-thru",
        "span_id": 6034696697722672488,
        "trace_id": 13527724480744218161
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-10 03:12:10
success: True
trace_id: 13527724480744218161

Scan 161730459

duration: 0:00:14.207858

exit_message:

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

id: 161730459

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_WorkOrderStatusSet/2026-04-09/1775721718",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-09/1775721718/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12278693336149683482,
        "service_name": "drive-thru",
        "span_id": 17503751622492885723,
        "trace_id": 3564895806432733940
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-09 03:07:20
success: True
trace_id: 3564895806432733940

Scan 161675695

duration: 0:00:14.077410

exit_message:

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

id: 161675695

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_WorkOrderStatusSet/2026-04-08/1775635549",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-08/1775635549/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8014200331692907880,
        "service_name": "drive-thru",
        "span_id": 2968966943327841198,
        "trace_id": 4502604398413287283
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-08 03:10:37
success: True
trace_id: 4502604398413287283

Scan 161619291

duration: 0:00:11.500081

exit_message:

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

id: 161619291

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_WorkOrderStatusSet/2026-04-07/1775548711",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-07/1775548711/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15674903478032597603,
        "service_name": "drive-thru",
        "span_id": 6021087904765862165,
        "trace_id": 13830295951483810561
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-07 03:02:44
success: True
trace_id: 13830295951483810561

Scan 161561678

duration: 0:00:14.013719

exit_message:

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

id: 161561678

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_WorkOrderStatusSet/2026-04-06/1775462662",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-06/1775462662/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12229965014067049325,
        "service_name": "drive-thru",
        "span_id": 17484984687490634687,
        "trace_id": 15985528251283033678
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-06 03:08:35
success: True
trace_id: 15985528251283033678

Scan 161514968

duration: 0:00:11.526161

exit_message:

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

id: 161514968

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_WorkOrderStatusSet/2026-04-05/1775376293",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-05/1775376293/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7554052280270901241,
        "service_name": "drive-thru",
        "span_id": 10367788789019152887,
        "trace_id": 4920488878308135978
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-05 03:08:29
success: True
trace_id: 4920488878308135978

Scan 161460552

duration: 0:00:11.556036

exit_message:

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

id: 161460552

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_WorkOrderStatusSet/2026-04-04/1775289775",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-04/1775289775/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7016211098238581429,
        "service_name": "drive-thru",
        "span_id": 3071308628114824542,
        "trace_id": 11468034840838176214
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-04 03:09:52
success: True
trace_id: 11468034840838176214

Scan 161401872

duration: 0:00:14.045132

exit_message:

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

id: 161401872

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_WorkOrderStatusSet/2026-04-03/1775203541",
        "key": "raw/molo_moloSV_WorkOrderStatusSet/2026-04-03/1775203541/SV_WorkOrderStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11248456609443776801,
        "service_name": "drive-thru",
        "span_id": 5196094265474857558,
        "trace_id": 12081574934869584067
    }
}

running: False
schema_name_id: 1733
start_time: 2026-04-03 03:08:59
success: True
trace_id: 12081574934869584067

Partitions:

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

Schema:

attributes:

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

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

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

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