Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloemailtokenset
- created: 2023-10-17 01:56:20
- disabled: False
- format: raw
- id: 1628
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloemailtokenset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717595
- created: 2026-04-17 03:01:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-17/1776412727'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-17/1776412727
- id: 1717595
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 162167325
- updated: 2026-04-17 03:02:00
-
Version 1716379
- created: 2026-04-16 03:06:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-16/1776326486'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-16/1776326486
- id: 1716379
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 162111784
- updated: 2026-04-16 03:07:03
-
Version 1715170
- created: 2026-04-15 03:02:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-15/1776239957'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-15/1776239957
- id: 1715170
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 162055794
- updated: 2026-04-15 03:03:06
-
Version 1714012
- created: 2026-04-14 03:05:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-14/1776153683'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-14/1776153683
- id: 1714012
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 162000489
- updated: 2026-04-14 03:06:08
-
Version 1712737
- created: 2026-04-13 02:56:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-13/1776066876'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-13/1776066876
- id: 1712737
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161941519
- updated: 2026-04-13 02:56:41
-
Version 1711560
- created: 2026-04-12 02:59:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-12/1775980591'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-12/1775980591
- id: 1711560
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161892510
- updated: 2026-04-12 03:00:00
-
Version 1710329
- created: 2026-04-11 03:01:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-11/1775894352'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-11/1775894352
- id: 1710329
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161840994
- updated: 2026-04-11 03:01:33
-
Version 1709168
- created: 2026-04-10 03:03:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-10/1775808107'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-10/1775808107
- id: 1709168
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161785829
- updated: 2026-04-10 03:03:18
-
Version 1708042
- created: 2026-04-09 02:59:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-09/1775721447'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-09/1775721447
- id: 1708042
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161729887
- updated: 2026-04-09 03:00:10
-
Version 1706802
- created: 2026-04-08 03:01:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-08/1775635254'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-08/1775635254
- id: 1706802
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161675315
- updated: 2026-04-08 03:01:24
-
Version 1705651
- created: 2026-04-07 02:54:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-07/1775548427'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-07/1775548427
- id: 1705651
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161618330
- updated: 2026-04-07 02:55:13
-
Version 1704528
- created: 2026-04-06 03:07:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-06/1775462395'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-06/1775462395
- id: 1704528
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161561632
- updated: 2026-04-06 03:07:34
-
Version 1703187
- created: 2026-04-05 03:00:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-05/1775376019'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-05/1775376019
- id: 1703187
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161514721
- updated: 2026-04-05 03:00:47
-
Version 1702066
- created: 2026-04-04 03:01:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-04/1775289503'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-04/1775289503
- id: 1702066
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161459919
- updated: 2026-04-04 03:01:25
-
Version 1700906
- created: 2026-04-03 03:08:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-03/1775203275'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEmailTokenSet/2026-04-03/1775203275
- id: 1700906
- processed: 1
- raw_data:
{ "Code": 1, "ContactId": 4, "Count": 2, "CreationTime": 3, "Id": 0, "MarinaId": 5 } - schema_attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - schema_name_id: 1628
- schema_scan_id: 161401853
- updated: 2026-04-03 03:08:41
Schema Scans: 15
Last at 2026-04-17 03:01:49
-
Scan 162167325
- duration: 0:00:11.791312
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167325
- 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_moloEmailTokenSet/2026-04-17/1776412727", "key": "raw/molo_moloEmailTokenSet/2026-04-17/1776412727/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2409068829106553561, "service_name": "drive-thru", "span_id": 9354775157301538556, "trace_id": 11370501830990102057 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-17 03:01:49
- success: True
- trace_id: 11370501830990102057
-
Scan 162111784
- duration: 0:00:14.345720
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162111784
- 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_moloEmailTokenSet/2026-04-16/1776326486", "key": "raw/molo_moloEmailTokenSet/2026-04-16/1776326486/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14638518195651515898, "service_name": "drive-thru", "span_id": 5915759665390480815, "trace_id": 2482094439555535799 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-16 03:06:49
- success: True
- trace_id: 2482094439555535799
-
Scan 162055794
- duration: 0:00:11.857936
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162055794
- 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_moloEmailTokenSet/2026-04-15/1776239957", "key": "raw/molo_moloEmailTokenSet/2026-04-15/1776239957/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12239635595998214061, "service_name": "drive-thru", "span_id": 6574627533143347945, "trace_id": 5866216578186575444 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-15 03:02:54
- success: True
- trace_id: 5866216578186575444
-
Scan 162000489
- duration: 0:00:14.318658
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000489
- 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_moloEmailTokenSet/2026-04-14/1776153683", "key": "raw/molo_moloEmailTokenSet/2026-04-14/1776153683/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12395299881910845417, "service_name": "drive-thru", "span_id": 9861151114226970307, "trace_id": 1490328156736985870 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-14 03:05:54
- success: True
- trace_id: 1490328156736985870
-
Scan 161941519
- duration: 0:00:14.240994
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941519
- 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_moloEmailTokenSet/2026-04-13/1776066876", "key": "raw/molo_moloEmailTokenSet/2026-04-13/1776066876/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3193403457849572135, "service_name": "drive-thru", "span_id": 4493055835491002355, "trace_id": 17861377660584810656 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-13 02:56:27
- success: True
- trace_id: 17861377660584810656
-
Scan 161892510
- duration: 0:00:14.515977
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892510
- 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_moloEmailTokenSet/2026-04-12/1775980591", "key": "raw/molo_moloEmailTokenSet/2026-04-12/1775980591/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7742821320396062478, "service_name": "drive-thru", "span_id": 16856928620251634244, "trace_id": 1888230965518193026 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-12 02:59:45
- success: True
- trace_id: 1888230965518193026
-
Scan 161840994
- duration: 0:00:14.323196
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161840994
- 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_moloEmailTokenSet/2026-04-11/1775894352", "key": "raw/molo_moloEmailTokenSet/2026-04-11/1775894352/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 714441518917869363, "service_name": "drive-thru", "span_id": 8284294100425727883, "trace_id": 1622757216261593390 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-11 03:01:19
- success: True
- trace_id: 1622757216261593390
-
Scan 161785829
- duration: 0:00:11.738402
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785829
- 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_moloEmailTokenSet/2026-04-10/1775808107", "key": "raw/molo_moloEmailTokenSet/2026-04-10/1775808107/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17210879626552544748, "service_name": "drive-thru", "span_id": 17361616358934481959, "trace_id": 2111796968115745277 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-10 03:03:07
- success: True
- trace_id: 2111796968115745277
-
Scan 161729887
- duration: 0:00:11.903274
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161729887
- 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_moloEmailTokenSet/2026-04-09/1775721447", "key": "raw/molo_moloEmailTokenSet/2026-04-09/1775721447/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6701336044501506760, "service_name": "drive-thru", "span_id": 15210355039685295426, "trace_id": 8512515611069823642 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-09 02:59:58
- success: True
- trace_id: 8512515611069823642
-
Scan 161675315
- duration: 0:00:14.317975
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675315
- 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_moloEmailTokenSet/2026-04-08/1775635254", "key": "raw/molo_moloEmailTokenSet/2026-04-08/1775635254/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7221454516105252398, "service_name": "drive-thru", "span_id": 7431659526610156484, "trace_id": 6025360540552032883 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-08 03:01:10
- success: True
- trace_id: 6025360540552032883
-
Scan 161618330
- duration: 0:00:14.408292
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618330
- 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_moloEmailTokenSet/2026-04-07/1775548427", "key": "raw/molo_moloEmailTokenSet/2026-04-07/1775548427/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3018797161193284690, "service_name": "drive-thru", "span_id": 7789371593144425435, "trace_id": 253194586314608564 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-07 02:54:59
- success: True
- trace_id: 253194586314608564
-
Scan 161561632
- duration: 0:00:14.311098
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561632
- 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_moloEmailTokenSet/2026-04-06/1775462395", "key": "raw/molo_moloEmailTokenSet/2026-04-06/1775462395/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1261239078756983239, "service_name": "drive-thru", "span_id": 17740271366638338133, "trace_id": 3074132752311174508 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-06 03:07:19
- success: True
- trace_id: 3074132752311174508
-
Scan 161514721
- duration: 0:00:14.273162
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514721
- 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_moloEmailTokenSet/2026-04-05/1775376019", "key": "raw/molo_moloEmailTokenSet/2026-04-05/1775376019/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12571209023835729975, "service_name": "drive-thru", "span_id": 1878700320847664750, "trace_id": 16678701507516129796 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-05 03:00:33
- success: True
- trace_id: 16678701507516129796
-
Scan 161459919
- duration: 0:00:11.791655
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161459919
- 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_moloEmailTokenSet/2026-04-04/1775289503", "key": "raw/molo_moloEmailTokenSet/2026-04-04/1775289503/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3858414646764208266, "service_name": "drive-thru", "span_id": 3259058344088777861, "trace_id": 17050735063039519917 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-04 03:01:13
- success: True
- trace_id: 17050735063039519917
-
Scan 161401853
- duration: 0:00:14.294107
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161401853
- 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_moloEmailTokenSet/2026-04-03/1775203275", "key": "raw/molo_moloEmailTokenSet/2026-04-03/1775203275/EmailTokenSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloEmailTokenSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13263969617935674347, "service_name": "drive-thru", "span_id": 3813456821087055698, "trace_id": 4107458978868839346 } } - running: False
- schema_name_id: 1628
- start_time: 2026-04-03 03:08:27
- success: True
- trace_id: 4107458978868839346
- attributes:
{ "Code": "string", "ContactId": "string", "Count": "string", "CreationTime": "string", "Id": "string", "MarinaId": "string" } - created: 2026-04-17 03:01:49
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-17/1776412727'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset" }
- 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:56:20",
"disabled": false,
"format": "raw",
"id": 1628,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloemailtokenset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Code": "string",
"ContactId": "string",
"Count": "string",
"CreationTime": "string",
"Id": "string",
"MarinaId": "string"
},
"created": "2026-04-17 03:01:49",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloemailtokenset`\n(\n `Id` string , `Code` string , `Count` string , `CreationTime` string , `ContactId` string , `MarinaId` 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_moloEmailTokenSet/2026-04-17/1776412727'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloemailtokenset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloemailtokenset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}