Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloboattypes

created: 2023-10-17 01:54:41
disabled: False
format: raw
id: 1582
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717550

created: 2026-04-17 02:59:20

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 162167132
updated: 2026-04-17 02:59:33

Version 1716317

created: 2026-04-16 03:03:19

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 162111660
updated: 2026-04-16 03:03:33

Version 1715130

created: 2026-04-15 03:00:45

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 162055644
updated: 2026-04-15 03:00:59

Version 1713927

created: 2026-04-14 03:01:37

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 162000305
updated: 2026-04-14 03:01:48

Version 1712714

created: 2026-04-13 02:55:35

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161941484
updated: 2026-04-13 02:55:49

Version 1711503

created: 2026-04-12 02:56:32

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161892259
updated: 2026-04-12 02:56:46

Version 1710343

created: 2026-04-11 03:01:56

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161841032
updated: 2026-04-11 03:02:09

Version 1709187

created: 2026-04-10 03:03:51

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161785867
updated: 2026-04-10 03:04:08

Version 1708046

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161729896
updated: 2026-04-09 03:00:21

Version 1706794

created: 2026-04-08 03:00:34

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161675249
updated: 2026-04-08 03:00:45

Version 1705636

created: 2026-04-07 02:54:29

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161618314
updated: 2026-04-07 02:54:40

Version 1704407

created: 2026-04-06 03:01:42

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161561385
updated: 2026-04-06 03:01:56

Version 1703218

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

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161514781
updated: 2026-04-05 03:02:03

Version 1702030

created: 2026-04-04 02:59:44

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161459802
updated: 2026-04-04 02:59:55

Version 1700958

created: 2026-04-03 03:10:27

ddl:

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

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

schema_attributes:

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

schema_name_id: 1582
schema_scan_id: 161401917
updated: 2026-04-03 03:10:41

Schema Scans: 15

Last at 2026-04-17 02:59:19

Scan 162167132

duration: 0:00:14.078697

exit_message:

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

id: 162167132

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_moloBoatTypes/2026-04-17/1776412694",
        "key": "raw/molo_moloBoatTypes/2026-04-17/1776412694/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3494889839859295457,
        "service_name": "drive-thru",
        "span_id": 13382752730684264228,
        "trace_id": 8667504821602165422
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-17 02:59:19
success: True
trace_id: 8667504821602165422

Scan 162111660

duration: 0:00:14.100241

exit_message:

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

id: 162111660

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_moloBoatTypes/2026-04-16/1776326458",
        "key": "raw/molo_moloBoatTypes/2026-04-16/1776326458/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9442795845383616943,
        "service_name": "drive-thru",
        "span_id": 16774790136405913426,
        "trace_id": 17252475565244178265
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-16 03:03:19
success: True
trace_id: 17252475565244178265

Scan 162055644

duration: 0:00:14.155120

exit_message:

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

id: 162055644

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_moloBoatTypes/2026-04-15/1776239928",
        "key": "raw/molo_moloBoatTypes/2026-04-15/1776239928/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15980818469096070186,
        "service_name": "drive-thru",
        "span_id": 10542869474807572816,
        "trace_id": 15425314221995316266
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-15 03:00:45
success: True
trace_id: 15425314221995316266

Scan 162000305

duration: 0:00:11.606203

exit_message:

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

id: 162000305

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_moloBoatTypes/2026-04-14/1776153653",
        "key": "raw/molo_moloBoatTypes/2026-04-14/1776153653/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3328185307914881526,
        "service_name": "drive-thru",
        "span_id": 11073102173541620689,
        "trace_id": 516971213223060423
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-14 03:01:36
success: True
trace_id: 516971213223060423

Scan 161941484

duration: 0:00:13.951406

exit_message:

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

id: 161941484

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_moloBoatTypes/2026-04-13/1776066847",
        "key": "raw/molo_moloBoatTypes/2026-04-13/1776066847/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14448549163823436547,
        "service_name": "drive-thru",
        "span_id": 8948919828634946878,
        "trace_id": 12242413895266967099
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-13 02:55:35
success: True
trace_id: 12242413895266967099

Scan 161892259

duration: 0:00:14.064833

exit_message:

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

id: 161892259

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_moloBoatTypes/2026-04-12/1775980562",
        "key": "raw/molo_moloBoatTypes/2026-04-12/1775980562/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17784390972087184011,
        "service_name": "drive-thru",
        "span_id": 18193811019165333070,
        "trace_id": 16929327940802975546
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-12 02:56:32
success: True
trace_id: 16929327940802975546

Scan 161841032

duration: 0:00:14.156923

exit_message:

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

id: 161841032

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_moloBoatTypes/2026-04-11/1775894322",
        "key": "raw/molo_moloBoatTypes/2026-04-11/1775894322/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2434780427754597746,
        "service_name": "drive-thru",
        "span_id": 18209469933862660478,
        "trace_id": 10077744314723493227
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-11 03:01:55
success: True
trace_id: 10077744314723493227

Scan 161785867

duration: 0:00:16.775352

exit_message:

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

id: 161785867

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_moloBoatTypes/2026-04-10/1775808079",
        "key": "raw/molo_moloBoatTypes/2026-04-10/1775808079/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8701584151920079263,
        "service_name": "drive-thru",
        "span_id": 17451542606933653721,
        "trace_id": 11260244795254155319
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-10 03:03:51
success: True
trace_id: 11260244795254155319

Scan 161729896

duration: 0:00:11.664713

exit_message:

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

id: 161729896

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_moloBoatTypes/2026-04-09/1775721417",
        "key": "raw/molo_moloBoatTypes/2026-04-09/1775721417/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7597174351243723677,
        "service_name": "drive-thru",
        "span_id": 8046030653274790292,
        "trace_id": 1630869631212357943
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-09 03:00:09
success: True
trace_id: 1630869631212357943

Scan 161675249

duration: 0:00:11.525957

exit_message:

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

id: 161675249

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_moloBoatTypes/2026-04-08/1775635225",
        "key": "raw/molo_moloBoatTypes/2026-04-08/1775635225/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12311799008312234104,
        "service_name": "drive-thru",
        "span_id": 6844229074536782321,
        "trace_id": 13436385255712479770
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-08 03:00:34
success: True
trace_id: 13436385255712479770

Scan 161618314

duration: 0:00:11.485163

exit_message:

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

id: 161618314

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_moloBoatTypes/2026-04-07/1775548397",
        "key": "raw/molo_moloBoatTypes/2026-04-07/1775548397/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6415228369152981873,
        "service_name": "drive-thru",
        "span_id": 3540505845565095218,
        "trace_id": 7280315809607324895
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-07 02:54:29
success: True
trace_id: 7280315809607324895

Scan 161561385

duration: 0:00:14.193803

exit_message:

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

id: 161561385

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_moloBoatTypes/2026-04-06/1775462362",
        "key": "raw/molo_moloBoatTypes/2026-04-06/1775462362/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4255698964326725064,
        "service_name": "drive-thru",
        "span_id": 4199696674311140658,
        "trace_id": 12276906174082394820
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-06 03:01:42
success: True
trace_id: 12276906174082394820

Scan 161514781

duration: 0:00:14.027042

exit_message:

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

id: 161514781

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_moloBoatTypes/2026-04-05/1775375989",
        "key": "raw/molo_moloBoatTypes/2026-04-05/1775375989/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3877753872330371989,
        "service_name": "drive-thru",
        "span_id": 684539826174848093,
        "trace_id": 14466101588959728193
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-05 03:01:49
success: True
trace_id: 14466101588959728193

Scan 161459802

duration: 0:00:11.504194

exit_message:

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

id: 161459802

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_moloBoatTypes/2026-04-04/1775289474",
        "key": "raw/molo_moloBoatTypes/2026-04-04/1775289474/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17658820340140229667,
        "service_name": "drive-thru",
        "span_id": 15039956320438026882,
        "trace_id": 1188312006286972476
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-04 02:59:44
success: True
trace_id: 1188312006286972476

Scan 161401917

duration: 0:00:14.173029

exit_message:

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

id: 161401917

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_moloBoatTypes/2026-04-03/1775203247",
        "key": "raw/molo_moloBoatTypes/2026-04-03/1775203247/BoatTypes.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloBoatTypes",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2887570268544382797,
        "service_name": "drive-thru",
        "span_id": 2762946557287794524,
        "trace_id": 10967901528234677666
    }
}

running: False
schema_name_id: 1582
start_time: 2026-04-03 03:10:27
success: True
trace_id: 10967901528234677666

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 02:59:20

ddl:

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

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