Schema Info

Schema Name: sfdl_dev_csv.salesforce_assets
  • created: 2022-10-24 14:51:08
  • disabled: False
  • format: raw
  • id: 2049
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "salesforce_assets"
}
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:34:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/assets/2024-06-10/1718051389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/assets/2024-06-10/1718051389
    • id: 4706466
    • 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: 2049
    • schema_scan_id: 6510725
    • updated: 2024-06-10 15:34:41
    • created: 2024-01-11 09:11:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `Asset_Notes__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 \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-dev/raw/assets/2024-01-11/1704985730'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/assets/2024-01-11/1704985730
    • id: 4700487
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 90,
    "ACHTransactionFee__c": 135,
    "ACHTransaction__c": 134,
    "AC_Expected_Launch_Date__c": 150,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 128,
    "Agency_Analytics_PPC_Dashboard__c": 127,
    "AnnualFee__c": 114,
    "Annualgroup__c": 110,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 115,
    "Asset_Notes__c": 77,
    "Asset_Type__c": 47,
    "AuthGroup__c": 104,
    "Avg_Actual_MVR__c": 109,
    "Beanstream_ID__c": 48,
    "BillingCancelled__c": 78,
    "BillingNotes__c": 80,
    "BillingStatus__c": 57,
    "Bulk_Churn_Email_Exemption__c": 192,
    "Bundle_Name__c": 199,
    "Bundle_Tier__c": 58,
    "Bundle_Type__c": 200,
    "CancelinBillingDate__c": 81,
    "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": 173,
    "Competitor_Lost_To__c": 75,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "Country": 43,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 157,
    "Datawire_ID__c": 49,
    "Date_Debooked__c": 168,
    "Date_New_to_Live__c": 144,
    "Date_Time_ESS_Transfer_Canceled__c": 176,
    "Date_Time_ESS_Transfer_Completed__c": 177,
    "Date_Time_ESS_Transfer_Created__c": 178,
    "Date_Time_ESS_Transfer_Effective__c": 179,
    "Debookedreason__c": 107,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 166,
    "DiscontinueProductDate__c": 82,
    "DiscountRate__c": 111,
    "Discountgroup__c": 106,
    "Download_ID__c": 50,
    "ESSAddOnId__c": 152,
    "ESSCompanyId__c": 153,
    "ESSDiscountExpirationDate__c": 156,
    "ESSDiscountedPrice__c": 158,
    "ESSFacilityId__c": 154,
    "ESSPrice__c": 159,
    "ESSSetupFee__c": 160,
    "ESSproduct__c": 137,
    "Epic_Location_Code__c": 194,
    "Epic_Lookup_Code__c": 195,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 118,
    "GPMCC__c": 92,
    "GeocodeAccuracy": 46,
    "Google_Ads_Account_Name__c": 119,
    "Google_Ads_Account_Number__c": 120,
    "Google_Ads_Campaign_Budget_Daily__c": 123,
    "Google_Ads_Campaign_Budget_Monthly__c": 122,
    "Google_Ads_Campaign_Launch_Date__c": 121,
    "Google_Ads_Google_Doc__c": 125,
    "Google_Ads_Management_Fee__c": 126,
    "Google_Ads_Payment_Type__c": 124,
    "HQMerchantID__c": 95,
    "Hardware__c": 183,
    "HollyID_Assets__c": 63,
    "Id": 0,
    "Imp_Case_Reopened__c": 164,
    "Implementationcase__c": 83,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 140,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "Latitude": 44,
    "LicenseTransferredFromAsset__c": 84,
    "LicenseTransferredtoAsset__c": 85,
    "ListPrice__c": 187,
    "LocationId": 32,
    "Longitude": 45,
    "MID_Rewrite__c": 181,
    "MRR__c": 60,
    "MRR_update_date_time_stamp__c": 130,
    "MRRupdated__c": 129,
    "MSTotalVolume__c": 103,
    "ManufactureDate": 20,
    "Merchant_ID_Assets__c": 71,
    "Merchant_ID__c": 51,
    "Merchant_Services_Account_Status__c": 167,
    "MonthlyFee__c": 113,
    "Monthly_Transaction_Volume_and_Rate__c": 59,
    "Name": 17,
    "NewProduct__c": 86,
    "North_ID__c": 52,
    "Opportunity_Product__c": 184,
    "Opportunity__c": 56,
    "OriginalLeaseDate__c": 87,
    "Originating_Order_Product__c": 180,
    "P_C_Commission__c": 196,
    "P_C_Expiration_Date__c": 197,
    "P_C_Insurance_Coverage_Types__c": 193,
    "P_C_Start_Date__c": 198,
    "ParentId": 3,
    "PaymentFamily__c": 108,
    "Payments_Activation_Date__c": 116,
    "PendingCancellationDate__c": 96,
    "Planned_Debooking_Date__c": 174,
    "PostalCode": 42,
    "PreviouslyinPendingCancellation__c": 99,
    "Price": 28,
    "Price_Change_Date__c": 165,
    "Price_Lock_Expiration__c": 182,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 161,
    "ProductDatabaseCreatedDate__c": 162,
    "ProductDatabaseLastModifiedDate__c": 163,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 55,
    "PurchaseDate": 24,
    "Quantity": 29,
    "Rate_Statement_Opportunity__c": 139,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 98,
    "Rental_Center_Version__c": 136,
    "RequestedCancellationDate__c": 88,
    "Retention_Case__c": 146,
    "RootAssetId": 4,
    "SE_Company_ID__c": 186,
    "SE_FMS_ID_Assets__c": 68,
    "SE_Facility_UUID__c": 171,
    "SE_UUID_Company__c": 170,
    "SFBEID__c": 97,
    "SFBidRate_Number__c": 79,
    "SFClientKey__c": 93,
    "SFFacilityKey__c": 94,
    "SF_Account_Status__c": 143,
    "SF_Bid_Rate__c": 62,
    "SF_Integration__c": 175,
    "SF_Substatus__c": 145,
    "SLMSAccount__c": 89,
    "SL_Corp_Code_Assets__c": 64,
    "SL_Location_Code_Assets__c": 65,
    "SSLRenewalDate__c": 101,
    "SerialNumber": 18,
    "Ship_To_Case__c": 155,
    "Short_Code__c": 141,
    "SoftwareDiscontinued__c": 91,
    "SoftwareServices__c": 185,
    "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": 132,
    "StoPay_Annual_Group__c": 147,
    "StoPay_Auth_Group__c": 148,
    "StoPay_Discount_Group__c": 149,
    "StoPay_Monthly_Group__c": 151,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 131,
    "StopayTotal__c": 133,
    "StorableCoveredEMVDeviceCost__c": 172,
    "Street": 39,
    "SystemModstamp": 14,
    "TerminalType__c": 102,
    "Terminal_ID__c": 54,
    "Text_Product_Name__c": 138,
    "TransactionFee__c": 112,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 169,
    "Uuid": 22,
    "WW_Cohort__c": 142,
    "Website_Type__c": 117,
    "Website__c": 100,
    "X1_Day_Hold__c": 53,
    "Zoho_Corporate_ID__c": 188,
    "Zoho_Corporate_URL__c": 189,
    "Zoho_ID__c": 190,
    "Zoho_URL__c": 191,
    "monthlygroup__c": 105
}
    • 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_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",
    "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",
    "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",
    "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",
    "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",
    "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: 2049
    • schema_scan_id: 6402627
    • updated: 2024-01-11 09:11:27
    • created: 2023-08-16 11:13:45
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Asset_Notes__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 \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-dev/raw/assets/2023-08-16/1692202279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692202279
    • id: 4697486
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 82,
    "ACHTransactionFee__c": 127,
    "ACHTransaction__c": 126,
    "AC_Expected_Launch_Date__c": 142,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 120,
    "Agency_Analytics_PPC_Dashboard__c": 119,
    "AnnualFee__c": 106,
    "Annualgroup__c": 102,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 107,
    "Asset_Notes__c": 69,
    "Asset_Type__c": 39,
    "AuthGroup__c": 96,
    "Avg_Actual_MVR__c": 101,
    "Beanstream_ID__c": 40,
    "BillingCancelled__c": 70,
    "BillingNotes__c": 72,
    "BillingStatus__c": 49,
    "Bundle_Tier__c": 50,
    "CancelinBillingDate__c": 73,
    "Cancellation_Date__c": 68,
    "Cancellation_Reason_Detail__c": 65,
    "Cancellation_Reason__c": 64,
    "Chargeover_ID_Assets__c": 61,
    "Chargeover_Parent_ID_Assets__c": 62,
    "Cloud_Node_ID__c": 165,
    "Competitor_Lost_To__c": 67,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 149,
    "Datawire_ID__c": 41,
    "Date_Debooked__c": 160,
    "Date_New_to_Live__c": 136,
    "Date_Time_ESS_Transfer_Canceled__c": 168,
    "Date_Time_ESS_Transfer_Completed__c": 169,
    "Date_Time_ESS_Transfer_Created__c": 170,
    "Date_Time_ESS_Transfer_Effective__c": 171,
    "Debookedreason__c": 99,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 158,
    "DiscontinueProductDate__c": 74,
    "DiscountRate__c": 103,
    "Discountgroup__c": 98,
    "Download_ID__c": 42,
    "ESSAddOnId__c": 144,
    "ESSCompanyId__c": 145,
    "ESSDiscountExpirationDate__c": 148,
    "ESSDiscountedPrice__c": 150,
    "ESSFacilityId__c": 146,
    "ESSPrice__c": 151,
    "ESSSetupFee__c": 152,
    "ESSproduct__c": 129,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 110,
    "GPMCC__c": 84,
    "Google_Ads_Account_Name__c": 111,
    "Google_Ads_Account_Number__c": 112,
    "Google_Ads_Campaign_Budget_Daily__c": 115,
    "Google_Ads_Campaign_Budget_Monthly__c": 114,
    "Google_Ads_Campaign_Launch_Date__c": 113,
    "Google_Ads_Google_Doc__c": 117,
    "Google_Ads_Management_Fee__c": 118,
    "Google_Ads_Payment_Type__c": 116,
    "HQMerchantID__c": 87,
    "Hardware__c": 175,
    "HollyID_Assets__c": 55,
    "Id": 0,
    "Imp_Case_Reopened__c": 156,
    "Implementationcase__c": 75,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 132,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "LicenseTransferredFromAsset__c": 76,
    "LicenseTransferredtoAsset__c": 77,
    "ListPrice__c": 179,
    "LocationId": 32,
    "MID_Rewrite__c": 173,
    "MRR__c": 52,
    "MRR_update_date_time_stamp__c": 122,
    "MRRupdated__c": 121,
    "MSTotalVolume__c": 95,
    "ManufactureDate": 20,
    "Merchant_ID_Assets__c": 63,
    "Merchant_ID__c": 43,
    "Merchant_Services_Account_Status__c": 159,
    "MonthlyFee__c": 105,
    "Monthly_Transaction_Volume_and_Rate__c": 51,
    "Name": 17,
    "NewProduct__c": 78,
    "North_ID__c": 44,
    "Opportunity_Product__c": 176,
    "Opportunity__c": 48,
    "OriginalLeaseDate__c": 79,
    "Originating_Order_Product__c": 172,
    "ParentId": 3,
    "PaymentFamily__c": 100,
    "Payments_Activation_Date__c": 108,
    "PendingCancellationDate__c": 88,
    "Planned_Debooking_Date__c": 166,
    "PreviouslyinPendingCancellation__c": 91,
    "Price": 28,
    "Price_Change_Date__c": 157,
    "Price_Lock_Expiration__c": 174,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 153,
    "ProductDatabaseCreatedDate__c": 154,
    "ProductDatabaseLastModifiedDate__c": 155,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 47,
    "PurchaseDate": 24,
    "Quantity": 29,
    "Rate_Statement_Opportunity__c": 131,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 90,
    "Rental_Center_Version__c": 128,
    "RequestedCancellationDate__c": 80,
    "Retention_Case__c": 138,
    "RootAssetId": 4,
    "SE_Company_ID__c": 178,
    "SE_FMS_ID_Assets__c": 60,
    "SE_Facility_UUID__c": 163,
    "SE_UUID_Company__c": 162,
    "SFBEID__c": 89,
    "SFBidRate_Number__c": 71,
    "SFClientKey__c": 85,
    "SFFacilityKey__c": 86,
    "SF_Account_Status__c": 135,
    "SF_Bid_Rate__c": 54,
    "SF_Integration__c": 167,
    "SF_Substatus__c": 137,
    "SLMSAccount__c": 81,
    "SL_Corp_Code_Assets__c": 56,
    "SL_Location_Code_Assets__c": 57,
    "SSLRenewalDate__c": 93,
    "SerialNumber": 18,
    "Ship_To_Case__c": 147,
    "Short_Code__c": 133,
    "SoftwareDiscontinued__c": 83,
    "SoftwareServices__c": 177,
    "Software_Tier__c": 53,
    "Sold_To__c": 66,
    "Source_Facility_Name_Assets__c": 59,
    "Source_Parent_Name_Assets__c": 58,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 124,
    "StoPay_Annual_Group__c": 139,
    "StoPay_Auth_Group__c": 140,
    "StoPay_Discount_Group__c": 141,
    "StoPay_Monthly_Group__c": 143,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 123,
    "StopayTotal__c": 125,
    "StorableCoveredEMVDeviceCost__c": 164,
    "SystemModstamp": 14,
    "TerminalType__c": 94,
    "Terminal_ID__c": 46,
    "Text_Product_Name__c": 130,
    "TransactionFee__c": 104,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 161,
    "Uuid": 22,
    "WW_Cohort__c": 134,
    "Website_Type__c": 109,
    "Website__c": 92,
    "X1_Day_Hold__c": 45,
    "Zoho_Corporate_ID__c": 180,
    "Zoho_Corporate_URL__c": 181,
    "Zoho_ID__c": 182,
    "Zoho_URL__c": 183,
    "monthlygroup__c": 97
}
    • 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_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",
    "Bundle_Tier__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",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "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",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "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",
    "InstallDate": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "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",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "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",
    "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",
    "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",
    "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: 2049
    • schema_scan_id: 6251491
    • updated: 2023-08-16 11:13:57
    • created: 2023-08-16 10:30:05
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Asset_Notes__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 \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-dev/raw/assets/2023-08-16/1692199544'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692199544
    • id: 4697449
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 82,
    "ACHTransactionFee__c": 127,
    "ACHTransaction__c": 126,
    "AC_Expected_Launch_Date__c": 142,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 120,
    "Agency_Analytics_PPC_Dashboard__c": 119,
    "AnnualFee__c": 106,
    "Annualgroup__c": 102,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 107,
    "Asset_Notes__c": 69,
    "Asset_Type__c": 39,
    "AuthGroup__c": 96,
    "Avg_Actual_MVR__c": 101,
    "Beanstream_ID__c": 40,
    "BillingCancelled__c": 70,
    "BillingNotes__c": 72,
    "BillingStatus__c": 49,
    "Bundle_Tier__c": 50,
    "CancelinBillingDate__c": 73,
    "Cancellation_Date__c": 68,
    "Cancellation_Reason_Detail__c": 65,
    "Cancellation_Reason__c": 64,
    "Chargeover_ID_Assets__c": 61,
    "Chargeover_Parent_ID_Assets__c": 62,
    "Cloud_Node_ID__c": 165,
    "Competitor_Lost_To__c": 67,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 149,
    "Datawire_ID__c": 41,
    "Date_Debooked__c": 160,
    "Date_New_to_Live__c": 136,
    "Date_Time_ESS_Transfer_Canceled__c": 168,
    "Date_Time_ESS_Transfer_Completed__c": 169,
    "Date_Time_ESS_Transfer_Created__c": 170,
    "Date_Time_ESS_Transfer_Effective__c": 171,
    "Debookedreason__c": 99,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 158,
    "DiscontinueProductDate__c": 74,
    "DiscountRate__c": 103,
    "Discountgroup__c": 98,
    "Download_ID__c": 42,
    "ESSAddOnId__c": 144,
    "ESSCompanyId__c": 145,
    "ESSDiscountExpirationDate__c": 148,
    "ESSDiscountedPrice__c": 150,
    "ESSFacilityId__c": 146,
    "ESSPrice__c": 151,
    "ESSSetupFee__c": 152,
    "ESSproduct__c": 129,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 110,
    "GPMCC__c": 84,
    "Google_Ads_Account_Name__c": 111,
    "Google_Ads_Account_Number__c": 112,
    "Google_Ads_Campaign_Budget_Daily__c": 115,
    "Google_Ads_Campaign_Budget_Monthly__c": 114,
    "Google_Ads_Campaign_Launch_Date__c": 113,
    "Google_Ads_Google_Doc__c": 117,
    "Google_Ads_Management_Fee__c": 118,
    "Google_Ads_Payment_Type__c": 116,
    "HQMerchantID__c": 87,
    "Hardware__c": 175,
    "HollyID_Assets__c": 55,
    "Id": 0,
    "Imp_Case_Reopened__c": 156,
    "Implementationcase__c": 75,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 132,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "LicenseTransferredFromAsset__c": 76,
    "LicenseTransferredtoAsset__c": 77,
    "ListPrice__c": 179,
    "LocationId": 32,
    "MID_Rewrite__c": 173,
    "MRR__c": 52,
    "MRR_update_date_time_stamp__c": 122,
    "MRRupdated__c": 121,
    "MSTotalVolume__c": 95,
    "ManufactureDate": 20,
    "Merchant_ID_Assets__c": 63,
    "Merchant_ID__c": 43,
    "Merchant_Services_Account_Status__c": 159,
    "MonthlyFee__c": 105,
    "Monthly_Transaction_Volume_and_Rate__c": 51,
    "Name": 17,
    "NewProduct__c": 78,
    "North_ID__c": 44,
    "Opportunity_Product__c": 176,
    "Opportunity__c": 48,
    "OriginalLeaseDate__c": 79,
    "Originating_Order_Product__c": 172,
    "ParentId": 3,
    "PaymentFamily__c": 100,
    "Payments_Activation_Date__c": 108,
    "PendingCancellationDate__c": 88,
    "Planned_Debooking_Date__c": 166,
    "PreviouslyinPendingCancellation__c": 91,
    "Price": 28,
    "Price_Change_Date__c": 157,
    "Price_Lock_Expiration__c": 174,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 153,
    "ProductDatabaseCreatedDate__c": 154,
    "ProductDatabaseLastModifiedDate__c": 155,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 47,
    "PurchaseDate": 24,
    "Quantity": 29,
    "Rate_Statement_Opportunity__c": 131,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 90,
    "Rental_Center_Version__c": 128,
    "RequestedCancellationDate__c": 80,
    "Retention_Case__c": 138,
    "RootAssetId": 4,
    "SE_Company_ID__c": 178,
    "SE_FMS_ID_Assets__c": 60,
    "SE_Facility_UUID__c": 163,
    "SE_UUID_Company__c": 162,
    "SFBEID__c": 89,
    "SFBidRate_Number__c": 71,
    "SFClientKey__c": 85,
    "SFFacilityKey__c": 86,
    "SF_Account_Status__c": 135,
    "SF_Bid_Rate__c": 54,
    "SF_Integration__c": 167,
    "SF_Substatus__c": 137,
    "SLMSAccount__c": 81,
    "SL_Corp_Code_Assets__c": 56,
    "SL_Location_Code_Assets__c": 57,
    "SSLRenewalDate__c": 93,
    "SerialNumber": 18,
    "Ship_To_Case__c": 147,
    "Short_Code__c": 133,
    "SoftwareDiscontinued__c": 83,
    "SoftwareServices__c": 177,
    "Software_Tier__c": 53,
    "Sold_To__c": 66,
    "Source_Facility_Name_Assets__c": 59,
    "Source_Parent_Name_Assets__c": 58,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 124,
    "StoPay_Annual_Group__c": 139,
    "StoPay_Auth_Group__c": 140,
    "StoPay_Discount_Group__c": 141,
    "StoPay_Monthly_Group__c": 143,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 123,
    "StopayTotal__c": 125,
    "StorableCoveredEMVDeviceCost__c": 164,
    "SystemModstamp": 14,
    "TerminalType__c": 94,
    "Terminal_ID__c": 46,
    "Text_Product_Name__c": 130,
    "TransactionFee__c": 104,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 161,
    "Uuid": 22,
    "WW_Cohort__c": 134,
    "Website_Type__c": 109,
    "Website__c": 92,
    "X1_Day_Hold__c": 45,
    "Zoho_Corporate_ID__c": 180,
    "Zoho_Corporate_URL__c": 181,
    "Zoho_ID__c": 182,
    "Zoho_URL__c": 183,
    "monthlygroup__c": 97
}
    • 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_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",
    "Bundle_Tier__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",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "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",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "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",
    "InstallDate": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "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",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "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",
    "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",
    "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",
    "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: 2049
    • schema_scan_id: 6251378
    • updated: 2023-08-16 10:30:16
    • created: 2023-08-16 09:26:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Asset_Notes__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 \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-dev/raw/assets/2023-08-16/1692195933'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692195933
    • id: 4697364
    • processed: 1
    • raw_data: 
      {
    "ACHID__c": 82,
    "ACHTransactionFee__c": 127,
    "ACHTransaction__c": 126,
    "AC_Expected_Launch_Date__c": 142,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 120,
    "Agency_Analytics_PPC_Dashboard__c": 119,
    "AnnualFee__c": 106,
    "Annualgroup__c": 102,
    "AssetLevel": 36,
    "AssetProvidedById": 33,
    "AssetServicedById": 34,
    "Asset_Activation_Status__c": 107,
    "Asset_Notes__c": 69,
    "Asset_Type__c": 39,
    "AuthGroup__c": 96,
    "Avg_Actual_MVR__c": 101,
    "Beanstream_ID__c": 40,
    "BillingCancelled__c": 70,
    "BillingNotes__c": 72,
    "BillingStatus__c": 49,
    "Bundle_Tier__c": 50,
    "CancelinBillingDate__c": 73,
    "Cancellation_Date__c": 68,
    "Cancellation_Reason_Detail__c": 65,
    "Cancellation_Reason__c": 64,
    "Chargeover_ID_Assets__c": 61,
    "Chargeover_Parent_ID_Assets__c": 62,
    "Cloud_Node_ID__c": 165,
    "Competitor_Lost_To__c": 67,
    "ConsequenceOfFailure": 38,
    "ContactId": 1,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 149,
    "Datawire_ID__c": 41,
    "Date_Debooked__c": 160,
    "Date_New_to_Live__c": 136,
    "Date_Time_ESS_Transfer_Canceled__c": 168,
    "Date_Time_ESS_Transfer_Completed__c": 169,
    "Date_Time_ESS_Transfer_Created__c": 170,
    "Date_Time_ESS_Transfer_Effective__c": 171,
    "Debookedreason__c": 99,
    "Description": 30,
    "DigitalAssetStatus": 27,
    "Digital_Marketing_Status__c": 158,
    "DiscontinueProductDate__c": 74,
    "DiscountRate__c": 103,
    "Discountgroup__c": 98,
    "Download_ID__c": 42,
    "ESSAddOnId__c": 144,
    "ESSCompanyId__c": 145,
    "ESSDiscountExpirationDate__c": 148,
    "ESSDiscountedPrice__c": 150,
    "ESSFacilityId__c": 146,
    "ESSPrice__c": 151,
    "ESSSetupFee__c": 152,
    "ESSproduct__c": 129,
    "ExternalIdentifier": 23,
    "GMB_Account_Name__c": 110,
    "GPMCC__c": 84,
    "Google_Ads_Account_Name__c": 111,
    "Google_Ads_Account_Number__c": 112,
    "Google_Ads_Campaign_Budget_Daily__c": 115,
    "Google_Ads_Campaign_Budget_Monthly__c": 114,
    "Google_Ads_Campaign_Launch_Date__c": 113,
    "Google_Ads_Google_Doc__c": 117,
    "Google_Ads_Management_Fee__c": 118,
    "Google_Ads_Payment_Type__c": 116,
    "HQMerchantID__c": 87,
    "Hardware__c": 175,
    "HollyID_Assets__c": 55,
    "Id": 0,
    "Imp_Case_Reopened__c": 156,
    "Implementationcase__c": 75,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 35,
    "JIRA_Ticket__c": 132,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "LicenseTransferredFromAsset__c": 76,
    "LicenseTransferredtoAsset__c": 77,
    "ListPrice__c": 179,
    "LocationId": 32,
    "MID_Rewrite__c": 173,
    "MRR__c": 52,
    "MRR_update_date_time_stamp__c": 122,
    "MRRupdated__c": 121,
    "MSTotalVolume__c": 95,
    "ManufactureDate": 20,
    "Merchant_ID_Assets__c": 63,
    "Merchant_ID__c": 43,
    "Merchant_Services_Account_Status__c": 159,
    "MonthlyFee__c": 105,
    "Monthly_Transaction_Volume_and_Rate__c": 51,
    "Name": 17,
    "NewProduct__c": 78,
    "North_ID__c": 44,
    "Opportunity_Product__c": 176,
    "Opportunity__c": 48,
    "OriginalLeaseDate__c": 79,
    "Originating_Order_Product__c": 172,
    "ParentId": 3,
    "PaymentFamily__c": 100,
    "Payments_Activation_Date__c": 108,
    "PendingCancellationDate__c": 88,
    "Planned_Debooking_Date__c": 166,
    "PreviouslyinPendingCancellation__c": 91,
    "Price": 28,
    "Price_Change_Date__c": 157,
    "Price_Lock_Expiration__c": 174,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 153,
    "ProductDatabaseCreatedDate__c": 154,
    "ProductDatabaseLastModifiedDate__c": 155,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 47,
    "PurchaseDate": 24,
    "Quantity": 29,
    "Rate_Statement_Opportunity__c": 131,
    "RecordTypeId": 31,
    "RelatedOpportunityhasbeenclosedwon__c": 90,
    "Rental_Center_Version__c": 128,
    "RequestedCancellationDate__c": 80,
    "Retention_Case__c": 138,
    "RootAssetId": 4,
    "SE_Company_ID__c": 178,
    "SE_FMS_ID_Assets__c": 60,
    "SE_Facility_UUID__c": 163,
    "SE_UUID_Company__c": 162,
    "SFBEID__c": 89,
    "SFBidRate_Number__c": 71,
    "SFClientKey__c": 85,
    "SFFacilityKey__c": 86,
    "SF_Account_Status__c": 135,
    "SF_Bid_Rate__c": 54,
    "SF_Integration__c": 167,
    "SF_Substatus__c": 137,
    "SLMSAccount__c": 81,
    "SL_Corp_Code_Assets__c": 56,
    "SL_Location_Code_Assets__c": 57,
    "SSLRenewalDate__c": 93,
    "SerialNumber": 18,
    "Ship_To_Case__c": 147,
    "Short_Code__c": 133,
    "SoftwareDiscontinued__c": 83,
    "SoftwareServices__c": 177,
    "Software_Tier__c": 53,
    "Sold_To__c": 66,
    "Source_Facility_Name_Assets__c": 59,
    "Source_Parent_Name_Assets__c": 58,
    "Status": 26,
    "StatusReason": 21,
    "Statuslastupdate__c": 124,
    "StoPay_Annual_Group__c": 139,
    "StoPay_Auth_Group__c": 140,
    "StoPay_Discount_Group__c": 141,
    "StoPay_Monthly_Group__c": 143,
    "StockKeepingUnit": 37,
    "StopayProduct__c": 123,
    "StopayTotal__c": 125,
    "StorableCoveredEMVDeviceCost__c": 164,
    "SystemModstamp": 14,
    "TerminalType__c": 94,
    "Terminal_ID__c": 46,
    "Text_Product_Name__c": 130,
    "TransactionFee__c": 104,
    "UsageEndDate": 25,
    "User_Activation_Tracking__c": 161,
    "Uuid": 22,
    "WW_Cohort__c": 134,
    "Website_Type__c": 109,
    "Website__c": 92,
    "X1_Day_Hold__c": 45,
    "Zoho_Corporate_ID__c": 180,
    "Zoho_Corporate_URL__c": 181,
    "Zoho_ID__c": 182,
    "Zoho_URL__c": 183,
    "monthlygroup__c": 97
}
    • 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_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",
    "Bundle_Tier__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",
    "CloseDate": "string",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "string",
    "ConsequenceOfFailure": "string",
    "ContactId": "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",
    "ExpectedRevenue": "string",
    "ExternalIdentifier": "string",
    "ForecastCategory": "string",
    "GMB_Account_Name__c": "string",
    "GPMCC__c": "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",
    "InstallDate": "string",
    "IsCompetitorProduct": "string",
    "IsDeleted": "string",
    "IsInternal": "string",
    "JIRA_Ticket__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LicenseTransferredFromAsset__c": "string",
    "LicenseTransferredtoAsset__c": "string",
    "ListPrice__c": "string",
    "LocationId": "string",
    "MID_Rewrite__c": "string",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__c": "string",
    "ManufactureDate": "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",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "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",
    "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",
    "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",
    "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: 2049
    • schema_scan_id: 6251247
    • updated: 2023-08-16 09:27:03
Schema Scans: 5
Last at 2024-06-10 15:34:20
    • duration: 0:00:20.240471
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6510725
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/assets/2024-06-10/1718051389",
        "key": "raw/assets/2024-06-10/1718051389/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4699405261572027927,
        "service_name": "drive-thru",
        "span_id": 4925862288762556147,
        "trace_id": 7057285929350931112
    }
}
    • running: False
    • schema_name_id: 2049
    • start_time: 2024-06-10 15:34:20
    • success: True
    • trace_id: 7057285929350931112
    • duration: 0:00:17.416682
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6402627
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/assets/2024-01-11/1704985730",
        "key": "raw/assets/2024-01-11/1704985730/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12392166872061325854,
        "service_name": "drive-thru",
        "span_id": 4134955881906388751,
        "trace_id": 4689181077617299294
    }
}
    • running: False
    • schema_name_id: 2049
    • start_time: 2024-01-11 09:11:10
    • success: True
    • trace_id: 4689181077617299294
    • duration: 0:00:16.880997
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251491
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692202279",
        "key": "raw/assets/2023-08-16/1692202279/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11475806762691802611,
        "service_name": "drive-thru",
        "span_id": 1961593276242955726,
        "trace_id": 14177263662310721599
    }
}
    • running: False
    • schema_name_id: 2049
    • start_time: 2023-08-16 11:13:40
    • success: True
    • trace_id: 14177263662310721599
    • duration: 0:00:17.250671
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251378
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692199544",
        "key": "raw/assets/2023-08-16/1692199544/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8008609612874578768,
        "service_name": "drive-thru",
        "span_id": 3660201323243590286,
        "trace_id": 5208884979359212874
    }
}
    • running: False
    • schema_name_id: 2049
    • start_time: 2023-08-16 10:29:59
    • success: True
    • trace_id: 5208884979359212874
    • duration: 0:00:16.817086
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251247
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/assets/2023-08-16/1692195933",
        "key": "raw/assets/2023-08-16/1692195933/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5626203351043394995,
        "service_name": "drive-thru",
        "span_id": 6499551215674480167,
        "trace_id": 15005326991247077145
    }
}
    • running: False
    • schema_name_id: 2049
    • start_time: 2023-08-16 09:26:46
    • success: True
    • trace_id: 15005326991247077145
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_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"
}
  • created: 2024-06-10 15:34:27
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/assets/2024-06-10/1718051389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2022-10-24 14:51:08",
        "disabled": false,
        "format": "raw",
        "id": 2049,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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_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"
        },
        "created": "2024-06-10 15:34:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/assets/2024-06-10/1718051389'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_assets`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_assets"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform