Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717577

created: 2026-04-17 03:00:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-17/1776412689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

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

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 162167214
updated: 2026-04-17 03:00:50

Version 1716315

created: 2026-04-16 03:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-16/1776326453'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-16/1776326453
id: 1716315
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 162111658
updated: 2026-04-16 03:03:28

Version 1715113

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-15/1776239924'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-15/1776239924
id: 1715113
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 162055585
updated: 2026-04-15 02:59:57

Version 1713944

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-14/1776153648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

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

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 162000356
updated: 2026-04-14 03:02:48

Version 1712696

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-13/1776066839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-13/1776066839
id: 1712696
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161941458
updated: 2026-04-13 02:55:01

Version 1711520

created: 2026-04-12 02:57:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-12/1775980558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-12/1775980558
id: 1711520
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161892289
updated: 2026-04-12 02:57:25

Version 1710297

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-11/1775894319'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-11/1775894319
id: 1710297
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161840802
updated: 2026-04-11 02:59:30

Version 1709146

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-10/1775808074'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-10/1775808074
id: 1709146
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161785775
updated: 2026-04-10 03:02:05

Version 1707998

created: 2026-04-09 02:57:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-09/1775721414'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-09/1775721414
id: 1707998
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161729653
updated: 2026-04-09 02:57:30

Version 1706870

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-08/1775635220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-08/1775635220
id: 1706870
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161675455
updated: 2026-04-08 03:04:17

Version 1705637

created: 2026-04-07 02:54:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-07/1775548393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-07/1775548393
id: 1705637
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161618313
updated: 2026-04-07 02:54:40

Version 1704401

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-06/1775462357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-06/1775462357
id: 1704401
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161561371
updated: 2026-04-06 03:01:40

Version 1703198

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-05/1775375985'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-05/1775375985
id: 1703198
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161514752
updated: 2026-04-05 03:01:14

Version 1702024

created: 2026-04-04 02:59:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-04/1775289470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-04/1775289470
id: 1702024
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161459785
updated: 2026-04-04 02:59:38

Version 1700839

created: 2026-04-03 03:05:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-03/1775203242'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizePaymentMethodSet/2026-04-03/1775203242
id: 1700839
processed: 1

raw_data:

{
    "ANetId": 1,
    "AddressId": 9,
    "BillingZipCode": 8,
    "CardType": 6,
    "ContactId": 2,
    "ExpMonth": 4,
    "ExpYear": 5,
    "GroupId": 7,
    "Id": 0,
    "IsDefault": 10,
    "Nickname": 11,
    "PMNumber": 12,
    "Type": 3
}

schema_attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

schema_name_id: 1589
schema_scan_id: 161401725
updated: 2026-04-03 03:05:23

Schema Scans: 15

Last at 2026-04-17 03:00:35

Scan 162167214

duration: 0:00:14.537805

exit_message:

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

id: 162167214

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_moloAuthorizePaymentMethodSet/2026-04-17/1776412689",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-17/1776412689/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1351390315922665606,
        "service_name": "drive-thru",
        "span_id": 5400911832664760881,
        "trace_id": 323858024722967107
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-17 03:00:35
success: True
trace_id: 323858024722967107

Scan 162111658

duration: 0:00:14.467122

exit_message:

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

id: 162111658

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_moloAuthorizePaymentMethodSet/2026-04-16/1776326453",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-16/1776326453/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14182111552339274943,
        "service_name": "drive-thru",
        "span_id": 13568220917002642384,
        "trace_id": 3706813691287410107
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-16 03:03:14
success: True
trace_id: 3706813691287410107

Scan 162055585

duration: 0:00:11.952161

exit_message:

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

id: 162055585

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_moloAuthorizePaymentMethodSet/2026-04-15/1776239924",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-15/1776239924/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9495925066186627654,
        "service_name": "drive-thru",
        "span_id": 12642421784423171132,
        "trace_id": 16775578601355854659
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-15 02:59:45
success: True
trace_id: 16775578601355854659

Scan 162000356

duration: 0:00:14.494260

exit_message:

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

id: 162000356

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_moloAuthorizePaymentMethodSet/2026-04-14/1776153648",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-14/1776153648/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3761913943004001898,
        "service_name": "drive-thru",
        "span_id": 5807371693095256493,
        "trace_id": 16687412801400012949
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-14 03:02:34
success: True
trace_id: 16687412801400012949

Scan 161941458

duration: 0:00:14.491700

exit_message:

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

id: 161941458

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_moloAuthorizePaymentMethodSet/2026-04-13/1776066839",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-13/1776066839/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10555861598014321631,
        "service_name": "drive-thru",
        "span_id": 5620246442099904257,
        "trace_id": 3433777095653773729
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-13 02:54:46
success: True
trace_id: 3433777095653773729

Scan 161892289

duration: 0:00:11.906805

exit_message:

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

id: 161892289

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_moloAuthorizePaymentMethodSet/2026-04-12/1775980558",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-12/1775980558/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2197859718794412703,
        "service_name": "drive-thru",
        "span_id": 17183195670303509698,
        "trace_id": 16213070630578575127
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-12 02:57:13
success: True
trace_id: 16213070630578575127

Scan 161840802

duration: 0:00:11.930271

exit_message:

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

id: 161840802

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_moloAuthorizePaymentMethodSet/2026-04-11/1775894319",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-11/1775894319/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3853548685286905815,
        "service_name": "drive-thru",
        "span_id": 3799181705598500893,
        "trace_id": 15072883195734202739
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-11 02:59:18
success: True
trace_id: 15072883195734202739

Scan 161785775

duration: 0:00:12.082536

exit_message:

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

id: 161785775

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_moloAuthorizePaymentMethodSet/2026-04-10/1775808074",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-10/1775808074/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8929487481849852110,
        "service_name": "drive-thru",
        "span_id": 8525284335329327946,
        "trace_id": 15145295680724553265
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-10 03:01:53
success: True
trace_id: 15145295680724553265

Scan 161729653

duration: 0:00:11.978469

exit_message:

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

id: 161729653

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_moloAuthorizePaymentMethodSet/2026-04-09/1775721414",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-09/1775721414/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1849402563828494119,
        "service_name": "drive-thru",
        "span_id": 14452867389769681719,
        "trace_id": 1829808077739297917
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-09 02:57:18
success: True
trace_id: 1829808077739297917

Scan 161675455

duration: 0:00:14.481548

exit_message:

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

id: 161675455

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_moloAuthorizePaymentMethodSet/2026-04-08/1775635220",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-08/1775635220/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7562488318838546605,
        "service_name": "drive-thru",
        "span_id": 4677015926894499664,
        "trace_id": 17109318719124955404
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-08 03:04:02
success: True
trace_id: 17109318719124955404

Scan 161618313

duration: 0:00:12.069575

exit_message:

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

id: 161618313

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_moloAuthorizePaymentMethodSet/2026-04-07/1775548393",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-07/1775548393/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7747825240614510255,
        "service_name": "drive-thru",
        "span_id": 13238077263663934909,
        "trace_id": 118304337339356461
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-07 02:54:28
success: True
trace_id: 118304337339356461

Scan 161561371

duration: 0:00:11.924732

exit_message:

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

id: 161561371

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_moloAuthorizePaymentMethodSet/2026-04-06/1775462357",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-06/1775462357/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17600280173619845381,
        "service_name": "drive-thru",
        "span_id": 13565511839279466881,
        "trace_id": 16029475282744101914
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-06 03:01:28
success: True
trace_id: 16029475282744101914

Scan 161514752

duration: 0:00:11.960431

exit_message:

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

id: 161514752

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_moloAuthorizePaymentMethodSet/2026-04-05/1775375985",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-05/1775375985/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 624589284970961197,
        "service_name": "drive-thru",
        "span_id": 5284436260617880113,
        "trace_id": 9236576620297648788
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-05 03:01:02
success: True
trace_id: 9236576620297648788

Scan 161459785

duration: 0:00:11.910880

exit_message:

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

id: 161459785

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_moloAuthorizePaymentMethodSet/2026-04-04/1775289470",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-04/1775289470/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11160628802567026789,
        "service_name": "drive-thru",
        "span_id": 7042379765260657730,
        "trace_id": 15966485755571683828
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-04 02:59:26
success: True
trace_id: 15966485755571683828

Scan 161401725

duration: 0:00:12.087042

exit_message:

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

id: 161401725

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_moloAuthorizePaymentMethodSet/2026-04-03/1775203242",
        "key": "raw/molo_moloAuthorizePaymentMethodSet/2026-04-03/1775203242/AuthorizePaymentMethodSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizePaymentMethodSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18044932317144584017,
        "service_name": "drive-thru",
        "span_id": 8477431637845244312,
        "trace_id": 17594914996386260176
    }
}

running: False
schema_name_id: 1589
start_time: 2026-04-03 03:05:11
success: True
trace_id: 17594914996386260176

Partitions:

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

Schema:

attributes:

{
    "ANetId": "string",
    "AddressId": "string",
    "BillingZipCode": "string",
    "CardType": "string",
    "ContactId": "string",
    "ExpMonth": "string",
    "ExpYear": "string",
    "GroupId": "string",
    "Id": "string",
    "IsDefault": "string",
    "Nickname": "string",
    "PMNumber": "string",
    "Type": "string"
}

created: 2026-04-17 03:00:36

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-17/1776412689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
}

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:54:55",
        "disabled": false,
        "format": "raw",
        "id": 1589,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloauthorizepaymentmethodset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ANetId": "string",
            "AddressId": "string",
            "BillingZipCode": "string",
            "CardType": "string",
            "ContactId": "string",
            "ExpMonth": "string",
            "ExpYear": "string",
            "GroupId": "string",
            "Id": "string",
            "IsDefault": "string",
            "Nickname": "string",
            "PMNumber": "string",
            "Type": "string"
        },
        "created": "2026-04-17 03:00:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`\n(\n `Id`  string , `ANetId`  string , `ContactId`  string , `Type`  string , `ExpMonth`  string , `ExpYear`  string , `CardType`  string , `GroupId`  string , `BillingZipCode`  string , `AddressId`  string , `IsDefault`  string , `Nickname`  string , `PMNumber`  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_moloAuthorizePaymentMethodSet/2026-04-17/1776412689'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizepaymentmethodset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}