Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_workorderjobstatusset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717719

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 162167719
updated: 2026-04-17 03:08:28

Version 1716481

created: 2026-04-16 03:10:53

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 162111923
updated: 2026-04-16 03:11:04

Version 1715385

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 162056193
updated: 2026-04-15 03:13:25

Version 1714157

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 162000677
updated: 2026-04-14 03:11:44

Version 1712928

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_workorderjobstatusset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_workorderjobstatusset`\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_WorkOrderJobStatusSet/2026-04-13/1776067160'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderjobstatusset"
]

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161942687
updated: 2026-04-13 03:05:18

Version 1711725

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161893404
updated: 2026-04-12 03:07:06

Version 1710452

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161841240
updated: 2026-04-11 03:06:47

Version 1709400

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161786104
updated: 2026-04-10 03:12:18

Version 1708259

created: 2026-04-09 03:09:31

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161730540
updated: 2026-04-09 03:09:42

Version 1707071

created: 2026-04-08 03:12:43

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161675743
updated: 2026-04-08 03:12:55

Version 1705880

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161619476
updated: 2026-04-07 03:05:23

Version 1704488

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161561575
updated: 2026-04-06 03:05:50

Version 1703386

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161514970
updated: 2026-04-05 03:08:43

Version 1702277

created: 2026-04-04 03:10:54

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161460589
updated: 2026-04-04 03:11:07

Version 1701014

created: 2026-04-03 03:12:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1725
schema_scan_id: 161401988
updated: 2026-04-03 03:13:02

Schema Scans: 15

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

Scan 162167719

duration: 0:00:14.128059

exit_message:

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

id: 162167719

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_WorkOrderJobStatusSet/2026-04-17/1776413129",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-17/1776413129/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17103626896086676616,
        "service_name": "drive-thru",
        "span_id": 2908515783121407697,
        "trace_id": 11990234187183569572
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-17 03:08:14
success: True
trace_id: 11990234187183569572

Scan 162111923

duration: 0:00:11.480289

exit_message:

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

id: 162111923

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_WorkOrderJobStatusSet/2026-04-16/1776326732",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-16/1776326732/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3864055029102138725,
        "service_name": "drive-thru",
        "span_id": 2425963543248418004,
        "trace_id": 7038283314076133242
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-16 03:10:53
success: True
trace_id: 7038283314076133242

Scan 162056193

duration: 0:00:11.489631

exit_message:

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

id: 162056193

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_WorkOrderJobStatusSet/2026-04-15/1776240198",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-15/1776240198/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4105177383753289807,
        "service_name": "drive-thru",
        "span_id": 1600028665440347748,
        "trace_id": 14610350506957559670
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-15 03:13:14
success: True
trace_id: 14610350506957559670

Scan 162000677

duration: 0:00:13.974733

exit_message:

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

id: 162000677

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_WorkOrderJobStatusSet/2026-04-14/1776154164",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-14/1776154164/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11563282715138605562,
        "service_name": "drive-thru",
        "span_id": 5392844634614350077,
        "trace_id": 3639948061143869256
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-14 03:11:30
success: True
trace_id: 3639948061143869256

Scan 161942687

duration: 0:00:14.108441

exit_message:

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

id: 161942687

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_WorkOrderJobStatusSet/2026-04-13/1776067160",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-13/1776067160/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13698544071052042243,
        "service_name": "drive-thru",
        "span_id": 1428449921416209054,
        "trace_id": 11110707530272521732
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-13 03:05:04
success: True
trace_id: 11110707530272521732

Scan 161893404

duration: 0:00:14.025254

exit_message:

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

id: 161893404

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_WorkOrderJobStatusSet/2026-04-12/1775980859",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-12/1775980859/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2035119359216187675,
        "service_name": "drive-thru",
        "span_id": 7701254219691673470,
        "trace_id": 7702828730629591342
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-12 03:06:52
success: True
trace_id: 7702828730629591342

Scan 161841240

duration: 0:00:11.473203

exit_message:

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

id: 161841240

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_WorkOrderJobStatusSet/2026-04-11/1775894627",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-11/1775894627/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 344423872640200391,
        "service_name": "drive-thru",
        "span_id": 17186359728342442837,
        "trace_id": 9412412994400726707
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-11 03:06:35
success: True
trace_id: 9412412994400726707

Scan 161786104

duration: 0:00:14.099482

exit_message:

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

id: 161786104

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_WorkOrderJobStatusSet/2026-04-10/1775808388",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-10/1775808388/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1685893341750303361,
        "service_name": "drive-thru",
        "span_id": 6448018837429035509,
        "trace_id": 3747032467881298187
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-10 03:12:04
success: True
trace_id: 3747032467881298187

Scan 161730540

duration: 0:00:11.526693

exit_message:

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

id: 161730540

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_WorkOrderJobStatusSet/2026-04-09/1775721718",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-09/1775721718/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4900426840673910809,
        "service_name": "drive-thru",
        "span_id": 8840257264010859750,
        "trace_id": 2704669451546283634
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-09 03:09:31
success: True
trace_id: 2704669451546283634

Scan 161675743

duration: 0:00:11.699254

exit_message:

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

id: 161675743

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_WorkOrderJobStatusSet/2026-04-08/1775635549",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-08/1775635549/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7738823377022592128,
        "service_name": "drive-thru",
        "span_id": 18342611053407587884,
        "trace_id": 1415915904036216992
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-08 03:12:43
success: True
trace_id: 1415915904036216992

Scan 161619476

duration: 0:00:11.631850

exit_message:

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

id: 161619476

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_WorkOrderJobStatusSet/2026-04-07/1775548711",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-07/1775548711/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17311947747420055598,
        "service_name": "drive-thru",
        "span_id": 13753228053423506834,
        "trace_id": 4635944882541408479
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-07 03:05:11
success: True
trace_id: 4635944882541408479

Scan 161561575

duration: 0:00:11.450403

exit_message:

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

id: 161561575

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_WorkOrderJobStatusSet/2026-04-06/1775462661",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-06/1775462661/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16383346311598038976,
        "service_name": "drive-thru",
        "span_id": 10996676725104384046,
        "trace_id": 1156596412291955293
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-06 03:05:39
success: True
trace_id: 1156596412291955293

Scan 161514970

duration: 0:00:11.478484

exit_message:

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

id: 161514970

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_WorkOrderJobStatusSet/2026-04-05/1775376293",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-05/1775376293/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4598784368482972156,
        "service_name": "drive-thru",
        "span_id": 15872460068414294834,
        "trace_id": 5799245346317275484
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-05 03:08:31
success: True
trace_id: 5799245346317275484

Scan 161460589

duration: 0:00:14.015367

exit_message:

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

id: 161460589

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_WorkOrderJobStatusSet/2026-04-04/1775289774",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-04/1775289774/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7345976703947103951,
        "service_name": "drive-thru",
        "span_id": 9702945600588421340,
        "trace_id": 14536360154070993936
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-04 03:10:53
success: True
trace_id: 14536360154070993936

Scan 161401988

duration: 0:00:11.726346

exit_message:

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

id: 161401988

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_WorkOrderJobStatusSet/2026-04-03/1775203539",
        "key": "raw/molo_moloSV_WorkOrderJobStatusSet/2026-04-03/1775203539/SV_WorkOrderJobStatusSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_WorkOrderJobStatusSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7843683985704539877,
        "service_name": "drive-thru",
        "span_id": 11052699184298616396,
        "trace_id": 16199776912996947779
    }
}

running: False
schema_name_id: 1725
start_time: 2026-04-03 03:12:51
success: True
trace_id: 16199776912996947779

Partitions:

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

Schema:

attributes:

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

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

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_workorderjobstatusset`\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_WorkOrderJobStatusSet/2026-04-17/1776413129'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_workorderjobstatusset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_workorderjobstatusset"
}

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