Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloaddonreservation

created: 2023-10-17 01:55:31
disabled: False
format: raw
id: 1605
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717553

created: 2026-04-17 02:59:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-17/1776412689
id: 1717553
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 162167139
updated: 2026-04-17 02:59:35

Version 1716333

created: 2026-04-16 03:04:20

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-16/1776326455
id: 1716333
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 162111686
updated: 2026-04-16 03:04:34

Version 1715112

created: 2026-04-15 02:59:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-15/1776239922
id: 1715112
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 162055574
updated: 2026-04-15 02:59:53

Version 1713948

created: 2026-04-14 03:02:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-14/1776153648
id: 1713948
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 162000369
updated: 2026-04-14 03:03:03

Version 1712703

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-13/1776066838
id: 1712703
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161941468
updated: 2026-04-13 02:55:20

Version 1711495

created: 2026-04-12 02:56:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-12/1775980559
id: 1711495
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161892245
updated: 2026-04-12 02:56:25

Version 1710310

created: 2026-04-11 03:00:16

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-11/1775894314
id: 1710310
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161840904
updated: 2026-04-11 03:00:30

Version 1709136

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-10/1775808072
id: 1709136
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161785743
updated: 2026-04-10 03:01:30

Version 1708015

created: 2026-04-09 02:58:33

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-09/1775721410
id: 1708015
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161729781
updated: 2026-04-09 02:58:44

Version 1706859

created: 2026-04-08 03:03:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-08/1775635218
id: 1706859
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161675439
updated: 2026-04-08 03:03:50

Version 1705615

created: 2026-04-07 02:53:37

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-07/1775548395
id: 1705615
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161618292
updated: 2026-04-07 02:53:49

Version 1704471

created: 2026-04-06 03:04:51

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-06/1775462358
id: 1704471
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161561548
updated: 2026-04-06 03:05:02

Version 1703194

created: 2026-04-05 03:00:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-05/1775375986
id: 1703194
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161514744
updated: 2026-04-05 03:01:01

Version 1702027

created: 2026-04-04 02:59:36

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-04/1775289474
id: 1702027
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161459796
updated: 2026-04-04 02:59:49

Version 1700926

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAddonReservation/2026-04-03/1775203243
id: 1700926
processed: 1

raw_data:

{
    "Addons_Id": 0,
    "Reservations_Id": 1
}

schema_attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

schema_name_id: 1605
schema_scan_id: 161401880
updated: 2026-04-03 03:09:28

Schema Scans: 15

Last at 2026-04-17 02:59:24

Scan 162167139

duration: 0:00:11.496145

exit_message:

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

id: 162167139

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_moloAddonReservation/2026-04-17/1776412689",
        "key": "raw/molo_moloAddonReservation/2026-04-17/1776412689/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15161884155308656702,
        "service_name": "drive-thru",
        "span_id": 10346207057661930326,
        "trace_id": 16853145770278005992
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-17 02:59:24
success: True
trace_id: 16853145770278005992

Scan 162111686

duration: 0:00:14.039368

exit_message:

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

id: 162111686

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_moloAddonReservation/2026-04-16/1776326455",
        "key": "raw/molo_moloAddonReservation/2026-04-16/1776326455/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7866429586073472236,
        "service_name": "drive-thru",
        "span_id": 10587673686876771049,
        "trace_id": 18415096479332037541
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-16 03:04:20
success: True
trace_id: 18415096479332037541

Scan 162055574

duration: 0:00:14.096724

exit_message:

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

id: 162055574

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_moloAddonReservation/2026-04-15/1776239922",
        "key": "raw/molo_moloAddonReservation/2026-04-15/1776239922/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8413295646996101751,
        "service_name": "drive-thru",
        "span_id": 16852625899909404105,
        "trace_id": 1963583325637758359
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-15 02:59:39
success: True
trace_id: 1963583325637758359

Scan 162000369

duration: 0:00:11.521034

exit_message:

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

id: 162000369

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_moloAddonReservation/2026-04-14/1776153648",
        "key": "raw/molo_moloAddonReservation/2026-04-14/1776153648/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9427718274541192364,
        "service_name": "drive-thru",
        "span_id": 8060802985532645026,
        "trace_id": 11577579228936714832
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-14 03:02:52
success: True
trace_id: 11577579228936714832

Scan 161941468

duration: 0:00:11.530437

exit_message:

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

id: 161941468

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_moloAddonReservation/2026-04-13/1776066838",
        "key": "raw/molo_moloAddonReservation/2026-04-13/1776066838/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14341438335749921656,
        "service_name": "drive-thru",
        "span_id": 16744835033977756782,
        "trace_id": 12333532454744568669
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-13 02:55:08
success: True
trace_id: 12333532454744568669

Scan 161892245

duration: 0:00:14.043465

exit_message:

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

id: 161892245

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_moloAddonReservation/2026-04-12/1775980559",
        "key": "raw/molo_moloAddonReservation/2026-04-12/1775980559/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7646245952389471485,
        "service_name": "drive-thru",
        "span_id": 8855037514435292738,
        "trace_id": 1084279084612861506
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-12 02:56:11
success: True
trace_id: 1084279084612861506

Scan 161840904

duration: 0:00:14.125121

exit_message:

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

id: 161840904

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_moloAddonReservation/2026-04-11/1775894314",
        "key": "raw/molo_moloAddonReservation/2026-04-11/1775894314/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15342096253735301934,
        "service_name": "drive-thru",
        "span_id": 10519647365820150387,
        "trace_id": 16713495185527888811
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-11 03:00:16
success: True
trace_id: 16713495185527888811

Scan 161785743

duration: 0:00:11.620517

exit_message:

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

id: 161785743

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_moloAddonReservation/2026-04-10/1775808072",
        "key": "raw/molo_moloAddonReservation/2026-04-10/1775808072/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 452110895390226069,
        "service_name": "drive-thru",
        "span_id": 11225952345597396249,
        "trace_id": 3269818894406811855
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-10 03:01:19
success: True
trace_id: 3269818894406811855

Scan 161729781

duration: 0:00:11.477713

exit_message:

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

id: 161729781

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_moloAddonReservation/2026-04-09/1775721410",
        "key": "raw/molo_moloAddonReservation/2026-04-09/1775721410/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12709594641636090378,
        "service_name": "drive-thru",
        "span_id": 14884294677585053595,
        "trace_id": 2173281425485139815
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-09 02:58:33
success: True
trace_id: 2173281425485139815

Scan 161675439

duration: 0:00:11.498482

exit_message:

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

id: 161675439

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_moloAddonReservation/2026-04-08/1775635218",
        "key": "raw/molo_moloAddonReservation/2026-04-08/1775635218/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7770610052435921825,
        "service_name": "drive-thru",
        "span_id": 9555313623773452,
        "trace_id": 13083455145101540713
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-08 03:03:39
success: True
trace_id: 13083455145101540713

Scan 161618292

duration: 0:00:11.496984

exit_message:

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

id: 161618292

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_moloAddonReservation/2026-04-07/1775548395",
        "key": "raw/molo_moloAddonReservation/2026-04-07/1775548395/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15141730063965120382,
        "service_name": "drive-thru",
        "span_id": 12677071037272196257,
        "trace_id": 15878697330571208590
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-07 02:53:37
success: True
trace_id: 15878697330571208590

Scan 161561548

duration: 0:00:11.411255

exit_message:

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

id: 161561548

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_moloAddonReservation/2026-04-06/1775462358",
        "key": "raw/molo_moloAddonReservation/2026-04-06/1775462358/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3355582843445898920,
        "service_name": "drive-thru",
        "span_id": 7286484184935044505,
        "trace_id": 2791538969098249250
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-06 03:04:50
success: True
trace_id: 2791538969098249250

Scan 161514744

duration: 0:00:11.517900

exit_message:

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

id: 161514744

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_moloAddonReservation/2026-04-05/1775375986",
        "key": "raw/molo_moloAddonReservation/2026-04-05/1775375986/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1938062516051594750,
        "service_name": "drive-thru",
        "span_id": 13772867469614063548,
        "trace_id": 7062645300768517652
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-05 03:00:49
success: True
trace_id: 7062645300768517652

Scan 161459796

duration: 0:00:13.991342

exit_message:

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

id: 161459796

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_moloAddonReservation/2026-04-04/1775289474",
        "key": "raw/molo_moloAddonReservation/2026-04-04/1775289474/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17329982471103013925,
        "service_name": "drive-thru",
        "span_id": 11552738987203519476,
        "trace_id": 7188332813804922875
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-04 02:59:35
success: True
trace_id: 7188332813804922875

Scan 161401880

duration: 0:00:14.048646

exit_message:

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

id: 161401880

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_moloAddonReservation/2026-04-03/1775203243",
        "key": "raw/molo_moloAddonReservation/2026-04-03/1775203243/AddonReservation.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAddonReservation",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6037912117147603355,
        "service_name": "drive-thru",
        "span_id": 4655697151495956325,
        "trace_id": 9792287017693158609
    }
}

running: False
schema_name_id: 1605
start_time: 2026-04-03 03:09:14
success: True
trace_id: 9792287017693158609

Partitions:

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

Schema:

attributes:

{
    "Addons_Id": "string",
    "Reservations_Id": "string"
}

created: 2026-04-17 02:59:24

ddl:

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

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:55:31",
        "disabled": false,
        "format": "raw",
        "id": 1605,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloaddonreservation"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Addons_Id": "string",
            "Reservations_Id": "string"
        },
        "created": "2026-04-17 02:59:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloaddonreservation`\n(\n `Addons_Id`  string , `Reservations_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_moloAddonReservation/2026-04-17/1776412689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloaddonreservation`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloaddonreservation"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}