Schema Info

Schema Name: sfdl_prod_drivethru.molo_molovesselengineclassset

created: 2023-10-17 02:02:05
disabled: False
format: raw
id: 1788
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717732

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 162167734
updated: 2026-04-17 03:08:55

Version 1716583

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 162112046
updated: 2026-04-16 03:14:56

Version 1715389

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 162056198
updated: 2026-04-15 03:13:40

Version 1714192

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 162000716
updated: 2026-04-14 03:13:00

Version 1712971

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161942836
updated: 2026-04-13 03:07:25

Version 1711738

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161893428
updated: 2026-04-12 03:07:38

Version 1710457

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161841246
updated: 2026-04-11 03:06:59

Version 1709321

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161786020
updated: 2026-04-10 03:09:13

Version 1708145

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161730313
updated: 2026-04-09 03:04:24

Version 1706929

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161675566
updated: 2026-04-08 03:06:55

Version 1705856

created: 2026-04-07 03:03:43

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161619370
updated: 2026-04-07 03:03:57

Version 1704566

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161561686
updated: 2026-04-06 03:08:59

Version 1703434

created: 2026-04-05 03:10:18

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161515023
updated: 2026-04-05 03:10:31

Version 1702243

created: 2026-04-04 03:09:26

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161460535
updated: 2026-04-04 03:09:37

Version 1701023

created: 2026-04-03 03:13:24

ddl:

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

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

schema_attributes:

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

schema_name_id: 1788
schema_scan_id: 161401999
updated: 2026-04-03 03:13:38

Schema Scans: 15

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

Scan 162167734

duration: 0:00:11.472381

exit_message:

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

id: 162167734

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_moloVesselEngineClassSet/2026-04-17/1776413272",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-17/1776413272/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11472134312946811447,
        "service_name": "drive-thru",
        "span_id": 10692106043501054870,
        "trace_id": 529220660803362622
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-17 03:08:44
success: True
trace_id: 529220660803362622

Scan 162112046

duration: 0:00:11.564541

exit_message:

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

id: 162112046

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_moloVesselEngineClassSet/2026-04-16/1776326749",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-16/1776326749/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1268419887637755806,
        "service_name": "drive-thru",
        "span_id": 17237894996028438261,
        "trace_id": 14590426669128070332
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-16 03:14:44
success: True
trace_id: 14590426669128070332

Scan 162056198

duration: 0:00:14.069251

exit_message:

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

id: 162056198

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_moloVesselEngineClassSet/2026-04-15/1776240210",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-15/1776240210/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15228001078505554140,
        "service_name": "drive-thru",
        "span_id": 5344856702445694482,
        "trace_id": 14257096371494050428
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-15 03:13:26
success: True
trace_id: 14257096371494050428

Scan 162000716

duration: 0:00:11.458417

exit_message:

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

id: 162000716

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_moloVesselEngineClassSet/2026-04-14/1776154174",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-14/1776154174/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15151130887039097585,
        "service_name": "drive-thru",
        "span_id": 4825040622777493765,
        "trace_id": 15703085026079035365
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-14 03:12:49
success: True
trace_id: 15703085026079035365

Scan 161942836

duration: 0:00:11.518654

exit_message:

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

id: 161942836

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_moloVesselEngineClassSet/2026-04-13/1776067167",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-13/1776067167/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13169727717898043388,
        "service_name": "drive-thru",
        "span_id": 2279553355087465997,
        "trace_id": 14510012588813201710
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-13 03:07:14
success: True
trace_id: 14510012588813201710

Scan 161893428

duration: 0:00:14.051717

exit_message:

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

id: 161893428

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_moloVesselEngineClassSet/2026-04-12/1775980870",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-12/1775980870/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12443154647541606644,
        "service_name": "drive-thru",
        "span_id": 4035677229762754398,
        "trace_id": 10496969336172226744
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-12 03:07:24
success: True
trace_id: 10496969336172226744

Scan 161841246

duration: 0:00:13.953854

exit_message:

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

id: 161841246

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_moloVesselEngineClassSet/2026-04-11/1775894646",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-11/1775894646/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13355534473334129796,
        "service_name": "drive-thru",
        "span_id": 14920171094096686373,
        "trace_id": 13928123010804608753
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-11 03:06:45
success: True
trace_id: 13928123010804608753

Scan 161786020

duration: 0:00:14.183267

exit_message:

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

id: 161786020

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_moloVesselEngineClassSet/2026-04-10/1775808400",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-10/1775808400/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 109351888763260485,
        "service_name": "drive-thru",
        "span_id": 2708916614998124329,
        "trace_id": 17740240959299585748
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-10 03:08:59
success: True
trace_id: 17740240959299585748

Scan 161730313

duration: 0:00:14.141104

exit_message:

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

id: 161730313

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_moloVesselEngineClassSet/2026-04-09/1775721732",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-09/1775721732/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17279698183823715643,
        "service_name": "drive-thru",
        "span_id": 6520464800435366223,
        "trace_id": 6986667534222602599
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-09 03:04:10
success: True
trace_id: 6986667534222602599

Scan 161675566

duration: 0:00:11.530228

exit_message:

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

id: 161675566

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_moloVesselEngineClassSet/2026-04-08/1775635560",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-08/1775635560/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2929206117216129663,
        "service_name": "drive-thru",
        "span_id": 15982649887263411841,
        "trace_id": 4883000039805224962
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-08 03:06:44
success: True
trace_id: 4883000039805224962

Scan 161619370

duration: 0:00:14.009258

exit_message:

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

id: 161619370

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_moloVesselEngineClassSet/2026-04-07/1775548720",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-07/1775548720/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2539776941864798272,
        "service_name": "drive-thru",
        "span_id": 14781939591570225023,
        "trace_id": 16472658035130333129
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-07 03:03:43
success: True
trace_id: 16472658035130333129

Scan 161561686

duration: 0:00:11.521486

exit_message:

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

id: 161561686

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_moloVesselEngineClassSet/2026-04-06/1775462672",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-06/1775462672/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1920471366138122904,
        "service_name": "drive-thru",
        "span_id": 13054412681691272472,
        "trace_id": 2315020133205376605
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-06 03:08:47
success: True
trace_id: 2315020133205376605

Scan 161515023

duration: 0:00:14.008497

exit_message:

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

id: 161515023

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_moloVesselEngineClassSet/2026-04-05/1775376302",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-05/1775376302/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14448188135627754999,
        "service_name": "drive-thru",
        "span_id": 8435465914732244764,
        "trace_id": 1995834167552979199
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-05 03:10:17
success: True
trace_id: 1995834167552979199

Scan 161460535

duration: 0:00:11.432012

exit_message:

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

id: 161460535

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_moloVesselEngineClassSet/2026-04-04/1775289786",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-04/1775289786/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 54181423051631157,
        "service_name": "drive-thru",
        "span_id": 1484330682593793219,
        "trace_id": 17557733690247093173
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-04 03:09:26
success: True
trace_id: 17557733690247093173

Scan 161401999

duration: 0:00:14.134292

exit_message:

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

id: 161401999

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_moloVesselEngineClassSet/2026-04-03/1775203551",
        "key": "raw/molo_moloVesselEngineClassSet/2026-04-03/1775203551/VesselEngineClassSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloVesselEngineClassSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8842561100328834890,
        "service_name": "drive-thru",
        "span_id": 8924791614445740504,
        "trace_id": 11222435623795814139
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-03 03:13:24
success: True
trace_id: 11222435623795814139

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molovesselengineclassset`\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_moloVesselEngineClassSet/2026-04-17/1776413272'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molovesselengineclassset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molovesselengineclassset"
}

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