Schema Info
Schema Name: sfdl_prod_drivethru.molo_molostripelocationset
- created: 2023-10-17 01:58:39
- disabled: False
- format: raw
- id: 1694
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molostripelocationset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717696
- created: 2026-04-17 03:07:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-17/1776412989'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-17/1776412989
- id: 1717696
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 162167686
- updated: 2026-04-17 03:07:32
-
Version 1716471
- created: 2026-04-16 03:10:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-16/1776326691'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-16/1776326691
- id: 1716471
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 162111908
- updated: 2026-04-16 03:10:39
-
Version 1715310
- created: 2026-04-15 03:09:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-15/1776240178'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-15/1776240178
- id: 1715310
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 162056097
- updated: 2026-04-15 03:09:43
-
Version 1714089
- created: 2026-04-14 03:08:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-14/1776154124'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-14/1776154124
- id: 1714089
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 162000595
- updated: 2026-04-14 03:09:05
-
Version 1712887
- created: 2026-04-13 03:03:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-13/1776067123'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-13/1776067123
- id: 1712887
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161942560
- updated: 2026-04-13 03:03:33
-
Version 1711744
- created: 2026-04-12 03:07:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-12/1775980818'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-12/1775980818
- id: 1711744
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161893438
- updated: 2026-04-12 03:07:52
-
Version 1710492
- created: 2026-04-11 03:08:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-11/1775894588'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-11/1775894588
- id: 1710492
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161841281
- updated: 2026-04-11 03:08:14
-
Version 1709293
- created: 2026-04-10 03:07:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-10/1775808352'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-10/1775808352
- id: 1709293
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161785987
- updated: 2026-04-10 03:08:06
-
Version 1708232
- created: 2026-04-09 03:08:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-09/1775721678'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-09/1775721678
- id: 1708232
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161730498
- updated: 2026-04-09 03:08:29
-
Version 1706899
- created: 2026-04-08 03:05:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-08/1775635513'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-08/1775635513
- id: 1706899
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161675518
- updated: 2026-04-08 03:05:34
-
Version 1705796
- created: 2026-04-07 03:00:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-07/1775548676'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-07/1775548676
- id: 1705796
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161618973
- updated: 2026-04-07 03:01:10
-
Version 1704610
- created: 2026-04-06 03:10:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-06/1775462625'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-06/1775462625
- id: 1704610
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161561757
- updated: 2026-04-06 03:10:48
-
Version 1703369
- created: 2026-04-05 03:07:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-05/1775376252'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-05/1775376252
- id: 1703369
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161514952
- updated: 2026-04-05 03:08:13
-
Version 1702172
- created: 2026-04-04 03:06:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-04/1775289738'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-04/1775289738
- id: 1702172
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161460404
- updated: 2026-04-04 03:06:16
-
Version 1700969
- created: 2026-04-03 03:10:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-03/1775203506'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeLocationSet/2026-04-03/1775203506
- id: 1700969
- processed: 1
- raw_data:
{ "DisplayName": 3, "Id": 0, "MarinaLocation_Id": 4, "Object": 2, "StripeId": 1 } - schema_attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - schema_name_id: 1694
- schema_scan_id: 161401936
- updated: 2026-04-03 03:11:06
Schema Scans: 15
Last at 2026-04-17 03:07:20
-
Scan 162167686
- duration: 0:00:11.585597
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167686
- 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_moloStripeLocationSet/2026-04-17/1776412989", "key": "raw/molo_moloStripeLocationSet/2026-04-17/1776412989/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12821799999397550593, "service_name": "drive-thru", "span_id": 14003074865227497735, "trace_id": 9372563048179393560 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-17 03:07:20
- success: True
- trace_id: 9372563048179393560
-
Scan 162111908
- duration: 0:00:11.625923
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111908
- 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_moloStripeLocationSet/2026-04-16/1776326691", "key": "raw/molo_moloStripeLocationSet/2026-04-16/1776326691/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12703369699740948547, "service_name": "drive-thru", "span_id": 6367562312755775711, "trace_id": 15963273592455257611 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-16 03:10:27
- success: True
- trace_id: 15963273592455257611
-
Scan 162056097
- duration: 0:00:11.576558
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056097
- 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_moloStripeLocationSet/2026-04-15/1776240178", "key": "raw/molo_moloStripeLocationSet/2026-04-15/1776240178/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1569108975736174793, "service_name": "drive-thru", "span_id": 7089172879800291229, "trace_id": 1268958574382761968 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-15 03:09:32
- success: True
- trace_id: 1268958574382761968
-
Scan 162000595
- duration: 0:00:11.706225
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000595
- 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_moloStripeLocationSet/2026-04-14/1776154124", "key": "raw/molo_moloStripeLocationSet/2026-04-14/1776154124/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9981072505695338386, "service_name": "drive-thru", "span_id": 14866778223494820163, "trace_id": 5752556897608672143 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-14 03:08:53
- success: True
- trace_id: 5752556897608672143
-
Scan 161942560
- duration: 0:00:14.192001
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942560
- 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_moloStripeLocationSet/2026-04-13/1776067123", "key": "raw/molo_moloStripeLocationSet/2026-04-13/1776067123/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7785510206461556123, "service_name": "drive-thru", "span_id": 6272830747187747687, "trace_id": 12409895312360413905 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-13 03:03:19
- success: True
- trace_id: 12409895312360413905
-
Scan 161893438
- duration: 0:00:14.211622
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893438
- 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_moloStripeLocationSet/2026-04-12/1775980818", "key": "raw/molo_moloStripeLocationSet/2026-04-12/1775980818/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9922069086457045556, "service_name": "drive-thru", "span_id": 14727476136702681922, "trace_id": 12265022801530617112 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-12 03:07:38
- success: True
- trace_id: 12265022801530617112
-
Scan 161841281
- duration: 0:00:11.556120
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841281
- 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_moloStripeLocationSet/2026-04-11/1775894588", "key": "raw/molo_moloStripeLocationSet/2026-04-11/1775894588/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16275881322228840781, "service_name": "drive-thru", "span_id": 5206623369076715516, "trace_id": 7592167647835027151 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-11 03:08:03
- success: True
- trace_id: 7592167647835027151
-
Scan 161785987
- duration: 0:00:11.655956
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785987
- 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_moloStripeLocationSet/2026-04-10/1775808352", "key": "raw/molo_moloStripeLocationSet/2026-04-10/1775808352/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17600727816143561839, "service_name": "drive-thru", "span_id": 3603602762870246416, "trace_id": 10743919133116974367 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-10 03:07:54
- success: True
- trace_id: 10743919133116974367
-
Scan 161730498
- duration: 0:00:11.658880
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730498
- 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_moloStripeLocationSet/2026-04-09/1775721678", "key": "raw/molo_moloStripeLocationSet/2026-04-09/1775721678/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15613631405025241652, "service_name": "drive-thru", "span_id": 12808078814731512128, "trace_id": 13881338665607593422 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-09 03:08:17
- success: True
- trace_id: 13881338665607593422
-
Scan 161675518
- duration: 0:00:11.688219
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675518
- 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_moloStripeLocationSet/2026-04-08/1775635513", "key": "raw/molo_moloStripeLocationSet/2026-04-08/1775635513/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1494642215610625460, "service_name": "drive-thru", "span_id": 937198026121739515, "trace_id": 2475670892149954202 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-08 03:05:23
- success: True
- trace_id: 2475670892149954202
-
Scan 161618973
- duration: 0:00:11.635042
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618973
- 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_moloStripeLocationSet/2026-04-07/1775548676", "key": "raw/molo_moloStripeLocationSet/2026-04-07/1775548676/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7905177222055534120, "service_name": "drive-thru", "span_id": 14941673292402375246, "trace_id": 6190154971172345499 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-07 03:00:58
- success: True
- trace_id: 6190154971172345499
-
Scan 161561757
- duration: 0:00:14.347908
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561757
- 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_moloStripeLocationSet/2026-04-06/1775462625", "key": "raw/molo_moloStripeLocationSet/2026-04-06/1775462625/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6777161170315030506, "service_name": "drive-thru", "span_id": 6702736701473169357, "trace_id": 12547127612404227349 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-06 03:10:33
- success: True
- trace_id: 12547127612404227349
-
Scan 161514952
- duration: 0:00:14.044157
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514952
- 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_moloStripeLocationSet/2026-04-05/1775376252", "key": "raw/molo_moloStripeLocationSet/2026-04-05/1775376252/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10552643681407809058, "service_name": "drive-thru", "span_id": 5174665433916989852, "trace_id": 12244724754659751513 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-05 03:07:59
- success: True
- trace_id: 12244724754659751513
-
Scan 161460404
- duration: 0:00:14.208410
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460404
- 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_moloStripeLocationSet/2026-04-04/1775289738", "key": "raw/molo_moloStripeLocationSet/2026-04-04/1775289738/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7032798272808504018, "service_name": "drive-thru", "span_id": 13324521426564069994, "trace_id": 2024586554752946809 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-04 03:06:02
- success: True
- trace_id: 2024586554752946809
-
Scan 161401936
- duration: 0:00:11.699220
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401936
- 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_moloStripeLocationSet/2026-04-03/1775203506", "key": "raw/molo_moloStripeLocationSet/2026-04-03/1775203506/StripeLocationSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloStripeLocationSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15595776361210654399, "service_name": "drive-thru", "span_id": 2967537749266421188, "trace_id": 3270967804846076064 } } - running: False
- schema_name_id: 1694
- start_time: 2026-04-03 03:10:54
- success: True
- trace_id: 3270967804846076064
- attributes:
{ "DisplayName": "string", "Id": "string", "MarinaLocation_Id": "string", "Object": "string", "StripeId": "string" } - created: 2026-04-17 03:07:21
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-17/1776412989'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 01:58:39",
"disabled": false,
"format": "raw",
"id": 1694,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molostripelocationset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"DisplayName": "string",
"Id": "string",
"MarinaLocation_Id": "string",
"Object": "string",
"StripeId": "string"
},
"created": "2026-04-17 03:07:21",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripelocationset`\n(\n `Id` string , `StripeId` string , `Object` string , `DisplayName` 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_moloStripeLocationSet/2026-04-17/1776412989'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripelocationset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripelocationset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}