Schema Info

Schema Name: sfdl_dev_csv.ownbackup_assets

created: 2022-09-12 16:16:33
disabled: False
format: raw
id: 2019
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_csv",
    "table": "ownbackup_assets"
}

type: csv

Schema Versions: 2

Version 4690074

created: 2022-09-13 11:14:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.ownbackup_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.ownbackup_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 , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  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 \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-ownbackup-dev/raw/assets/2022-09-13/1663085630'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.ownbackup_assets"
]

hive_path: s3://sfdl-csv-ownbackup-dev/raw/assets/2022-09-13/1663085630
id: 4690074
processed: 1

raw_data:

{
    "ACHID__c": 75,
    "ACHTransactionFee__c": 120,
    "ACHTransaction__c": 119,
    "AC_Expected_Launch_Date__c": 135,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 113,
    "Agency_Analytics_PPC_Dashboard__c": 112,
    "AnnualFee__c": 99,
    "Annualgroup__c": 95,
    "AssetLevel": 30,
    "AssetProvidedById": 27,
    "AssetServicedById": 28,
    "Asset_Activation_Status__c": 100,
    "Asset_Notes__c": 62,
    "Asset_Type__c": 32,
    "AuthGroup__c": 89,
    "Avg_Actual_MVR__c": 94,
    "Beanstream_ID__c": 33,
    "BillingCancelled__c": 63,
    "BillingNotes__c": 65,
    "BillingStatus__c": 42,
    "Bundle_Tier__c": 43,
    "CancelinBillingDate__c": 66,
    "Cancellation_Date__c": 61,
    "Cancellation_Reason_Detail__c": 58,
    "Cancellation_Reason__c": 57,
    "Chargeover_ID_Assets__c": 54,
    "Chargeover_Parent_ID_Assets__c": 55,
    "Cloud_Node_ID__c": 158,
    "Competitor_Lost_To__c": 60,
    "ContactId": 1,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 142,
    "Datawire_ID__c": 34,
    "Date_Debooked__c": 153,
    "Date_New_to_Live__c": 129,
    "Debookedreason__c": 92,
    "Description": 25,
    "Digital_Marketing_Status__c": 151,
    "DiscontinueProductDate__c": 67,
    "DiscountRate__c": 96,
    "Discountgroup__c": 91,
    "Download_ID__c": 35,
    "ESSAddOnId__c": 137,
    "ESSCompanyId__c": 138,
    "ESSDiscountExpirationDate__c": 141,
    "ESSDiscountedPrice__c": 143,
    "ESSFacilityId__c": 139,
    "ESSPrice__c": 144,
    "ESSSetupFee__c": 145,
    "ESSproduct__c": 122,
    "GMB_Account_Name__c": 103,
    "GPMCC__c": 77,
    "Google_Ads_Account_Name__c": 104,
    "Google_Ads_Account_Number__c": 105,
    "Google_Ads_Campaign_Budget_Daily__c": 108,
    "Google_Ads_Campaign_Budget_Monthly__c": 107,
    "Google_Ads_Campaign_Launch_Date__c": 106,
    "Google_Ads_Google_Doc__c": 110,
    "Google_Ads_Management_Fee__c": 111,
    "Google_Ads_Payment_Type__c": 109,
    "HQMerchantID__c": 80,
    "HollyID_Assets__c": 48,
    "Id": 0,
    "Imp_Case_Reopened__c": 149,
    "Implementationcase__c": 68,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 29,
    "JIRA_Ticket__c": 125,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "LicenseTransferredFromAsset__c": 69,
    "LicenseTransferredtoAsset__c": 70,
    "MRR__c": 45,
    "MRR_update_date_time_stamp__c": 115,
    "MRRupdated__c": 114,
    "MSTotalVolume__c": 88,
    "Merchant_ID_Assets__c": 56,
    "Merchant_ID__c": 36,
    "Merchant_Services_Account_Status__c": 152,
    "MonthlyFee__c": 98,
    "Monthly_Transaction_Volume_and_Rate__c": 44,
    "Name": 17,
    "NewProduct__c": 71,
    "North_ID__c": 37,
    "Opportunity__c": 41,
    "OriginalLeaseDate__c": 72,
    "ParentId": 3,
    "PaymentFamily__c": 93,
    "Payments_Activation_Date__c": 101,
    "PendingCancellationDate__c": 81,
    "Planned_Debooking_Date__c": 159,
    "PreviouslyinPendingCancellation__c": 84,
    "Price": 23,
    "Price_Change_Date__c": 150,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 146,
    "ProductDatabaseCreatedDate__c": 147,
    "ProductDatabaseLastModifiedDate__c": 148,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 40,
    "PurchaseDate": 20,
    "Quantity": 24,
    "Rate_Statement_Opportunity__c": 124,
    "RecordTypeId": 26,
    "RelatedOpportunityhasbeenclosedwon__c": 83,
    "Rental_Center_Version__c": 121,
    "RequestedCancellationDate__c": 73,
    "Retention_Case__c": 131,
    "RootAssetId": 4,
    "SE_FMS_ID_Assets__c": 53,
    "SE_Facility_UUID__c": 156,
    "SE_UUID_Company__c": 155,
    "SFBEID__c": 82,
    "SFBidRate_Number__c": 64,
    "SFClientKey__c": 78,
    "SFFacilityKey__c": 79,
    "SF_Account_Status__c": 128,
    "SF_Bid_Rate__c": 47,
    "SF_Integration__c": 160,
    "SF_Substatus__c": 130,
    "SLMSAccount__c": 74,
    "SL_Corp_Code_Assets__c": 49,
    "SL_Location_Code_Assets__c": 50,
    "SSLRenewalDate__c": 86,
    "SerialNumber": 18,
    "Ship_To_Case__c": 140,
    "Short_Code__c": 126,
    "SoftwareDiscontinued__c": 76,
    "Software_Tier__c": 46,
    "Sold_To__c": 59,
    "Source_Facility_Name_Assets__c": 52,
    "Source_Parent_Name_Assets__c": 51,
    "Status": 22,
    "Statuslastupdate__c": 117,
    "StoPay_Annual_Group__c": 132,
    "StoPay_Auth_Group__c": 133,
    "StoPay_Discount_Group__c": 134,
    "StoPay_Monthly_Group__c": 136,
    "StockKeepingUnit": 31,
    "StopayProduct__c": 116,
    "StopayTotal__c": 118,
    "StorableCoveredEMVDeviceCost__c": 157,
    "SystemModstamp": 14,
    "TerminalType__c": 87,
    "Terminal_ID__c": 39,
    "Text_Product_Name__c": 123,
    "TransactionFee__c": 97,
    "UsageEndDate": 21,
    "User_Activation_Tracking__c": 154,
    "WW_Cohort__c": 127,
    "Website_Type__c": 102,
    "Website__c": 85,
    "X1_Day_Hold__c": 38,
    "monthlygroup__c": 90
}

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",
    "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",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "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",
    "Debookedreason__c": "string",
    "Description": "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",
    "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",
    "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",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__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",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "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_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",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "Status": "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",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "monthlygroup__c": "string"
}

schema_name_id: 2019
schema_scan_id: 5977865
updated: 2022-09-13 11:14:32

Version 4690070

created: 2022-09-12 16:16:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.ownbackup_assets`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.ownbackup_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 , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  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 \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-ownbackup-dev/raw/assets/2022-09-12/1663017384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.ownbackup_assets"
]

hive_path: s3://sfdl-csv-ownbackup-dev/raw/assets/2022-09-12/1663017384
id: 4690070
processed: 1

raw_data:

{
    "ACHID__c": 75,
    "ACHTransactionFee__c": 120,
    "ACHTransaction__c": 119,
    "AC_Expected_Launch_Date__c": 135,
    "AccountId": 2,
    "Agency_Analytics_Custom_Reports__c": 113,
    "Agency_Analytics_PPC_Dashboard__c": 112,
    "AnnualFee__c": 99,
    "Annualgroup__c": 95,
    "AssetLevel": 30,
    "AssetProvidedById": 27,
    "AssetServicedById": 28,
    "Asset_Activation_Status__c": 100,
    "Asset_Notes__c": 62,
    "Asset_Type__c": 32,
    "AuthGroup__c": 89,
    "Avg_Actual_MVR__c": 94,
    "Beanstream_ID__c": 33,
    "BillingCancelled__c": 63,
    "BillingNotes__c": 65,
    "BillingStatus__c": 42,
    "Bundle_Tier__c": 43,
    "CancelinBillingDate__c": 66,
    "Cancellation_Date__c": 61,
    "Cancellation_Reason_Detail__c": 58,
    "Cancellation_Reason__c": 57,
    "Chargeover_ID_Assets__c": 54,
    "Chargeover_Parent_ID_Assets__c": 55,
    "Cloud_Node_ID__c": 158,
    "Competitor_Lost_To__c": 60,
    "ContactId": 1,
    "CreatedById": 11,
    "CreatedDate": 10,
    "CurrencyIsoCode": 16,
    "DataLakeSyncDate__c": 142,
    "Datawire_ID__c": 34,
    "Date_Debooked__c": 153,
    "Date_New_to_Live__c": 129,
    "Debookedreason__c": 92,
    "Description": 25,
    "Digital_Marketing_Status__c": 151,
    "DiscontinueProductDate__c": 67,
    "DiscountRate__c": 96,
    "Discountgroup__c": 91,
    "Download_ID__c": 35,
    "ESSAddOnId__c": 137,
    "ESSCompanyId__c": 138,
    "ESSDiscountExpirationDate__c": 141,
    "ESSDiscountedPrice__c": 143,
    "ESSFacilityId__c": 139,
    "ESSPrice__c": 144,
    "ESSSetupFee__c": 145,
    "ESSproduct__c": 122,
    "GMB_Account_Name__c": 103,
    "GPMCC__c": 77,
    "Google_Ads_Account_Name__c": 104,
    "Google_Ads_Account_Number__c": 105,
    "Google_Ads_Campaign_Budget_Daily__c": 108,
    "Google_Ads_Campaign_Budget_Monthly__c": 107,
    "Google_Ads_Campaign_Launch_Date__c": 106,
    "Google_Ads_Google_Doc__c": 110,
    "Google_Ads_Management_Fee__c": 111,
    "Google_Ads_Payment_Type__c": 109,
    "HQMerchantID__c": 80,
    "HollyID_Assets__c": 48,
    "Id": 0,
    "Imp_Case_Reopened__c": 149,
    "Implementationcase__c": 68,
    "InstallDate": 19,
    "IsCompetitorProduct": 9,
    "IsDeleted": 15,
    "IsInternal": 29,
    "JIRA_Ticket__c": 125,
    "LastModifiedById": 13,
    "LastModifiedDate": 12,
    "LicenseTransferredFromAsset__c": 69,
    "LicenseTransferredtoAsset__c": 70,
    "MRR__c": 45,
    "MRR_update_date_time_stamp__c": 115,
    "MRRupdated__c": 114,
    "MSTotalVolume__c": 88,
    "Merchant_ID_Assets__c": 56,
    "Merchant_ID__c": 36,
    "Merchant_Services_Account_Status__c": 152,
    "MonthlyFee__c": 98,
    "Monthly_Transaction_Volume_and_Rate__c": 44,
    "Name": 17,
    "NewProduct__c": 71,
    "North_ID__c": 37,
    "Opportunity__c": 41,
    "OriginalLeaseDate__c": 72,
    "ParentId": 3,
    "PaymentFamily__c": 93,
    "Payments_Activation_Date__c": 101,
    "PendingCancellationDate__c": 81,
    "Planned_Debooking_Date__c": 159,
    "PreviouslyinPendingCancellation__c": 84,
    "Price": 23,
    "Price_Change_Date__c": 150,
    "Product2Id": 5,
    "ProductCode": 6,
    "ProductDatabaseCancelledDate__c": 146,
    "ProductDatabaseCreatedDate__c": 147,
    "ProductDatabaseLastModifiedDate__c": 148,
    "ProductDescription": 8,
    "ProductFamily": 7,
    "Profituity_ID__c": 40,
    "PurchaseDate": 20,
    "Quantity": 24,
    "Rate_Statement_Opportunity__c": 124,
    "RecordTypeId": 26,
    "RelatedOpportunityhasbeenclosedwon__c": 83,
    "Rental_Center_Version__c": 121,
    "RequestedCancellationDate__c": 73,
    "Retention_Case__c": 131,
    "RootAssetId": 4,
    "SE_FMS_ID_Assets__c": 53,
    "SE_Facility_UUID__c": 156,
    "SE_UUID_Company__c": 155,
    "SFBEID__c": 82,
    "SFBidRate_Number__c": 64,
    "SFClientKey__c": 78,
    "SFFacilityKey__c": 79,
    "SF_Account_Status__c": 128,
    "SF_Bid_Rate__c": 47,
    "SF_Integration__c": 160,
    "SF_Substatus__c": 130,
    "SLMSAccount__c": 74,
    "SL_Corp_Code_Assets__c": 49,
    "SL_Location_Code_Assets__c": 50,
    "SSLRenewalDate__c": 86,
    "SerialNumber": 18,
    "Ship_To_Case__c": 140,
    "Short_Code__c": 126,
    "SoftwareDiscontinued__c": 76,
    "Software_Tier__c": 46,
    "Sold_To__c": 59,
    "Source_Facility_Name_Assets__c": 52,
    "Source_Parent_Name_Assets__c": 51,
    "Status": 22,
    "Statuslastupdate__c": 117,
    "StoPay_Annual_Group__c": 132,
    "StoPay_Auth_Group__c": 133,
    "StoPay_Discount_Group__c": 134,
    "StoPay_Monthly_Group__c": 136,
    "StockKeepingUnit": 31,
    "StopayProduct__c": 116,
    "StopayTotal__c": 118,
    "StorableCoveredEMVDeviceCost__c": 157,
    "SystemModstamp": 14,
    "TerminalType__c": 87,
    "Terminal_ID__c": 39,
    "Text_Product_Name__c": 123,
    "TransactionFee__c": 97,
    "UsageEndDate": 21,
    "User_Activation_Tracking__c": 154,
    "WW_Cohort__c": 127,
    "Website_Type__c": 102,
    "Website__c": 85,
    "X1_Day_Hold__c": 38,
    "monthlygroup__c": 90
}

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",
    "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",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "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",
    "Debookedreason__c": "string",
    "Description": "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",
    "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",
    "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",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__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",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "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_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",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "Status": "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",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "monthlygroup__c": "string"
}

schema_name_id: 2019
schema_scan_id: 5977571
updated: 2022-09-12 16:16:53

Schema Scans: 2

Last at 2022-09-13 11:14:16

Scan 5977865

duration: 0:00:16.680815

exit_message:

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

id: 5977865

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-ownbackup-dev",
        "hive_path": "s3://sfdl-csv-ownbackup-dev/raw/assets/2022-09-13/1663085630",
        "key": "raw/assets/2022-09-13/1663085630/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.ownbackup_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11260103831300488079,
        "service_name": "drive-thru",
        "span_id": 6707839147680276628,
        "trace_id": 6353576929147636662
    }
}

running: False
schema_name_id: 2019
start_time: 2022-09-13 11:14:16
success: True
trace_id: 6353576929147636662

Scan 5977571

duration: 0:00:20.385303

exit_message:

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

id: 5977571

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-ownbackup-dev",
        "hive_path": "s3://sfdl-csv-ownbackup-dev/raw/assets/2022-09-12/1663017384",
        "key": "raw/assets/2022-09-12/1663017384/assets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.ownbackup_assets",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7642398953510406298,
        "service_name": "drive-thru",
        "span_id": 1065516758771151407,
        "trace_id": 8628651442961751241
    }
}

running: False
schema_name_id: 2019
start_time: 2022-09-12 16:16:33
success: True
trace_id: 8628651442961751241

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",
    "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",
    "Cloud_Node_ID__c": "string",
    "Competitor_Lost_To__c": "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",
    "Debookedreason__c": "string",
    "Description": "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",
    "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",
    "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",
    "MRR__c": "string",
    "MRR_update_date_time_stamp__c": "string",
    "MRRupdated__c": "string",
    "MSTotalVolume__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",
    "Opportunity__c": "string",
    "OriginalLeaseDate__c": "string",
    "ParentId": "string",
    "PaymentFamily__c": "string",
    "Payments_Activation_Date__c": "string",
    "PendingCancellationDate__c": "string",
    "Planned_Debooking_Date__c": "string",
    "PreviouslyinPendingCancellation__c": "string",
    "Price": "string",
    "Price_Change_Date__c": "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_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",
    "Software_Tier__c": "string",
    "Sold_To__c": "string",
    "Source_Facility_Name_Assets__c": "string",
    "Source_Parent_Name_Assets__c": "string",
    "Status": "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",
    "WW_Cohort__c": "string",
    "Website_Type__c": "string",
    "Website__c": "string",
    "X1_Day_Hold__c": "string",
    "monthlygroup__c": "string"
}

created: 2022-09-13 11:14:21

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.ownbackup_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 , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  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 \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-ownbackup-dev/raw/assets/2022-09-13/1663085630'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.ownbackup_assets`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.ownbackup_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-09-12 16:16:33",
        "disabled": false,
        "format": "raw",
        "id": 2019,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_csv",
            "table": "ownbackup_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",
            "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",
            "Cloud_Node_ID__c": "string",
            "Competitor_Lost_To__c": "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",
            "Debookedreason__c": "string",
            "Description": "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",
            "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",
            "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",
            "MRR__c": "string",
            "MRR_update_date_time_stamp__c": "string",
            "MRRupdated__c": "string",
            "MSTotalVolume__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",
            "Opportunity__c": "string",
            "OriginalLeaseDate__c": "string",
            "ParentId": "string",
            "PaymentFamily__c": "string",
            "Payments_Activation_Date__c": "string",
            "PendingCancellationDate__c": "string",
            "Planned_Debooking_Date__c": "string",
            "PreviouslyinPendingCancellation__c": "string",
            "Price": "string",
            "Price_Change_Date__c": "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_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",
            "Software_Tier__c": "string",
            "Sold_To__c": "string",
            "Source_Facility_Name_Assets__c": "string",
            "Source_Parent_Name_Assets__c": "string",
            "Status": "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",
            "WW_Cohort__c": "string",
            "Website_Type__c": "string",
            "Website__c": "string",
            "X1_Day_Hold__c": "string",
            "monthlygroup__c": "string"
        },
        "created": "2022-09-13 11:14:21",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_csv.ownbackup_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 , `PurchaseDate`  string , `UsageEndDate`  string , `Status`  string , `Price`  string , `Quantity`  string , `Description`  string , `RecordTypeId`  string , `AssetProvidedById`  string , `AssetServicedById`  string , `IsInternal`  string , `AssetLevel`  string , `StockKeepingUnit`  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 \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-ownbackup-dev/raw/assets/2022-09-13/1663085630'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.ownbackup_assets`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.ownbackup_assets"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}