Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloofferpaymentmethodset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717660

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-17/1776412807
id: 1717660
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 162167633
updated: 2026-04-17 03:05:57

Version 1716426

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-16/1776326561
id: 1716426
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 162111861
updated: 2026-04-16 03:08:59

Version 1715273

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-15/1776240030
id: 1715273
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 162056021
updated: 2026-04-15 03:07:58

Version 1714070

created: 2026-04-14 03:08:11

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-14/1776153759
id: 1714070
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 162000569
updated: 2026-04-14 03:08:22

Version 1712794

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-13/1776066953
id: 1712794
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161941737
updated: 2026-04-13 02:59:18

Version 1711617

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-12/1775980666
id: 1711617
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161892770
updated: 2026-04-12 03:01:48

Version 1710472

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-11/1775894427
id: 1710472
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161841262
updated: 2026-04-11 03:07:34

Version 1709194

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-10/1775808184
id: 1709194
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161785875
updated: 2026-04-10 03:04:24

Version 1708157

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-09/1775721524
id: 1708157
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161730354
updated: 2026-04-09 03:05:12

Version 1706940

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-08/1775635354
id: 1706940
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161675583
updated: 2026-04-08 03:07:19

Version 1705702

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-07/1775548501
id: 1705702
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161618402
updated: 2026-04-07 02:57:14

Version 1704437

created: 2026-04-06 03:03:18

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-06/1775462468
id: 1704437
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161561478
updated: 2026-04-06 03:03:31

Version 1703329

created: 2026-04-05 03:06:22

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-05/1775376094
id: 1703329
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161514910
updated: 2026-04-05 03:06:36

Version 1702122

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-04/1775289577
id: 1702122
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161460289
updated: 2026-04-04 03:04:02

Version 1700973

created: 2026-04-03 03:11:06

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloOfferPaymentMethodSet/2026-04-03/1775203350
id: 1700973
processed: 1
raw_data:
```
{
    "Id": 0,
    "Name": 1
}
```

schema_attributes:

{
    "Id": "string",
    "Name": "string"
}

schema_name_id: 1623
schema_scan_id: 161401942
updated: 2026-04-03 03:11:19

Schema Scans: 15

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

Scan 162167633

duration: 0:00:14.024388

exit_message:

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

id: 162167633

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_moloOfferPaymentMethodSet/2026-04-17/1776412807",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-17/1776412807/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2532970052370136223,
        "service_name": "drive-thru",
        "span_id": 7599895747262546195,
        "trace_id": 8788553176493612466
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-17 03:05:43
success: True
trace_id: 8788553176493612466

Scan 162111861

duration: 0:00:14.043347

exit_message:

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

id: 162111861

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_moloOfferPaymentMethodSet/2026-04-16/1776326561",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-16/1776326561/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15467826508260133730,
        "service_name": "drive-thru",
        "span_id": 446672135272684424,
        "trace_id": 2130609808576981881
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-16 03:08:45
success: True
trace_id: 2130609808576981881

Scan 162056021

duration: 0:00:14.059491

exit_message:

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

id: 162056021

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_moloOfferPaymentMethodSet/2026-04-15/1776240030",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-15/1776240030/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14237549851894821259,
        "service_name": "drive-thru",
        "span_id": 4937232851796297544,
        "trace_id": 18239685270896974428
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-15 03:07:44
success: True
trace_id: 18239685270896974428

Scan 162000569

duration: 0:00:11.567014

exit_message:

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

id: 162000569

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_moloOfferPaymentMethodSet/2026-04-14/1776153759",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-14/1776153759/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12150922880209736092,
        "service_name": "drive-thru",
        "span_id": 17008224565224679978,
        "trace_id": 15833079832739156273
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-14 03:08:11
success: True
trace_id: 15833079832739156273

Scan 161941737

duration: 0:00:11.463082

exit_message:

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

id: 161941737

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_moloOfferPaymentMethodSet/2026-04-13/1776066953",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-13/1776066953/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6288576758769443091,
        "service_name": "drive-thru",
        "span_id": 2407551426386833405,
        "trace_id": 1462885288109571878
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-13 02:59:07
success: True
trace_id: 1462885288109571878

Scan 161892770

duration: 0:00:13.970022

exit_message:

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

id: 161892770

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_moloOfferPaymentMethodSet/2026-04-12/1775980666",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-12/1775980666/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5350825085737760303,
        "service_name": "drive-thru",
        "span_id": 15059627874006061283,
        "trace_id": 16416702981832213896
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-12 03:01:34
success: True
trace_id: 16416702981832213896

Scan 161841262

duration: 0:00:14.068082

exit_message:

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

id: 161841262

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_moloOfferPaymentMethodSet/2026-04-11/1775894427",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-11/1775894427/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6245726313157051475,
        "service_name": "drive-thru",
        "span_id": 10151478360522293658,
        "trace_id": 15291501134789819052
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-11 03:07:20
success: True
trace_id: 15291501134789819052

Scan 161785875

duration: 0:00:11.521852

exit_message:

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

id: 161785875

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_moloOfferPaymentMethodSet/2026-04-10/1775808184",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-10/1775808184/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6488485554138074049,
        "service_name": "drive-thru",
        "span_id": 13054623433585182565,
        "trace_id": 8286014200580997630
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-10 03:04:12
success: True
trace_id: 8286014200580997630

Scan 161730354

duration: 0:00:14.113612

exit_message:

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

id: 161730354

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_moloOfferPaymentMethodSet/2026-04-09/1775721524",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-09/1775721524/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10459552378068617653,
        "service_name": "drive-thru",
        "span_id": 5191496759138812594,
        "trace_id": 17639608256081893509
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-09 03:04:58
success: True
trace_id: 17639608256081893509

Scan 161675583

duration: 0:00:11.497472

exit_message:

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

id: 161675583

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_moloOfferPaymentMethodSet/2026-04-08/1775635354",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-08/1775635354/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1473854828678065751,
        "service_name": "drive-thru",
        "span_id": 9065247758692951915,
        "trace_id": 11273160559721798327
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-08 03:07:08
success: True
trace_id: 11273160559721798327

Scan 161618402

duration: 0:00:13.949778

exit_message:

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

id: 161618402

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_moloOfferPaymentMethodSet/2026-04-07/1775548501",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-07/1775548501/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16334439030050268423,
        "service_name": "drive-thru",
        "span_id": 405967867902948593,
        "trace_id": 15420295422892425407
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-07 02:57:00
success: True
trace_id: 15420295422892425407

Scan 161561478

duration: 0:00:13.990042

exit_message:

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

id: 161561478

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_moloOfferPaymentMethodSet/2026-04-06/1775462468",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-06/1775462468/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10884684010934153724,
        "service_name": "drive-thru",
        "span_id": 7930669562424965567,
        "trace_id": 4923452227459426072
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-06 03:03:18
success: True
trace_id: 4923452227459426072

Scan 161514910

duration: 0:00:14.096521

exit_message:

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

id: 161514910

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_moloOfferPaymentMethodSet/2026-04-05/1775376094",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-05/1775376094/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10852858563472798747,
        "service_name": "drive-thru",
        "span_id": 13810528632732616602,
        "trace_id": 4415456986110368841
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-05 03:06:22
success: True
trace_id: 4415456986110368841

Scan 161460289

duration: 0:00:14.098539

exit_message:

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

id: 161460289

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_moloOfferPaymentMethodSet/2026-04-04/1775289577",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-04/1775289577/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6277199258963310028,
        "service_name": "drive-thru",
        "span_id": 4670011811415529764,
        "trace_id": 8303280982513516440
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-04 03:03:48
success: True
trace_id: 8303280982513516440

Scan 161401942

duration: 0:00:14.139546

exit_message:

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

id: 161401942

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_moloOfferPaymentMethodSet/2026-04-03/1775203350",
        "key": "raw/molo_moloOfferPaymentMethodSet/2026-04-03/1775203350/OfferPaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloOfferPaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3016903422673242489,
        "service_name": "drive-thru",
        "span_id": 2807374862615416669,
        "trace_id": 201578948227143112
    }
}

running: False
schema_name_id: 1623
start_time: 2026-04-03 03:11:05
success: True
trace_id: 201578948227143112

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "Name": "string"
}

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

ddl:

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

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