Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn
- created: 2024-06-11 02:47:28
- disabled: False
- format: raw
- id: 1887
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsmolo_stripe_mxn" } - type: drivethrucsv
Schema Versions: 7
-
Version 1701734
- created: 2026-04-03 17:37:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842
- id: 1701734
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 47, "automatic_payout_id": 46, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 42, "card_address_country": 45, "card_address_line1": 40, "card_address_line2": 41, "card_address_postal_code": 44, "card_address_state": 43, "card_brand": 55, "card_country": 57, "card_funding": 56, "charge_id": 48, "connected_account_country": 83, "connected_account_direct_charge_id": 84, "connected_account_id": 81, "connected_account_name": 82, "country": 15, "currency": 9, "customer_address_city": 30, "customer_address_country": 33, "customer_address_line1": 28, "customer_address_line2": 29, "customer_address_postal_code": 32, "customer_address_state": 31, "customer_description": 21, "customer_email": 19, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 18, "customer_name": 20, "customer_shipping_address_city": 24, "customer_shipping_address_country": 27, "customer_shipping_address_line1": 22, "customer_shipping_address_line2": 23, "customer_shipping_address_postal_code": 26, "customer_shipping_address_state": 25, "dispute_id": 79, "event_type": 4, "fee_id": 14, "invoice_id": 50, "invoice_number": 51, "is_link": 54, "payment_intent_id": 49, "payment_metadata[CompanyName]": 59, "payment_metadata[ContactHashId]": 61, "payment_metadata[Contact]": 60, "payment_metadata[DOCUMENT_URL]": 62, "payment_metadata[EmailAddress]": 63, "payment_metadata[Invoice number]": 64, "payment_metadata[InvoiceID]": 65, "payment_metadata[MarinaName]": 66, "payment_metadata[MoloReader]": 67, "payment_metadata[OrgCode]": 68, "payment_metadata[OrgName]": 69, "payment_metadata[ReservationID]": 70, "payment_metadata[ResourceBookingID]": 71, "payment_metadata[collector_id]": 72, "payment_metadata[email]": 73, "payment_metadata[envelopeId]": 74, "payment_metadata[item-1]": 75, "payment_metadata[item-2]": 76, "payment_metadata[name]": 77, "payment_method_type": 53, "product_ids": 16, "product_names": 17, "refund_id": 78, "shipping_address_city": 36, "shipping_address_country": 39, "shipping_address_line1": 34, "shipping_address_line2": 35, "shipping_address_postal_code": 38, "shipping_address_state": 37, "statement_descriptor": 58, "subscription_id": 52, "transfer_id": 80, "transfer_metadata[Note!]": 86, "transfer_metadata[Note]": 85 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "country": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "product_ids": "string", "product_names": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 161439963
- updated: 2026-04-03 17:37:44
-
Version 1665077
- created: 2026-03-03 15:21:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-03-03/1772572864'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2026-03-03/1772572864
- id: 1665077
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 47, "automatic_payout_id": 46, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 42, "card_address_country": 45, "card_address_line1": 40, "card_address_line2": 41, "card_address_postal_code": 44, "card_address_state": 43, "card_brand": 55, "card_country": 57, "card_funding": 56, "charge_id": 48, "connected_account_country": 83, "connected_account_direct_charge_id": 84, "connected_account_id": 81, "connected_account_name": 82, "country": 15, "currency": 9, "customer_address_city": 30, "customer_address_country": 33, "customer_address_line1": 28, "customer_address_line2": 29, "customer_address_postal_code": 32, "customer_address_state": 31, "customer_description": 21, "customer_email": 19, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 18, "customer_name": 20, "customer_shipping_address_city": 24, "customer_shipping_address_country": 27, "customer_shipping_address_line1": 22, "customer_shipping_address_line2": 23, "customer_shipping_address_postal_code": 26, "customer_shipping_address_state": 25, "dispute_id": 79, "event_type": 4, "fee_id": 14, "invoice_id": 50, "invoice_number": 51, "is_link": 54, "payment_intent_id": 49, "payment_metadata[CompanyName]": 59, "payment_metadata[ContactHashId]": 61, "payment_metadata[Contact]": 60, "payment_metadata[DOCUMENT_URL]": 62, "payment_metadata[EmailAddress]": 63, "payment_metadata[Invoice number]": 64, "payment_metadata[InvoiceID]": 65, "payment_metadata[MarinaName]": 66, "payment_metadata[MoloReader]": 67, "payment_metadata[OrgCode]": 68, "payment_metadata[OrgName]": 69, "payment_metadata[ReservationID]": 70, "payment_metadata[ResourceBookingID]": 71, "payment_metadata[collector_id]": 72, "payment_metadata[email]": 73, "payment_metadata[envelopeId]": 74, "payment_metadata[item-1]": 75, "payment_metadata[item-2]": 76, "payment_metadata[name]": 77, "payment_method_type": 53, "product_ids": 16, "product_names": 17, "refund_id": 78, "shipping_address_city": 36, "shipping_address_country": 39, "shipping_address_line1": 34, "shipping_address_line2": 35, "shipping_address_postal_code": 38, "shipping_address_state": 37, "statement_descriptor": 58, "subscription_id": 52, "transfer_id": 80, "transfer_metadata[Note!]": 86, "transfer_metadata[Note]": 85 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "country": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "product_ids": "string", "product_names": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 159680330
- updated: 2026-03-03 15:21:27
-
Version 1634403
- created: 2026-02-05 04:35:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-02-05/1770287733'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2026-02-05/1770287733
- id: 1634403
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 47, "automatic_payout_id": 46, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 42, "card_address_country": 45, "card_address_line1": 40, "card_address_line2": 41, "card_address_postal_code": 44, "card_address_state": 43, "card_brand": 55, "card_country": 57, "card_funding": 56, "charge_id": 48, "connected_account_country": 83, "connected_account_direct_charge_id": 84, "connected_account_id": 81, "connected_account_name": 82, "country": 15, "currency": 9, "customer_address_city": 30, "customer_address_country": 33, "customer_address_line1": 28, "customer_address_line2": 29, "customer_address_postal_code": 32, "customer_address_state": 31, "customer_description": 21, "customer_email": 19, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 18, "customer_name": 20, "customer_shipping_address_city": 24, "customer_shipping_address_country": 27, "customer_shipping_address_line1": 22, "customer_shipping_address_line2": 23, "customer_shipping_address_postal_code": 26, "customer_shipping_address_state": 25, "dispute_id": 79, "event_type": 4, "fee_id": 14, "invoice_id": 50, "invoice_number": 51, "is_link": 54, "payment_intent_id": 49, "payment_metadata[CompanyName]": 59, "payment_metadata[ContactHashId]": 61, "payment_metadata[Contact]": 60, "payment_metadata[DOCUMENT_URL]": 62, "payment_metadata[EmailAddress]": 63, "payment_metadata[Invoice number]": 64, "payment_metadata[InvoiceID]": 65, "payment_metadata[MarinaName]": 66, "payment_metadata[MoloReader]": 67, "payment_metadata[OrgCode]": 68, "payment_metadata[OrgName]": 69, "payment_metadata[ReservationID]": 70, "payment_metadata[ResourceBookingID]": 71, "payment_metadata[collector_id]": 72, "payment_metadata[email]": 73, "payment_metadata[envelopeId]": 74, "payment_metadata[item-1]": 75, "payment_metadata[item-2]": 76, "payment_metadata[name]": 77, "payment_method_type": 53, "product_ids": 16, "product_names": 17, "refund_id": 78, "shipping_address_city": 36, "shipping_address_country": 39, "shipping_address_line1": 34, "shipping_address_line2": 35, "shipping_address_postal_code": 38, "shipping_address_state": 37, "statement_descriptor": 58, "subscription_id": 52, "transfer_id": 80, "transfer_metadata[Note!]": 86, "transfer_metadata[Note]": 85 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "country": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "product_ids": "string", "product_names": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 158223078
- updated: 2026-02-05 04:35:52
-
Version 1634398
- created: 2026-02-05 04:35:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-02-05/1770287683'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2026-02-05/1770287683
- id: 1634398
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 47, "automatic_payout_id": 46, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 42, "card_address_country": 45, "card_address_line1": 40, "card_address_line2": 41, "card_address_postal_code": 44, "card_address_state": 43, "card_brand": 55, "card_country": 57, "card_funding": 56, "charge_id": 48, "connected_account_country": 83, "connected_account_direct_charge_id": 84, "connected_account_id": 81, "connected_account_name": 82, "country": 15, "currency": 9, "customer_address_city": 30, "customer_address_country": 33, "customer_address_line1": 28, "customer_address_line2": 29, "customer_address_postal_code": 32, "customer_address_state": 31, "customer_description": 21, "customer_email": 19, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 18, "customer_name": 20, "customer_shipping_address_city": 24, "customer_shipping_address_country": 27, "customer_shipping_address_line1": 22, "customer_shipping_address_line2": 23, "customer_shipping_address_postal_code": 26, "customer_shipping_address_state": 25, "dispute_id": 79, "event_type": 4, "fee_id": 14, "invoice_id": 50, "invoice_number": 51, "is_link": 54, "payment_intent_id": 49, "payment_metadata[CompanyName]": 59, "payment_metadata[ContactHashId]": 61, "payment_metadata[Contact]": 60, "payment_metadata[DOCUMENT_URL]": 62, "payment_metadata[EmailAddress]": 63, "payment_metadata[Invoice number]": 64, "payment_metadata[InvoiceID]": 65, "payment_metadata[MarinaName]": 66, "payment_metadata[MoloReader]": 67, "payment_metadata[OrgCode]": 68, "payment_metadata[OrgName]": 69, "payment_metadata[ReservationID]": 70, "payment_metadata[ResourceBookingID]": 71, "payment_metadata[collector_id]": 72, "payment_metadata[email]": 73, "payment_metadata[envelopeId]": 74, "payment_metadata[item-1]": 75, "payment_metadata[item-2]": 76, "payment_metadata[name]": 77, "payment_method_type": 53, "product_ids": 16, "product_names": 17, "refund_id": 78, "shipping_address_city": 36, "shipping_address_country": 39, "shipping_address_line1": 34, "shipping_address_line2": 35, "shipping_address_postal_code": 38, "shipping_address_state": 37, "statement_descriptor": 58, "subscription_id": 52, "transfer_id": 80, "transfer_metadata[Note!]": 86, "transfer_metadata[Note]": 85 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "country": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "product_ids": "string", "product_names": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 158223069
- updated: 2026-02-05 04:35:18
-
Version 1600530
- created: 2026-01-06 22:02:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-01-06/1767758514'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2026-01-06/1767758514
- id: 1600530
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 44, "automatic_payout_id": 43, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 39, "card_address_country": 42, "card_address_line1": 37, "card_address_line2": 38, "card_address_postal_code": 41, "card_address_state": 40, "card_brand": 52, "card_country": 54, "card_funding": 53, "charge_id": 45, "connected_account_country": 80, "connected_account_direct_charge_id": 81, "connected_account_id": 78, "connected_account_name": 79, "currency": 9, "customer_address_city": 27, "customer_address_country": 30, "customer_address_line1": 25, "customer_address_line2": 26, "customer_address_postal_code": 29, "customer_address_state": 28, "customer_description": 18, "customer_email": 16, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 15, "customer_name": 17, "customer_shipping_address_city": 21, "customer_shipping_address_country": 24, "customer_shipping_address_line1": 19, "customer_shipping_address_line2": 20, "customer_shipping_address_postal_code": 23, "customer_shipping_address_state": 22, "dispute_id": 76, "event_type": 4, "fee_id": 14, "invoice_id": 47, "invoice_number": 48, "is_link": 51, "payment_intent_id": 46, "payment_metadata[CompanyName]": 56, "payment_metadata[ContactHashId]": 58, "payment_metadata[Contact]": 57, "payment_metadata[DOCUMENT_URL]": 59, "payment_metadata[EmailAddress]": 60, "payment_metadata[Invoice number]": 61, "payment_metadata[InvoiceID]": 62, "payment_metadata[MarinaName]": 63, "payment_metadata[MoloReader]": 64, "payment_metadata[OrgCode]": 65, "payment_metadata[OrgName]": 66, "payment_metadata[ReservationID]": 67, "payment_metadata[ResourceBookingID]": 68, "payment_metadata[collector_id]": 69, "payment_metadata[email]": 70, "payment_metadata[envelopeId]": 71, "payment_metadata[item-1]": 72, "payment_metadata[item-2]": 73, "payment_metadata[name]": 74, "payment_method_type": 50, "refund_id": 75, "shipping_address_city": 33, "shipping_address_country": 36, "shipping_address_line1": 31, "shipping_address_line2": 32, "shipping_address_postal_code": 35, "shipping_address_state": 34, "statement_descriptor": 55, "subscription_id": 49, "transfer_id": 77, "transfer_metadata[Note!]": 83, "transfer_metadata[Note]": 82 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 156632552
- updated: 2026-01-06 22:02:46
-
Version 1561797
- created: 2025-12-03 19:26:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2025-12-03/1764811520'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2025-12-03/1764811520
- id: 1561797
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 44, "automatic_payout_id": 43, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 39, "card_address_country": 42, "card_address_line1": 37, "card_address_line2": 38, "card_address_postal_code": 41, "card_address_state": 40, "card_brand": 52, "card_country": 54, "card_funding": 53, "charge_id": 45, "connected_account_country": 80, "connected_account_direct_charge_id": 81, "connected_account_id": 78, "connected_account_name": 79, "currency": 9, "customer_address_city": 27, "customer_address_country": 30, "customer_address_line1": 25, "customer_address_line2": 26, "customer_address_postal_code": 29, "customer_address_state": 28, "customer_description": 18, "customer_email": 16, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 15, "customer_name": 17, "customer_shipping_address_city": 21, "customer_shipping_address_country": 24, "customer_shipping_address_line1": 19, "customer_shipping_address_line2": 20, "customer_shipping_address_postal_code": 23, "customer_shipping_address_state": 22, "dispute_id": 76, "event_type": 4, "fee_id": 14, "invoice_id": 47, "invoice_number": 48, "is_link": 51, "payment_intent_id": 46, "payment_metadata[CompanyName]": 56, "payment_metadata[ContactHashId]": 58, "payment_metadata[Contact]": 57, "payment_metadata[DOCUMENT_URL]": 59, "payment_metadata[EmailAddress]": 60, "payment_metadata[Invoice number]": 61, "payment_metadata[InvoiceID]": 62, "payment_metadata[MarinaName]": 63, "payment_metadata[MoloReader]": 64, "payment_metadata[OrgCode]": 65, "payment_metadata[OrgName]": 66, "payment_metadata[ReservationID]": 67, "payment_metadata[ResourceBookingID]": 68, "payment_metadata[collector_id]": 69, "payment_metadata[email]": 70, "payment_metadata[envelopeId]": 71, "payment_metadata[item-1]": 72, "payment_metadata[item-2]": 73, "payment_metadata[name]": 74, "payment_method_type": 50, "refund_id": 75, "shipping_address_city": 33, "shipping_address_country": 36, "shipping_address_line1": 31, "shipping_address_line2": 32, "shipping_address_postal_code": 35, "shipping_address_state": 34, "statement_descriptor": 55, "subscription_id": 49, "transfer_id": 77, "transfer_metadata[Note!]": 83, "transfer_metadata[Note]": 82 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 154803693
- updated: 2025-12-03 19:26:14
-
Version 1528721
- created: 2025-11-04 23:58:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2025-11-04/1762321215'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_mxn/2025-11-04/1762321215
- id: 1528721
- processed: 1
- raw_data:
{ "activity_at": 5, "activity_end_date": 8, "activity_interval_type": 6, "activity_start_date": 7, "amount": 10, "automatic_payout_effective_at": 44, "automatic_payout_id": 43, "balance_transaction_component": 3, "balance_transaction_created_at": 1, "balance_transaction_description": 13, "balance_transaction_id": 0, "balance_transaction_reporting_category": 2, "card_address_city": 39, "card_address_country": 42, "card_address_line1": 37, "card_address_line2": 38, "card_address_postal_code": 41, "card_address_state": 40, "card_brand": 52, "card_country": 54, "card_funding": 53, "charge_id": 45, "connected_account_country": 80, "connected_account_direct_charge_id": 81, "connected_account_id": 78, "connected_account_name": 79, "currency": 9, "customer_address_city": 27, "customer_address_country": 30, "customer_address_line1": 25, "customer_address_line2": 26, "customer_address_postal_code": 29, "customer_address_state": 28, "customer_description": 18, "customer_email": 16, "customer_facing_amount": 12, "customer_facing_currency": 11, "customer_id": 15, "customer_name": 17, "customer_shipping_address_city": 21, "customer_shipping_address_country": 24, "customer_shipping_address_line1": 19, "customer_shipping_address_line2": 20, "customer_shipping_address_postal_code": 23, "customer_shipping_address_state": 22, "dispute_id": 76, "event_type": 4, "fee_id": 14, "invoice_id": 47, "invoice_number": 48, "is_link": 51, "payment_intent_id": 46, "payment_metadata[CompanyName]": 56, "payment_metadata[ContactHashId]": 58, "payment_metadata[Contact]": 57, "payment_metadata[DOCUMENT_URL]": 59, "payment_metadata[EmailAddress]": 60, "payment_metadata[Invoice number]": 61, "payment_metadata[InvoiceID]": 62, "payment_metadata[MarinaName]": 63, "payment_metadata[MoloReader]": 64, "payment_metadata[OrgCode]": 65, "payment_metadata[OrgName]": 66, "payment_metadata[ReservationID]": 67, "payment_metadata[ResourceBookingID]": 68, "payment_metadata[collector_id]": 69, "payment_metadata[email]": 70, "payment_metadata[envelopeId]": 71, "payment_metadata[item-1]": 72, "payment_metadata[item-2]": 73, "payment_metadata[name]": 74, "payment_method_type": 50, "refund_id": 75, "shipping_address_city": 33, "shipping_address_country": 36, "shipping_address_line1": 31, "shipping_address_line2": 32, "shipping_address_postal_code": 35, "shipping_address_state": 34, "statement_descriptor": 55, "subscription_id": 49, "transfer_id": 77, "transfer_metadata[Note!]": 83, "transfer_metadata[Note]": 82 } - schema_attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - schema_name_id: 1887
- schema_scan_id: 153035196
- updated: 2025-11-04 23:58:37
Schema Scans: 7
Last at 2026-04-03 17:37:31
-
Scan 161439963
- duration: 0:00:13.683577
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161439963
- 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/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842", "key": "raw/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8949395550321402744, "service_name": "drive-thru", "span_id": 8880948559299674838, "trace_id": 13506637161931689318 } } - running: False
- schema_name_id: 1887
- start_time: 2026-04-03 17:37:31
- success: True
- trace_id: 13506637161931689318
-
Scan 159680330
- duration: 0:00:16.343260
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 159680330
- 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/stellar_imsmolo_stripe_mxn/2026-03-03/1772572864", "key": "raw/stellar_imsmolo_stripe_mxn/2026-03-03/1772572864/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4311128718223777094, "service_name": "drive-thru", "span_id": 6246886135900143590, "trace_id": 9237345578179995800 } } - running: False
- schema_name_id: 1887
- start_time: 2026-03-03 15:21:11
- success: True
- trace_id: 9237345578179995800
-
Scan 158223078
- duration: 0:00:16.283585
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 158223078
- 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/stellar_imsmolo_stripe_mxn/2026-02-05/1770287733", "key": "raw/stellar_imsmolo_stripe_mxn/2026-02-05/1770287733/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13481495277013829746, "service_name": "drive-thru", "span_id": 12839255737857156722, "trace_id": 10392666898404202151 } } - running: False
- schema_name_id: 1887
- start_time: 2026-02-05 04:35:35
- success: True
- trace_id: 10392666898404202151
-
Scan 158223069
- duration: 0:00:16.588989
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 158223069
- 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/stellar_imsmolo_stripe_mxn/2026-02-05/1770287683", "key": "raw/stellar_imsmolo_stripe_mxn/2026-02-05/1770287683/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1889187602214958255, "service_name": "drive-thru", "span_id": 16930297055629105572, "trace_id": 6285140286343218072 } } - running: False
- schema_name_id: 1887
- start_time: 2026-02-05 04:35:02
- success: True
- trace_id: 6285140286343218072
-
Scan 156632552
- duration: 0:00:14.154125
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 156632552
- 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/stellar_imsmolo_stripe_mxn/2026-01-06/1767758514", "key": "raw/stellar_imsmolo_stripe_mxn/2026-01-06/1767758514/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11791240772346739709, "service_name": "drive-thru", "span_id": 15129511586643905090, "trace_id": 12882059845268795887 } } - running: False
- schema_name_id: 1887
- start_time: 2026-01-06 22:02:32
- success: True
- trace_id: 12882059845268795887
-
Scan 154803693
- duration: 0:00:14.219436
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 154803693
- 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/stellar_imsmolo_stripe_mxn/2025-12-03/1764811520", "key": "raw/stellar_imsmolo_stripe_mxn/2025-12-03/1764811520/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9530119651995525190, "service_name": "drive-thru", "span_id": 15047116044133486937, "trace_id": 13284727919868232467 } } - running: False
- schema_name_id: 1887
- start_time: 2025-12-03 19:26:00
- success: True
- trace_id: 13284727919868232467
-
Scan 153035196
- duration: 0:00:14.095297
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 153035196
- 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/stellar_imsmolo_stripe_mxn/2025-11-04/1762321215", "key": "raw/stellar_imsmolo_stripe_mxn/2025-11-04/1762321215/molo_stripe_mxn.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4222572835786645794, "service_name": "drive-thru", "span_id": 15026023249092265134, "trace_id": 11651314442831295928 } } - running: False
- schema_name_id: 1887
- start_time: 2025-11-04 23:58:23
- success: True
- trace_id: 11651314442831295928
- attributes:
{ "activity_at": "string", "activity_end_date": "string", "activity_interval_type": "string", "activity_start_date": "string", "amount": "string", "automatic_payout_effective_at": "string", "automatic_payout_id": "string", "balance_transaction_component": "string", "balance_transaction_created_at": "string", "balance_transaction_description": "string", "balance_transaction_id": "string", "balance_transaction_reporting_category": "string", "card_address_city": "string", "card_address_country": "string", "card_address_line1": "string", "card_address_line2": "string", "card_address_postal_code": "string", "card_address_state": "string", "card_brand": "string", "card_country": "string", "card_funding": "string", "charge_id": "string", "connected_account_country": "string", "connected_account_direct_charge_id": "string", "connected_account_id": "string", "connected_account_name": "string", "country": "string", "currency": "string", "customer_address_city": "string", "customer_address_country": "string", "customer_address_line1": "string", "customer_address_line2": "string", "customer_address_postal_code": "string", "customer_address_state": "string", "customer_description": "string", "customer_email": "string", "customer_facing_amount": "string", "customer_facing_currency": "string", "customer_id": "string", "customer_name": "string", "customer_shipping_address_city": "string", "customer_shipping_address_country": "string", "customer_shipping_address_line1": "string", "customer_shipping_address_line2": "string", "customer_shipping_address_postal_code": "string", "customer_shipping_address_state": "string", "dispute_id": "string", "event_type": "string", "fee_id": "string", "invoice_id": "string", "invoice_number": "string", "is_link": "string", "payment_intent_id": "string", "payment_metadata_CompanyName_": "string", "payment_metadata_ContactHashId_": "string", "payment_metadata_Contact_": "string", "payment_metadata_DOCUMENT_URL_": "string", "payment_metadata_EmailAddress_": "string", "payment_metadata_InvoiceID_": "string", "payment_metadata_InvoiceId_": "string", "payment_metadata_Invoice_number_": "string", "payment_metadata_MarinaName_": "string", "payment_metadata_MoloReader_": "string", "payment_metadata_OrgCode_": "string", "payment_metadata_OrgName_": "string", "payment_metadata_ReservationID_": "string", "payment_metadata_ResourceBookingID_": "string", "payment_metadata_collector_id_": "string", "payment_metadata_email_": "string", "payment_metadata_envelopeId_": "string", "payment_metadata_item_1_": "string", "payment_metadata_item_2_": "string", "payment_metadata_name_": "string", "payment_method_type": "string", "product_ids": "string", "product_names": "string", "refund_id": "string", "shipping_address_city": "string", "shipping_address_country": "string", "shipping_address_line1": "string", "shipping_address_line2": "string", "shipping_address_postal_code": "string", "shipping_address_state": "string", "statement_descriptor": "string", "subscription_id": "string", "transfer_id": "string", "transfer_metadata_Note_": "string", "transfer_metadata_Note__": "string" } - created: 2026-04-03 17:37:33
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-06-11 02:47:28",
"disabled": false,
"format": "raw",
"id": 1887,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsmolo_stripe_mxn"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"activity_at": "string",
"activity_end_date": "string",
"activity_interval_type": "string",
"activity_start_date": "string",
"amount": "string",
"automatic_payout_effective_at": "string",
"automatic_payout_id": "string",
"balance_transaction_component": "string",
"balance_transaction_created_at": "string",
"balance_transaction_description": "string",
"balance_transaction_id": "string",
"balance_transaction_reporting_category": "string",
"card_address_city": "string",
"card_address_country": "string",
"card_address_line1": "string",
"card_address_line2": "string",
"card_address_postal_code": "string",
"card_address_state": "string",
"card_brand": "string",
"card_country": "string",
"card_funding": "string",
"charge_id": "string",
"connected_account_country": "string",
"connected_account_direct_charge_id": "string",
"connected_account_id": "string",
"connected_account_name": "string",
"country": "string",
"currency": "string",
"customer_address_city": "string",
"customer_address_country": "string",
"customer_address_line1": "string",
"customer_address_line2": "string",
"customer_address_postal_code": "string",
"customer_address_state": "string",
"customer_description": "string",
"customer_email": "string",
"customer_facing_amount": "string",
"customer_facing_currency": "string",
"customer_id": "string",
"customer_name": "string",
"customer_shipping_address_city": "string",
"customer_shipping_address_country": "string",
"customer_shipping_address_line1": "string",
"customer_shipping_address_line2": "string",
"customer_shipping_address_postal_code": "string",
"customer_shipping_address_state": "string",
"dispute_id": "string",
"event_type": "string",
"fee_id": "string",
"invoice_id": "string",
"invoice_number": "string",
"is_link": "string",
"payment_intent_id": "string",
"payment_metadata_CompanyName_": "string",
"payment_metadata_ContactHashId_": "string",
"payment_metadata_Contact_": "string",
"payment_metadata_DOCUMENT_URL_": "string",
"payment_metadata_EmailAddress_": "string",
"payment_metadata_InvoiceID_": "string",
"payment_metadata_InvoiceId_": "string",
"payment_metadata_Invoice_number_": "string",
"payment_metadata_MarinaName_": "string",
"payment_metadata_MoloReader_": "string",
"payment_metadata_OrgCode_": "string",
"payment_metadata_OrgName_": "string",
"payment_metadata_ReservationID_": "string",
"payment_metadata_ResourceBookingID_": "string",
"payment_metadata_collector_id_": "string",
"payment_metadata_email_": "string",
"payment_metadata_envelopeId_": "string",
"payment_metadata_item_1_": "string",
"payment_metadata_item_2_": "string",
"payment_metadata_name_": "string",
"payment_method_type": "string",
"product_ids": "string",
"product_names": "string",
"refund_id": "string",
"shipping_address_city": "string",
"shipping_address_country": "string",
"shipping_address_line1": "string",
"shipping_address_line2": "string",
"shipping_address_postal_code": "string",
"shipping_address_state": "string",
"statement_descriptor": "string",
"subscription_id": "string",
"transfer_id": "string",
"transfer_metadata_Note_": "string",
"transfer_metadata_Note__": "string"
},
"created": "2026-04-03 17:37:33",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`\n(\n `balance_transaction_id` string , `balance_transaction_created_at` string , `balance_transaction_reporting_category` string , `balance_transaction_component` string , `event_type` string , `activity_at` string , `activity_interval_type` string , `activity_start_date` string , `activity_end_date` string , `currency` string , `amount` string , `customer_facing_currency` string , `customer_facing_amount` string , `balance_transaction_description` string , `fee_id` string , `country` string , `product_ids` string , `product_names` string , `customer_id` string , `customer_email` string , `customer_name` string , `customer_description` string , `customer_shipping_address_line1` string , `customer_shipping_address_line2` string , `customer_shipping_address_city` string , `customer_shipping_address_state` string , `customer_shipping_address_postal_code` string , `customer_shipping_address_country` string , `customer_address_line1` string , `customer_address_line2` string , `customer_address_city` string , `customer_address_state` string , `customer_address_postal_code` string , `customer_address_country` string , `shipping_address_line1` string , `shipping_address_line2` string , `shipping_address_city` string , `shipping_address_state` string , `shipping_address_postal_code` string , `shipping_address_country` string , `card_address_line1` string , `card_address_line2` string , `card_address_city` string , `card_address_state` string , `card_address_postal_code` string , `card_address_country` string , `automatic_payout_id` string , `automatic_payout_effective_at` string , `charge_id` string , `payment_intent_id` string , `invoice_id` string , `invoice_number` string , `subscription_id` string , `payment_method_type` string , `is_link` string , `card_brand` string , `card_funding` string , `card_country` string , `statement_descriptor` string , `payment_metadata_CompanyName_` string , `payment_metadata_Contact_` string , `payment_metadata_ContactHashId_` string , `payment_metadata_DOCUMENT_URL_` string , `payment_metadata_EmailAddress_` string , `payment_metadata_Invoice_number_` string , `payment_metadata_InvoiceID_` string , `payment_metadata_MarinaName_` string , `payment_metadata_MoloReader_` string , `payment_metadata_OrgCode_` string , `payment_metadata_OrgName_` string , `payment_metadata_ReservationID_` string , `payment_metadata_ResourceBookingID_` string , `payment_metadata_collector_id_` string , `payment_metadata_email_` string , `payment_metadata_envelopeId_` string , `payment_metadata_item_1_` string , `payment_metadata_item_2_` string , `payment_metadata_name_` string , `refund_id` string , `dispute_id` string , `transfer_id` string , `connected_account_id` string , `connected_account_name` string , `connected_account_country` string , `connected_account_direct_charge_id` string , `transfer_metadata_Note_` string , `transfer_metadata_Note__` 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/stellar_imsmolo_stripe_mxn/2026-04-03/1775255842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_mxn"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}