Schema Info

Schema Name: sfdl_prod_drivethru.molo_molooffersslip

created: 2023-10-17 01:58:27
disabled: False
format: raw
id: 1687
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717665

created: 2026-04-17 03:05:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-17/1776412807
id: 1717665
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 162167643
updated: 2026-04-17 03:06:11

Version 1716408

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-16/1776326563
id: 1716408
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 162111838
updated: 2026-04-16 03:08:17

Version 1715204

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-15/1776240033
id: 1715204
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 162055913
updated: 2026-04-15 03:05:01

Version 1714033

created: 2026-04-14 03:06:40

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-14/1776153761
id: 1714033
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 162000517
updated: 2026-04-14 03:06:51

Version 1712809

created: 2026-04-13 02:59:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-13/1776066955
id: 1712809
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161941769
updated: 2026-04-13 02:59:42

Version 1711618

created: 2026-04-12 03:01:34

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-12/1775980668
id: 1711618
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161892771
updated: 2026-04-12 03:01:46

Version 1710381

created: 2026-04-11 03:03:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-11/1775894429
id: 1710381
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161841125
updated: 2026-04-11 03:03:55

Version 1709201

created: 2026-04-10 03:04:27

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-10/1775808186
id: 1709201
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161785882
updated: 2026-04-10 03:04:39

Version 1708141

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-09/1775721525
id: 1708141
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161730304
updated: 2026-04-09 03:04:18

Version 1706939

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-08/1775635354
id: 1706939
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161675582
updated: 2026-04-08 03:07:21

Version 1705726

created: 2026-04-07 02:57:58

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-07/1775548503
id: 1705726
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161618440
updated: 2026-04-07 02:58:09

Version 1704450

created: 2026-04-06 03:03:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-06/1775462470
id: 1704450
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161561505
updated: 2026-04-06 03:04:00

Version 1703250

created: 2026-04-05 03:03:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-05/1775376095
id: 1703250
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161514820
updated: 2026-04-05 03:03:18

Version 1702124

created: 2026-04-04 03:03:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-04/1775289579
id: 1702124
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161460293
updated: 2026-04-04 03:04:04

Version 1701060

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOffersSlip/2026-04-03/1775203352
id: 1701060
processed: 1

raw_data:

{
    "Offers_Id": 0,
    "Slip_Id": 1
}

schema_attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

schema_name_id: 1687
schema_scan_id: 161402051
updated: 2026-04-03 03:15:44

Schema Scans: 15

Last at 2026-04-17 03:05:57

Scan 162167643

duration: 0:00:14.299601

exit_message:

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

id: 162167643

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_moloOffersSlip/2026-04-17/1776412807",
        "key": "raw/molo_moloOffersSlip/2026-04-17/1776412807/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7671649331772555649,
        "service_name": "drive-thru",
        "span_id": 8429437236365803961,
        "trace_id": 8326187770183026463
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-17 03:05:57
success: True
trace_id: 8326187770183026463

Scan 162111838

duration: 0:00:11.554926

exit_message:

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

id: 162111838

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_moloOffersSlip/2026-04-16/1776326563",
        "key": "raw/molo_moloOffersSlip/2026-04-16/1776326563/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5846439337727384586,
        "service_name": "drive-thru",
        "span_id": 12136299963624484872,
        "trace_id": 7078458151985065517
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-16 03:08:05
success: True
trace_id: 7078458151985065517

Scan 162055913

duration: 0:00:14.321420

exit_message:

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

id: 162055913

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_moloOffersSlip/2026-04-15/1776240033",
        "key": "raw/molo_moloOffersSlip/2026-04-15/1776240033/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3128485250528759381,
        "service_name": "drive-thru",
        "span_id": 4508190915947783313,
        "trace_id": 9381322664695845274
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-15 03:04:47
success: True
trace_id: 9381322664695845274

Scan 162000517

duration: 0:00:11.757550

exit_message:

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

id: 162000517

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_moloOffersSlip/2026-04-14/1776153761",
        "key": "raw/molo_moloOffersSlip/2026-04-14/1776153761/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 705829005833028353,
        "service_name": "drive-thru",
        "span_id": 3833070114021470635,
        "trace_id": 2076503532604485918
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-14 03:06:40
success: True
trace_id: 2076503532604485918

Scan 161941769

duration: 0:00:11.598172

exit_message:

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

id: 161941769

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_moloOffersSlip/2026-04-13/1776066955",
        "key": "raw/molo_moloOffersSlip/2026-04-13/1776066955/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17709688284211786324,
        "service_name": "drive-thru",
        "span_id": 14069187132956332301,
        "trace_id": 1770084349204986474
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-13 02:59:30
success: True
trace_id: 1770084349204986474

Scan 161892771

duration: 0:00:11.695153

exit_message:

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

id: 161892771

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_moloOffersSlip/2026-04-12/1775980668",
        "key": "raw/molo_moloOffersSlip/2026-04-12/1775980668/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8932454419997614100,
        "service_name": "drive-thru",
        "span_id": 10167215596396904366,
        "trace_id": 7537544976127366341
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-12 03:01:34
success: True
trace_id: 7537544976127366341

Scan 161841125

duration: 0:00:14.045797

exit_message:

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

id: 161841125

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_moloOffersSlip/2026-04-11/1775894429",
        "key": "raw/molo_moloOffersSlip/2026-04-11/1775894429/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18111755123537813933,
        "service_name": "drive-thru",
        "span_id": 2779694983336585895,
        "trace_id": 7567481236198567184
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-11 03:03:41
success: True
trace_id: 7567481236198567184

Scan 161785882

duration: 0:00:11.646500

exit_message:

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

id: 161785882

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_moloOffersSlip/2026-04-10/1775808186",
        "key": "raw/molo_moloOffersSlip/2026-04-10/1775808186/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2066393119040932388,
        "service_name": "drive-thru",
        "span_id": 2451618653790208431,
        "trace_id": 5089196913015919077
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-10 03:04:27
success: True
trace_id: 5089196913015919077

Scan 161730304

duration: 0:00:14.651099

exit_message:

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

id: 161730304

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_moloOffersSlip/2026-04-09/1775721525",
        "key": "raw/molo_moloOffersSlip/2026-04-09/1775721525/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11906214367365133340,
        "service_name": "drive-thru",
        "span_id": 7412669904394538345,
        "trace_id": 13367710845133536312
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-09 03:04:03
success: True
trace_id: 13367710845133536312

Scan 161675582

duration: 0:00:14.261516

exit_message:

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

id: 161675582

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_moloOffersSlip/2026-04-08/1775635354",
        "key": "raw/molo_moloOffersSlip/2026-04-08/1775635354/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5781408358608639777,
        "service_name": "drive-thru",
        "span_id": 8596937984697086391,
        "trace_id": 10474140390815509533
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-08 03:07:07
success: True
trace_id: 10474140390815509533

Scan 161618440

duration: 0:00:11.574276

exit_message:

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

id: 161618440

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_moloOffersSlip/2026-04-07/1775548503",
        "key": "raw/molo_moloOffersSlip/2026-04-07/1775548503/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10859363475184564242,
        "service_name": "drive-thru",
        "span_id": 13699125370515646239,
        "trace_id": 4555888904303162665
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-07 02:57:57
success: True
trace_id: 4555888904303162665

Scan 161561505

duration: 0:00:11.645029

exit_message:

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

id: 161561505

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_moloOffersSlip/2026-04-06/1775462470",
        "key": "raw/molo_moloOffersSlip/2026-04-06/1775462470/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2302723294330168673,
        "service_name": "drive-thru",
        "span_id": 8677555652388590956,
        "trace_id": 12827776737566419484
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-06 03:03:48
success: True
trace_id: 12827776737566419484

Scan 161514820

duration: 0:00:11.645987

exit_message:

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

id: 161514820

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_moloOffersSlip/2026-04-05/1775376095",
        "key": "raw/molo_moloOffersSlip/2026-04-05/1775376095/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 517935193523470307,
        "service_name": "drive-thru",
        "span_id": 18391072934638257985,
        "trace_id": 2684483987985493087
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-05 03:03:06
success: True
trace_id: 2684483987985493087

Scan 161460293

duration: 0:00:14.141704

exit_message:

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

id: 161460293

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_moloOffersSlip/2026-04-04/1775289579",
        "key": "raw/molo_moloOffersSlip/2026-04-04/1775289579/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7151174331079772925,
        "service_name": "drive-thru",
        "span_id": 6649912188255129837,
        "trace_id": 2022965677562594873
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-04 03:03:50
success: True
trace_id: 2022965677562594873

Scan 161402051

duration: 0:00:14.250955

exit_message:

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

id: 161402051

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_moloOffersSlip/2026-04-03/1775203352",
        "key": "raw/molo_moloOffersSlip/2026-04-03/1775203352/OffersSlip.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOffersSlip",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10443424224076093130,
        "service_name": "drive-thru",
        "span_id": 4339853397089731752,
        "trace_id": 15909899830584255492
    }
}

running: False
schema_name_id: 1687
start_time: 2026-04-03 03:15:29
success: True
trace_id: 15909899830584255492

Partitions:

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

Schema:

attributes:

{
    "Offers_Id": "string",
    "Slip_Id": "string"
}

created: 2026-04-17 03:05:57

ddl:

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

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