Schema Info
Schema Name: sfdl_prod_drivethru.molo_molomarinalocationamenitiesset
- created: 2023-10-17 01:57:31
- disabled: False
- format: raw
- id: 1662
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_molomarinalocationamenitiesset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717638
- created: 2026-04-17 03:04:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803
- id: 1717638
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 162167591
- updated: 2026-04-17 03:04:50
-
Version 1716355
- created: 2026-04-16 03:05:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-16/1776326558'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-16/1776326558
- id: 1716355
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 162111738
- updated: 2026-04-16 03:05:48
-
Version 1715185
- created: 2026-04-15 03:03:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-15/1776240027'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-15/1776240027
- id: 1715185
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 162055869
- updated: 2026-04-15 03:03:59
-
Version 1714018
- created: 2026-04-14 03:06:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-14/1776153755'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-14/1776153755
- id: 1714018
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 162000501
- updated: 2026-04-14 03:06:23
-
Version 1712781
- created: 2026-04-13 02:58:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-13/1776066949'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-13/1776066949
- id: 1712781
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161941701
- updated: 2026-04-13 02:58:55
-
Version 1711586
- created: 2026-04-12 03:00:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-12/1775980663'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-12/1775980663
- id: 1711586
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161892628
- updated: 2026-04-12 03:00:48
-
Version 1710368
- created: 2026-04-11 03:03:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-11/1775894423'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-11/1775894423
- id: 1710368
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161841105
- updated: 2026-04-11 03:03:17
-
Version 1709189
- created: 2026-04-10 03:03:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-10/1775808181'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-10/1775808181
- id: 1709189
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161785869
- updated: 2026-04-10 03:04:13
-
Version 1708076
- created: 2026-04-09 03:01:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-09/1775721520'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-09/1775721520
- id: 1708076
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161730064
- updated: 2026-04-09 03:01:41
-
Version 1706978
- created: 2026-04-08 03:08:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-08/1775635349'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-08/1775635349
- id: 1706978
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161675635
- updated: 2026-04-08 03:08:52
-
Version 1705709
- created: 2026-04-07 02:57:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-07/1775548498'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-07/1775548498
- id: 1705709
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161618413
- updated: 2026-04-07 02:57:30
-
Version 1704418
- created: 2026-04-06 03:02:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-06/1775462465'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-06/1775462465
- id: 1704418
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161561411
- updated: 2026-04-06 03:02:26
-
Version 1703268
- created: 2026-04-05 03:03:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-05/1775376091'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-05/1775376091
- id: 1703268
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161514842
- updated: 2026-04-05 03:04:00
-
Version 1702114
- created: 2026-04-04 03:03:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-04/1775289574'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-04/1775289574
- id: 1702114
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161460250
- updated: 2026-04-04 03:03:41
-
Version 1700962
- created: 2026-04-03 03:10:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-03/1775203346'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloMarinaLocationAmenitiesSet/2026-04-03/1775203346
- id: 1700962
- processed: 1
- raw_data:
{ "Comments": 2, "Id": 0, "MarinaLocation_Id": 3, "Name": 1 } - schema_attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - schema_name_id: 1662
- schema_scan_id: 161401924
- updated: 2026-04-03 03:10:48
Schema Scans: 15
Last at 2026-04-17 03:04:36
-
Scan 162167591
- duration: 0:00:14.113609
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167591
- 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_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5841624949781321024, "service_name": "drive-thru", "span_id": 1006827634780456636, "trace_id": 6452640248158934643 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-17 03:04:36
- success: True
- trace_id: 6452640248158934643
-
Scan 162111738
- duration: 0:00:14.289971
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111738
- 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_moloMarinaLocationAmenitiesSet/2026-04-16/1776326558", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-16/1776326558/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8337715863223675634, "service_name": "drive-thru", "span_id": 3564090192274323755, "trace_id": 13039447650828684945 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-16 03:05:33
- success: True
- trace_id: 13039447650828684945
-
Scan 162055869
- duration: 0:00:11.538580
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055869
- 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_moloMarinaLocationAmenitiesSet/2026-04-15/1776240027", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-15/1776240027/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12838830416720252853, "service_name": "drive-thru", "span_id": 18023072622741467045, "trace_id": 15541861151277496539 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-15 03:03:47
- success: True
- trace_id: 15541861151277496539
-
Scan 162000501
- duration: 0:00:14.119204
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000501
- 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_moloMarinaLocationAmenitiesSet/2026-04-14/1776153755", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-14/1776153755/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13122770432261420520, "service_name": "drive-thru", "span_id": 12654770645998464573, "trace_id": 13826097539868650218 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-14 03:06:09
- success: True
- trace_id: 13826097539868650218
-
Scan 161941701
- duration: 0:00:14.132794
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941701
- 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_moloMarinaLocationAmenitiesSet/2026-04-13/1776066949", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-13/1776066949/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11040237526892432430, "service_name": "drive-thru", "span_id": 9112139397351962035, "trace_id": 2874482602503452211 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-13 02:58:41
- success: True
- trace_id: 2874482602503452211
-
Scan 161892628
- duration: 0:00:11.493384
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892628
- 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_moloMarinaLocationAmenitiesSet/2026-04-12/1775980663", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-12/1775980663/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6823016368616350667, "service_name": "drive-thru", "span_id": 5033007603222785135, "trace_id": 7188619046531059168 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-12 03:00:37
- success: True
- trace_id: 7188619046531059168
-
Scan 161841105
- duration: 0:00:11.584872
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841105
- 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_moloMarinaLocationAmenitiesSet/2026-04-11/1775894423", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-11/1775894423/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17459954731518308486, "service_name": "drive-thru", "span_id": 3591183349287427401, "trace_id": 673410271256207610 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-11 03:03:05
- success: True
- trace_id: 673410271256207610
-
Scan 161785869
- duration: 0:00:14.187884
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785869
- 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_moloMarinaLocationAmenitiesSet/2026-04-10/1775808181", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-10/1775808181/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1746413978369338701, "service_name": "drive-thru", "span_id": 12705753876260890861, "trace_id": 12189879081772158026 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-10 03:03:59
- success: True
- trace_id: 12189879081772158026
-
Scan 161730064
- duration: 0:00:14.190752
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730064
- 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_moloMarinaLocationAmenitiesSet/2026-04-09/1775721520", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-09/1775721520/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17744129979418876426, "service_name": "drive-thru", "span_id": 14520398126059209035, "trace_id": 16346881766935617649 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-09 03:01:27
- success: True
- trace_id: 16346881766935617649
-
Scan 161675635
- duration: 0:00:14.221562
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675635
- 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_moloMarinaLocationAmenitiesSet/2026-04-08/1775635349", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-08/1775635349/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16105750155375506927, "service_name": "drive-thru", "span_id": 1568103522135088256, "trace_id": 11993809513633567704 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-08 03:08:38
- success: True
- trace_id: 11993809513633567704
-
Scan 161618413
- duration: 0:00:11.564962
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618413
- 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_moloMarinaLocationAmenitiesSet/2026-04-07/1775548498", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-07/1775548498/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 674905087108124811, "service_name": "drive-thru", "span_id": 17526342726348497607, "trace_id": 11079863116218975754 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-07 02:57:19
- success: True
- trace_id: 11079863116218975754
-
Scan 161561411
- duration: 0:00:11.551880
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561411
- 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_moloMarinaLocationAmenitiesSet/2026-04-06/1775462465", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-06/1775462465/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5592027373430615899, "service_name": "drive-thru", "span_id": 1868637945820563947, "trace_id": 11091019890485332605 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-06 03:02:15
- success: True
- trace_id: 11091019890485332605
-
Scan 161514842
- duration: 0:00:14.134115
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514842
- 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_moloMarinaLocationAmenitiesSet/2026-04-05/1775376091", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-05/1775376091/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3842722113048228621, "service_name": "drive-thru", "span_id": 16020877864883100811, "trace_id": 13337569173001946466 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-05 03:03:46
- success: True
- trace_id: 13337569173001946466
-
Scan 161460250
- duration: 0:00:13.978866
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460250
- 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_moloMarinaLocationAmenitiesSet/2026-04-04/1775289574", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-04/1775289574/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11144204086326699052, "service_name": "drive-thru", "span_id": 8690442314593897637, "trace_id": 1160071458963060715 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-04 03:03:27
- success: True
- trace_id: 1160071458963060715
-
Scan 161401924
- duration: 0:00:11.665315
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401924
- 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_moloMarinaLocationAmenitiesSet/2026-04-03/1775203346", "key": "raw/molo_moloMarinaLocationAmenitiesSet/2026-04-03/1775203346/MarinaLocationAmenitiesSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloMarinaLocationAmenitiesSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2202858098508168163, "service_name": "drive-thru", "span_id": 11041108849808653574, "trace_id": 6898617211888870079 } } - running: False
- schema_name_id: 1662
- start_time: 2026-04-03 03:10:36
- success: True
- trace_id: 6898617211888870079
- attributes:
{ "Comments": "string", "Id": "string", "MarinaLocation_Id": "string", "Name": "string" } - created: 2026-04-17 03:04:36
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset" }
- 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:57:31",
"disabled": false,
"format": "raw",
"id": 1662,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_molomarinalocationamenitiesset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Comments": "string",
"Id": "string",
"MarinaLocation_Id": "string",
"Name": "string"
},
"created": "2026-04-17 03:04:36",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`\n(\n `Id` string , `Name` string , `Comments` 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_moloMarinaLocationAmenitiesSet/2026-04-17/1776412803'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molomarinalocationamenitiesset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molomarinalocationamenitiesset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}