Schema Info

Schema Name: sfdl_prod_drivethru.molo_molostripecardset

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717773

created: 2026-04-17 03:10:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-17/1776412854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-17/1776412854
id: 1717773
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 162167796
updated: 2026-04-17 03:10:42

Version 1716534

created: 2026-04-16 03:12:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-16/1776326608'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-16/1776326608
id: 1716534
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 162111986
updated: 2026-04-16 03:13:09

Version 1715275

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-15/1776240077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-15/1776240077
id: 1715275
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 162056023
updated: 2026-04-15 03:07:59

Version 1713989

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-14/1776153843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-14/1776153843
id: 1713989
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 162000433
updated: 2026-04-14 03:05:03

Version 1712840

created: 2026-04-13 03:00:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-13/1776067002'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-13/1776067002
id: 1712840
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161941892
updated: 2026-04-13 03:00:35

Version 1711671

created: 2026-04-12 03:03:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-12/1775980713'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-12/1775980713
id: 1711671
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161893120
updated: 2026-04-12 03:03:56

Version 1710442

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-11/1775894481'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-11/1775894481
id: 1710442
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161841228
updated: 2026-04-11 03:06:25

Version 1709271

created: 2026-04-10 03:07:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-10/1775808239'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-10/1775808239
id: 1709271
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161785964
updated: 2026-04-10 03:07:18

Version 1708116

created: 2026-04-09 03:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-09/1775721571'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-09/1775721571
id: 1708116
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161730219
updated: 2026-04-09 03:03:10

Version 1707029

created: 2026-04-08 03:10:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-08/1775635399'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-08/1775635399
id: 1707029
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161675692
updated: 2026-04-08 03:10:45

Version 1705786

created: 2026-04-07 03:00:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-07/1775548556'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-07/1775548556
id: 1705786
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161618734
updated: 2026-04-07 03:00:21

Version 1704629

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-06/1775462516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-06/1775462516
id: 1704629
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161561777
updated: 2026-04-06 03:11:29

Version 1703343

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-05/1775376142'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-05/1775376142
id: 1703343
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161514924
updated: 2026-04-05 03:07:08

Version 1702156

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-04/1775289626'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-04/1775289626
id: 1702156
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161460354
updated: 2026-04-04 03:05:23

Version 1701033

created: 2026-04-03 03:13:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-03/1775203398'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloStripeCardSet/2026-04-03/1775203398
id: 1701033
processed: 1

raw_data:

{
    "Brand": 3,
    "Country": 4,
    "CreationAspNetUser_Id": 20,
    "CreationDateTime": 19,
    "DeletionAspNetUser_Id": 23,
    "DeletionDateTime": 24,
    "DynamicLast4": 5,
    "ExpirationMonth": 6,
    "ExpirationYear": 7,
    "Fingerprint": 8,
    "Funding": 9,
    "Id": 0,
    "InstantPayoutMethod": 21,
    "Last4": 10,
    "Name": 11,
    "Object": 2,
    "RecordStatus_Id": 22,
    "StripeCustomer_Id": 12,
    "StripeId": 1,
    "UseForAutoCharge": 25,
    "address_city": 15,
    "address_country": 18,
    "address_line1": 13,
    "address_line2": 14,
    "address_state": 16,
    "address_zip": 17
}

schema_attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

schema_name_id: 1676
schema_scan_id: 161402013
updated: 2026-04-03 03:14:08

Schema Scans: 15

Last at 2026-04-17 03:10:27

Scan 162167796

duration: 0:00:14.824302

exit_message:

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

id: 162167796

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_moloStripeCardSet/2026-04-17/1776412854",
        "key": "raw/molo_moloStripeCardSet/2026-04-17/1776412854/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3349606923936856750,
        "service_name": "drive-thru",
        "span_id": 14249642125708697755,
        "trace_id": 15279407492335367743
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-17 03:10:27
success: True
trace_id: 15279407492335367743

Scan 162111986

duration: 0:00:12.564544

exit_message:

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

id: 162111986

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_moloStripeCardSet/2026-04-16/1776326608",
        "key": "raw/molo_moloStripeCardSet/2026-04-16/1776326608/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14468521378029553298,
        "service_name": "drive-thru",
        "span_id": 8635578591618261013,
        "trace_id": 654373450308661206
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-16 03:12:56
success: True
trace_id: 654373450308661206

Scan 162056023

duration: 0:00:12.269597

exit_message:

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

id: 162056023

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_moloStripeCardSet/2026-04-15/1776240077",
        "key": "raw/molo_moloStripeCardSet/2026-04-15/1776240077/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2021215405360694868,
        "service_name": "drive-thru",
        "span_id": 17413539832482898025,
        "trace_id": 15886646196150871384
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-15 03:07:47
success: True
trace_id: 15886646196150871384

Scan 162000433

duration: 0:00:14.909206

exit_message:

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

id: 162000433

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_moloStripeCardSet/2026-04-14/1776153843",
        "key": "raw/molo_moloStripeCardSet/2026-04-14/1776153843/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10984428913057131599,
        "service_name": "drive-thru",
        "span_id": 14985160007820776546,
        "trace_id": 8334802910285261428
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-14 03:04:48
success: True
trace_id: 8334802910285261428

Scan 161941892

duration: 0:00:12.341864

exit_message:

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

id: 161941892

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_moloStripeCardSet/2026-04-13/1776067002",
        "key": "raw/molo_moloStripeCardSet/2026-04-13/1776067002/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17602737348344330215,
        "service_name": "drive-thru",
        "span_id": 16737892518391004440,
        "trace_id": 8130704027296889329
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-13 03:00:23
success: True
trace_id: 8130704027296889329

Scan 161893120

duration: 0:00:14.857798

exit_message:

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

id: 161893120

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_moloStripeCardSet/2026-04-12/1775980713",
        "key": "raw/molo_moloStripeCardSet/2026-04-12/1775980713/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3738781127676390247,
        "service_name": "drive-thru",
        "span_id": 6447939203347275539,
        "trace_id": 6337959330073538119
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-12 03:03:41
success: True
trace_id: 6337959330073538119

Scan 161841228

duration: 0:00:12.313905

exit_message:

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

id: 161841228

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_moloStripeCardSet/2026-04-11/1775894481",
        "key": "raw/molo_moloStripeCardSet/2026-04-11/1775894481/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10695742871730222368,
        "service_name": "drive-thru",
        "span_id": 10283264704155348735,
        "trace_id": 9266085579898831770
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-11 03:06:13
success: True
trace_id: 9266085579898831770

Scan 161785964

duration: 0:00:12.580177

exit_message:

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

id: 161785964

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_moloStripeCardSet/2026-04-10/1775808239",
        "key": "raw/molo_moloStripeCardSet/2026-04-10/1775808239/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 809040724067025002,
        "service_name": "drive-thru",
        "span_id": 3648640963736159099,
        "trace_id": 14717352291126662868
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-10 03:07:06
success: True
trace_id: 14717352291126662868

Scan 161730219

duration: 0:00:14.874210

exit_message:

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

id: 161730219

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_moloStripeCardSet/2026-04-09/1775721571",
        "key": "raw/molo_moloStripeCardSet/2026-04-09/1775721571/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4822151513812588890,
        "service_name": "drive-thru",
        "span_id": 12499147552424196417,
        "trace_id": 11838345235882041668
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-09 03:02:55
success: True
trace_id: 11838345235882041668

Scan 161675692

duration: 0:00:12.398886

exit_message:

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

id: 161675692

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_moloStripeCardSet/2026-04-08/1775635399",
        "key": "raw/molo_moloStripeCardSet/2026-04-08/1775635399/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18429463184552215231,
        "service_name": "drive-thru",
        "span_id": 9143284868718325789,
        "trace_id": 12283076578619651426
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-08 03:10:32
success: True
trace_id: 12283076578619651426

Scan 161618734

duration: 0:00:12.265295

exit_message:

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

id: 161618734

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_moloStripeCardSet/2026-04-07/1775548556",
        "key": "raw/molo_moloStripeCardSet/2026-04-07/1775548556/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6321957026497266271,
        "service_name": "drive-thru",
        "span_id": 14858985057727750407,
        "trace_id": 12739891559025960630
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-07 03:00:09
success: True
trace_id: 12739891559025960630

Scan 161561777

duration: 0:00:12.439820

exit_message:

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

id: 161561777

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_moloStripeCardSet/2026-04-06/1775462516",
        "key": "raw/molo_moloStripeCardSet/2026-04-06/1775462516/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12684579661211785102,
        "service_name": "drive-thru",
        "span_id": 2026818470466769370,
        "trace_id": 6866928243386160012
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-06 03:11:17
success: True
trace_id: 6866928243386160012

Scan 161514924

duration: 0:00:12.393948

exit_message:

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

id: 161514924

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_moloStripeCardSet/2026-04-05/1775376142",
        "key": "raw/molo_moloStripeCardSet/2026-04-05/1775376142/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4061970223596224952,
        "service_name": "drive-thru",
        "span_id": 11901841851987581275,
        "trace_id": 6100917170071613678
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-05 03:06:56
success: True
trace_id: 6100917170071613678

Scan 161460354

duration: 0:00:14.820133

exit_message:

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

id: 161460354

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_moloStripeCardSet/2026-04-04/1775289626",
        "key": "raw/molo_moloStripeCardSet/2026-04-04/1775289626/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13193411493083162210,
        "service_name": "drive-thru",
        "span_id": 17149804163706828361,
        "trace_id": 13286293254446233777
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-04 03:05:08
success: True
trace_id: 13286293254446233777

Scan 161402013

duration: 0:00:14.840292

exit_message:

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

id: 161402013

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_moloStripeCardSet/2026-04-03/1775203398",
        "key": "raw/molo_moloStripeCardSet/2026-04-03/1775203398/StripeCardSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloStripeCardSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14776706678738348505,
        "service_name": "drive-thru",
        "span_id": 5698969885592350971,
        "trace_id": 1529605444737247817
    }
}

running: False
schema_name_id: 1676
start_time: 2026-04-03 03:13:54
success: True
trace_id: 1529605444737247817

Partitions:

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

Schema:

attributes:

{
    "Brand": "string",
    "Country": "string",
    "CreationAspNetUser_Id": "string",
    "CreationDateTime": "string",
    "DeletionAspNetUser_Id": "string",
    "DeletionDateTime": "string",
    "DynamicLast4": "string",
    "ExpirationMonth": "string",
    "ExpirationYear": "string",
    "Fingerprint": "string",
    "Funding": "string",
    "Id": "string",
    "InstantPayoutMethod": "string",
    "Last4": "string",
    "Name": "string",
    "Object": "string",
    "RecordStatus_Id": "string",
    "StripeCustomer_Id": "string",
    "StripeId": "string",
    "UseForAutoCharge": "string",
    "address_city": "string",
    "address_country": "string",
    "address_line1": "string",
    "address_line2": "string",
    "address_state": "string",
    "address_zip": "string"
}

created: 2026-04-17 03:10:28

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-17/1776412854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2023-10-17 01:58:03",
        "disabled": false,
        "format": "raw",
        "id": 1676,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_molostripecardset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Brand": "string",
            "Country": "string",
            "CreationAspNetUser_Id": "string",
            "CreationDateTime": "string",
            "DeletionAspNetUser_Id": "string",
            "DeletionDateTime": "string",
            "DynamicLast4": "string",
            "ExpirationMonth": "string",
            "ExpirationYear": "string",
            "Fingerprint": "string",
            "Funding": "string",
            "Id": "string",
            "InstantPayoutMethod": "string",
            "Last4": "string",
            "Name": "string",
            "Object": "string",
            "RecordStatus_Id": "string",
            "StripeCustomer_Id": "string",
            "StripeId": "string",
            "UseForAutoCharge": "string",
            "address_city": "string",
            "address_country": "string",
            "address_line1": "string",
            "address_line2": "string",
            "address_state": "string",
            "address_zip": "string"
        },
        "created": "2026-04-17 03:10:28",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_molostripecardset`\n(\n `Id`  string , `StripeId`  string , `Object`  string , `Brand`  string , `Country`  string , `DynamicLast4`  string , `ExpirationMonth`  string , `ExpirationYear`  string , `Fingerprint`  string , `Funding`  string , `Last4`  string , `Name`  string , `StripeCustomer_Id`  string , `address_line1`  string , `address_line2`  string , `address_city`  string , `address_state`  string , `address_zip`  string , `address_country`  string , `CreationDateTime`  string , `CreationAspNetUser_Id`  string , `InstantPayoutMethod`  string , `RecordStatus_Id`  string , `DeletionAspNetUser_Id`  string , `DeletionDateTime`  string , `UseForAutoCharge`  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_moloStripeCardSet/2026-04-17/1776412854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_molostripecardset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_molostripecardset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}