Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd
- created: 2024-06-05 16:12:42
- disabled: False
- format: raw
- id: 1883
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsmolo_stripe_nzd" } - type: drivethrucsv
Schema Versions: 7
-
Version 1701735
- created: 2026-04-03 17:37:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2026-04-03/1775255844'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2026-04-03/1775255844
- id: 1701735
- 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: 1883
- schema_scan_id: 161439964
- updated: 2026-04-03 17:37:45
-
Version 1665082
- created: 2026-03-03 15:21:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2026-03-03/1772572866'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2026-03-03/1772572866
- id: 1665082
- 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: 1883
- schema_scan_id: 159680345
- updated: 2026-03-03 15:21:55
-
Version 1634404
- 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_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2026-02-05/1770287733'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2026-02-05/1770287733
- id: 1634404
- 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: 1883
- schema_scan_id: 158223077
- updated: 2026-02-05 04:35:52
-
Version 1634402
- created: 2026-02-05 04:35:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2026-02-05/1770287683'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2026-02-05/1770287683
- id: 1634402
- 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: 1883
- schema_scan_id: 158223075
- updated: 2026-02-05 04:35:24
-
Version 1600532
- created: 2026-01-06 22:02:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2026-01-06/1767758515'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2026-01-06/1767758515
- id: 1600532
- 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: 1883
- schema_scan_id: 156632565
- updated: 2026-01-06 22:02:54
-
Version 1561796
- created: 2025-12-03 19:25:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2025-12-03/1764811522'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2025-12-03/1764811522
- id: 1561796
- 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: 1883
- schema_scan_id: 154803692
- updated: 2025-12-03 19:26:09
-
Version 1528720
- created: 2025-11-04 23:58:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`\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_nzd/2025-11-04/1762321214'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmolo_stripe_nzd/2025-11-04/1762321214
- id: 1528720
- 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: 1883
- schema_scan_id: 153035181
- updated: 2025-11-04 23:58:21
Schema Scans: 7
Last at 2026-04-03 17:37:31
-
Scan 161439964
- duration: 0:00:13.868882
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161439964
- 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_nzd/2026-04-03/1775255844", "key": "raw/stellar_imsmolo_stripe_nzd/2026-04-03/1775255844/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11111539053350265985, "service_name": "drive-thru", "span_id": 9319651254642376285, "trace_id": 12803286919405595969 } } - running: False
- schema_name_id: 1883
- start_time: 2026-04-03 17:37:31
- success: True
- trace_id: 12803286919405595969
-
Scan 159680345
- duration: 0:00:16.588665
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 159680345
- 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_nzd/2026-03-03/1772572866", "key": "raw/stellar_imsmolo_stripe_nzd/2026-03-03/1772572866/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17976969244591357485, "service_name": "drive-thru", "span_id": 1206742740704204332, "trace_id": 6163096213145644119 } } - running: False
- schema_name_id: 1883
- start_time: 2026-03-03 15:21:38
- success: True
- trace_id: 6163096213145644119
-
Scan 158223077
- duration: 0:00:16.563884
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 158223077
- 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_nzd/2026-02-05/1770287733", "key": "raw/stellar_imsmolo_stripe_nzd/2026-02-05/1770287733/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14755106133069287417, "service_name": "drive-thru", "span_id": 551573601386580686, "trace_id": 3750405472561134949 } } - running: False
- schema_name_id: 1883
- start_time: 2026-02-05 04:35:35
- success: True
- trace_id: 3750405472561134949
-
Scan 158223075
- duration: 0:00:14.011090
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 158223075
- 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_nzd/2026-02-05/1770287683", "key": "raw/stellar_imsmolo_stripe_nzd/2026-02-05/1770287683/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9686091617403169492, "service_name": "drive-thru", "span_id": 11775581611587089205, "trace_id": 6625625782155174899 } } - running: False
- schema_name_id: 1883
- start_time: 2026-02-05 04:35:10
- success: True
- trace_id: 6625625782155174899
-
Scan 156632565
- duration: 0:00:16.766327
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 156632565
- 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_nzd/2026-01-06/1767758515", "key": "raw/stellar_imsmolo_stripe_nzd/2026-01-06/1767758515/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10060602179111244237, "service_name": "drive-thru", "span_id": 4931035601045165352, "trace_id": 9298650166250984704 } } - running: False
- schema_name_id: 1883
- start_time: 2026-01-06 22:02:38
- success: True
- trace_id: 9298650166250984704
-
Scan 154803692
- duration: 0:00:17.000603
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 154803692
- 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_nzd/2025-12-03/1764811522", "key": "raw/stellar_imsmolo_stripe_nzd/2025-12-03/1764811522/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14930493429572805599, "service_name": "drive-thru", "span_id": 7537554505950805657, "trace_id": 10030841574497150305 } } - running: False
- schema_name_id: 1883
- start_time: 2025-12-03 19:25:52
- success: True
- trace_id: 10030841574497150305
-
Scan 153035181
- duration: 0:00:14.006140
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 153035181
- 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_nzd/2025-11-04/1762321214", "key": "raw/stellar_imsmolo_stripe_nzd/2025-11-04/1762321214/molo_stripe_nzd.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14024823489700930055, "service_name": "drive-thru", "span_id": 11017935618901428274, "trace_id": 10993395092815881607 } } - running: False
- schema_name_id: 1883
- start_time: 2025-11-04 23:58:07
- success: True
- trace_id: 10993395092815881607
- 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:34
- 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_nzd`\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_nzd/2026-04-03/1775255844'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-06-05 16:12:42",
"disabled": false,
"format": "raw",
"id": 1883,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsmolo_stripe_nzd"
},
"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:34",
"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_nzd`\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_nzd/2026-04-03/1775255844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmolo_stripe_nzd"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}