Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloeventsv_employee

created: 2023-10-17 01:56:47
disabled: False
format: raw
id: 1642
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717602

created: 2026-04-17 03:02:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-17/1776412730
id: 1717602
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 162167369
updated: 2026-04-17 03:02:29

Version 1716338

created: 2026-04-16 03:04:38

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-16/1776326488
id: 1716338
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 162111699
updated: 2026-04-16 03:04:52

Version 1715167

created: 2026-04-15 03:02:44

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-15/1776239958
id: 1715167
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 162055782
updated: 2026-04-15 03:02:55

Version 1713958

created: 2026-04-14 03:03:27

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-14/1776153683
id: 1713958
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 162000385
updated: 2026-04-14 03:03:40

Version 1712761

created: 2026-04-13 02:57:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-13/1776066878
id: 1712761
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161941576
updated: 2026-04-13 02:57:44

Version 1711558

created: 2026-04-12 02:59:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-12/1775980593
id: 1711558
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161892439
updated: 2026-04-12 02:59:37

Version 1710403

created: 2026-04-11 03:04:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-11/1775894354
id: 1710403
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161841172
updated: 2026-04-11 03:04:50

Version 1709173

created: 2026-04-10 03:03:17

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-10/1775808111
id: 1709173
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161785839
updated: 2026-04-10 03:03:31

Version 1708070

created: 2026-04-09 03:01:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-09/1775721447
id: 1708070
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161730043
updated: 2026-04-09 03:01:27

Version 1706824

created: 2026-04-08 03:02:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-08/1775635256
id: 1706824
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161675365
updated: 2026-04-08 03:02:20

Version 1705655

created: 2026-04-07 02:55:08

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-07/1775548429
id: 1705655
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161618334
updated: 2026-04-07 02:55:19

Version 1704534

created: 2026-04-06 03:07:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-06/1775462396
id: 1704534
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161561644
updated: 2026-04-06 03:07:47

Version 1703266

created: 2026-04-05 03:03:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-05/1775376020
id: 1703266
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161514840
updated: 2026-04-05 03:03:54

Version 1702084

created: 2026-04-04 03:01:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-04/1775289504
id: 1702084
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161460015
updated: 2026-04-04 03:02:12

Version 1700818

created: 2026-04-03 03:03:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventSV_Employee/2026-04-03/1775203276
id: 1700818
processed: 1

raw_data:

{
    "Event_Id": 0,
    "SV_Employee_Id": 1
}

schema_attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

schema_name_id: 1642
schema_scan_id: 161401642
updated: 2026-04-03 03:03:44

Schema Scans: 15

Last at 2026-04-17 03:02:15

Scan 162167369

duration: 0:00:14.085560

exit_message:

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

id: 162167369

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_moloEventSV_Employee/2026-04-17/1776412730",
        "key": "raw/molo_moloEventSV_Employee/2026-04-17/1776412730/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17451126489770736361,
        "service_name": "drive-thru",
        "span_id": 1023690920429738342,
        "trace_id": 3497731072705310454
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-17 03:02:15
success: True
trace_id: 3497731072705310454

Scan 162111699

duration: 0:00:14.146297

exit_message:

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

id: 162111699

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_moloEventSV_Employee/2026-04-16/1776326488",
        "key": "raw/molo_moloEventSV_Employee/2026-04-16/1776326488/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 937928771612791740,
        "service_name": "drive-thru",
        "span_id": 14944126427431242076,
        "trace_id": 5535236542313734150
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-16 03:04:37
success: True
trace_id: 5535236542313734150

Scan 162055782

duration: 0:00:11.571474

exit_message:

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

id: 162055782

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_moloEventSV_Employee/2026-04-15/1776239958",
        "key": "raw/molo_moloEventSV_Employee/2026-04-15/1776239958/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14838861241162096648,
        "service_name": "drive-thru",
        "span_id": 12201339510514124821,
        "trace_id": 3294485770573578919
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-15 03:02:43
success: True
trace_id: 3294485770573578919

Scan 162000385

duration: 0:00:14.184550

exit_message:

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

id: 162000385

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_moloEventSV_Employee/2026-04-14/1776153683",
        "key": "raw/molo_moloEventSV_Employee/2026-04-14/1776153683/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15100069008186237370,
        "service_name": "drive-thru",
        "span_id": 646546121320154996,
        "trace_id": 12922230860783353482
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-14 03:03:26
success: True
trace_id: 12922230860783353482

Scan 161941576

duration: 0:00:14.086792

exit_message:

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

id: 161941576

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_moloEventSV_Employee/2026-04-13/1776066878",
        "key": "raw/molo_moloEventSV_Employee/2026-04-13/1776066878/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7957371974716328801,
        "service_name": "drive-thru",
        "span_id": 157058983516759757,
        "trace_id": 8589413798288403912
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-13 02:57:30
success: True
trace_id: 8589413798288403912

Scan 161892439

duration: 0:00:14.085340

exit_message:

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

id: 161892439

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_moloEventSV_Employee/2026-04-12/1775980593",
        "key": "raw/molo_moloEventSV_Employee/2026-04-12/1775980593/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8741390315467334840,
        "service_name": "drive-thru",
        "span_id": 5037919835891565809,
        "trace_id": 13849390532487778293
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-12 02:59:23
success: True
trace_id: 13849390532487778293

Scan 161841172

duration: 0:00:14.138027

exit_message:

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

id: 161841172

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_moloEventSV_Employee/2026-04-11/1775894354",
        "key": "raw/molo_moloEventSV_Employee/2026-04-11/1775894354/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11455089613916672916,
        "service_name": "drive-thru",
        "span_id": 10396613327476818717,
        "trace_id": 8804451814467288325
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-11 03:04:36
success: True
trace_id: 8804451814467288325

Scan 161785839

duration: 0:00:14.212647

exit_message:

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

id: 161785839

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_moloEventSV_Employee/2026-04-10/1775808111",
        "key": "raw/molo_moloEventSV_Employee/2026-04-10/1775808111/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13199394022467517210,
        "service_name": "drive-thru",
        "span_id": 15222283225538633870,
        "trace_id": 6439076316944159257
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-10 03:03:16
success: True
trace_id: 6439076316944159257

Scan 161730043

duration: 0:00:11.634268

exit_message:

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

id: 161730043

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_moloEventSV_Employee/2026-04-09/1775721447",
        "key": "raw/molo_moloEventSV_Employee/2026-04-09/1775721447/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8947649392518483976,
        "service_name": "drive-thru",
        "span_id": 5472755839952793702,
        "trace_id": 12994065076277862714
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-09 03:01:16
success: True
trace_id: 12994065076277862714

Scan 161675365

duration: 0:00:14.477617

exit_message:

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

id: 161675365

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_moloEventSV_Employee/2026-04-08/1775635256",
        "key": "raw/molo_moloEventSV_Employee/2026-04-08/1775635256/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14856865300467490678,
        "service_name": "drive-thru",
        "span_id": 11127230918163679924,
        "trace_id": 10524664514978364917
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-08 03:02:05
success: True
trace_id: 10524664514978364917

Scan 161618334

duration: 0:00:11.661280

exit_message:

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

id: 161618334

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_moloEventSV_Employee/2026-04-07/1775548429",
        "key": "raw/molo_moloEventSV_Employee/2026-04-07/1775548429/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12311033979239020550,
        "service_name": "drive-thru",
        "span_id": 18426214240555645784,
        "trace_id": 6294967713046696838
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-07 02:55:07
success: True
trace_id: 6294967713046696838

Scan 161561644

duration: 0:00:11.567268

exit_message:

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

id: 161561644

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_moloEventSV_Employee/2026-04-06/1775462396",
        "key": "raw/molo_moloEventSV_Employee/2026-04-06/1775462396/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5981758428536202905,
        "service_name": "drive-thru",
        "span_id": 2752911770221154999,
        "trace_id": 5004387062732463907
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-06 03:07:36
success: True
trace_id: 5004387062732463907

Scan 161514840

duration: 0:00:11.596077

exit_message:

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

id: 161514840

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_moloEventSV_Employee/2026-04-05/1775376020",
        "key": "raw/molo_moloEventSV_Employee/2026-04-05/1775376020/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15063450461490950633,
        "service_name": "drive-thru",
        "span_id": 9278330019317405930,
        "trace_id": 4670637827239872176
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-05 03:03:42
success: True
trace_id: 4670637827239872176

Scan 161460015

duration: 0:00:14.231891

exit_message:

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

id: 161460015

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_moloEventSV_Employee/2026-04-04/1775289504",
        "key": "raw/molo_moloEventSV_Employee/2026-04-04/1775289504/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5408819178087131175,
        "service_name": "drive-thru",
        "span_id": 12558694365602534286,
        "trace_id": 7680331209596728245
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-04 03:01:58
success: True
trace_id: 7680331209596728245

Scan 161401642

duration: 0:00:14.207240

exit_message:

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

id: 161401642

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_moloEventSV_Employee/2026-04-03/1775203276",
        "key": "raw/molo_moloEventSV_Employee/2026-04-03/1775203276/EventSV_Employee.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventSV_Employee",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8912271779326726890,
        "service_name": "drive-thru",
        "span_id": 11525278940499940687,
        "trace_id": 2562202780854805966
    }
}

running: False
schema_name_id: 1642
start_time: 2026-04-03 03:03:30
success: True
trace_id: 2562202780854805966

Partitions:

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

Schema:

attributes:

{
    "Event_Id": "string",
    "SV_Employee_Id": "string"
}

created: 2026-04-17 03:02:16

ddl:

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

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

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