Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloauthorizenetresponseset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717576

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-17/1776412691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-17/1776412691
id: 1717576
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 162167206
updated: 2026-04-17 03:00:44

Version 1716312

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-16/1776326453'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 162111651
updated: 2026-04-16 03:03:19

Version 1715138

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-15/1776239926'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-15/1776239926
id: 1715138
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 162055664
updated: 2026-04-15 03:01:21

Version 1713953

created: 2026-04-14 03:03:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-14/1776153648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 162000379
updated: 2026-04-14 03:03:26

Version 1712693

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-13/1776066841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-13/1776066841
id: 1712693
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161941450
updated: 2026-04-13 02:54:52

Version 1711494

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-12/1775980557'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161892244
updated: 2026-04-12 02:56:22

Version 1710300

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-11/1775894316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-11/1775894316
id: 1710300
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161840810
updated: 2026-04-11 02:59:37

Version 1709156

created: 2026-04-10 03:02:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-10/1775808074'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161785792
updated: 2026-04-10 03:02:33

Version 1708004

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-09/1775721414'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161729696
updated: 2026-04-09 02:58:00

Version 1706814

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-08/1775635221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-08/1775635221
id: 1706814
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161675347
updated: 2026-04-08 03:01:53

Version 1705616

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-07/1775548393'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161618293
updated: 2026-04-07 02:53:58

Version 1704386

created: 2026-04-06 03:00:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-06/1775462357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161561304
updated: 2026-04-06 03:00:52

Version 1703230

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-05/1775375988'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-05/1775375988
id: 1703230
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161514795
updated: 2026-04-05 03:02:31

Version 1702016

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-04/1775289473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloAuthorizeNetResponseSet/2026-04-04/1775289473
id: 1702016
processed: 1

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161459747
updated: 2026-04-04 02:59:14

Version 1700809

created: 2026-04-03 03:02:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-03/1775203242'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
]

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

raw_data:

{
    "AVSResultCode": 6,
    "Amount": 22,
    "AuthorizationCode": 5,
    "AutoCharge": 17,
    "CAVVResultCode": 7,
    "CVVResultCode": 8,
    "Contact_Id": 19,
    "Date": 15,
    "EmailPaymentTokenId": 16,
    "Id": 0,
    "InvoiceId": 20,
    "MarinaLocation_Id": 18,
    "MessagesCoding": 2,
    "MessagesText": 3,
    "MoloTransactionId": 21,
    "ResponseCode": 4,
    "ResultCode": 1,
    "ResultMessageCode": 13,
    "ResultMessageText": 14,
    "TransactionAccountNumber": 11,
    "TransactionAccountType": 12,
    "TransactionHash": 10,
    "TransactionId": 9
}

schema_attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

schema_name_id: 1569
schema_scan_id: 161401592
updated: 2026-04-03 03:02:58

Schema Scans: 15

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

Scan 162167206

duration: 0:00:14.801267

exit_message:

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

id: 162167206

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_moloAuthorizeNetResponseSet/2026-04-17/1776412691",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-17/1776412691/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11294510763320142224,
        "service_name": "drive-thru",
        "span_id": 9120810766360272944,
        "trace_id": 12715998977138360478
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-17 03:00:30
success: True
trace_id: 12715998977138360478

Scan 162111651

duration: 0:00:14.826822

exit_message:

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

id: 162111651

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_moloAuthorizeNetResponseSet/2026-04-16/1776326453",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-16/1776326453/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14580764435462179847,
        "service_name": "drive-thru",
        "span_id": 9580414064298871474,
        "trace_id": 838698692058019883
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-16 03:03:04
success: True
trace_id: 838698692058019883

Scan 162055664

duration: 0:00:14.682832

exit_message:

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

id: 162055664

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_moloAuthorizeNetResponseSet/2026-04-15/1776239926",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-15/1776239926/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 297321898591615410,
        "service_name": "drive-thru",
        "span_id": 3210278591515708662,
        "trace_id": 16315604781212001508
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-15 03:01:06
success: True
trace_id: 16315604781212001508

Scan 162000379

duration: 0:00:14.804320

exit_message:

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

id: 162000379

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_moloAuthorizeNetResponseSet/2026-04-14/1776153648",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-14/1776153648/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8396384924961841643,
        "service_name": "drive-thru",
        "span_id": 8727588042929803898,
        "trace_id": 14151430604104574963
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-14 03:03:11
success: True
trace_id: 14151430604104574963

Scan 161941450

duration: 0:00:12.312671

exit_message:

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

id: 161941450

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_moloAuthorizeNetResponseSet/2026-04-13/1776066841",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-13/1776066841/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17068641794574793675,
        "service_name": "drive-thru",
        "span_id": 7091838127286210834,
        "trace_id": 11237516408435417915
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-13 02:54:40
success: True
trace_id: 11237516408435417915

Scan 161892244

duration: 0:00:12.214395

exit_message:

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

id: 161892244

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_moloAuthorizeNetResponseSet/2026-04-12/1775980557",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-12/1775980557/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6466882240438474343,
        "service_name": "drive-thru",
        "span_id": 10506401760703010175,
        "trace_id": 1012069400651913652
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-12 02:56:09
success: True
trace_id: 1012069400651913652

Scan 161840810

duration: 0:00:14.763312

exit_message:

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

id: 161840810

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_moloAuthorizeNetResponseSet/2026-04-11/1775894316",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-11/1775894316/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13942746351703368971,
        "service_name": "drive-thru",
        "span_id": 10320152414448607279,
        "trace_id": 17333655870008431220
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-11 02:59:22
success: True
trace_id: 17333655870008431220

Scan 161785792

duration: 0:00:12.252970

exit_message:

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

id: 161785792

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_moloAuthorizeNetResponseSet/2026-04-10/1775808074",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-10/1775808074/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15448763796918138516,
        "service_name": "drive-thru",
        "span_id": 32300665057257181,
        "trace_id": 3513774517140176259
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-10 03:02:21
success: True
trace_id: 3513774517140176259

Scan 161729696

duration: 0:00:14.678659

exit_message:

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

id: 161729696

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_moloAuthorizeNetResponseSet/2026-04-09/1775721414",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-09/1775721414/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7363879793408070269,
        "service_name": "drive-thru",
        "span_id": 10664326584296399928,
        "trace_id": 5531929553682214167
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-09 02:57:45
success: True
trace_id: 5531929553682214167

Scan 161675347

duration: 0:00:12.185088

exit_message:

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

id: 161675347

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_moloAuthorizeNetResponseSet/2026-04-08/1775635221",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-08/1775635221/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5738191928197262617,
        "service_name": "drive-thru",
        "span_id": 810725985465980071,
        "trace_id": 17964508920339952612
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-08 03:01:41
success: True
trace_id: 17964508920339952612

Scan 161618293

duration: 0:00:12.250642

exit_message:

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

id: 161618293

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_moloAuthorizeNetResponseSet/2026-04-07/1775548393",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-07/1775548393/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16202561159478688430,
        "service_name": "drive-thru",
        "span_id": 8009437760133732808,
        "trace_id": 6572133722087851232
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-07 02:53:46
success: True
trace_id: 6572133722087851232

Scan 161561304

duration: 0:00:12.322918

exit_message:

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

id: 161561304

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_moloAuthorizeNetResponseSet/2026-04-06/1775462357",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-06/1775462357/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17548715567652213552,
        "service_name": "drive-thru",
        "span_id": 9699318724217097762,
        "trace_id": 12704069300623955420
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-06 03:00:40
success: True
trace_id: 12704069300623955420

Scan 161514795

duration: 0:00:14.852314

exit_message:

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

id: 161514795

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_moloAuthorizeNetResponseSet/2026-04-05/1775375988",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-05/1775375988/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14959104022576739193,
        "service_name": "drive-thru",
        "span_id": 9080217471185548650,
        "trace_id": 13731125527487717224
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-05 03:02:16
success: True
trace_id: 13731125527487717224

Scan 161459747

duration: 0:00:12.298242

exit_message:

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

id: 161459747

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_moloAuthorizeNetResponseSet/2026-04-04/1775289473",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-04/1775289473/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13623019690190939637,
        "service_name": "drive-thru",
        "span_id": 1938047683575288280,
        "trace_id": 16494544325656220130
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-04 02:59:01
success: True
trace_id: 16494544325656220130

Scan 161401592

duration: 0:00:12.245054

exit_message:

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

id: 161401592

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_moloAuthorizeNetResponseSet/2026-04-03/1775203242",
        "key": "raw/molo_moloAuthorizeNetResponseSet/2026-04-03/1775203242/AuthorizeNetResponseSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloAuthorizeNetResponseSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5976340840768829606,
        "service_name": "drive-thru",
        "span_id": 17147314900692805552,
        "trace_id": 18122902647755546352
    }
}

running: False
schema_name_id: 1569
start_time: 2026-04-03 03:02:45
success: True
trace_id: 18122902647755546352

Partitions:

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

Schema:

attributes:

{
    "AVSResultCode": "string",
    "Amount": "string",
    "AuthorizationCode": "string",
    "AutoCharge": "string",
    "CAVVResultCode": "string",
    "CVVResultCode": "string",
    "Contact_Id": "string",
    "Date": "string",
    "EmailPaymentTokenId": "string",
    "Id": "string",
    "InvoiceId": "string",
    "MarinaLocation_Id": "string",
    "MessagesCoding": "string",
    "MessagesText": "string",
    "MoloTransactionId": "string",
    "ResponseCode": "string",
    "ResultCode": "string",
    "ResultMessageCode": "string",
    "ResultMessageText": "string",
    "TransactionAccountNumber": "string",
    "TransactionAccountType": "string",
    "TransactionHash": "string",
    "TransactionId": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-17/1776412691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
}

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:14",
        "disabled": false,
        "format": "raw",
        "id": 1569,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloauthorizenetresponseset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AVSResultCode": "string",
            "Amount": "string",
            "AuthorizationCode": "string",
            "AutoCharge": "string",
            "CAVVResultCode": "string",
            "CVVResultCode": "string",
            "Contact_Id": "string",
            "Date": "string",
            "EmailPaymentTokenId": "string",
            "Id": "string",
            "InvoiceId": "string",
            "MarinaLocation_Id": "string",
            "MessagesCoding": "string",
            "MessagesText": "string",
            "MoloTransactionId": "string",
            "ResponseCode": "string",
            "ResultCode": "string",
            "ResultMessageCode": "string",
            "ResultMessageText": "string",
            "TransactionAccountNumber": "string",
            "TransactionAccountType": "string",
            "TransactionHash": "string",
            "TransactionId": "string"
        },
        "created": "2026-04-17 03:00:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloauthorizenetresponseset`\n(\n `Id`  string , `ResultCode`  string , `MessagesCoding`  string , `MessagesText`  string , `ResponseCode`  string , `AuthorizationCode`  string , `AVSResultCode`  string , `CAVVResultCode`  string , `CVVResultCode`  string , `TransactionId`  string , `TransactionHash`  string , `TransactionAccountNumber`  string , `TransactionAccountType`  string , `ResultMessageCode`  string , `ResultMessageText`  string , `Date`  string , `EmailPaymentTokenId`  string , `AutoCharge`  string , `MarinaLocation_Id`  string , `Contact_Id`  string , `InvoiceId`  string , `MoloTransactionId`  string , `Amount`  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_moloAuthorizeNetResponseSet/2026-04-17/1776412691'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloauthorizenetresponseset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloauthorizenetresponseset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}