Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_inventoryroomset

created: 2023-10-17 02:02:43
disabled: False
format: raw
id: 1803
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717706

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-17/1776412998
id: 1717706
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 162167704
updated: 2026-04-17 03:07:58

Version 1716491

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-16/1776326697
id: 1716491
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 162111933
updated: 2026-04-16 03:11:28

Version 1715346

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-15/1776240185
id: 1715346
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 162056141
updated: 2026-04-15 03:11:37

Version 1714164

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-14/1776154139
id: 1714164
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 162000686
updated: 2026-04-14 03:12:01

Version 1712919

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-13/1776067135
id: 1712919
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161942627
updated: 2026-04-13 03:04:40

Version 1711693

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-12/1775980830
id: 1711693
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161893309
updated: 2026-04-12 03:05:17

Version 1710423

created: 2026-04-11 03:05:29

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-11/1775894600
id: 1710423
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161841204
updated: 2026-04-11 03:05:41

Version 1709273

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-10/1775808364
id: 1709273
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161785966
updated: 2026-04-10 03:07:24

Version 1708274

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-09/1775721688
id: 1708274
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161730567
updated: 2026-04-09 03:10:22

Version 1706947

created: 2026-04-08 03:07:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-08/1775635524
id: 1706947
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161675593
updated: 2026-04-08 03:07:42

Version 1705818

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-07/1775548687
id: 1705818
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161619211
updated: 2026-04-07 03:02:15

Version 1704633

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-06/1775462637
id: 1704633
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161561782
updated: 2026-04-06 03:11:37

Version 1703406

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-05/1775376269
id: 1703406
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161514991
updated: 2026-04-05 03:09:31

Version 1702293

created: 2026-04-04 03:11:47

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-04/1775289750
id: 1702293
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161460622
updated: 2026-04-04 03:12:01

Version 1701048

created: 2026-04-03 03:14:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_InventoryRoomSet/2026-04-03/1775203517
id: 1701048
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1803
schema_scan_id: 161402031
updated: 2026-04-03 03:14:46

Schema Scans: 15

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

Scan 162167704

duration: 0:00:14.231361

exit_message:

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

id: 162167704

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_InventoryRoomSet/2026-04-17/1776412998",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-17/1776412998/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4851763349438634779,
        "service_name": "drive-thru",
        "span_id": 2461511490609499534,
        "trace_id": 17528365680185476470
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-17 03:07:44
success: True
trace_id: 17528365680185476470

Scan 162111933

duration: 0:00:14.152583

exit_message:

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

id: 162111933

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_InventoryRoomSet/2026-04-16/1776326697",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-16/1776326697/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2744915220912148738,
        "service_name": "drive-thru",
        "span_id": 12388222370507545920,
        "trace_id": 8414920085458935755
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-16 03:11:14
success: True
trace_id: 8414920085458935755

Scan 162056141

duration: 0:00:11.705646

exit_message:

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

id: 162056141

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_InventoryRoomSet/2026-04-15/1776240185",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-15/1776240185/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4256742212320509361,
        "service_name": "drive-thru",
        "span_id": 9663820820119748498,
        "trace_id": 16995518702601224619
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-15 03:11:26
success: True
trace_id: 16995518702601224619

Scan 162000686

duration: 0:00:14.225910

exit_message:

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

id: 162000686

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_InventoryRoomSet/2026-04-14/1776154139",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-14/1776154139/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16046105347271592521,
        "service_name": "drive-thru",
        "span_id": 14196686759054829278,
        "trace_id": 2315586611474141381
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-14 03:11:46
success: True
trace_id: 2315586611474141381

Scan 161942627

duration: 0:00:14.141883

exit_message:

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

id: 161942627

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_InventoryRoomSet/2026-04-13/1776067135",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-13/1776067135/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1044833559378875553,
        "service_name": "drive-thru",
        "span_id": 9772775665480289296,
        "trace_id": 9281418171038255195
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-13 03:04:26
success: True
trace_id: 9281418171038255195

Scan 161893309

duration: 0:00:11.687581

exit_message:

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

id: 161893309

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_InventoryRoomSet/2026-04-12/1775980830",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-12/1775980830/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 777612245017686295,
        "service_name": "drive-thru",
        "span_id": 2005426343589279265,
        "trace_id": 3540532718777629539
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-12 03:05:05
success: True
trace_id: 3540532718777629539

Scan 161841204

duration: 0:00:11.648522

exit_message:

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

id: 161841204

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_InventoryRoomSet/2026-04-11/1775894600",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-11/1775894600/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11438806556939022113,
        "service_name": "drive-thru",
        "span_id": 1881640691472631218,
        "trace_id": 4411995436597156118
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-11 03:05:29
success: True
trace_id: 4411995436597156118

Scan 161785966

duration: 0:00:11.555987

exit_message:

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

id: 161785966

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_InventoryRoomSet/2026-04-10/1775808364",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-10/1775808364/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13601488961054462119,
        "service_name": "drive-thru",
        "span_id": 12360158657596505817,
        "trace_id": 8045226523254198335
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-10 03:07:13
success: True
trace_id: 8045226523254198335

Scan 161730567

duration: 0:00:11.631201

exit_message:

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

id: 161730567

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_InventoryRoomSet/2026-04-09/1775721688",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-09/1775721688/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5815803833476335247,
        "service_name": "drive-thru",
        "span_id": 11293665226908288298,
        "trace_id": 2867104049575321374
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-09 03:10:10
success: True
trace_id: 2867104049575321374

Scan 161675593

duration: 0:00:14.091354

exit_message:

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

id: 161675593

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_InventoryRoomSet/2026-04-08/1775635524",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-08/1775635524/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14060743296121079328,
        "service_name": "drive-thru",
        "span_id": 10023309171377033802,
        "trace_id": 3294138443104356853
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-08 03:07:28
success: True
trace_id: 3294138443104356853

Scan 161619211

duration: 0:00:11.550427

exit_message:

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

id: 161619211

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_InventoryRoomSet/2026-04-07/1775548687",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-07/1775548687/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15099612942102085929,
        "service_name": "drive-thru",
        "span_id": 5996514634924235837,
        "trace_id": 5562841651940974168
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-07 03:02:04
success: True
trace_id: 5562841651940974168

Scan 161561782

duration: 0:00:11.665501

exit_message:

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

id: 161561782

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_InventoryRoomSet/2026-04-06/1775462637",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-06/1775462637/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13483288653235689579,
        "service_name": "drive-thru",
        "span_id": 14864039238509358604,
        "trace_id": 4216145507398983775
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-06 03:11:25
success: True
trace_id: 4216145507398983775

Scan 161514991

duration: 0:00:14.084091

exit_message:

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

id: 161514991

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_InventoryRoomSet/2026-04-05/1775376269",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-05/1775376269/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2664078438179552601,
        "service_name": "drive-thru",
        "span_id": 13996701461237428868,
        "trace_id": 7576973893422829987
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-05 03:09:17
success: True
trace_id: 7576973893422829987

Scan 161460622

duration: 0:00:14.284774

exit_message:

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

id: 161460622

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_InventoryRoomSet/2026-04-04/1775289750",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-04/1775289750/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8629182063762844533,
        "service_name": "drive-thru",
        "span_id": 8204437954426894128,
        "trace_id": 13848466014110790882
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-04 03:11:47
success: True
trace_id: 13848466014110790882

Scan 161402031

duration: 0:00:11.547216

exit_message:

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

id: 161402031

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_InventoryRoomSet/2026-04-03/1775203517",
        "key": "raw/molo_moloSV_InventoryRoomSet/2026-04-03/1775203517/SV_InventoryRoomSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_InventoryRoomSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11091911959805861909,
        "service_name": "drive-thru",
        "span_id": 8084452340192421650,
        "trace_id": 1917463890570252887
    }
}

running: False
schema_name_id: 1803
start_time: 2026-04-03 03:14:34
success: True
trace_id: 1917463890570252887

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 03:07: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_molosv_inventoryroomset`\n(\n `Id`  string , `Name`  string , `MarinaLocation_Id`  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_InventoryRoomSet/2026-04-17/1776412998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_inventoryroomset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_inventoryroomset"
}

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