Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717543

created: 2026-04-17 02:58:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-17/1776412688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-17/1776412688
id: 1717543
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 162167084
updated: 2026-04-17 02:59:01

Version 1716417

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-16/1776326451'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-16/1776326451
id: 1716417
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 162111851
updated: 2026-04-16 03:08:39

Version 1715118

created: 2026-04-15 03:00:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-15/1776239925'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-15/1776239925
id: 1715118
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 162055615
updated: 2026-04-15 03:00:26

Version 1713941

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-14/1776153646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-14/1776153646
id: 1713941
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 162000349
updated: 2026-04-14 03:02:34

Version 1712688

created: 2026-04-13 02:54:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-13/1776066837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-13/1776066837
id: 1712688
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161941444
updated: 2026-04-13 02:54:38

Version 1711504

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-12/1775980557'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-12/1775980557
id: 1711504
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161892261
updated: 2026-04-12 02:56:49

Version 1710303

created: 2026-04-11 02:59:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-11/1775894318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-11/1775894318
id: 1710303
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161840848
updated: 2026-04-11 02:59:57

Version 1709195

created: 2026-04-10 03:04:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-10/1775808073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-10/1775808073
id: 1709195
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161785876
updated: 2026-04-10 03:04:28

Version 1708011

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-09/1775721411'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-09/1775721411
id: 1708011
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161729772
updated: 2026-04-09 02:58:41

Version 1706821

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-08/1775635222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-08/1775635222
id: 1706821
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161675361
updated: 2026-04-08 03:02:15

Version 1705610

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-07/1775548391'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-07/1775548391
id: 1705610
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161618287
updated: 2026-04-07 02:53:45

Version 1704398

created: 2026-04-06 03:01:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-06/1775462356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-06/1775462356
id: 1704398
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161561367
updated: 2026-04-06 03:01:35

Version 1703173

created: 2026-04-05 02:59:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-05/1775375984'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-05/1775375984
id: 1703173
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161514671
updated: 2026-04-05 03:00:05

Version 1702049

created: 2026-04-04 03:00:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-04/1775289474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

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

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161459857
updated: 2026-04-04 03:00:47

Version 1700841

created: 2026-04-03 03:05:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-03/1775203244'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAllowedPaymentMethodsSet/2026-04-03/1775203244
id: 1700841
processed: 1

raw_data:

{
    "CreditCardGas": 4,
    "CreditCardMarina": 6,
    "CreditCardService": 5,
    "Id": 0,
    "MarinaLocation_Id": 7,
    "eCheckGas": 1,
    "eCheckMarina": 2,
    "eCheckService": 3
}

schema_attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

schema_name_id: 1592
schema_scan_id: 161401728
updated: 2026-04-03 03:05:30

Schema Scans: 15

Last at 2026-04-17 02:58:47

Scan 162167084

duration: 0:00:14.257834

exit_message:

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

id: 162167084

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_moloAllowedPaymentMethodsSet/2026-04-17/1776412688",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-17/1776412688/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5678344233483239605,
        "service_name": "drive-thru",
        "span_id": 14342676822623290086,
        "trace_id": 6718374828127560898
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-17 02:58:47
success: True
trace_id: 6718374828127560898

Scan 162111851

duration: 0:00:11.742454

exit_message:

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

id: 162111851

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_moloAllowedPaymentMethodsSet/2026-04-16/1776326451",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-16/1776326451/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14677252213780015796,
        "service_name": "drive-thru",
        "span_id": 11134370347834801806,
        "trace_id": 16974014608129452512
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-16 03:08:28
success: True
trace_id: 16974014608129452512

Scan 162055615

duration: 0:00:14.400058

exit_message:

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

id: 162055615

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_moloAllowedPaymentMethodsSet/2026-04-15/1776239925",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-15/1776239925/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1803242892154443827,
        "service_name": "drive-thru",
        "span_id": 13172602105363888195,
        "trace_id": 6172994943176621271
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-15 03:00:11
success: True
trace_id: 6172994943176621271

Scan 162000349

duration: 0:00:14.383215

exit_message:

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

id: 162000349

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_moloAllowedPaymentMethodsSet/2026-04-14/1776153646",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-14/1776153646/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7475297911375704921,
        "service_name": "drive-thru",
        "span_id": 2171265474990450134,
        "trace_id": 8602184623202246460
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-14 03:02:19
success: True
trace_id: 8602184623202246460

Scan 161941444

duration: 0:00:11.619588

exit_message:

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

id: 161941444

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_moloAllowedPaymentMethodsSet/2026-04-13/1776066837",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-13/1776066837/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16362718974537679034,
        "service_name": "drive-thru",
        "span_id": 9656538810699798187,
        "trace_id": 15845106505642665602
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-13 02:54:27
success: True
trace_id: 15845106505642665602

Scan 161892261

duration: 0:00:14.152163

exit_message:

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

id: 161892261

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_moloAllowedPaymentMethodsSet/2026-04-12/1775980557",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-12/1775980557/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5856503053579965144,
        "service_name": "drive-thru",
        "span_id": 14225048593696914707,
        "trace_id": 1641602313384809722
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-12 02:56:34
success: True
trace_id: 1641602313384809722

Scan 161840848

duration: 0:00:14.252293

exit_message:

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

id: 161840848

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_moloAllowedPaymentMethodsSet/2026-04-11/1775894318",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-11/1775894318/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12491709333815465001,
        "service_name": "drive-thru",
        "span_id": 7282832269715645786,
        "trace_id": 7038309249581955087
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-11 02:59:42
success: True
trace_id: 7038309249581955087

Scan 161785876

duration: 0:00:14.417305

exit_message:

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

id: 161785876

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_moloAllowedPaymentMethodsSet/2026-04-10/1775808073",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-10/1775808073/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10335991708077223461,
        "service_name": "drive-thru",
        "span_id": 1549718935380636242,
        "trace_id": 16576152536486276429
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-10 03:04:13
success: True
trace_id: 16576152536486276429

Scan 161729772

duration: 0:00:11.775935

exit_message:

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

id: 161729772

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_moloAllowedPaymentMethodsSet/2026-04-09/1775721411",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-09/1775721411/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7413689539771127579,
        "service_name": "drive-thru",
        "span_id": 14349286642865710350,
        "trace_id": 2187699989064077620
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-09 02:58:29
success: True
trace_id: 2187699989064077620

Scan 161675361

duration: 0:00:14.371655

exit_message:

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

id: 161675361

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_moloAllowedPaymentMethodsSet/2026-04-08/1775635222",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-08/1775635222/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 365300422195451627,
        "service_name": "drive-thru",
        "span_id": 2288206769128541959,
        "trace_id": 16801270672527668653
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-08 03:02:01
success: True
trace_id: 16801270672527668653

Scan 161618287

duration: 0:00:11.784217

exit_message:

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

id: 161618287

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_moloAllowedPaymentMethodsSet/2026-04-07/1775548391",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-07/1775548391/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7912930656342059763,
        "service_name": "drive-thru",
        "span_id": 110566990601942078,
        "trace_id": 3953875149047510807
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-07 02:53:34
success: True
trace_id: 3953875149047510807

Scan 161561367

duration: 0:00:11.682624

exit_message:

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

id: 161561367

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_moloAllowedPaymentMethodsSet/2026-04-06/1775462356",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-06/1775462356/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6729025375973347500,
        "service_name": "drive-thru",
        "span_id": 218982351200050128,
        "trace_id": 1840397185049619577
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-06 03:01:23
success: True
trace_id: 1840397185049619577

Scan 161514671

duration: 0:00:14.408895

exit_message:

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

id: 161514671

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_moloAllowedPaymentMethodsSet/2026-04-05/1775375984",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-05/1775375984/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17474132304582097186,
        "service_name": "drive-thru",
        "span_id": 1805251832577336685,
        "trace_id": 8299220572627516919
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-05 02:59:51
success: True
trace_id: 8299220572627516919

Scan 161459857

duration: 0:00:14.150467

exit_message:

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

id: 161459857

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_moloAllowedPaymentMethodsSet/2026-04-04/1775289474",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-04/1775289474/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9224698227049741908,
        "service_name": "drive-thru",
        "span_id": 1114727101685900937,
        "trace_id": 11841611559392525434
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-04 03:00:33
success: True
trace_id: 11841611559392525434

Scan 161401728

duration: 0:00:14.346876

exit_message:

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

id: 161401728

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_moloAllowedPaymentMethodsSet/2026-04-03/1775203244",
        "key": "raw/molo_moloAllowedPaymentMethodsSet/2026-04-03/1775203244/AllowedPaymentMethodsSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAllowedPaymentMethodsSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1233453133432284763,
        "service_name": "drive-thru",
        "span_id": 15470392710806353493,
        "trace_id": 11118387356051506428
    }
}

running: False
schema_name_id: 1592
start_time: 2026-04-03 03:05:16
success: True
trace_id: 11118387356051506428

Partitions:

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

Schema:

attributes:

{
    "CreditCardGas": "string",
    "CreditCardMarina": "string",
    "CreditCardService": "string",
    "Id": "string",
    "MarinaLocation_Id": "string",
    "eCheckGas": "string",
    "eCheckMarina": "string",
    "eCheckService": "string"
}

created: 2026-04-17 02:58:47

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-17/1776412688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
}

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:07",
        "disabled": false,
        "format": "raw",
        "id": 1592,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloallowedpaymentmethodsset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreditCardGas": "string",
            "CreditCardMarina": "string",
            "CreditCardService": "string",
            "Id": "string",
            "MarinaLocation_Id": "string",
            "eCheckGas": "string",
            "eCheckMarina": "string",
            "eCheckService": "string"
        },
        "created": "2026-04-17 02:58:47",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`\n(\n `Id`  string , `eCheckGas`  string , `eCheckMarina`  string , `eCheckService`  string , `CreditCardGas`  string , `CreditCardService`  string , `CreditCardMarina`  string , `MarinaLocation_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_moloAllowedPaymentMethodsSet/2026-04-17/1776412688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloallowedpaymentmethodsset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}