Schema Info

Schema Name: sfdl_stage_csv.salesforce_assets
  • created: 2022-09-13 15:28:51
  • disabled: False
  • format: raw
  • id: 1413
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_stage_csv",
    "table": "salesforce_assets"
}
  • type: csv
Schema Versions: 3
    • created: 2026-02-27 09:13:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_assets`\n(\n `Id`  string , `ContactId`  string , `AccountId`  string , `ParentId`  string , `RootAssetId`  string , `Product2Id`  string , `ProductCode`  string , `ProductFamily`  string , `ProductDescription`  string , `IsCompetitorProduct`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsDeleted`  string , `CurrencyIsoCode`  string , `Name`  string , `SerialNumber`  string , `InstallDate`  string , `ManufactureDate`  string , `StatusReason`  string , `Uuid`  string , `ExternalIdentifier`  string , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `DigitalAssetStatus`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `LocationId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  string , `ConsequenceOfFailure`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Asset_Type__c`  string , `Beanstream_ID__c`  string , `Datawire_ID__c`  string , `Download_ID__c`  string , `Merchant_ID__c`  string , `North_ID__c`  string , `X1_Day_Hold__c`  string , `Terminal_ID__c`  string , `Profituity_ID__c`  string , `Opportunity__c`  string , `BillingStatus__c`  string , `Bundle_Tier__c`  string , `Monthly_Transaction_Volume_and_Rate__c`  string , `MRR__c`  string , `Software_Tier__c`  string , `SF_Bid_Rate__c`  string , `HollyID_Assets__c`  string , `SL_Corp_Code_Assets__c`  string , `SL_Location_Code_Assets__c`  string , `Source_Parent_Name_Assets__c`  string , `Source_Facility_Name_Assets__c`  string , `SE_FMS_ID_Assets__c`  string , `Chargeover_ID_Assets__c`  string , `Chargeover_Parent_ID_Assets__c`  string , `Merchant_ID_Assets__c`  string , `Cancellation_Reason__c`  string , `Cancellation_Reason_Detail__c`  string , `Sold_To__c`  string , `Cancellation_Date__c`  string , `BillingCancelled__c`  string , `SFBidRate_Number__c`  string , `BillingNotes__c`  string , `CancelinBillingDate__c`  string , `DiscontinueProductDate__c`  string , `Implementationcase__c`  string , `LicenseTransferredFromAsset__c`  string , `LicenseTransferredtoAsset__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `RequestedCancellationDate__c`  string , `SLMSAccount__c`  string , `ACHID__c`  string , `SoftwareDiscontinued__c`  string , `GPMCC__c`  string , `SFClientKey__c`  string , `SFFacilityKey__c`  string , `HQMerchantID__c`  string , `PendingCancellationDate__c`  string , `SFBEID__c`  string , `RelatedOpportunityhasbeenclosedwon__c`  string , `PreviouslyinPendingCancellation__c`  string , `Website__c`  string , `SSLRenewalDate__c`  string , `TerminalType__c`  string , `MSTotalVolume__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Debookedreason__c`  string , `PaymentFamily__c`  string , `Avg_Actual_MVR__c`  string , `Annualgroup__c`  string , `DiscountRate__c`  string , `TransactionFee__c`  string , `MonthlyFee__c`  string , `AnnualFee__c`  string , `Asset_Activation_Status__c`  string , `Payments_Activation_Date__c`  string , `Website_Type__c`  string , `GMB_Account_Name__c`  string , `Google_Ads_Account_Name__c`  string , `Google_Ads_Account_Number__c`  string , `Google_Ads_Campaign_Launch_Date__c`  string , `Google_Ads_Campaign_Budget_Monthly__c`  string , `Google_Ads_Campaign_Budget_Daily__c`  string , `Google_Ads_Payment_Type__c`  string , `Google_Ads_Google_Doc__c`  string , `Google_Ads_Management_Fee__c`  string , `Agency_Analytics_PPC_Dashboard__c`  string , `Agency_Analytics_Custom_Reports__c`  string , `MRRupdated__c`  string , `MRR_update_date_time_stamp__c`  string , `StopayProduct__c`  string , `Statuslastupdate__c`  string , `StopayTotal__c`  string , `ACHTransaction__c`  string , `ACHTransactionFee__c`  string , `Rental_Center_Version__c`  string , `ESSproduct__c`  string , `Text_Product_Name__c`  string , `Rate_Statement_Opportunity__c`  string , `JIRA_Ticket__c`  string , `Short_Code__c`  string , `WW_Cohort__c`  string , `SF_Account_Status__c`  string , `Date_New_to_Live__c`  string , `SF_Substatus__c`  string , `New_Insurance_Provider__c`  string , `New_Access_Provider_Other__c`  string , `New_Access_Provider__c`  string , `New_Insurance_Provider_Other__c`  string , `RI_2025_Free_Trial_Converted__c`  string , `RI_2025_Free_Trial_Need_Cancelled__c`  string , `International_Currency__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `Cancelled_via_Cancellation_Wizard__c`  string , `Churn_Opportunity__c`  string , `Cancellation_Method__c`  string , `Digital_Marketing_Welcome_Sent__c`  string , `Marine_Reprice__c`  string , `Churn_Forecast_Reason__c`  string , `Churn_Forecast_Date__c`  string , `Financial_Churn_Date__c`  string , `Churn_Forecast_Reason_Detail__c`  string , `Last_Churn_Save_Date__c`  string , `Marine_Competitor_Lost_To__c`  string , `Reason_Lost_Category__c`  string , `LicenseId__c`  string , `MigrationId__c`  string , `NB_CompanyId__c`  string , `NB_PropertyID__c`  string , `NB_Region__c`  string , `SubscriptionInterval__c`  string , `next_run__c`  string , `suspend_date__c`  string , `Promotional_Expiration_Date__c`  string , `Data_Load_By__c`  string , `Cap__c`  string , `Promo_End_Cap__c`  string , `Promo_End_Tier__c`  string , `Retention_Case__c`  string , `StoPay_Annual_Group__c`  string , `StoPay_Auth_Group__c`  string , `StoPay_Discount_Group__c`  string , `AC_Expected_Launch_Date__c`  string , `StoPay_Monthly_Group__c`  string , `ESSAddOnId__c`  string , `ESSCompanyId__c`  string , `ESSFacilityId__c`  string , `Ship_To_Case__c`  string , `ESSDiscountExpirationDate__c`  string , `DataLakeSyncDate__c`  string , `ESSDiscountedPrice__c`  string , `ESSPrice__c`  string , `ESSSetupFee__c`  string , `ProductDatabaseCancelledDate__c`  string , `ProductDatabaseCreatedDate__c`  string , `ProductDatabaseLastModifiedDate__c`  string , `Imp_Case_Reopened__c`  string , `Price_Change_Date__c`  string , `Digital_Marketing_Status__c`  string , `Merchant_Services_Account_Status__c`  string , `Date_Debooked__c`  string , `User_Activation_Tracking__c`  string , `SE_UUID_Company__c`  string , `SE_Facility_UUID__c`  string , `StorableCoveredEMVDeviceCost__c`  string , `Cloud_Node_ID__c`  string , `Planned_Debooking_Date__c`  string , `SF_Integration__c`  string , `Date_Time_ESS_Transfer_Canceled__c`  string , `Date_Time_ESS_Transfer_Completed__c`  string , `Date_Time_ESS_Transfer_Created__c`  string , `Date_Time_ESS_Transfer_Effective__c`  string , `Originating_Order_Product__c`  string , `MID_Rewrite__c`  string , `Price_Lock_Expiration__c`  string , `Hardware__c`  string , `Opportunity_Product__c`  string , `SoftwareServices__c`  string , `SE_Company_ID__c`  string , `ListPrice__c`  string , `Zoho_Corporate_ID__c`  string , `Zoho_Corporate_URL__c`  string , `Zoho_ID__c`  string , `Zoho_URL__c`  string , `Bulk_Churn_Email_Exemption__c`  string , `P_C_Insurance_Coverage_Types__c`  string , `Epic_Location_Code__c`  string , `Epic_Lookup_Code__c`  string , `P_C_Commission__c`  string , `P_C_Expiration_Date__c`  string , `P_C_Start_Date__c`  string , `Bundle_Name__c`  string , `Bundle_Type__c`  string , `Repriced__c`  string , `Asset_Cancelled_Non_Payment__c`  string , `Suspend_Asset_Customer_Past_Due__c`  string , `PPS_Cleanup_Cancellation__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Billing_Type__c`  string , `Convenience_Fee__c`  string , `Integration_Software__c`  string , `Marine_Expiration_Date__c`  string , `Molo_ID__c`  string , `Molo_Site_ID__c`  string , `Stellar_Company_ID__c`  string , `Stellar_Facility_ID__c`  string , `Asset_Cleanup_Case__c`  string , `Database_Merge_Cleanup__c`  string , `PCI_Activated__c`  string , `PCI_ID__c`  string , `PCI_Parent_ID__c`  string , `New_Website_Provider_Other__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider_Other__c`  string , `New_Software_Provider__c`  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-csv-salesforce-stage/raw/assets/2026-02-27/1772205053'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/assets/2026-02-27/1772205053
    • id: 896365
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 88,
    "ACHTransactionFee__c": 133,
    "ACHTransaction__c": 132,
    "AC_Expected_Launch_Date__c": 182,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 126,
    "Agency_Analytics_PPC_Dashboard__c": 125,
    "AnnualFee__c": 112,
    "Annualgroup__c": 108,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 113,
    "Asset_Cancelled_Non_Payment__c": 234,
    "Asset_Cleanup_Case__c": 250,
    "Asset_Type__c": 47,
    "AuthGroup__c": 102,
    "Avg_Actual_MVR__c": 107,
    "Beanstream_ID__c": 48,
    "BillingCancelled__c": 76,
    "BillingNotes__c": 78,
    "BillingStatus__c": 57,
    "Billing_Type__c": 242,
    "Bulk_Churn_Email_Exemption__c": 224,
    "Bundle_Name__c": 231,
    "Bundle_Tier__c": 58,
    "Bundle_Type__c": 232,
    "CP_Company_ID__c": 151,
    "CP_Location_ID__c": 152,
    "CancelinBillingDate__c": 79,
    "Cancellation_Date__c": 75,
    "Cancellation_Method__c": 155,
    "Cancellation_Reason_Detail__c": 73,
    "Cancellation_Reason__c": 72,
    "Cancelled_via_Cancellation_Wizard__c": 153,
    "Cap__c": 175,
    "Chargeover_ID_Assets__c": 69,
    "Chargeover_Parent_ID_Assets__c": 70,
    "Churn_Forecast_Date__c": 159,
    "Churn_Forecast_Reason_Detail__c": 161,
    "Churn_Forecast_Reason__c": 158,
    "Churn_Opportunity__c": 154,
    "City": 40,
    "Cloud_Node_ID__c": 205,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "Convenience_Fee__c": 243,
    "Country": 43,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 189,
    "Data_Load_By__c": 174,
    "Database_Merge_Cleanup__c": 251,
    "Datawire_ID__c": 49,
    "Date_Debooked__c": 200,
    "Date_New_to_Live__c": 142,
    "Date_Time_ESS_Transfer_Canceled__c": 208,
    "Date_Time_ESS_Transfer_Completed__c": 209,
    "Date_Time_ESS_Transfer_Created__c": 210,
    "Date_Time_ESS_Transfer_Effective__c": 211,
    "Debookedreason__c": 105,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 198,
    "Digital_Marketing_Welcome_Sent__c": 156,
    "DiscontinueProductDate__c": 80,
    "DiscountRate__c": 109,
    "Discountgroup__c": 104,
    "Download_ID__c": 50,
    "ESSAddOnId__c": 184,
    "ESSCompanyId__c": 185,
    "ESSDiscountExpirationDate__c": 188,
    "ESSDiscountedPrice__c": 190,
    "ESSFacilityId__c": 186,
    "ESSPrice__c": 191,
    "ESSSetupFee__c": 192,
    "ESSproduct__c": 135,
    "Epic_Location_Code__c": 226,
    "Epic_Lookup_Code__c": 227,
    "ExternalIdentifier": 23,
    "Financial_Churn_Date__c": 160,
    "GMB_Account_Name__c": 116,
    "GPMCC__c": 90,
    "GeocodeAccuracy": 46,
    "Google_Ads_Account_Name__c": 117,
    "Google_Ads_Account_Number__c": 118,
    "Google_Ads_Campaign_Budget_Daily__c": 121,
    "Google_Ads_Campaign_Budget_Monthly__c": 120,
    "Google_Ads_Campaign_Launch_Date__c": 119,
    "Google_Ads_Google_Doc__c": 123,
    "Google_Ads_Management_Fee__c": 124,
    "Google_Ads_Payment_Type__c": 122,
    "HQMerchantID__c": 93,
    "Hardware__c": 215,
    "HollyID_Assets__c": 63,
    "Id": 0,
    "Imp_Case_Reopened__c": 196,
    "Implementationcase__c": 81,
    "Included_Minutes__c": 237,
    "Included_Tracking_Numbers__c": 238,
    "InstallDate": 19,
    "Integration_Software__c": 244,
    "International_Currency__c": 150,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 138,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "Last_Churn_Save_Date__c": 162,
    "Latitude": 44,
    "LicenseId__c": 165,
    "LicenseTransferredFromAsset__c": 82,
    "LicenseTransferredtoAsset__c": 83,
    "ListPrice__c": 219,
    "LocationId": 32,
    "Longitude": 45,
    "MID_Rewrite__c": 213,
    "MRR__c": 60,
    "MRR_update_date_time_stamp__c": 128,
    "MRRupdated__c": 127,
    "MSTotalVolume__c": 101,
    "ManufactureDate": 20,
    "Marine_Competitor_Lost_To__c": 163,
    "Marine_Expiration_Date__c": 245,
    "Marine_Reprice__c": 157,
    "Maximum_Usage__c": 239,
    "Merchant_ID_Assets__c": 71,
    "Merchant_ID__c": 51,
    "Merchant_Services_Account_Status__c": 199,
    "MigrationId__c": 166,
    "Molo_ID__c": 246,
    "Molo_Site_ID__c": 247,
    "MonthlyFee__c": 111,
    "Monthly_Transaction_Volume_and_Rate__c": 59,
    "NB_CompanyId__c": 167,
    "NB_PropertyID__c": 168,
    "NB_Region__c": 169,
    "Name": 17,
    "NewProduct__c": 84,
    "New_Access_Provider_Other__c": 145,
    "New_Access_Provider__c": 146,
    "New_Insurance_Provider_Other__c": 147,
    "New_Insurance_Provider__c": 144,
    "New_Software_Provider_Other__c": 257,
    "New_Software_Provider__c": 258,
    "New_Website_Provider_Other__c": 255,
    "New_Website_Provider__c": 256,
    "North_ID__c": 52,
    "Opportunity_Product__c": 216,
    "Opportunity__c": 56,
    "OriginalLeaseDate__c": 85,
    "Originating_Order_Product__c": 212,
    "Overage_Rate_for_Minutes__c": 240,
    "Overage_Rate_for_Tracking_Numbers__c": 241,
    "PCI_Activated__c": 252,
    "PCI_ID__c": 253,
    "PCI_Parent_ID__c": 254,
    "PPS_Cleanup_Cancellation__c": 236,
    "P_C_Commission__c": 228,
    "P_C_Expiration_Date__c": 229,
    "P_C_Insurance_Coverage_Types__c": 225,
    "P_C_Start_Date__c": 230,
    "ParentId": 3,
    "PaymentFamily__c": 106,
    "Payments_Activation_Date__c": 114,
    "PendingCancellationDate__c": 94,
    "Planned_Debooking_Date__c": 206,
    "PostalCode": 42,
    "PreviouslyinPendingCancellation__c": 97,
    "Price": 28,
    "Price_Change_Date__c": 197,
    "Price_Lock_Expiration__c": 214,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 193,
    "ProductDatabaseCreatedDate__c": 194,
    "ProductDatabaseLastModifiedDate__c": 195,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 55,
    "Promo_End_Cap__c": 176,
    "Promo_End_Tier__c": 177,
    "Promotional_Expiration_Date__c": 173,
    "PurchaseDate": 24,
    "Quantity": 29,
    "RI_2025_Free_Trial_Converted__c": 148,
    "RI_2025_Free_Trial_Need_Cancelled__c": 149,
    "Rate_Statement_Opportunity__c": 137,
    "Reason_Lost_Category__c": 164,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 96,
    "Rental_Center_Version__c": 134,
    "Repriced__c": 233,
    "RequestedCancellationDate__c": 86,
    "Retention_Case__c": 178,
    "RootAssetId": 4,
    "SE_Company_ID__c": 218,
    "SE_FMS_ID_Assets__c": 68,
    "SE_Facility_UUID__c": 203,
    "SE_UUID_Company__c": 202,
    "SFBEID__c": 95,
    "SFBidRate_Number__c": 77,
    "SFClientKey__c": 91,
    "SFFacilityKey__c": 92,
    "SF_Account_Status__c": 141,
    "SF_Bid_Rate__c": 62,
    "SF_Integration__c": 207,
    "SF_Substatus__c": 143,
    "SLMSAccount__c": 87,
    "SL_Corp_Code_Assets__c": 64,
    "SL_Location_Code_Assets__c": 65,
    "SSLRenewalDate__c": 99,
    "SerialNumber": 18,
    "Ship_To_Case__c": 187,
    "Short_Code__c": 139,
    "SoftwareDiscontinued__c": 89,
    "SoftwareServices__c": 217,
    "Software_Tier__c": 61,
    "Sold_To__c": 74,
    "Source_Facility_Name_Assets__c": 67,
    "Source_Parent_Name_Assets__c": 66,
    "State": 41,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 130,
    "Stellar_Company_ID__c": 248,
    "Stellar_Facility_ID__c": 249,
    "StoPay_Annual_Group__c": 179,
    "StoPay_Auth_Group__c": 180,
    "StoPay_Discount_Group__c": 181,
    "StoPay_Monthly_Group__c": 183,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 129,
    "StopayTotal__c": 131,
    "StorableCoveredEMVDeviceCost__c": 204,
    "Street": 39,
    "SubscriptionInterval__c": 170,
    "Suspend_Asset_Customer_Past_Due__c": 235,
    "SystemModstamp": 14,
    "TerminalType__c": 100,
    "Terminal_ID__c": 54,
    "Text_Product_Name__c": 136,
    "TransactionFee__c": 110,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 201,
    "Uuid": 22,
    "WW_Cohort__c": 140,
    "Website_Type__c": 115,
    "Website__c": 98,
    "X1_Day_Hold__c": 53,
    "Zoho_Corporate_ID__c": 220,
    "Zoho_Corporate_URL__c": 221,
    "Zoho_ID__c": 222,
    "Zoho_URL__c": 223,
    "monthlygroup__c": 103,
    "next_run__c": 171,
    "suspend_date__c": 172
}
    • schema_attributes: 
      {
    "ACHID__c": "string",
    "ACHTransactionFee__c": "string",
    "ACHTransaction__c": "string",
    "AC_Expected_Launch_Date__c": "string",
    "AccountId": "string",
    "Agency_Analytics_Custom_Reports__c": "string",
    "Agency_Analytics_PPC_Dashboard__c": "string",
    "Amount": "string",
    "AnnualFee__c": "string",
    "Annualgroup__c": "string",
    "AssetLevel": "string",
    "AssetProvidedById": "string",
    "AssetServicedById": "string",
    "Asset_Activation_Status__c": "string",
    "Asset_Cancelled_Non_Payment__c": "string",
    "Asset_Cleanup_Case__c": "string",
    "Asset_Notes__c": "string",
    "Asset_Type__c": "string",
    "AuthGroup__c": "string",
    "Avg_Actual_MVR__c": "string",
    "Beanstream_ID__c": "string",
    "BillingCancelled__c": "string",
    "BillingNotes__c": "string",
    "BillingStatus__c": "string",
    "Billing_Type__c": "string",
    "Bulk_Churn_Email_Exemption__c": "string",
    "Bundle_Name__c": "string",
    "Bundle_Tier__c": "string",
    "Bundle_Type__c": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellation_Date__c": "string",
    "Cancellation_Method__c": "string",
    "Cancellation_Reason_Detail__c": "string",
    "Cancellation_Reason__c": "string",
    "Cancelled_via_Cancellation_Wizard__c": "string",
    "Cap__c": "string",
    "Chargeover_ID_Assets__c": "string",
    "Chargeover_Parent_ID_Assets__c": "string",
    "Churn_Forecast_Date__c": "string",
    "Churn_Forecast_Reason_Detail__c": "string",
    "Churn_Forecast_Reason__c": "string",
    "Churn_Opportunity__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "string",
    "Convenience_Fee__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataLakeSyncDate__c": "string",
    "Data_Load_By__c": "string",
    "Database_Merge_Cleanup__c": "string",
    "Datawire_ID__c": "string",
    "Date_Debooked__c": "string",
    "Date_New_to_Live__c": "string",
    "Date_Time_ESS_Transfer_Canceled__c": "string",
    "Date_Time_ESS_Transfer_Completed__c": "string",
    "Date_Time_ESS_Transfer_Created__c": "string",
    "Date_Time_ESS_Transfer_Effective__c": "string",
    "Debookedreason__c": "string",
    "Description": "string",
    "DigitalAssetStatus": "string",
    "Digital_Marketing_Status__c": "string",
    "Digital_Marketing_Welcome_Sent__c": "string",
    "DiscontinueProductDate__c": "string",
    "DiscountRate__c": "string",
    "Discountgroup__c": "string",
    "Download_ID__c": "string",
    "ESSAddOnId__c": "string",
    "ESSCompanyId__c": "string",
    "ESSDiscountExpirationDate__c": "string",
    "ESSDiscountedPrice__c": "string",
    "ESSFacilityId__c": "string",
    "ESSPrice__c": "string",
    "ESSSetupFee__c": "string",
    "ESSproduct__c": "string",
    "Epic_Location_Code__c": "string",
    "Epic_Lookup_Code__c": "string",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "Financial_Churn_Date__c": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "string",
    "GeocodeAccuracy": "string",
    "Google_Ads_Account_Name__c": "string",
    "Google_Ads_Account_Number__c": "string",
    "Google_Ads_Campaign_Budget_Daily__c": "string",
    "Google_Ads_Campaign_Budget_Monthly__c": "string",
    "Google_Ads_Campaign_Launch_Date__c": "string",
    "Google_Ads_Google_Doc__c": "string",
    "Google_Ads_Management_Fee__c": "string",
    "Google_Ads_Payment_Type__c": "string",
    "HQMerchantID__c": "string",
    "Hardware__c": "string",
    "HollyID_Assets__c": "string",
    "Id": "string",
    "Imp_Case_Reopened__c": "string",
    "Implementationcase__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "InstallDate": "string",
    "Integration_Software__c": "string",
    "International_Currency__c": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Churn_Save_Date__c": "string",
    "Latitude": "string",
    "LicenseId__c": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "Longitude": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "string",
    "Marine_Competitor_Lost_To__c": "string",
    "Marine_Expiration_Date__c": "string",
    "Marine_Reprice__c": "string",
    "Maximum_Usage__c": "string",
    "Merchant_ID_Assets__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "MigrationId__c": "string",
    "Molo_ID__c": "string",
    "Molo_Site_ID__c": "string",
    "MonthlyFee__c": "string",
    "Monthly_Transaction_Volume_and_Rate__c": "string",
    "NB_CompanyId__c": "string",
    "NB_PropertyID__c": "string",
    "NB_Region__c": "string",
    "Name": "string",
    "NewProduct__c": "string",
    "New_Access_Provider_Other__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_Other__c": "string",
    "New_Insurance_Provider__c": "string",
    "New_Software_Provider_Other__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Provider_Other__c": "string",
    "New_Website_Provider__c": "string",
    "North_ID__c": "string",
    "OpportunityId": "string",
    "Opportunity_Product__c": "string",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "Originating_Order_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PCI_Activated__c": "string",
    "PCI_ID__c": "string",
    "PCI_Parent_ID__c": "string",
    "PPS_Cleanup_Cancellation__c": "string",
    "P_C_Commission__c": "string",
    "P_C_Expiration_Date__c": "string",
    "P_C_Insurance_Coverage_Types__c": "string",
    "P_C_Start_Date__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "string",
    "Price_Lock_Expiration__c": "string",
    "Probability": "string",
    "Product2Id": "string",
    "ProductCode": "string",
    "ProductDatabaseCancelledDate__c": "string",
    "ProductDatabaseCreatedDate__c": "string",
    "ProductDatabaseLastModifiedDate__c": "string",
    "ProductDescription": "string",
    "ProductFamily": "string",
    "Profituity_ID__c": "string",
    "Promo_End_Cap__c": "string",
    "Promo_End_Tier__c": "string",
    "Promotional_Expiration_Date__c": "string",
    "PurchaseDate": "string",
    "Quantity": "string",
    "RI_2025_Free_Trial_Converted__c": "string",
    "RI_2025_Free_Trial_Need_Cancelled__c": "string",
    "Rate_Statement_Opportunity__c": "string",
    "Reason_Lost_Category__c": "string",
    "RecordTypeId": "string",
    "RelatedOpportunityhasbeenclosedwon__c": "string",
    "Rental_Center_Version__c": "string",
    "Repriced__c": "string",
    "RequestedCancellationDate__c": "string",
    "Retention_Case__c": "string",
    "RootAssetId": "string",
    "SE_Company_ID__c": "string",
    "SE_FMS_ID_Assets__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_UUID_Company__c": "string",
    "SFBEID__c": "string",
    "SFBidRate_Number__c": "string",
    "SFClientKey__c": "string",
    "SFFacilityKey__c": "string",
    "SF_Account_Status__c": "string",
    "SF_Bid_Rate__c": "string",
    "SF_Integration__c": "string",
    "SF_Substatus__c": "string",
    "SLMSAccount__c": "string",
    "SL_Corp_Code_Assets__c": "string",
    "SL_Location_Code_Assets__c": "string",
    "SSLRenewalDate__c": "string",
    "SerialNumber": "string",
    "Ship_To_Case__c": "string",
    "Short_Code__c": "string",
    "SoftwareDiscontinued__c": "string",
    "SoftwareServices__c": "string",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "StatusReason": "string",
    "Statuslastupdate__c": "string",
    "Stellar_Company_ID__c": "string",
    "Stellar_Facility_ID__c": "string",
    "StoPay_Annual_Group__c": "string",
    "StoPay_Auth_Group__c": "string",
    "StoPay_Discount_Group__c": "string",
    "StoPay_Monthly_Group__c": "string",
    "StockKeepingUnit": "string",
    "StopayProduct__c": "string",
    "StopayTotal__c": "string",
    "StorableCoveredEMVDeviceCost__c": "string",
    "Street": "string",
    "SubscriptionInterval__c": "string",
    "Suspend_Asset_Customer_Past_Due__c": "string",
    "SystemModstamp": "string",
    "TerminalType__c": "string",
    "Terminal_ID__c": "string",
    "Text_Product_Name__c": "string",
    "TransactionFee__c": "string",
    "UsageEndDate": "string",
    "User_Activation_Tracking__c": "string",
    "Uuid": "string",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "Zoho_Corporate_ID__c": "string",
    "Zoho_Corporate_URL__c": "string",
    "Zoho_ID__c": "string",
    "Zoho_URL__c": "string",
    "monthlygroup__c": "string",
    "next_run__c": "string",
    "suspend_date__c": "string"
}
    • schema_name_id: 1413
    • schema_scan_id: 6391696
    • updated: 2026-02-27 09:13:36
    • created: 2025-01-09 15:16:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_assets`\n(\n `Id`  string , `ContactId`  string , `AccountId`  string , `ParentId`  string , `RootAssetId`  string , `Product2Id`  string , `ProductCode`  string , `ProductFamily`  string , `ProductDescription`  string , `IsCompetitorProduct`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsDeleted`  string , `CurrencyIsoCode`  string , `Name`  string , `SerialNumber`  string , `InstallDate`  string , `ManufactureDate`  string , `StatusReason`  string , `Uuid`  string , `ExternalIdentifier`  string , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `DigitalAssetStatus`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `LocationId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  string , `ConsequenceOfFailure`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Asset_Type__c`  string , `Beanstream_ID__c`  string , `Datawire_ID__c`  string , `Download_ID__c`  string , `Merchant_ID__c`  string , `North_ID__c`  string , `X1_Day_Hold__c`  string , `Terminal_ID__c`  string , `Profituity_ID__c`  string , `Opportunity__c`  string , `BillingStatus__c`  string , `Bundle_Tier__c`  string , `Monthly_Transaction_Volume_and_Rate__c`  string , `MRR__c`  string , `Software_Tier__c`  string , `SF_Bid_Rate__c`  string , `HollyID_Assets__c`  string , `SL_Corp_Code_Assets__c`  string , `SL_Location_Code_Assets__c`  string , `Source_Parent_Name_Assets__c`  string , `Source_Facility_Name_Assets__c`  string , `SE_FMS_ID_Assets__c`  string , `Chargeover_ID_Assets__c`  string , `Chargeover_Parent_ID_Assets__c`  string , `Merchant_ID_Assets__c`  string , `Cancellation_Reason__c`  string , `Cancellation_Reason_Detail__c`  string , `Sold_To__c`  string , `Competitor_Lost_To__c`  string , `Cancellation_Date__c`  string , `BillingCancelled__c`  string , `SFBidRate_Number__c`  string , `BillingNotes__c`  string , `CancelinBillingDate__c`  string , `DiscontinueProductDate__c`  string , `Implementationcase__c`  string , `LicenseTransferredFromAsset__c`  string , `LicenseTransferredtoAsset__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `RequestedCancellationDate__c`  string , `SLMSAccount__c`  string , `ACHID__c`  string , `SoftwareDiscontinued__c`  string , `GPMCC__c`  string , `SFClientKey__c`  string , `SFFacilityKey__c`  string , `HQMerchantID__c`  string , `PendingCancellationDate__c`  string , `SFBEID__c`  string , `RelatedOpportunityhasbeenclosedwon__c`  string , `PreviouslyinPendingCancellation__c`  string , `Website__c`  string , `SSLRenewalDate__c`  string , `TerminalType__c`  string , `MSTotalVolume__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Debookedreason__c`  string , `PaymentFamily__c`  string , `Avg_Actual_MVR__c`  string , `Annualgroup__c`  string , `DiscountRate__c`  string , `TransactionFee__c`  string , `MonthlyFee__c`  string , `AnnualFee__c`  string , `Asset_Activation_Status__c`  string , `Payments_Activation_Date__c`  string , `Website_Type__c`  string , `GMB_Account_Name__c`  string , `Google_Ads_Account_Name__c`  string , `Google_Ads_Account_Number__c`  string , `Google_Ads_Campaign_Launch_Date__c`  string , `Google_Ads_Campaign_Budget_Monthly__c`  string , `Google_Ads_Campaign_Budget_Daily__c`  string , `Google_Ads_Payment_Type__c`  string , `Google_Ads_Google_Doc__c`  string , `Google_Ads_Management_Fee__c`  string , `Agency_Analytics_PPC_Dashboard__c`  string , `Agency_Analytics_Custom_Reports__c`  string , `MRRupdated__c`  string , `MRR_update_date_time_stamp__c`  string , `StopayProduct__c`  string , `Statuslastupdate__c`  string , `StopayTotal__c`  string , `ACHTransaction__c`  string , `ACHTransactionFee__c`  string , `Rental_Center_Version__c`  string , `ESSproduct__c`  string , `Text_Product_Name__c`  string , `Rate_Statement_Opportunity__c`  string , `JIRA_Ticket__c`  string , `Short_Code__c`  string , `WW_Cohort__c`  string , `SF_Account_Status__c`  string , `Date_New_to_Live__c`  string , `SF_Substatus__c`  string , `New_Insurance_Provider__c`  string , `New_Access_Provider_Other__c`  string , `New_Access_Provider__c`  string , `New_Insurance_Provider_Other__c`  string , `RI_2025_Free_Trial_Converted__c`  string , `RI_2025_Free_Trial_Need_Cancelled__c`  string , `Retention_Case__c`  string , `StoPay_Annual_Group__c`  string , `StoPay_Auth_Group__c`  string , `StoPay_Discount_Group__c`  string , `AC_Expected_Launch_Date__c`  string , `StoPay_Monthly_Group__c`  string , `ESSAddOnId__c`  string , `ESSCompanyId__c`  string , `ESSFacilityId__c`  string , `Ship_To_Case__c`  string , `ESSDiscountExpirationDate__c`  string , `DataLakeSyncDate__c`  string , `ESSDiscountedPrice__c`  string , `ESSPrice__c`  string , `ESSSetupFee__c`  string , `ProductDatabaseCancelledDate__c`  string , `ProductDatabaseCreatedDate__c`  string , `ProductDatabaseLastModifiedDate__c`  string , `Imp_Case_Reopened__c`  string , `Price_Change_Date__c`  string , `Digital_Marketing_Status__c`  string , `Merchant_Services_Account_Status__c`  string , `Date_Debooked__c`  string , `User_Activation_Tracking__c`  string , `SE_UUID_Company__c`  string , `SE_Facility_UUID__c`  string , `StorableCoveredEMVDeviceCost__c`  string , `Cloud_Node_ID__c`  string , `Planned_Debooking_Date__c`  string , `SF_Integration__c`  string , `Date_Time_ESS_Transfer_Canceled__c`  string , `Date_Time_ESS_Transfer_Completed__c`  string , `Date_Time_ESS_Transfer_Created__c`  string , `Date_Time_ESS_Transfer_Effective__c`  string , `Originating_Order_Product__c`  string , `MID_Rewrite__c`  string , `Price_Lock_Expiration__c`  string , `Hardware__c`  string , `Opportunity_Product__c`  string , `SoftwareServices__c`  string , `SE_Company_ID__c`  string , `ListPrice__c`  string , `Zoho_Corporate_ID__c`  string , `Zoho_Corporate_URL__c`  string , `Zoho_ID__c`  string , `Zoho_URL__c`  string , `Bulk_Churn_Email_Exemption__c`  string , `P_C_Insurance_Coverage_Types__c`  string , `Epic_Location_Code__c`  string , `Epic_Lookup_Code__c`  string , `P_C_Commission__c`  string , `P_C_Expiration_Date__c`  string , `P_C_Start_Date__c`  string , `Bundle_Name__c`  string , `Bundle_Type__c`  string , `Repriced__c`  string , `Asset_Cancelled_Non_Payment__c`  string , `Suspend_Asset_Customer_Past_Due__c`  string , `PPS_Cleanup_Cancellation__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Billing_Type__c`  string , `Convenience_Fee__c`  string , `Integration_Software__c`  string , `Marine_Expiration_Date__c`  string , `Molo_ID__c`  string , `Molo_Site_ID__c`  string , `Stellar_Company_ID__c`  string , `Stellar_Facility_ID__c`  string , `Asset_Cleanup_Case__c`  string , `Database_Merge_Cleanup__c`  string , `PCI_Activated__c`  string , `PCI_ID__c`  string , `PCI_Parent_ID__c`  string , `New_Website_Provider_Other__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider_Other__c`  string , `New_Software_Provider__c`  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-csv-salesforce-stage/raw/assets/2025-01-09/1736457277'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/assets/2025-01-09/1736457277
    • id: 797918
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 89,
    "ACHTransactionFee__c": 134,
    "ACHTransaction__c": 133,
    "AC_Expected_Launch_Date__c": 155,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 127,
    "Agency_Analytics_PPC_Dashboard__c": 126,
    "AnnualFee__c": 113,
    "Annualgroup__c": 109,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 114,
    "Asset_Cancelled_Non_Payment__c": 207,
    "Asset_Cleanup_Case__c": 223,
    "Asset_Type__c": 47,
    "AuthGroup__c": 103,
    "Avg_Actual_MVR__c": 108,
    "Beanstream_ID__c": 48,
    "BillingCancelled__c": 77,
    "BillingNotes__c": 79,
    "BillingStatus__c": 57,
    "Billing_Type__c": 215,
    "Bulk_Churn_Email_Exemption__c": 197,
    "Bundle_Name__c": 204,
    "Bundle_Tier__c": 58,
    "Bundle_Type__c": 205,
    "CancelinBillingDate__c": 80,
    "Cancellation_Date__c": 76,
    "Cancellation_Reason_Detail__c": 73,
    "Cancellation_Reason__c": 72,
    "Chargeover_ID_Assets__c": 69,
    "Chargeover_Parent_ID_Assets__c": 70,
    "City": 40,
    "Cloud_Node_ID__c": 178,
    "Competitor_Lost_To__c": 75,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "Convenience_Fee__c": 216,
    "Country": 43,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 162,
    "Database_Merge_Cleanup__c": 224,
    "Datawire_ID__c": 49,
    "Date_Debooked__c": 173,
    "Date_New_to_Live__c": 143,
    "Date_Time_ESS_Transfer_Canceled__c": 181,
    "Date_Time_ESS_Transfer_Completed__c": 182,
    "Date_Time_ESS_Transfer_Created__c": 183,
    "Date_Time_ESS_Transfer_Effective__c": 184,
    "Debookedreason__c": 106,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 171,
    "DiscontinueProductDate__c": 81,
    "DiscountRate__c": 110,
    "Discountgroup__c": 105,
    "Download_ID__c": 50,
    "ESSAddOnId__c": 157,
    "ESSCompanyId__c": 158,
    "ESSDiscountExpirationDate__c": 161,
    "ESSDiscountedPrice__c": 163,
    "ESSFacilityId__c": 159,
    "ESSPrice__c": 164,
    "ESSSetupFee__c": 165,
    "ESSproduct__c": 136,
    "Epic_Location_Code__c": 199,
    "Epic_Lookup_Code__c": 200,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 117,
    "GPMCC__c": 91,
    "GeocodeAccuracy": 46,
    "Google_Ads_Account_Name__c": 118,
    "Google_Ads_Account_Number__c": 119,
    "Google_Ads_Campaign_Budget_Daily__c": 122,
    "Google_Ads_Campaign_Budget_Monthly__c": 121,
    "Google_Ads_Campaign_Launch_Date__c": 120,
    "Google_Ads_Google_Doc__c": 124,
    "Google_Ads_Management_Fee__c": 125,
    "Google_Ads_Payment_Type__c": 123,
    "HQMerchantID__c": 94,
    "Hardware__c": 188,
    "HollyID_Assets__c": 63,
    "Id": 0,
    "Imp_Case_Reopened__c": 169,
    "Implementationcase__c": 82,
    "Included_Minutes__c": 210,
    "Included_Tracking_Numbers__c": 211,
    "InstallDate": 19,
    "Integration_Software__c": 217,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 139,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "Latitude": 44,
    "LicenseTransferredFromAsset__c": 83,
    "LicenseTransferredtoAsset__c": 84,
    "ListPrice__c": 192,
    "LocationId": 32,
    "Longitude": 45,
    "MID_Rewrite__c": 186,
    "MRR__c": 60,
    "MRR_update_date_time_stamp__c": 129,
    "MRRupdated__c": 128,
    "MSTotalVolume__c": 102,
    "ManufactureDate": 20,
    "Marine_Expiration_Date__c": 218,
    "Maximum_Usage__c": 212,
    "Merchant_ID_Assets__c": 71,
    "Merchant_ID__c": 51,
    "Merchant_Services_Account_Status__c": 172,
    "Molo_ID__c": 219,
    "Molo_Site_ID__c": 220,
    "MonthlyFee__c": 112,
    "Monthly_Transaction_Volume_and_Rate__c": 59,
    "Name": 17,
    "NewProduct__c": 85,
    "New_Access_Provider_Other__c": 146,
    "New_Access_Provider__c": 147,
    "New_Insurance_Provider_Other__c": 148,
    "New_Insurance_Provider__c": 145,
    "New_Software_Provider_Other__c": 230,
    "New_Software_Provider__c": 231,
    "New_Website_Provider_Other__c": 228,
    "New_Website_Provider__c": 229,
    "North_ID__c": 52,
    "Opportunity_Product__c": 189,
    "Opportunity__c": 56,
    "OriginalLeaseDate__c": 86,
    "Originating_Order_Product__c": 185,
    "Overage_Rate_for_Minutes__c": 213,
    "Overage_Rate_for_Tracking_Numbers__c": 214,
    "PCI_Activated__c": 225,
    "PCI_ID__c": 226,
    "PCI_Parent_ID__c": 227,
    "PPS_Cleanup_Cancellation__c": 209,
    "P_C_Commission__c": 201,
    "P_C_Expiration_Date__c": 202,
    "P_C_Insurance_Coverage_Types__c": 198,
    "P_C_Start_Date__c": 203,
    "ParentId": 3,
    "PaymentFamily__c": 107,
    "Payments_Activation_Date__c": 115,
    "PendingCancellationDate__c": 95,
    "Planned_Debooking_Date__c": 179,
    "PostalCode": 42,
    "PreviouslyinPendingCancellation__c": 98,
    "Price": 28,
    "Price_Change_Date__c": 170,
    "Price_Lock_Expiration__c": 187,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 166,
    "ProductDatabaseCreatedDate__c": 167,
    "ProductDatabaseLastModifiedDate__c": 168,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 55,
    "PurchaseDate": 24,
    "Quantity": 29,
    "RI_2025_Free_Trial_Converted__c": 149,
    "RI_2025_Free_Trial_Need_Cancelled__c": 150,
    "Rate_Statement_Opportunity__c": 138,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 97,
    "Rental_Center_Version__c": 135,
    "Repriced__c": 206,
    "RequestedCancellationDate__c": 87,
    "Retention_Case__c": 151,
    "RootAssetId": 4,
    "SE_Company_ID__c": 191,
    "SE_FMS_ID_Assets__c": 68,
    "SE_Facility_UUID__c": 176,
    "SE_UUID_Company__c": 175,
    "SFBEID__c": 96,
    "SFBidRate_Number__c": 78,
    "SFClientKey__c": 92,
    "SFFacilityKey__c": 93,
    "SF_Account_Status__c": 142,
    "SF_Bid_Rate__c": 62,
    "SF_Integration__c": 180,
    "SF_Substatus__c": 144,
    "SLMSAccount__c": 88,
    "SL_Corp_Code_Assets__c": 64,
    "SL_Location_Code_Assets__c": 65,
    "SSLRenewalDate__c": 100,
    "SerialNumber": 18,
    "Ship_To_Case__c": 160,
    "Short_Code__c": 140,
    "SoftwareDiscontinued__c": 90,
    "SoftwareServices__c": 190,
    "Software_Tier__c": 61,
    "Sold_To__c": 74,
    "Source_Facility_Name_Assets__c": 67,
    "Source_Parent_Name_Assets__c": 66,
    "State": 41,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 131,
    "Stellar_Company_ID__c": 221,
    "Stellar_Facility_ID__c": 222,
    "StoPay_Annual_Group__c": 152,
    "StoPay_Auth_Group__c": 153,
    "StoPay_Discount_Group__c": 154,
    "StoPay_Monthly_Group__c": 156,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 130,
    "StopayTotal__c": 132,
    "StorableCoveredEMVDeviceCost__c": 177,
    "Street": 39,
    "Suspend_Asset_Customer_Past_Due__c": 208,
    "SystemModstamp": 14,
    "TerminalType__c": 101,
    "Terminal_ID__c": 54,
    "Text_Product_Name__c": 137,
    "TransactionFee__c": 111,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 174,
    "Uuid": 22,
    "WW_Cohort__c": 141,
    "Website_Type__c": 116,
    "Website__c": 99,
    "X1_Day_Hold__c": 53,
    "Zoho_Corporate_ID__c": 193,
    "Zoho_Corporate_URL__c": 194,
    "Zoho_ID__c": 195,
    "Zoho_URL__c": 196,
    "monthlygroup__c": 104
}
    • schema_attributes: 
      {
    "ACHID__c": "string",
    "ACHTransactionFee__c": "string",
    "ACHTransaction__c": "string",
    "AC_Expected_Launch_Date__c": "string",
    "AccountId": "string",
    "Agency_Analytics_Custom_Reports__c": "string",
    "Agency_Analytics_PPC_Dashboard__c": "string",
    "Amount": "string",
    "AnnualFee__c": "string",
    "Annualgroup__c": "string",
    "AssetLevel": "string",
    "AssetProvidedById": "string",
    "AssetServicedById": "string",
    "Asset_Activation_Status__c": "string",
    "Asset_Cancelled_Non_Payment__c": "string",
    "Asset_Cleanup_Case__c": "string",
    "Asset_Notes__c": "string",
    "Asset_Type__c": "string",
    "AuthGroup__c": "string",
    "Avg_Actual_MVR__c": "string",
    "Beanstream_ID__c": "string",
    "BillingCancelled__c": "string",
    "BillingNotes__c": "string",
    "BillingStatus__c": "string",
    "Billing_Type__c": "string",
    "Bulk_Churn_Email_Exemption__c": "string",
    "Bundle_Name__c": "string",
    "Bundle_Tier__c": "string",
    "Bundle_Type__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellation_Date__c": "string",
    "Cancellation_Reason_Detail__c": "string",
    "Cancellation_Reason__c": "string",
    "Chargeover_ID_Assets__c": "string",
    "Chargeover_Parent_ID_Assets__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "string",
    "Convenience_Fee__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataLakeSyncDate__c": "string",
    "Database_Merge_Cleanup__c": "string",
    "Datawire_ID__c": "string",
    "Date_Debooked__c": "string",
    "Date_New_to_Live__c": "string",
    "Date_Time_ESS_Transfer_Canceled__c": "string",
    "Date_Time_ESS_Transfer_Completed__c": "string",
    "Date_Time_ESS_Transfer_Created__c": "string",
    "Date_Time_ESS_Transfer_Effective__c": "string",
    "Debookedreason__c": "string",
    "Description": "string",
    "DigitalAssetStatus": "string",
    "Digital_Marketing_Status__c": "string",
    "DiscontinueProductDate__c": "string",
    "DiscountRate__c": "string",
    "Discountgroup__c": "string",
    "Download_ID__c": "string",
    "ESSAddOnId__c": "string",
    "ESSCompanyId__c": "string",
    "ESSDiscountExpirationDate__c": "string",
    "ESSDiscountedPrice__c": "string",
    "ESSFacilityId__c": "string",
    "ESSPrice__c": "string",
    "ESSSetupFee__c": "string",
    "ESSproduct__c": "string",
    "Epic_Location_Code__c": "string",
    "Epic_Lookup_Code__c": "string",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "string",
    "GeocodeAccuracy": "string",
    "Google_Ads_Account_Name__c": "string",
    "Google_Ads_Account_Number__c": "string",
    "Google_Ads_Campaign_Budget_Daily__c": "string",
    "Google_Ads_Campaign_Budget_Monthly__c": "string",
    "Google_Ads_Campaign_Launch_Date__c": "string",
    "Google_Ads_Google_Doc__c": "string",
    "Google_Ads_Management_Fee__c": "string",
    "Google_Ads_Payment_Type__c": "string",
    "HQMerchantID__c": "string",
    "Hardware__c": "string",
    "HollyID_Assets__c": "string",
    "Id": "string",
    "Imp_Case_Reopened__c": "string",
    "Implementationcase__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "InstallDate": "string",
    "Integration_Software__c": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Latitude": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "Longitude": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "string",
    "Marine_Expiration_Date__c": "string",
    "Maximum_Usage__c": "string",
    "Merchant_ID_Assets__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "Molo_ID__c": "string",
    "Molo_Site_ID__c": "string",
    "MonthlyFee__c": "string",
    "Monthly_Transaction_Volume_and_Rate__c": "string",
    "Name": "string",
    "NewProduct__c": "string",
    "New_Access_Provider_Other__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_Other__c": "string",
    "New_Insurance_Provider__c": "string",
    "New_Software_Provider_Other__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Provider_Other__c": "string",
    "New_Website_Provider__c": "string",
    "North_ID__c": "string",
    "OpportunityId": "string",
    "Opportunity_Product__c": "string",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "Originating_Order_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PCI_Activated__c": "string",
    "PCI_ID__c": "string",
    "PCI_Parent_ID__c": "string",
    "PPS_Cleanup_Cancellation__c": "string",
    "P_C_Commission__c": "string",
    "P_C_Expiration_Date__c": "string",
    "P_C_Insurance_Coverage_Types__c": "string",
    "P_C_Start_Date__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "string",
    "Price_Lock_Expiration__c": "string",
    "Probability": "string",
    "Product2Id": "string",
    "ProductCode": "string",
    "ProductDatabaseCancelledDate__c": "string",
    "ProductDatabaseCreatedDate__c": "string",
    "ProductDatabaseLastModifiedDate__c": "string",
    "ProductDescription": "string",
    "ProductFamily": "string",
    "Profituity_ID__c": "string",
    "PurchaseDate": "string",
    "Quantity": "string",
    "RI_2025_Free_Trial_Converted__c": "string",
    "RI_2025_Free_Trial_Need_Cancelled__c": "string",
    "Rate_Statement_Opportunity__c": "string",
    "RecordTypeId": "string",
    "RelatedOpportunityhasbeenclosedwon__c": "string",
    "Rental_Center_Version__c": "string",
    "Repriced__c": "string",
    "RequestedCancellationDate__c": "string",
    "Retention_Case__c": "string",
    "RootAssetId": "string",
    "SE_Company_ID__c": "string",
    "SE_FMS_ID_Assets__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_UUID_Company__c": "string",
    "SFBEID__c": "string",
    "SFBidRate_Number__c": "string",
    "SFClientKey__c": "string",
    "SFFacilityKey__c": "string",
    "SF_Account_Status__c": "string",
    "SF_Bid_Rate__c": "string",
    "SF_Integration__c": "string",
    "SF_Substatus__c": "string",
    "SLMSAccount__c": "string",
    "SL_Corp_Code_Assets__c": "string",
    "SL_Location_Code_Assets__c": "string",
    "SSLRenewalDate__c": "string",
    "SerialNumber": "string",
    "Ship_To_Case__c": "string",
    "Short_Code__c": "string",
    "SoftwareDiscontinued__c": "string",
    "SoftwareServices__c": "string",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "StatusReason": "string",
    "Statuslastupdate__c": "string",
    "Stellar_Company_ID__c": "string",
    "Stellar_Facility_ID__c": "string",
    "StoPay_Annual_Group__c": "string",
    "StoPay_Auth_Group__c": "string",
    "StoPay_Discount_Group__c": "string",
    "StoPay_Monthly_Group__c": "string",
    "StockKeepingUnit": "string",
    "StopayProduct__c": "string",
    "StopayTotal__c": "string",
    "StorableCoveredEMVDeviceCost__c": "string",
    "Street": "string",
    "Suspend_Asset_Customer_Past_Due__c": "string",
    "SystemModstamp": "string",
    "TerminalType__c": "string",
    "Terminal_ID__c": "string",
    "Text_Product_Name__c": "string",
    "TransactionFee__c": "string",
    "UsageEndDate": "string",
    "User_Activation_Tracking__c": "string",
    "Uuid": "string",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "Zoho_Corporate_ID__c": "string",
    "Zoho_Corporate_URL__c": "string",
    "Zoho_ID__c": "string",
    "Zoho_URL__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 1413
    • schema_scan_id: 6197233
    • updated: 2025-01-09 15:16:41
    • created: 2024-05-01 08:53:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_assets`\n(\n `Id`  string , `ContactId`  string , `AccountId`  string , `ParentId`  string , `RootAssetId`  string , `Product2Id`  string , `ProductCode`  string , `ProductFamily`  string , `ProductDescription`  string , `IsCompetitorProduct`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsDeleted`  string , `CurrencyIsoCode`  string , `Name`  string , `SerialNumber`  string , `InstallDate`  string , `ManufactureDate`  string , `StatusReason`  string , `Uuid`  string , `ExternalIdentifier`  string , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `DigitalAssetStatus`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `LocationId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  string , `ConsequenceOfFailure`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Asset_Type__c`  string , `Beanstream_ID__c`  string , `Datawire_ID__c`  string , `Download_ID__c`  string , `Merchant_ID__c`  string , `North_ID__c`  string , `X1_Day_Hold__c`  string , `Terminal_ID__c`  string , `Profituity_ID__c`  string , `Opportunity__c`  string , `BillingStatus__c`  string , `Bundle_Tier__c`  string , `Monthly_Transaction_Volume_and_Rate__c`  string , `MRR__c`  string , `Software_Tier__c`  string , `SF_Bid_Rate__c`  string , `HollyID_Assets__c`  string , `SL_Corp_Code_Assets__c`  string , `SL_Location_Code_Assets__c`  string , `Source_Parent_Name_Assets__c`  string , `Source_Facility_Name_Assets__c`  string , `SE_FMS_ID_Assets__c`  string , `Chargeover_ID_Assets__c`  string , `Chargeover_Parent_ID_Assets__c`  string , `Merchant_ID_Assets__c`  string , `Cancellation_Reason__c`  string , `Cancellation_Reason_Detail__c`  string , `Sold_To__c`  string , `Competitor_Lost_To__c`  string , `Cancellation_Date__c`  string , `BillingCancelled__c`  string , `SFBidRate_Number__c`  string , `BillingNotes__c`  string , `CancelinBillingDate__c`  string , `DiscontinueProductDate__c`  string , `Implementationcase__c`  string , `LicenseTransferredFromAsset__c`  string , `LicenseTransferredtoAsset__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `RequestedCancellationDate__c`  string , `SLMSAccount__c`  string , `ACHID__c`  string , `SoftwareDiscontinued__c`  string , `GPMCC__c`  string , `SFClientKey__c`  string , `SFFacilityKey__c`  string , `HQMerchantID__c`  string , `PendingCancellationDate__c`  string , `SFBEID__c`  string , `RelatedOpportunityhasbeenclosedwon__c`  string , `PreviouslyinPendingCancellation__c`  string , `Website__c`  string , `SSLRenewalDate__c`  string , `TerminalType__c`  string , `MSTotalVolume__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Debookedreason__c`  string , `PaymentFamily__c`  string , `Avg_Actual_MVR__c`  string , `Annualgroup__c`  string , `DiscountRate__c`  string , `TransactionFee__c`  string , `MonthlyFee__c`  string , `AnnualFee__c`  string , `Asset_Activation_Status__c`  string , `Payments_Activation_Date__c`  string , `Website_Type__c`  string , `GMB_Account_Name__c`  string , `Google_Ads_Account_Name__c`  string , `Google_Ads_Account_Number__c`  string , `Google_Ads_Campaign_Launch_Date__c`  string , `Google_Ads_Campaign_Budget_Monthly__c`  string , `Google_Ads_Campaign_Budget_Daily__c`  string , `Google_Ads_Payment_Type__c`  string , `Google_Ads_Google_Doc__c`  string , `Google_Ads_Management_Fee__c`  string , `Agency_Analytics_PPC_Dashboard__c`  string , `Agency_Analytics_Custom_Reports__c`  string , `MRRupdated__c`  string , `MRR_update_date_time_stamp__c`  string , `StopayProduct__c`  string , `Statuslastupdate__c`  string , `StopayTotal__c`  string , `ACHTransaction__c`  string , `ACHTransactionFee__c`  string , `Rental_Center_Version__c`  string , `ESSproduct__c`  string , `Text_Product_Name__c`  string , `Rate_Statement_Opportunity__c`  string , `JIRA_Ticket__c`  string , `Short_Code__c`  string , `WW_Cohort__c`  string , `SF_Account_Status__c`  string , `Date_New_to_Live__c`  string , `SF_Substatus__c`  string , `Retention_Case__c`  string , `StoPay_Annual_Group__c`  string , `StoPay_Auth_Group__c`  string , `StoPay_Discount_Group__c`  string , `AC_Expected_Launch_Date__c`  string , `StoPay_Monthly_Group__c`  string , `ESSAddOnId__c`  string , `ESSCompanyId__c`  string , `ESSFacilityId__c`  string , `Ship_To_Case__c`  string , `ESSDiscountExpirationDate__c`  string , `DataLakeSyncDate__c`  string , `ESSDiscountedPrice__c`  string , `ESSPrice__c`  string , `ESSSetupFee__c`  string , `ProductDatabaseCancelledDate__c`  string , `ProductDatabaseCreatedDate__c`  string , `ProductDatabaseLastModifiedDate__c`  string , `Imp_Case_Reopened__c`  string , `Price_Change_Date__c`  string , `Digital_Marketing_Status__c`  string , `Merchant_Services_Account_Status__c`  string , `Date_Debooked__c`  string , `User_Activation_Tracking__c`  string , `SE_UUID_Company__c`  string , `SE_Facility_UUID__c`  string , `StorableCoveredEMVDeviceCost__c`  string , `Cloud_Node_ID__c`  string , `Planned_Debooking_Date__c`  string , `SF_Integration__c`  string , `Date_Time_ESS_Transfer_Canceled__c`  string , `Date_Time_ESS_Transfer_Completed__c`  string , `Date_Time_ESS_Transfer_Created__c`  string , `Date_Time_ESS_Transfer_Effective__c`  string , `Originating_Order_Product__c`  string , `MID_Rewrite__c`  string , `Price_Lock_Expiration__c`  string , `Hardware__c`  string , `Opportunity_Product__c`  string , `SoftwareServices__c`  string , `SE_Company_ID__c`  string , `ListPrice__c`  string , `Zoho_Corporate_ID__c`  string , `Zoho_Corporate_URL__c`  string , `Zoho_ID__c`  string , `Zoho_URL__c`  string , `Bulk_Churn_Email_Exemption__c`  string , `P_C_Insurance_Coverage_Types__c`  string , `Epic_Location_Code__c`  string , `Epic_Lookup_Code__c`  string , `P_C_Commission__c`  string , `P_C_Expiration_Date__c`  string , `P_C_Start_Date__c`  string , `Bundle_Name__c`  string , `Bundle_Type__c`  string , `Repriced__c`  string , `Asset_Cancelled_Non_Payment__c`  string , `Suspend_Asset_Customer_Past_Due__c`  string , `PPS_Cleanup_Cancellation__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  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-csv-salesforce-stage/raw/assets/2024-05-01/1714571558'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-stage/raw/assets/2024-05-01/1714571558
    • id: 693414
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 89,
    "ACHTransactionFee__c": 134,
    "ACHTransaction__c": 133,
    "AC_Expected_Launch_Date__c": 149,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 127,
    "Agency_Analytics_PPC_Dashboard__c": 126,
    "AnnualFee__c": 113,
    "Annualgroup__c": 109,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 114,
    "Asset_Cancelled_Non_Payment__c": 201,
    "Asset_Type__c": 47,
    "AuthGroup__c": 103,
    "Avg_Actual_MVR__c": 108,
    "Beanstream_ID__c": 48,
    "BillingCancelled__c": 77,
    "BillingNotes__c": 79,
    "BillingStatus__c": 57,
    "Bulk_Churn_Email_Exemption__c": 191,
    "Bundle_Name__c": 198,
    "Bundle_Tier__c": 58,
    "Bundle_Type__c": 199,
    "CancelinBillingDate__c": 80,
    "Cancellation_Date__c": 76,
    "Cancellation_Reason_Detail__c": 73,
    "Cancellation_Reason__c": 72,
    "Chargeover_ID_Assets__c": 69,
    "Chargeover_Parent_ID_Assets__c": 70,
    "City": 40,
    "Cloud_Node_ID__c": 172,
    "Competitor_Lost_To__c": 75,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "Country": 43,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 156,
    "Datawire_ID__c": 49,
    "Date_Debooked__c": 167,
    "Date_New_to_Live__c": 143,
    "Date_Time_ESS_Transfer_Canceled__c": 175,
    "Date_Time_ESS_Transfer_Completed__c": 176,
    "Date_Time_ESS_Transfer_Created__c": 177,
    "Date_Time_ESS_Transfer_Effective__c": 178,
    "Debookedreason__c": 106,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 165,
    "DiscontinueProductDate__c": 81,
    "DiscountRate__c": 110,
    "Discountgroup__c": 105,
    "Download_ID__c": 50,
    "ESSAddOnId__c": 151,
    "ESSCompanyId__c": 152,
    "ESSDiscountExpirationDate__c": 155,
    "ESSDiscountedPrice__c": 157,
    "ESSFacilityId__c": 153,
    "ESSPrice__c": 158,
    "ESSSetupFee__c": 159,
    "ESSproduct__c": 136,
    "Epic_Location_Code__c": 193,
    "Epic_Lookup_Code__c": 194,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 117,
    "GPMCC__c": 91,
    "GeocodeAccuracy": 46,
    "Google_Ads_Account_Name__c": 118,
    "Google_Ads_Account_Number__c": 119,
    "Google_Ads_Campaign_Budget_Daily__c": 122,
    "Google_Ads_Campaign_Budget_Monthly__c": 121,
    "Google_Ads_Campaign_Launch_Date__c": 120,
    "Google_Ads_Google_Doc__c": 124,
    "Google_Ads_Management_Fee__c": 125,
    "Google_Ads_Payment_Type__c": 123,
    "HQMerchantID__c": 94,
    "Hardware__c": 182,
    "HollyID_Assets__c": 63,
    "Id": 0,
    "Imp_Case_Reopened__c": 163,
    "Implementationcase__c": 82,
    "Included_Minutes__c": 204,
    "Included_Tracking_Numbers__c": 205,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 139,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "Latitude": 44,
    "LicenseTransferredFromAsset__c": 83,
    "LicenseTransferredtoAsset__c": 84,
    "ListPrice__c": 186,
    "LocationId": 32,
    "Longitude": 45,
    "MID_Rewrite__c": 180,
    "MRR__c": 60,
    "MRR_update_date_time_stamp__c": 129,
    "MRRupdated__c": 128,
    "MSTotalVolume__c": 102,
    "ManufactureDate": 20,
    "Maximum_Usage__c": 206,
    "Merchant_ID_Assets__c": 71,
    "Merchant_ID__c": 51,
    "Merchant_Services_Account_Status__c": 166,
    "MonthlyFee__c": 112,
    "Monthly_Transaction_Volume_and_Rate__c": 59,
    "Name": 17,
    "NewProduct__c": 85,
    "North_ID__c": 52,
    "Opportunity_Product__c": 183,
    "Opportunity__c": 56,
    "OriginalLeaseDate__c": 86,
    "Originating_Order_Product__c": 179,
    "Overage_Rate_for_Minutes__c": 207,
    "Overage_Rate_for_Tracking_Numbers__c": 208,
    "PPS_Cleanup_Cancellation__c": 203,
    "P_C_Commission__c": 195,
    "P_C_Expiration_Date__c": 196,
    "P_C_Insurance_Coverage_Types__c": 192,
    "P_C_Start_Date__c": 197,
    "ParentId": 3,
    "PaymentFamily__c": 107,
    "Payments_Activation_Date__c": 115,
    "PendingCancellationDate__c": 95,
    "Planned_Debooking_Date__c": 173,
    "PostalCode": 42,
    "PreviouslyinPendingCancellation__c": 98,
    "Price": 28,
    "Price_Change_Date__c": 164,
    "Price_Lock_Expiration__c": 181,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 160,
    "ProductDatabaseCreatedDate__c": 161,
    "ProductDatabaseLastModifiedDate__c": 162,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 55,
    "PurchaseDate": 24,
    "Quantity": 29,
    "Rate_Statement_Opportunity__c": 138,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 97,
    "Rental_Center_Version__c": 135,
    "Repriced__c": 200,
    "RequestedCancellationDate__c": 87,
    "Retention_Case__c": 145,
    "RootAssetId": 4,
    "SE_Company_ID__c": 185,
    "SE_FMS_ID_Assets__c": 68,
    "SE_Facility_UUID__c": 170,
    "SE_UUID_Company__c": 169,
    "SFBEID__c": 96,
    "SFBidRate_Number__c": 78,
    "SFClientKey__c": 92,
    "SFFacilityKey__c": 93,
    "SF_Account_Status__c": 142,
    "SF_Bid_Rate__c": 62,
    "SF_Integration__c": 174,
    "SF_Substatus__c": 144,
    "SLMSAccount__c": 88,
    "SL_Corp_Code_Assets__c": 64,
    "SL_Location_Code_Assets__c": 65,
    "SSLRenewalDate__c": 100,
    "SerialNumber": 18,
    "Ship_To_Case__c": 154,
    "Short_Code__c": 140,
    "SoftwareDiscontinued__c": 90,
    "SoftwareServices__c": 184,
    "Software_Tier__c": 61,
    "Sold_To__c": 74,
    "Source_Facility_Name_Assets__c": 67,
    "Source_Parent_Name_Assets__c": 66,
    "State": 41,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 131,
    "StoPay_Annual_Group__c": 146,
    "StoPay_Auth_Group__c": 147,
    "StoPay_Discount_Group__c": 148,
    "StoPay_Monthly_Group__c": 150,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 130,
    "StopayTotal__c": 132,
    "StorableCoveredEMVDeviceCost__c": 171,
    "Street": 39,
    "Suspend_Asset_Customer_Past_Due__c": 202,
    "SystemModstamp": 14,
    "TerminalType__c": 101,
    "Terminal_ID__c": 54,
    "Text_Product_Name__c": 137,
    "TransactionFee__c": 111,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 168,
    "Uuid": 22,
    "WW_Cohort__c": 141,
    "Website_Type__c": 116,
    "Website__c": 99,
    "X1_Day_Hold__c": 53,
    "Zoho_Corporate_ID__c": 187,
    "Zoho_Corporate_URL__c": 188,
    "Zoho_ID__c": 189,
    "Zoho_URL__c": 190,
    "monthlygroup__c": 104
}
    • schema_attributes: 
      {
    "ACHID__c": "string",
    "ACHTransactionFee__c": "string",
    "ACHTransaction__c": "string",
    "AC_Expected_Launch_Date__c": "string",
    "AccountId": "string",
    "Agency_Analytics_Custom_Reports__c": "string",
    "Agency_Analytics_PPC_Dashboard__c": "string",
    "Amount": "string",
    "AnnualFee__c": "string",
    "Annualgroup__c": "string",
    "AssetLevel": "string",
    "AssetProvidedById": "string",
    "AssetServicedById": "string",
    "Asset_Activation_Status__c": "string",
    "Asset_Cancelled_Non_Payment__c": "string",
    "Asset_Notes__c": "string",
    "Asset_Type__c": "string",
    "AuthGroup__c": "string",
    "Avg_Actual_MVR__c": "string",
    "Beanstream_ID__c": "string",
    "BillingCancelled__c": "string",
    "BillingNotes__c": "string",
    "BillingStatus__c": "string",
    "Bulk_Churn_Email_Exemption__c": "string",
    "Bundle_Name__c": "string",
    "Bundle_Tier__c": "string",
    "Bundle_Type__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellation_Date__c": "string",
    "Cancellation_Reason_Detail__c": "string",
    "Cancellation_Reason__c": "string",
    "Chargeover_ID_Assets__c": "string",
    "Chargeover_Parent_ID_Assets__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataLakeSyncDate__c": "string",
    "Datawire_ID__c": "string",
    "Date_Debooked__c": "string",
    "Date_New_to_Live__c": "string",
    "Date_Time_ESS_Transfer_Canceled__c": "string",
    "Date_Time_ESS_Transfer_Completed__c": "string",
    "Date_Time_ESS_Transfer_Created__c": "string",
    "Date_Time_ESS_Transfer_Effective__c": "string",
    "Debookedreason__c": "string",
    "Description": "string",
    "DigitalAssetStatus": "string",
    "Digital_Marketing_Status__c": "string",
    "DiscontinueProductDate__c": "string",
    "DiscountRate__c": "string",
    "Discountgroup__c": "string",
    "Download_ID__c": "string",
    "ESSAddOnId__c": "string",
    "ESSCompanyId__c": "string",
    "ESSDiscountExpirationDate__c": "string",
    "ESSDiscountedPrice__c": "string",
    "ESSFacilityId__c": "string",
    "ESSPrice__c": "string",
    "ESSSetupFee__c": "string",
    "ESSproduct__c": "string",
    "Epic_Location_Code__c": "string",
    "Epic_Lookup_Code__c": "string",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "string",
    "GeocodeAccuracy": "string",
    "Google_Ads_Account_Name__c": "string",
    "Google_Ads_Account_Number__c": "string",
    "Google_Ads_Campaign_Budget_Daily__c": "string",
    "Google_Ads_Campaign_Budget_Monthly__c": "string",
    "Google_Ads_Campaign_Launch_Date__c": "string",
    "Google_Ads_Google_Doc__c": "string",
    "Google_Ads_Management_Fee__c": "string",
    "Google_Ads_Payment_Type__c": "string",
    "HQMerchantID__c": "string",
    "Hardware__c": "string",
    "HollyID_Assets__c": "string",
    "Id": "string",
    "Imp_Case_Reopened__c": "string",
    "Implementationcase__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "InstallDate": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Latitude": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "Longitude": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "string",
    "Maximum_Usage__c": "string",
    "Merchant_ID_Assets__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "MonthlyFee__c": "string",
    "Monthly_Transaction_Volume_and_Rate__c": "string",
    "Name": "string",
    "NewProduct__c": "string",
    "North_ID__c": "string",
    "OpportunityId": "string",
    "Opportunity_Product__c": "string",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "Originating_Order_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PPS_Cleanup_Cancellation__c": "string",
    "P_C_Commission__c": "string",
    "P_C_Expiration_Date__c": "string",
    "P_C_Insurance_Coverage_Types__c": "string",
    "P_C_Start_Date__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "string",
    "Price_Lock_Expiration__c": "string",
    "Probability": "string",
    "Product2Id": "string",
    "ProductCode": "string",
    "ProductDatabaseCancelledDate__c": "string",
    "ProductDatabaseCreatedDate__c": "string",
    "ProductDatabaseLastModifiedDate__c": "string",
    "ProductDescription": "string",
    "ProductFamily": "string",
    "Profituity_ID__c": "string",
    "PurchaseDate": "string",
    "Quantity": "string",
    "Rate_Statement_Opportunity__c": "string",
    "RecordTypeId": "string",
    "RelatedOpportunityhasbeenclosedwon__c": "string",
    "Rental_Center_Version__c": "string",
    "Repriced__c": "string",
    "RequestedCancellationDate__c": "string",
    "Retention_Case__c": "string",
    "RootAssetId": "string",
    "SE_Company_ID__c": "string",
    "SE_FMS_ID_Assets__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_UUID_Company__c": "string",
    "SFBEID__c": "string",
    "SFBidRate_Number__c": "string",
    "SFClientKey__c": "string",
    "SFFacilityKey__c": "string",
    "SF_Account_Status__c": "string",
    "SF_Bid_Rate__c": "string",
    "SF_Integration__c": "string",
    "SF_Substatus__c": "string",
    "SLMSAccount__c": "string",
    "SL_Corp_Code_Assets__c": "string",
    "SL_Location_Code_Assets__c": "string",
    "SSLRenewalDate__c": "string",
    "SerialNumber": "string",
    "Ship_To_Case__c": "string",
    "Short_Code__c": "string",
    "SoftwareDiscontinued__c": "string",
    "SoftwareServices__c": "string",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "StatusReason": "string",
    "Statuslastupdate__c": "string",
    "StoPay_Annual_Group__c": "string",
    "StoPay_Auth_Group__c": "string",
    "StoPay_Discount_Group__c": "string",
    "StoPay_Monthly_Group__c": "string",
    "StockKeepingUnit": "string",
    "StopayProduct__c": "string",
    "StopayTotal__c": "string",
    "StorableCoveredEMVDeviceCost__c": "string",
    "Street": "string",
    "Suspend_Asset_Customer_Past_Due__c": "string",
    "SystemModstamp": "string",
    "TerminalType__c": "string",
    "Terminal_ID__c": "string",
    "Text_Product_Name__c": "string",
    "TransactionFee__c": "string",
    "UsageEndDate": "string",
    "User_Activation_Tracking__c": "string",
    "Uuid": "string",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "Zoho_Corporate_ID__c": "string",
    "Zoho_Corporate_URL__c": "string",
    "Zoho_ID__c": "string",
    "Zoho_URL__c": "string",
    "monthlygroup__c": "string"
}
    • schema_name_id: 1413
    • schema_scan_id: 5671808
    • updated: 2024-05-01 08:53:22
Schema Scans: 3
Last at 2026-02-27 09:13:17
    • duration: 0:00:19.266213
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6391696
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/assets/2026-02-27/1772205053",
        "key": "raw/assets/2026-02-27/1772205053/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12037260217701816616,
        "service_name": "drive-thru",
        "span_id": 11399570082426579994,
        "trace_id": 8093185205116485871
    }
}
    • running: False
    • schema_name_id: 1413
    • start_time: 2026-02-27 09:13:17
    • success: True
    • trace_id: 8093185205116485871
    • duration: 0:00:18.745657
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6197233
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/assets/2025-01-09/1736457277",
        "key": "raw/assets/2025-01-09/1736457277/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6138918671335451044,
        "service_name": "drive-thru",
        "span_id": 180802426054814039,
        "trace_id": 5045385030915451653
    }
}
    • running: False
    • schema_name_id: 1413
    • start_time: 2025-01-09 15:16:23
    • success: True
    • trace_id: 5045385030915451653
    • duration: 0:00:20.446450
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 5671808
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/assets/2024-05-01/1714571558",
        "key": "raw/assets/2024-05-01/1714571558/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9153459162068138138,
        "service_name": "drive-thru",
        "span_id": 4072875372454972522,
        "trace_id": 13518483009001345113
    }
}
    • running: False
    • schema_name_id: 1413
    • start_time: 2024-05-01 08:53:01
    • success: True
    • trace_id: 13518483009001345113
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "ACHID__c": "string",
    "ACHTransactionFee__c": "string",
    "ACHTransaction__c": "string",
    "AC_Expected_Launch_Date__c": "string",
    "AccountId": "string",
    "Agency_Analytics_Custom_Reports__c": "string",
    "Agency_Analytics_PPC_Dashboard__c": "string",
    "Amount": "string",
    "AnnualFee__c": "string",
    "Annualgroup__c": "string",
    "AssetLevel": "string",
    "AssetProvidedById": "string",
    "AssetServicedById": "string",
    "Asset_Activation_Status__c": "string",
    "Asset_Cancelled_Non_Payment__c": "string",
    "Asset_Cleanup_Case__c": "string",
    "Asset_Notes__c": "string",
    "Asset_Type__c": "string",
    "AuthGroup__c": "string",
    "Avg_Actual_MVR__c": "string",
    "Beanstream_ID__c": "string",
    "BillingCancelled__c": "string",
    "BillingNotes__c": "string",
    "BillingStatus__c": "string",
    "Billing_Type__c": "string",
    "Bulk_Churn_Email_Exemption__c": "string",
    "Bundle_Name__c": "string",
    "Bundle_Tier__c": "string",
    "Bundle_Type__c": "string",
    "CP_Company_ID__c": "string",
    "CP_Location_ID__c": "string",
    "CancelinBillingDate__c": "string",
    "Cancellation_Date__c": "string",
    "Cancellation_Method__c": "string",
    "Cancellation_Reason_Detail__c": "string",
    "Cancellation_Reason__c": "string",
    "Cancelled_via_Cancellation_Wizard__c": "string",
    "Cap__c": "string",
    "Chargeover_ID_Assets__c": "string",
    "Chargeover_Parent_ID_Assets__c": "string",
    "Churn_Forecast_Date__c": "string",
    "Churn_Forecast_Reason_Detail__c": "string",
    "Churn_Forecast_Reason__c": "string",
    "Churn_Opportunity__c": "string",
    "City": "string",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "string",
    "Convenience_Fee__c": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataLakeSyncDate__c": "string",
    "Data_Load_By__c": "string",
    "Database_Merge_Cleanup__c": "string",
    "Datawire_ID__c": "string",
    "Date_Debooked__c": "string",
    "Date_New_to_Live__c": "string",
    "Date_Time_ESS_Transfer_Canceled__c": "string",
    "Date_Time_ESS_Transfer_Completed__c": "string",
    "Date_Time_ESS_Transfer_Created__c": "string",
    "Date_Time_ESS_Transfer_Effective__c": "string",
    "Debookedreason__c": "string",
    "Description": "string",
    "DigitalAssetStatus": "string",
    "Digital_Marketing_Status__c": "string",
    "Digital_Marketing_Welcome_Sent__c": "string",
    "DiscontinueProductDate__c": "string",
    "DiscountRate__c": "string",
    "Discountgroup__c": "string",
    "Download_ID__c": "string",
    "ESSAddOnId__c": "string",
    "ESSCompanyId__c": "string",
    "ESSDiscountExpirationDate__c": "string",
    "ESSDiscountedPrice__c": "string",
    "ESSFacilityId__c": "string",
    "ESSPrice__c": "string",
    "ESSSetupFee__c": "string",
    "ESSproduct__c": "string",
    "Epic_Location_Code__c": "string",
    "Epic_Lookup_Code__c": "string",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "Financial_Churn_Date__c": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "string",
    "GeocodeAccuracy": "string",
    "Google_Ads_Account_Name__c": "string",
    "Google_Ads_Account_Number__c": "string",
    "Google_Ads_Campaign_Budget_Daily__c": "string",
    "Google_Ads_Campaign_Budget_Monthly__c": "string",
    "Google_Ads_Campaign_Launch_Date__c": "string",
    "Google_Ads_Google_Doc__c": "string",
    "Google_Ads_Management_Fee__c": "string",
    "Google_Ads_Payment_Type__c": "string",
    "HQMerchantID__c": "string",
    "Hardware__c": "string",
    "HollyID_Assets__c": "string",
    "Id": "string",
    "Imp_Case_Reopened__c": "string",
    "Implementationcase__c": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "InstallDate": "string",
    "Integration_Software__c": "string",
    "International_Currency__c": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Churn_Save_Date__c": "string",
    "Latitude": "string",
    "LicenseId__c": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "Longitude": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "string",
    "Marine_Competitor_Lost_To__c": "string",
    "Marine_Expiration_Date__c": "string",
    "Marine_Reprice__c": "string",
    "Maximum_Usage__c": "string",
    "Merchant_ID_Assets__c": "string",
    "Merchant_ID__c": "string",
    "Merchant_Services_Account_Status__c": "string",
    "MigrationId__c": "string",
    "Molo_ID__c": "string",
    "Molo_Site_ID__c": "string",
    "MonthlyFee__c": "string",
    "Monthly_Transaction_Volume_and_Rate__c": "string",
    "NB_CompanyId__c": "string",
    "NB_PropertyID__c": "string",
    "NB_Region__c": "string",
    "Name": "string",
    "NewProduct__c": "string",
    "New_Access_Provider_Other__c": "string",
    "New_Access_Provider__c": "string",
    "New_Insurance_Provider_Other__c": "string",
    "New_Insurance_Provider__c": "string",
    "New_Software_Provider_Other__c": "string",
    "New_Software_Provider__c": "string",
    "New_Website_Provider_Other__c": "string",
    "New_Website_Provider__c": "string",
    "North_ID__c": "string",
    "OpportunityId": "string",
    "Opportunity_Product__c": "string",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "Originating_Order_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PCI_Activated__c": "string",
    "PCI_ID__c": "string",
    "PCI_Parent_ID__c": "string",
    "PPS_Cleanup_Cancellation__c": "string",
    "P_C_Commission__c": "string",
    "P_C_Expiration_Date__c": "string",
    "P_C_Insurance_Coverage_Types__c": "string",
    "P_C_Start_Date__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "string",
    "Price_Lock_Expiration__c": "string",
    "Probability": "string",
    "Product2Id": "string",
    "ProductCode": "string",
    "ProductDatabaseCancelledDate__c": "string",
    "ProductDatabaseCreatedDate__c": "string",
    "ProductDatabaseLastModifiedDate__c": "string",
    "ProductDescription": "string",
    "ProductFamily": "string",
    "Profituity_ID__c": "string",
    "Promo_End_Cap__c": "string",
    "Promo_End_Tier__c": "string",
    "Promotional_Expiration_Date__c": "string",
    "PurchaseDate": "string",
    "Quantity": "string",
    "RI_2025_Free_Trial_Converted__c": "string",
    "RI_2025_Free_Trial_Need_Cancelled__c": "string",
    "Rate_Statement_Opportunity__c": "string",
    "Reason_Lost_Category__c": "string",
    "RecordTypeId": "string",
    "RelatedOpportunityhasbeenclosedwon__c": "string",
    "Rental_Center_Version__c": "string",
    "Repriced__c": "string",
    "RequestedCancellationDate__c": "string",
    "Retention_Case__c": "string",
    "RootAssetId": "string",
    "SE_Company_ID__c": "string",
    "SE_FMS_ID_Assets__c": "string",
    "SE_Facility_UUID__c": "string",
    "SE_UUID_Company__c": "string",
    "SFBEID__c": "string",
    "SFBidRate_Number__c": "string",
    "SFClientKey__c": "string",
    "SFFacilityKey__c": "string",
    "SF_Account_Status__c": "string",
    "SF_Bid_Rate__c": "string",
    "SF_Integration__c": "string",
    "SF_Substatus__c": "string",
    "SLMSAccount__c": "string",
    "SL_Corp_Code_Assets__c": "string",
    "SL_Location_Code_Assets__c": "string",
    "SSLRenewalDate__c": "string",
    "SerialNumber": "string",
    "Ship_To_Case__c": "string",
    "Short_Code__c": "string",
    "SoftwareDiscontinued__c": "string",
    "SoftwareServices__c": "string",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "StageName": "string",
    "State": "string",
    "Status": "string",
    "StatusReason": "string",
    "Statuslastupdate__c": "string",
    "Stellar_Company_ID__c": "string",
    "Stellar_Facility_ID__c": "string",
    "StoPay_Annual_Group__c": "string",
    "StoPay_Auth_Group__c": "string",
    "StoPay_Discount_Group__c": "string",
    "StoPay_Monthly_Group__c": "string",
    "StockKeepingUnit": "string",
    "StopayProduct__c": "string",
    "StopayTotal__c": "string",
    "StorableCoveredEMVDeviceCost__c": "string",
    "Street": "string",
    "SubscriptionInterval__c": "string",
    "Suspend_Asset_Customer_Past_Due__c": "string",
    "SystemModstamp": "string",
    "TerminalType__c": "string",
    "Terminal_ID__c": "string",
    "Text_Product_Name__c": "string",
    "TransactionFee__c": "string",
    "UsageEndDate": "string",
    "User_Activation_Tracking__c": "string",
    "Uuid": "string",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "Zoho_Corporate_ID__c": "string",
    "Zoho_Corporate_URL__c": "string",
    "Zoho_ID__c": "string",
    "Zoho_URL__c": "string",
    "monthlygroup__c": "string",
    "next_run__c": "string",
    "suspend_date__c": "string"
}
  • created: 2026-02-27 09:13:25
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_assets`\n(\n `Id`  string , `ContactId`  string , `AccountId`  string , `ParentId`  string , `RootAssetId`  string , `Product2Id`  string , `ProductCode`  string , `ProductFamily`  string , `ProductDescription`  string , `IsCompetitorProduct`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsDeleted`  string , `CurrencyIsoCode`  string , `Name`  string , `SerialNumber`  string , `InstallDate`  string , `ManufactureDate`  string , `StatusReason`  string , `Uuid`  string , `ExternalIdentifier`  string , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `DigitalAssetStatus`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `LocationId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  string , `ConsequenceOfFailure`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Asset_Type__c`  string , `Beanstream_ID__c`  string , `Datawire_ID__c`  string , `Download_ID__c`  string , `Merchant_ID__c`  string , `North_ID__c`  string , `X1_Day_Hold__c`  string , `Terminal_ID__c`  string , `Profituity_ID__c`  string , `Opportunity__c`  string , `BillingStatus__c`  string , `Bundle_Tier__c`  string , `Monthly_Transaction_Volume_and_Rate__c`  string , `MRR__c`  string , `Software_Tier__c`  string , `SF_Bid_Rate__c`  string , `HollyID_Assets__c`  string , `SL_Corp_Code_Assets__c`  string , `SL_Location_Code_Assets__c`  string , `Source_Parent_Name_Assets__c`  string , `Source_Facility_Name_Assets__c`  string , `SE_FMS_ID_Assets__c`  string , `Chargeover_ID_Assets__c`  string , `Chargeover_Parent_ID_Assets__c`  string , `Merchant_ID_Assets__c`  string , `Cancellation_Reason__c`  string , `Cancellation_Reason_Detail__c`  string , `Sold_To__c`  string , `Cancellation_Date__c`  string , `BillingCancelled__c`  string , `SFBidRate_Number__c`  string , `BillingNotes__c`  string , `CancelinBillingDate__c`  string , `DiscontinueProductDate__c`  string , `Implementationcase__c`  string , `LicenseTransferredFromAsset__c`  string , `LicenseTransferredtoAsset__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `RequestedCancellationDate__c`  string , `SLMSAccount__c`  string , `ACHID__c`  string , `SoftwareDiscontinued__c`  string , `GPMCC__c`  string , `SFClientKey__c`  string , `SFFacilityKey__c`  string , `HQMerchantID__c`  string , `PendingCancellationDate__c`  string , `SFBEID__c`  string , `RelatedOpportunityhasbeenclosedwon__c`  string , `PreviouslyinPendingCancellation__c`  string , `Website__c`  string , `SSLRenewalDate__c`  string , `TerminalType__c`  string , `MSTotalVolume__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Debookedreason__c`  string , `PaymentFamily__c`  string , `Avg_Actual_MVR__c`  string , `Annualgroup__c`  string , `DiscountRate__c`  string , `TransactionFee__c`  string , `MonthlyFee__c`  string , `AnnualFee__c`  string , `Asset_Activation_Status__c`  string , `Payments_Activation_Date__c`  string , `Website_Type__c`  string , `GMB_Account_Name__c`  string , `Google_Ads_Account_Name__c`  string , `Google_Ads_Account_Number__c`  string , `Google_Ads_Campaign_Launch_Date__c`  string , `Google_Ads_Campaign_Budget_Monthly__c`  string , `Google_Ads_Campaign_Budget_Daily__c`  string , `Google_Ads_Payment_Type__c`  string , `Google_Ads_Google_Doc__c`  string , `Google_Ads_Management_Fee__c`  string , `Agency_Analytics_PPC_Dashboard__c`  string , `Agency_Analytics_Custom_Reports__c`  string , `MRRupdated__c`  string , `MRR_update_date_time_stamp__c`  string , `StopayProduct__c`  string , `Statuslastupdate__c`  string , `StopayTotal__c`  string , `ACHTransaction__c`  string , `ACHTransactionFee__c`  string , `Rental_Center_Version__c`  string , `ESSproduct__c`  string , `Text_Product_Name__c`  string , `Rate_Statement_Opportunity__c`  string , `JIRA_Ticket__c`  string , `Short_Code__c`  string , `WW_Cohort__c`  string , `SF_Account_Status__c`  string , `Date_New_to_Live__c`  string , `SF_Substatus__c`  string , `New_Insurance_Provider__c`  string , `New_Access_Provider_Other__c`  string , `New_Access_Provider__c`  string , `New_Insurance_Provider_Other__c`  string , `RI_2025_Free_Trial_Converted__c`  string , `RI_2025_Free_Trial_Need_Cancelled__c`  string , `International_Currency__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `Cancelled_via_Cancellation_Wizard__c`  string , `Churn_Opportunity__c`  string , `Cancellation_Method__c`  string , `Digital_Marketing_Welcome_Sent__c`  string , `Marine_Reprice__c`  string , `Churn_Forecast_Reason__c`  string , `Churn_Forecast_Date__c`  string , `Financial_Churn_Date__c`  string , `Churn_Forecast_Reason_Detail__c`  string , `Last_Churn_Save_Date__c`  string , `Marine_Competitor_Lost_To__c`  string , `Reason_Lost_Category__c`  string , `LicenseId__c`  string , `MigrationId__c`  string , `NB_CompanyId__c`  string , `NB_PropertyID__c`  string , `NB_Region__c`  string , `SubscriptionInterval__c`  string , `next_run__c`  string , `suspend_date__c`  string , `Promotional_Expiration_Date__c`  string , `Data_Load_By__c`  string , `Cap__c`  string , `Promo_End_Cap__c`  string , `Promo_End_Tier__c`  string , `Retention_Case__c`  string , `StoPay_Annual_Group__c`  string , `StoPay_Auth_Group__c`  string , `StoPay_Discount_Group__c`  string , `AC_Expected_Launch_Date__c`  string , `StoPay_Monthly_Group__c`  string , `ESSAddOnId__c`  string , `ESSCompanyId__c`  string , `ESSFacilityId__c`  string , `Ship_To_Case__c`  string , `ESSDiscountExpirationDate__c`  string , `DataLakeSyncDate__c`  string , `ESSDiscountedPrice__c`  string , `ESSPrice__c`  string , `ESSSetupFee__c`  string , `ProductDatabaseCancelledDate__c`  string , `ProductDatabaseCreatedDate__c`  string , `ProductDatabaseLastModifiedDate__c`  string , `Imp_Case_Reopened__c`  string , `Price_Change_Date__c`  string , `Digital_Marketing_Status__c`  string , `Merchant_Services_Account_Status__c`  string , `Date_Debooked__c`  string , `User_Activation_Tracking__c`  string , `SE_UUID_Company__c`  string , `SE_Facility_UUID__c`  string , `StorableCoveredEMVDeviceCost__c`  string , `Cloud_Node_ID__c`  string , `Planned_Debooking_Date__c`  string , `SF_Integration__c`  string , `Date_Time_ESS_Transfer_Canceled__c`  string , `Date_Time_ESS_Transfer_Completed__c`  string , `Date_Time_ESS_Transfer_Created__c`  string , `Date_Time_ESS_Transfer_Effective__c`  string , `Originating_Order_Product__c`  string , `MID_Rewrite__c`  string , `Price_Lock_Expiration__c`  string , `Hardware__c`  string , `Opportunity_Product__c`  string , `SoftwareServices__c`  string , `SE_Company_ID__c`  string , `ListPrice__c`  string , `Zoho_Corporate_ID__c`  string , `Zoho_Corporate_URL__c`  string , `Zoho_ID__c`  string , `Zoho_URL__c`  string , `Bulk_Churn_Email_Exemption__c`  string , `P_C_Insurance_Coverage_Types__c`  string , `Epic_Location_Code__c`  string , `Epic_Lookup_Code__c`  string , `P_C_Commission__c`  string , `P_C_Expiration_Date__c`  string , `P_C_Start_Date__c`  string , `Bundle_Name__c`  string , `Bundle_Type__c`  string , `Repriced__c`  string , `Asset_Cancelled_Non_Payment__c`  string , `Suspend_Asset_Customer_Past_Due__c`  string , `PPS_Cleanup_Cancellation__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Billing_Type__c`  string , `Convenience_Fee__c`  string , `Integration_Software__c`  string , `Marine_Expiration_Date__c`  string , `Molo_ID__c`  string , `Molo_Site_ID__c`  string , `Stellar_Company_ID__c`  string , `Stellar_Facility_ID__c`  string , `Asset_Cleanup_Case__c`  string , `Database_Merge_Cleanup__c`  string , `PCI_Activated__c`  string , `PCI_ID__c`  string , `PCI_Parent_ID__c`  string , `New_Website_Provider_Other__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider_Other__c`  string , `New_Software_Provider__c`  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-csv-salesforce-stage/raw/assets/2026-02-27/1772205053'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_assets`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_assets"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-09-13 15:28:51",
        "disabled": false,
        "format": "raw",
        "id": 1413,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "salesforce_assets"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ACHID__c": "string",
            "ACHTransactionFee__c": "string",
            "ACHTransaction__c": "string",
            "AC_Expected_Launch_Date__c": "string",
            "AccountId": "string",
            "Agency_Analytics_Custom_Reports__c": "string",
            "Agency_Analytics_PPC_Dashboard__c": "string",
            "Amount": "string",
            "AnnualFee__c": "string",
            "Annualgroup__c": "string",
            "AssetLevel": "string",
            "AssetProvidedById": "string",
            "AssetServicedById": "string",
            "Asset_Activation_Status__c": "string",
            "Asset_Cancelled_Non_Payment__c": "string",
            "Asset_Cleanup_Case__c": "string",
            "Asset_Notes__c": "string",
            "Asset_Type__c": "string",
            "AuthGroup__c": "string",
            "Avg_Actual_MVR__c": "string",
            "Beanstream_ID__c": "string",
            "BillingCancelled__c": "string",
            "BillingNotes__c": "string",
            "BillingStatus__c": "string",
            "Billing_Type__c": "string",
            "Bulk_Churn_Email_Exemption__c": "string",
            "Bundle_Name__c": "string",
            "Bundle_Tier__c": "string",
            "Bundle_Type__c": "string",
            "CP_Company_ID__c": "string",
            "CP_Location_ID__c": "string",
            "CancelinBillingDate__c": "string",
            "Cancellation_Date__c": "string",
            "Cancellation_Method__c": "string",
            "Cancellation_Reason_Detail__c": "string",
            "Cancellation_Reason__c": "string",
            "Cancelled_via_Cancellation_Wizard__c": "string",
            "Cap__c": "string",
            "Chargeover_ID_Assets__c": "string",
            "Chargeover_Parent_ID_Assets__c": "string",
            "Churn_Forecast_Date__c": "string",
            "Churn_Forecast_Reason_Detail__c": "string",
            "Churn_Forecast_Reason__c": "string",
            "Churn_Opportunity__c": "string",
            "City": "string",
            "CloseDate": "string",
            "Cloud_Node_ID__c": "string",
            "Competitor_Lost_To__c": "string",
            "ConsequenceOfFailure": "string",
            "ContactId": "string",
            "Convenience_Fee__c": "string",
            "Country": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "DataLakeSyncDate__c": "string",
            "Data_Load_By__c": "string",
            "Database_Merge_Cleanup__c": "string",
            "Datawire_ID__c": "string",
            "Date_Debooked__c": "string",
            "Date_New_to_Live__c": "string",
            "Date_Time_ESS_Transfer_Canceled__c": "string",
            "Date_Time_ESS_Transfer_Completed__c": "string",
            "Date_Time_ESS_Transfer_Created__c": "string",
            "Date_Time_ESS_Transfer_Effective__c": "string",
            "Debookedreason__c": "string",
            "Description": "string",
            "DigitalAssetStatus": "string",
            "Digital_Marketing_Status__c": "string",
            "Digital_Marketing_Welcome_Sent__c": "string",
            "DiscontinueProductDate__c": "string",
            "DiscountRate__c": "string",
            "Discountgroup__c": "string",
            "Download_ID__c": "string",
            "ESSAddOnId__c": "string",
            "ESSCompanyId__c": "string",
            "ESSDiscountExpirationDate__c": "string",
            "ESSDiscountedPrice__c": "string",
            "ESSFacilityId__c": "string",
            "ESSPrice__c": "string",
            "ESSSetupFee__c": "string",
            "ESSproduct__c": "string",
            "Epic_Location_Code__c": "string",
            "Epic_Lookup_Code__c": "string",
            "ExpectedRevenue": "string",
            "ExternalIdentifier": "string",
            "Financial_Churn_Date__c": "string",
            "ForecastCategory": "string",
            "GMB_Account_Name__c": "string",
            "GPMCC__c": "string",
            "GeocodeAccuracy": "string",
            "Google_Ads_Account_Name__c": "string",
            "Google_Ads_Account_Number__c": "string",
            "Google_Ads_Campaign_Budget_Daily__c": "string",
            "Google_Ads_Campaign_Budget_Monthly__c": "string",
            "Google_Ads_Campaign_Launch_Date__c": "string",
            "Google_Ads_Google_Doc__c": "string",
            "Google_Ads_Management_Fee__c": "string",
            "Google_Ads_Payment_Type__c": "string",
            "HQMerchantID__c": "string",
            "Hardware__c": "string",
            "HollyID_Assets__c": "string",
            "Id": "string",
            "Imp_Case_Reopened__c": "string",
            "Implementationcase__c": "string",
            "Included_Minutes__c": "string",
            "Included_Tracking_Numbers__c": "string",
            "InstallDate": "string",
            "Integration_Software__c": "string",
            "International_Currency__c": "string",
            "IsCompetitorProduct": "string",
            "IsDeleted": "string",
            "IsInternal": "string",
            "JIRA_Ticket__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Last_Churn_Save_Date__c": "string",
            "Latitude": "string",
            "LicenseId__c": "string",
            "LicenseTransferredFromAsset__c": "string",
            "LicenseTransferredtoAsset__c": "string",
            "ListPrice__c": "string",
            "LocationId": "string",
            "Longitude": "string",
            "MID_Rewrite__c": "string",
            "MRR__c": "string",
            "MRR_update_date_time_stamp__c": "string",
            "MRRupdated__c": "string",
            "MSTotalVolume__c": "string",
            "ManufactureDate": "string",
            "Marine_Competitor_Lost_To__c": "string",
            "Marine_Expiration_Date__c": "string",
            "Marine_Reprice__c": "string",
            "Maximum_Usage__c": "string",
            "Merchant_ID_Assets__c": "string",
            "Merchant_ID__c": "string",
            "Merchant_Services_Account_Status__c": "string",
            "MigrationId__c": "string",
            "Molo_ID__c": "string",
            "Molo_Site_ID__c": "string",
            "MonthlyFee__c": "string",
            "Monthly_Transaction_Volume_and_Rate__c": "string",
            "NB_CompanyId__c": "string",
            "NB_PropertyID__c": "string",
            "NB_Region__c": "string",
            "Name": "string",
            "NewProduct__c": "string",
            "New_Access_Provider_Other__c": "string",
            "New_Access_Provider__c": "string",
            "New_Insurance_Provider_Other__c": "string",
            "New_Insurance_Provider__c": "string",
            "New_Software_Provider_Other__c": "string",
            "New_Software_Provider__c": "string",
            "New_Website_Provider_Other__c": "string",
            "New_Website_Provider__c": "string",
            "North_ID__c": "string",
            "OpportunityId": "string",
            "Opportunity_Product__c": "string",
            "Opportunity__c": "string",
            "OriginalLeaseDate__c": "string",
            "Originating_Order_Product__c": "string",
            "Overage_Rate_for_Minutes__c": "string",
            "Overage_Rate_for_Tracking_Numbers__c": "string",
            "PCI_Activated__c": "string",
            "PCI_ID__c": "string",
            "PCI_Parent_ID__c": "string",
            "PPS_Cleanup_Cancellation__c": "string",
            "P_C_Commission__c": "string",
            "P_C_Expiration_Date__c": "string",
            "P_C_Insurance_Coverage_Types__c": "string",
            "P_C_Start_Date__c": "string",
            "ParentId": "string",
            "PaymentFamily__c": "string",
            "Payments_Activation_Date__c": "string",
            "PendingCancellationDate__c": "string",
            "Planned_Debooking_Date__c": "string",
            "PostalCode": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "PreviouslyinPendingCancellation__c": "string",
            "Price": "string",
            "Price_Change_Date__c": "string",
            "Price_Lock_Expiration__c": "string",
            "Probability": "string",
            "Product2Id": "string",
            "ProductCode": "string",
            "ProductDatabaseCancelledDate__c": "string",
            "ProductDatabaseCreatedDate__c": "string",
            "ProductDatabaseLastModifiedDate__c": "string",
            "ProductDescription": "string",
            "ProductFamily": "string",
            "Profituity_ID__c": "string",
            "Promo_End_Cap__c": "string",
            "Promo_End_Tier__c": "string",
            "Promotional_Expiration_Date__c": "string",
            "PurchaseDate": "string",
            "Quantity": "string",
            "RI_2025_Free_Trial_Converted__c": "string",
            "RI_2025_Free_Trial_Need_Cancelled__c": "string",
            "Rate_Statement_Opportunity__c": "string",
            "Reason_Lost_Category__c": "string",
            "RecordTypeId": "string",
            "RelatedOpportunityhasbeenclosedwon__c": "string",
            "Rental_Center_Version__c": "string",
            "Repriced__c": "string",
            "RequestedCancellationDate__c": "string",
            "Retention_Case__c": "string",
            "RootAssetId": "string",
            "SE_Company_ID__c": "string",
            "SE_FMS_ID_Assets__c": "string",
            "SE_Facility_UUID__c": "string",
            "SE_UUID_Company__c": "string",
            "SFBEID__c": "string",
            "SFBidRate_Number__c": "string",
            "SFClientKey__c": "string",
            "SFFacilityKey__c": "string",
            "SF_Account_Status__c": "string",
            "SF_Bid_Rate__c": "string",
            "SF_Integration__c": "string",
            "SF_Substatus__c": "string",
            "SLMSAccount__c": "string",
            "SL_Corp_Code_Assets__c": "string",
            "SL_Location_Code_Assets__c": "string",
            "SSLRenewalDate__c": "string",
            "SerialNumber": "string",
            "Ship_To_Case__c": "string",
            "Short_Code__c": "string",
            "SoftwareDiscontinued__c": "string",
            "SoftwareServices__c": "string",
            "Software_Tier__c": "string",
            "Sold_To__c": "string",
            "Source_Facility_Name_Assets__c": "string",
            "Source_Parent_Name_Assets__c": "string",
            "StageName": "string",
            "State": "string",
            "Status": "string",
            "StatusReason": "string",
            "Statuslastupdate__c": "string",
            "Stellar_Company_ID__c": "string",
            "Stellar_Facility_ID__c": "string",
            "StoPay_Annual_Group__c": "string",
            "StoPay_Auth_Group__c": "string",
            "StoPay_Discount_Group__c": "string",
            "StoPay_Monthly_Group__c": "string",
            "StockKeepingUnit": "string",
            "StopayProduct__c": "string",
            "StopayTotal__c": "string",
            "StorableCoveredEMVDeviceCost__c": "string",
            "Street": "string",
            "SubscriptionInterval__c": "string",
            "Suspend_Asset_Customer_Past_Due__c": "string",
            "SystemModstamp": "string",
            "TerminalType__c": "string",
            "Terminal_ID__c": "string",
            "Text_Product_Name__c": "string",
            "TransactionFee__c": "string",
            "UsageEndDate": "string",
            "User_Activation_Tracking__c": "string",
            "Uuid": "string",
            "WW_Cohort__c": "string",
            "Website_Type__c": "string",
            "Website__c": "string",
            "X1_Day_Hold__c": "string",
            "Zoho_Corporate_ID__c": "string",
            "Zoho_Corporate_URL__c": "string",
            "Zoho_ID__c": "string",
            "Zoho_URL__c": "string",
            "monthlygroup__c": "string",
            "next_run__c": "string",
            "suspend_date__c": "string"
        },
        "created": "2026-02-27 09:13:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_assets`\n(\n `Id`  string , `ContactId`  string , `AccountId`  string , `ParentId`  string , `RootAssetId`  string , `Product2Id`  string , `ProductCode`  string , `ProductFamily`  string , `ProductDescription`  string , `IsCompetitorProduct`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsDeleted`  string , `CurrencyIsoCode`  string , `Name`  string , `SerialNumber`  string , `InstallDate`  string , `ManufactureDate`  string , `StatusReason`  string , `Uuid`  string , `ExternalIdentifier`  string , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `DigitalAssetStatus`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `LocationId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  string , `ConsequenceOfFailure`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Asset_Type__c`  string , `Beanstream_ID__c`  string , `Datawire_ID__c`  string , `Download_ID__c`  string , `Merchant_ID__c`  string , `North_ID__c`  string , `X1_Day_Hold__c`  string , `Terminal_ID__c`  string , `Profituity_ID__c`  string , `Opportunity__c`  string , `BillingStatus__c`  string , `Bundle_Tier__c`  string , `Monthly_Transaction_Volume_and_Rate__c`  string , `MRR__c`  string , `Software_Tier__c`  string , `SF_Bid_Rate__c`  string , `HollyID_Assets__c`  string , `SL_Corp_Code_Assets__c`  string , `SL_Location_Code_Assets__c`  string , `Source_Parent_Name_Assets__c`  string , `Source_Facility_Name_Assets__c`  string , `SE_FMS_ID_Assets__c`  string , `Chargeover_ID_Assets__c`  string , `Chargeover_Parent_ID_Assets__c`  string , `Merchant_ID_Assets__c`  string , `Cancellation_Reason__c`  string , `Cancellation_Reason_Detail__c`  string , `Sold_To__c`  string , `Cancellation_Date__c`  string , `BillingCancelled__c`  string , `SFBidRate_Number__c`  string , `BillingNotes__c`  string , `CancelinBillingDate__c`  string , `DiscontinueProductDate__c`  string , `Implementationcase__c`  string , `LicenseTransferredFromAsset__c`  string , `LicenseTransferredtoAsset__c`  string , `NewProduct__c`  string , `OriginalLeaseDate__c`  string , `RequestedCancellationDate__c`  string , `SLMSAccount__c`  string , `ACHID__c`  string , `SoftwareDiscontinued__c`  string , `GPMCC__c`  string , `SFClientKey__c`  string , `SFFacilityKey__c`  string , `HQMerchantID__c`  string , `PendingCancellationDate__c`  string , `SFBEID__c`  string , `RelatedOpportunityhasbeenclosedwon__c`  string , `PreviouslyinPendingCancellation__c`  string , `Website__c`  string , `SSLRenewalDate__c`  string , `TerminalType__c`  string , `MSTotalVolume__c`  string , `AuthGroup__c`  string , `monthlygroup__c`  string , `Discountgroup__c`  string , `Debookedreason__c`  string , `PaymentFamily__c`  string , `Avg_Actual_MVR__c`  string , `Annualgroup__c`  string , `DiscountRate__c`  string , `TransactionFee__c`  string , `MonthlyFee__c`  string , `AnnualFee__c`  string , `Asset_Activation_Status__c`  string , `Payments_Activation_Date__c`  string , `Website_Type__c`  string , `GMB_Account_Name__c`  string , `Google_Ads_Account_Name__c`  string , `Google_Ads_Account_Number__c`  string , `Google_Ads_Campaign_Launch_Date__c`  string , `Google_Ads_Campaign_Budget_Monthly__c`  string , `Google_Ads_Campaign_Budget_Daily__c`  string , `Google_Ads_Payment_Type__c`  string , `Google_Ads_Google_Doc__c`  string , `Google_Ads_Management_Fee__c`  string , `Agency_Analytics_PPC_Dashboard__c`  string , `Agency_Analytics_Custom_Reports__c`  string , `MRRupdated__c`  string , `MRR_update_date_time_stamp__c`  string , `StopayProduct__c`  string , `Statuslastupdate__c`  string , `StopayTotal__c`  string , `ACHTransaction__c`  string , `ACHTransactionFee__c`  string , `Rental_Center_Version__c`  string , `ESSproduct__c`  string , `Text_Product_Name__c`  string , `Rate_Statement_Opportunity__c`  string , `JIRA_Ticket__c`  string , `Short_Code__c`  string , `WW_Cohort__c`  string , `SF_Account_Status__c`  string , `Date_New_to_Live__c`  string , `SF_Substatus__c`  string , `New_Insurance_Provider__c`  string , `New_Access_Provider_Other__c`  string , `New_Access_Provider__c`  string , `New_Insurance_Provider_Other__c`  string , `RI_2025_Free_Trial_Converted__c`  string , `RI_2025_Free_Trial_Need_Cancelled__c`  string , `International_Currency__c`  string , `CP_Company_ID__c`  string , `CP_Location_ID__c`  string , `Cancelled_via_Cancellation_Wizard__c`  string , `Churn_Opportunity__c`  string , `Cancellation_Method__c`  string , `Digital_Marketing_Welcome_Sent__c`  string , `Marine_Reprice__c`  string , `Churn_Forecast_Reason__c`  string , `Churn_Forecast_Date__c`  string , `Financial_Churn_Date__c`  string , `Churn_Forecast_Reason_Detail__c`  string , `Last_Churn_Save_Date__c`  string , `Marine_Competitor_Lost_To__c`  string , `Reason_Lost_Category__c`  string , `LicenseId__c`  string , `MigrationId__c`  string , `NB_CompanyId__c`  string , `NB_PropertyID__c`  string , `NB_Region__c`  string , `SubscriptionInterval__c`  string , `next_run__c`  string , `suspend_date__c`  string , `Promotional_Expiration_Date__c`  string , `Data_Load_By__c`  string , `Cap__c`  string , `Promo_End_Cap__c`  string , `Promo_End_Tier__c`  string , `Retention_Case__c`  string , `StoPay_Annual_Group__c`  string , `StoPay_Auth_Group__c`  string , `StoPay_Discount_Group__c`  string , `AC_Expected_Launch_Date__c`  string , `StoPay_Monthly_Group__c`  string , `ESSAddOnId__c`  string , `ESSCompanyId__c`  string , `ESSFacilityId__c`  string , `Ship_To_Case__c`  string , `ESSDiscountExpirationDate__c`  string , `DataLakeSyncDate__c`  string , `ESSDiscountedPrice__c`  string , `ESSPrice__c`  string , `ESSSetupFee__c`  string , `ProductDatabaseCancelledDate__c`  string , `ProductDatabaseCreatedDate__c`  string , `ProductDatabaseLastModifiedDate__c`  string , `Imp_Case_Reopened__c`  string , `Price_Change_Date__c`  string , `Digital_Marketing_Status__c`  string , `Merchant_Services_Account_Status__c`  string , `Date_Debooked__c`  string , `User_Activation_Tracking__c`  string , `SE_UUID_Company__c`  string , `SE_Facility_UUID__c`  string , `StorableCoveredEMVDeviceCost__c`  string , `Cloud_Node_ID__c`  string , `Planned_Debooking_Date__c`  string , `SF_Integration__c`  string , `Date_Time_ESS_Transfer_Canceled__c`  string , `Date_Time_ESS_Transfer_Completed__c`  string , `Date_Time_ESS_Transfer_Created__c`  string , `Date_Time_ESS_Transfer_Effective__c`  string , `Originating_Order_Product__c`  string , `MID_Rewrite__c`  string , `Price_Lock_Expiration__c`  string , `Hardware__c`  string , `Opportunity_Product__c`  string , `SoftwareServices__c`  string , `SE_Company_ID__c`  string , `ListPrice__c`  string , `Zoho_Corporate_ID__c`  string , `Zoho_Corporate_URL__c`  string , `Zoho_ID__c`  string , `Zoho_URL__c`  string , `Bulk_Churn_Email_Exemption__c`  string , `P_C_Insurance_Coverage_Types__c`  string , `Epic_Location_Code__c`  string , `Epic_Lookup_Code__c`  string , `P_C_Commission__c`  string , `P_C_Expiration_Date__c`  string , `P_C_Start_Date__c`  string , `Bundle_Name__c`  string , `Bundle_Type__c`  string , `Repriced__c`  string , `Asset_Cancelled_Non_Payment__c`  string , `Suspend_Asset_Customer_Past_Due__c`  string , `PPS_Cleanup_Cancellation__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Billing_Type__c`  string , `Convenience_Fee__c`  string , `Integration_Software__c`  string , `Marine_Expiration_Date__c`  string , `Molo_ID__c`  string , `Molo_Site_ID__c`  string , `Stellar_Company_ID__c`  string , `Stellar_Facility_ID__c`  string , `Asset_Cleanup_Case__c`  string , `Database_Merge_Cleanup__c`  string , `PCI_Activated__c`  string , `PCI_ID__c`  string , `PCI_Parent_ID__c`  string , `New_Website_Provider_Other__c`  string , `New_Website_Provider__c`  string , `New_Software_Provider_Other__c`  string , `New_Software_Provider__c`  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-csv-salesforce-stage/raw/assets/2026-02-27/1772205053'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_assets`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_assets"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform