Schema Info

Schema Name: sfdl_prod_drivethru.molo_molosv_serviceresourceevent

created: 2023-10-17 02:01:41
disabled: False
format: raw
id: 1778
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717776

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126
id: 1717776
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 162167800
updated: 2026-04-17 03:10:51

Version 1716586

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-16/1776326730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-16/1776326730
id: 1716586
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 162112050
updated: 2026-04-16 03:15:02

Version 1715321

created: 2026-04-15 03:10:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-15/1776240197'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-15/1776240197
id: 1715321
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 162056109
updated: 2026-04-15 03:10:12

Version 1714112

created: 2026-04-14 03:09:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-14/1776154163'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-14/1776154163
id: 1714112
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 162000625
updated: 2026-04-14 03:10:00

Version 1712927

created: 2026-04-13 03:05:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-13/1776067159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-13/1776067159
id: 1712927
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161942686
updated: 2026-04-13 03:05:17

Version 1711778

created: 2026-04-12 03:09:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-12/1775980859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-12/1775980859
id: 1711778
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161893513
updated: 2026-04-12 03:14:44

Version 1710551

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-11/1775894626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-11/1775894626
id: 1710551
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161841355
updated: 2026-04-11 03:10:42

Version 1709415

created: 2026-04-10 03:12:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-10/1775808387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-10/1775808387
id: 1709415
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161786123
updated: 2026-04-10 03:13:05

Version 1708276

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-09/1775721716'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-09/1775721716
id: 1708276
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161730570
updated: 2026-04-09 03:10:22

Version 1706944

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-08/1775635548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-08/1775635548
id: 1706944
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161675590
updated: 2026-04-08 03:07:34

Version 1705874

created: 2026-04-07 03:04:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-07/1775548710'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-07/1775548710
id: 1705874
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161619444
updated: 2026-04-07 03:04:56

Version 1704557

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-06/1775462659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-06/1775462659
id: 1704557
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161561671
updated: 2026-04-06 03:08:35

Version 1703422

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-05/1775376291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-05/1775376291
id: 1703422
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161515008
updated: 2026-04-05 03:10:03

Version 1702233

created: 2026-04-04 03:09:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-04/1775289773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-04/1775289773
id: 1702233
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161460522
updated: 2026-04-04 03:09:17

Version 1701055

created: 2026-04-03 03:15:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-03/1775203539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-03/1775203539
id: 1701055
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

schema_name_id: 1778
schema_scan_id: 161402044
updated: 2026-04-03 03:15:18

Schema Scans: 15

Last at 2026-04-17 03:10:37

Scan 162167800

duration: 0:00:14.076786

exit_message:

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

id: 162167800

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12854227712176941650,
        "service_name": "drive-thru",
        "span_id": 11318369617992772138,
        "trace_id": 9105666847757879099
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-17 03:10:37
success: True
trace_id: 9105666847757879099

Scan 162112050

duration: 0:00:11.509536

exit_message:

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

id: 162112050

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-16/1776326730",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-16/1776326730/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10107838152005074520,
        "service_name": "drive-thru",
        "span_id": 8632360436695724872,
        "trace_id": 7139265650348494428
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-16 03:14:50
success: True
trace_id: 7139265650348494428

Scan 162056109

duration: 0:00:11.830325

exit_message:

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

id: 162056109

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-15/1776240197",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-15/1776240197/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 62235871541226659,
        "service_name": "drive-thru",
        "span_id": 17554032003097004009,
        "trace_id": 13358395436921344225
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-15 03:10:00
success: True
trace_id: 13358395436921344225

Scan 162000625

duration: 0:00:11.470296

exit_message:

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

id: 162000625

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-14/1776154163",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-14/1776154163/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14000834386974226644,
        "service_name": "drive-thru",
        "span_id": 10337420823444516522,
        "trace_id": 8973925378232808577
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-14 03:09:49
success: True
trace_id: 8973925378232808577

Scan 161942686

duration: 0:00:14.193225

exit_message:

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

id: 161942686

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-13/1776067159",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-13/1776067159/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13411441912324215361,
        "service_name": "drive-thru",
        "span_id": 18222402103897746744,
        "trace_id": 15170819279040184476
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-13 03:05:03
success: True
trace_id: 15170819279040184476

Scan 161893513

duration: 0:05:01.259813

exit_message:

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

id: 161893513

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-12/1775980859",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-12/1775980859/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 53596416236391891,
        "service_name": "drive-thru",
        "span_id": 12427193976090370207,
        "trace_id": 3228696078778495066
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-12 03:09:42
success: True
trace_id: 3228696078778495066

Scan 161841355

duration: 0:00:14.063128

exit_message:

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

id: 161841355

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-11/1775894626",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-11/1775894626/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17176763780641709017,
        "service_name": "drive-thru",
        "span_id": 11481787218902413846,
        "trace_id": 7899492666289002544
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-11 03:10:28
success: True
trace_id: 7899492666289002544

Scan 161786123

duration: 0:00:14.086358

exit_message:

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

id: 161786123

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-10/1775808387",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-10/1775808387/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8259050543394520089,
        "service_name": "drive-thru",
        "span_id": 6536673997622866967,
        "trace_id": 4000475139904471985
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-10 03:12:51
success: True
trace_id: 4000475139904471985

Scan 161730570

duration: 0:00:11.542186

exit_message:

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

id: 161730570

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-09/1775721716",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-09/1775721716/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5123671172142358279,
        "service_name": "drive-thru",
        "span_id": 15200165218048317759,
        "trace_id": 13830961429976614755
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-09 03:10:11
success: True
trace_id: 13830961429976614755

Scan 161675590

duration: 0:00:14.042261

exit_message:

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

id: 161675590

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-08/1775635548",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-08/1775635548/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17381199122113090611,
        "service_name": "drive-thru",
        "span_id": 13076874901697846892,
        "trace_id": 9964773787770155843
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-08 03:07:20
success: True
trace_id: 9964773787770155843

Scan 161619444

duration: 0:00:11.570912

exit_message:

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

id: 161619444

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-07/1775548710",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-07/1775548710/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15553696428900762033,
        "service_name": "drive-thru",
        "span_id": 13815808263089435164,
        "trace_id": 15511941350221174633
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-07 03:04:45
success: True
trace_id: 15511941350221174633

Scan 161561671

duration: 0:00:14.038897

exit_message:

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

id: 161561671

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-06/1775462659",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-06/1775462659/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13694043912456939004,
        "service_name": "drive-thru",
        "span_id": 10075707905276497953,
        "trace_id": 9772646221973453823
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-06 03:08:21
success: True
trace_id: 9772646221973453823

Scan 161515008

duration: 0:00:11.493467

exit_message:

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

id: 161515008

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-05/1775376291",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-05/1775376291/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5600178069034082192,
        "service_name": "drive-thru",
        "span_id": 15720942220926936586,
        "trace_id": 14673316565531194418
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-05 03:09:51
success: True
trace_id: 14673316565531194418

Scan 161460522

duration: 0:00:14.000432

exit_message:

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

id: 161460522

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-04/1775289773",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-04/1775289773/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12142983540390155865,
        "service_name": "drive-thru",
        "span_id": 1174185631990769157,
        "trace_id": 7301036524219133486
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-04 03:09:03
success: True
trace_id: 7301036524219133486

Scan 161402044

duration: 0:00:14.066261

exit_message:

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

id: 161402044

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-03/1775203539",
        "key": "raw/molo_moloSV_ServiceResourceEvent/2026-04-03/1775203539/SV_ServiceResourceEvent.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloSV_ServiceResourceEvent",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17716303505080095834,
        "service_name": "drive-thru",
        "span_id": 2931646871980521159,
        "trace_id": 4087964196797950257
    }
}

running: False
schema_name_id: 1778
start_time: 2026-04-03 03:15:04
success: True
trace_id: 4087964196797950257

Partitions:

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

Schema:

attributes:

{
    "Event_Id": "string",
    "SV_ServiceResource_Id": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:01:41",
        "disabled": false,
        "format": "raw",
        "id": 1778,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molosv_serviceresourceevent"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Event_Id": "string",
            "SV_ServiceResource_Id": "string"
        },
        "created": "2026-04-17 03:10:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molosv_serviceresourceevent`\n(\n `SV_ServiceResource_Id`  string , `Event_Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSV_ServiceResourceEvent/2026-04-17/1776413126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molosv_serviceresourceevent`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molosv_serviceresourceevent"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}