Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloeventresources

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717604

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-17/1776412728
id: 1717604
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 162167370
updated: 2026-04-17 03:02:30

Version 1716484

created: 2026-04-16 03:10:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-16/1776326487
id: 1716484
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 162111926
updated: 2026-04-16 03:11:11

Version 1715173

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-15/1776239957
id: 1715173
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 162055820
updated: 2026-04-15 03:03:20

Version 1713993

created: 2026-04-14 03:04:55

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 162000440
updated: 2026-04-14 03:05:12

Version 1712750

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-13/1776066877
id: 1712750
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161941556
updated: 2026-04-13 02:57:15

Version 1711562

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

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161892516
updated: 2026-04-12 02:59:58

Version 1710401

created: 2026-04-11 03:04:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-11/1775894353
id: 1710401
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161841171
updated: 2026-04-11 03:04:49

Version 1709166

created: 2026-04-10 03:03:00

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-10/1775808108
id: 1709166
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161785816
updated: 2026-04-10 03:03:11

Version 1708064

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

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161730023
updated: 2026-04-09 03:01:16

Version 1706808

created: 2026-04-08 03:01:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-08/1775635255
id: 1706808
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161675334
updated: 2026-04-08 03:01:36

Version 1705654

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-07/1775548428
id: 1705654
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161618333
updated: 2026-04-07 02:55:18

Version 1704420

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

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161561425
updated: 2026-04-06 03:02:42

Version 1703281

created: 2026-04-05 03:04:21

ddl:

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

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

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161514858
updated: 2026-04-05 03:04:35

Version 1702076

created: 2026-04-04 03:01:42

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-04/1775289503
id: 1702076
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161459984
updated: 2026-04-04 03:01:55

Version 1700855

created: 2026-04-03 03:05:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloEventResources/2026-04-03/1775203275
id: 1700855
processed: 1

raw_data:

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

schema_attributes:

{
    "Event_Id": "string",
    "Resources_Id": "string"
}

schema_name_id: 1637
schema_scan_id: 161401757
updated: 2026-04-03 03:06:09

Schema Scans: 15

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

Scan 162167370

duration: 0:00:14.020283

exit_message:

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

id: 162167370

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_moloEventResources/2026-04-17/1776412728",
        "key": "raw/molo_moloEventResources/2026-04-17/1776412728/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2582538698339854623,
        "service_name": "drive-thru",
        "span_id": 1672933605289358710,
        "trace_id": 6482559425562468315
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-17 03:02:16
success: True
trace_id: 6482559425562468315

Scan 162111926

duration: 0:00:14.083337

exit_message:

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

id: 162111926

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_moloEventResources/2026-04-16/1776326487",
        "key": "raw/molo_moloEventResources/2026-04-16/1776326487/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15929610085596302767,
        "service_name": "drive-thru",
        "span_id": 6568669551780999816,
        "trace_id": 5169284423426367271
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-16 03:10:57
success: True
trace_id: 5169284423426367271

Scan 162055820

duration: 0:00:11.541210

exit_message:

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

id: 162055820

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_moloEventResources/2026-04-15/1776239957",
        "key": "raw/molo_moloEventResources/2026-04-15/1776239957/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1544757060014344469,
        "service_name": "drive-thru",
        "span_id": 8994242558590507013,
        "trace_id": 15046889577712899490
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-15 03:03:08
success: True
trace_id: 15046889577712899490

Scan 162000440

duration: 0:00:16.532092

exit_message:

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

id: 162000440

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_moloEventResources/2026-04-14/1776153683",
        "key": "raw/molo_moloEventResources/2026-04-14/1776153683/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15143723544334701499,
        "service_name": "drive-thru",
        "span_id": 8854176936354592181,
        "trace_id": 8749282554183736747
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-14 03:04:55
success: True
trace_id: 8749282554183736747

Scan 161941556

duration: 0:00:11.446121

exit_message:

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

id: 161941556

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_moloEventResources/2026-04-13/1776066877",
        "key": "raw/molo_moloEventResources/2026-04-13/1776066877/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12912872123805592585,
        "service_name": "drive-thru",
        "span_id": 13523792087524925922,
        "trace_id": 9808967174007543955
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-13 02:57:03
success: True
trace_id: 9808967174007543955

Scan 161892516

duration: 0:00:11.515249

exit_message:

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

id: 161892516

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_moloEventResources/2026-04-12/1775980593",
        "key": "raw/molo_moloEventResources/2026-04-12/1775980593/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17150474358859749561,
        "service_name": "drive-thru",
        "span_id": 15418146910719791988,
        "trace_id": 7023319630208683324
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-12 02:59:47
success: True
trace_id: 7023319630208683324

Scan 161841171

duration: 0:00:14.129124

exit_message:

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

id: 161841171

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_moloEventResources/2026-04-11/1775894353",
        "key": "raw/molo_moloEventResources/2026-04-11/1775894353/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17822236168660384394,
        "service_name": "drive-thru",
        "span_id": 4142889375928354677,
        "trace_id": 1618990522649165960
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-11 03:04:35
success: True
trace_id: 1618990522649165960

Scan 161785816

duration: 0:00:11.582659

exit_message:

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

id: 161785816

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_moloEventResources/2026-04-10/1775808108",
        "key": "raw/molo_moloEventResources/2026-04-10/1775808108/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6312804249837276785,
        "service_name": "drive-thru",
        "span_id": 16230433809968262670,
        "trace_id": 13927515314026566480
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-10 03:03:00
success: True
trace_id: 13927515314026566480

Scan 161730023

duration: 0:00:11.617023

exit_message:

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

id: 161730023

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_moloEventResources/2026-04-09/1775721447",
        "key": "raw/molo_moloEventResources/2026-04-09/1775721447/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1063347977263353980,
        "service_name": "drive-thru",
        "span_id": 7533503360761332537,
        "trace_id": 9163428533236791444
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-09 03:01:05
success: True
trace_id: 9163428533236791444

Scan 161675334

duration: 0:00:11.668624

exit_message:

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

id: 161675334

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_moloEventResources/2026-04-08/1775635255",
        "key": "raw/molo_moloEventResources/2026-04-08/1775635255/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1956845706887178160,
        "service_name": "drive-thru",
        "span_id": 7572591048827615787,
        "trace_id": 5552701228682728303
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-08 03:01:24
success: True
trace_id: 5552701228682728303

Scan 161618333

duration: 0:00:11.431172

exit_message:

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

id: 161618333

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_moloEventResources/2026-04-07/1775548428",
        "key": "raw/molo_moloEventResources/2026-04-07/1775548428/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8848773242879328762,
        "service_name": "drive-thru",
        "span_id": 9161712908968147714,
        "trace_id": 9216290320844947409
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-07 02:55:07
success: True
trace_id: 9216290320844947409

Scan 161561425

duration: 0:00:14.111547

exit_message:

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

id: 161561425

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_moloEventResources/2026-04-06/1775462396",
        "key": "raw/molo_moloEventResources/2026-04-06/1775462396/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10125895116315655614,
        "service_name": "drive-thru",
        "span_id": 174393048587984719,
        "trace_id": 8370797374806817415
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-06 03:02:28
success: True
trace_id: 8370797374806817415

Scan 161514858

duration: 0:00:14.036268

exit_message:

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

id: 161514858

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_moloEventResources/2026-04-05/1775376020",
        "key": "raw/molo_moloEventResources/2026-04-05/1775376020/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9657938774650860719,
        "service_name": "drive-thru",
        "span_id": 16453354484831878466,
        "trace_id": 9608050214813366722
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-05 03:04:21
success: True
trace_id: 9608050214813366722

Scan 161459984

duration: 0:00:14.061226

exit_message:

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

id: 161459984

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_moloEventResources/2026-04-04/1775289503",
        "key": "raw/molo_moloEventResources/2026-04-04/1775289503/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15581572743183361475,
        "service_name": "drive-thru",
        "span_id": 16204975591553831960,
        "trace_id": 10717053316202856479
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-04 03:01:41
success: True
trace_id: 10717053316202856479

Scan 161401757

duration: 0:00:11.529678

exit_message:

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

id: 161401757

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_moloEventResources/2026-04-03/1775203275",
        "key": "raw/molo_moloEventResources/2026-04-03/1775203275/EventResources.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloEventResources",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18193854780829522517,
        "service_name": "drive-thru",
        "span_id": 10258717635117393463,
        "trace_id": 9478463925069859923
    }
}

running: False
schema_name_id: 1637
start_time: 2026-04-03 03:05:58
success: True
trace_id: 9478463925069859923

Partitions:

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

Schema:

attributes:

{
    "Event_Id": "string",
    "Resources_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_moloeventresources`\n(\n `Event_Id`  string , `Resources_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_moloEventResources/2026-04-17/1776412728'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloeventresources`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloeventresources"
}

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:37",
        "disabled": false,
        "format": "raw",
        "id": 1637,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloeventresources"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Event_Id": "string",
            "Resources_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_moloeventresources`\n(\n `Event_Id`  string , `Resources_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_moloEventResources/2026-04-17/1776412728'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloeventresources`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloeventresources"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}