Schema Info

Schema Name: sfdl_prod_csv.salesforce_order_items
  • created: 2023-03-28 12:46:19
  • disabled: False
  • format: raw
  • id: 1530
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_csv",
    "table": "salesforce_order_items"
}
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 07:06:03
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-17/1776427484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-17/1776427484
    • id: 1718082
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 162173050
    • updated: 2026-04-17 07:06:17
    • created: 2026-04-16 07:05:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-16/1776341077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-16/1776341077
    • id: 1716838
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 162117308
    • updated: 2026-04-16 07:05:27
    • created: 2026-04-15 07:07:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-15/1776254753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-15/1776254753
    • id: 1715643
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 162061779
    • updated: 2026-04-15 07:07:45
    • created: 2026-04-14 07:07:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-14/1776168344'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-14/1776168344
    • id: 1714491
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 162006420
    • updated: 2026-04-14 07:08:00
    • created: 2026-04-13 07:04:47
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-13/1776081880'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-13/1776081880
    • id: 1713212
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161948282
    • updated: 2026-04-13 07:05:01
    • created: 2026-04-12 07:09:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-12/1775995765'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-12/1775995765
    • id: 1712081
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161899566
    • updated: 2026-04-12 07:09:47
    • created: 2026-04-11 07:04:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-11/1775909059'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-11/1775909059
    • id: 1710828
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161846836
    • updated: 2026-04-11 07:04:45
    • created: 2026-04-10 07:05:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-10/1775822699'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-10/1775822699
    • id: 1709661
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161792059
    • updated: 2026-04-10 07:06:03
    • created: 2026-04-09 07:06:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-09/1775736296'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-09/1775736296
    • id: 1708520
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161736252
    • updated: 2026-04-09 07:06:36
    • created: 2026-04-08 07:04:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-08/1775649882'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-08/1775649882
    • id: 1707307
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161681359
    • updated: 2026-04-08 07:05:06
    • created: 2026-04-07 07:05:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-07/1775563492'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-07/1775563492
    • id: 1706128
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161625166
    • updated: 2026-04-07 07:05:53
    • created: 2026-04-06 07:07:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-06/1775477087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-06/1775477087
    • id: 1704909
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161567318
    • updated: 2026-04-06 07:07:21
    • created: 2026-04-05 07:04:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-05/1775390637'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-05/1775390637
    • id: 1703672
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161519950
    • updated: 2026-04-05 07:04:25
    • created: 2026-04-04 07:07:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-04/1775304395'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-04/1775304395
    • id: 1702542
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161466412
    • updated: 2026-04-04 07:07:53
    • created: 2026-04-03 07:04:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-03/1775217856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-03/1775217856
    • id: 1701341
    • processed: 1
    • raw_data: 
      {
    "AC_Introductory_Discount_Months__c": 31,
    "All_Minutes_Included__c": 45,
    "All_Tracking_Numbers_Included__c": 46,
    "Asset_ID__c": 36,
    "AvailableQuantity": 7,
    "Cap__c": 53,
    "Contract_End_of_Term_Action__c": 47,
    "Contract_Term_in_Months__c": 48,
    "CreatedById": 17,
    "CreatedDate": 16,
    "CurrencyIsoCode": 9,
    "Data_Load_By__c": 54,
    "Debook_Date__c": 34,
    "Debook_Reason__c": 35,
    "Description": 15,
    "EndDate": 14,
    "Escalation_Percent__c": 49,
    "Escalation_Rate__c": 50,
    "FMS_Introductory_Discount_Months__c": 22,
    "Free_Initial_Period_Days__c": 51,
    "Id": 0,
    "Included_Minutes__c": 37,
    "Included_Tracking_Numbers__c": 38,
    "Intro_Discount_Term_Months__c": 43,
    "IsDeleted": 2,
    "LastModifiedById": 19,
    "LastModifiedDate": 18,
    "Legacy__c": 39,
    "ListPrice": 11,
    "List_Price_Normalized__c": 44,
    "Maximum_Usage__c": 40,
    "NetSuite_ID__c": 23,
    "NetSuite_List_Price__c": 32,
    "NetSuite_Sync_Time__c": 24,
    "NetSuite_Transaction__c": 25,
    "Next_Escalation_Date__c": 52,
    "Opportunity__c": 33,
    "OrderId": 3,
    "OrderItemNumber": 21,
    "OriginalOrderItemId": 5,
    "Originating_Opportunity_Product__c": 26,
    "Overage_Rate_for_Minutes__c": 41,
    "Overage_Rate_for_Tracking_Numbers__c": 42,
    "PricebookEntryId": 4,
    "Product2Id": 1,
    "Product_Category_Text__c": 27,
    "Product_Type__c": 28,
    "Quantity": 8,
    "QuoteLineItemId": 6,
    "ServiceDate": 13,
    "Status__c": 29,
    "SystemModstamp": 20,
    "TotalPrice": 12,
    "UnitPrice": 10,
    "Website_Introductory_Discount_Months__c": 30
}
    • schema_attributes: 
      {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
    • schema_name_id: 1530
    • schema_scan_id: 161408543
    • updated: 2026-04-03 07:05:00
Schema Scans: 15
Last at 2026-04-17 07:06:00
    • duration: 0:00:16.677771
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173050
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-17/1776427484",
        "key": "raw/order_items/2026-04-17/1776427484/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18270944272107201527,
        "service_name": "drive-thru",
        "span_id": 9848221779745754603,
        "trace_id": 4472955805450490752
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-17 07:06:00
    • success: True
    • trace_id: 4472955805450490752
    • duration: 0:00:13.186429
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117308
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-16/1776341077",
        "key": "raw/order_items/2026-04-16/1776341077/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6195438014290260050,
        "service_name": "drive-thru",
        "span_id": 7690033537605472832,
        "trace_id": 6491245509029744060
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-16 07:05:14
    • success: True
    • trace_id: 6491245509029744060
    • duration: 0:00:15.795700
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061779
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-15/1776254753",
        "key": "raw/order_items/2026-04-15/1776254753/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4055656584016875021,
        "service_name": "drive-thru",
        "span_id": 17049884788640118235,
        "trace_id": 4579929199659073571
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-15 07:07:30
    • success: True
    • trace_id: 4579929199659073571
    • duration: 0:00:15.937401
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006420
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-14/1776168344",
        "key": "raw/order_items/2026-04-14/1776168344/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4157312358452960798,
        "service_name": "drive-thru",
        "span_id": 14199208174783925058,
        "trace_id": 1077166487667259540
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-14 07:07:44
    • success: True
    • trace_id: 1077166487667259540
    • duration: 0:00:15.542973
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948282
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-13/1776081880",
        "key": "raw/order_items/2026-04-13/1776081880/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 912042872929190384,
        "service_name": "drive-thru",
        "span_id": 17906338741922769110,
        "trace_id": 1870302858551577548
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-13 07:04:45
    • success: True
    • trace_id: 1870302858551577548
    • duration: 0:00:15.611240
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899566
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-12/1775995765",
        "key": "raw/order_items/2026-04-12/1775995765/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13520261298797634673,
        "service_name": "drive-thru",
        "span_id": 15440007557745259045,
        "trace_id": 14814242283188815914
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-12 07:09:32
    • success: True
    • trace_id: 14814242283188815914
    • duration: 0:00:13.115631
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846836
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-11/1775909059",
        "key": "raw/order_items/2026-04-11/1775909059/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7445469985050424251,
        "service_name": "drive-thru",
        "span_id": 5871622113244388893,
        "trace_id": 14817081835183502781
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-11 07:04:32
    • success: True
    • trace_id: 14817081835183502781
    • duration: 0:00:15.597209
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792059
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-10/1775822699",
        "key": "raw/order_items/2026-04-10/1775822699/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6697412921452886913,
        "service_name": "drive-thru",
        "span_id": 12980041570320877883,
        "trace_id": 9466791345772894906
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-10 07:05:48
    • success: True
    • trace_id: 9466791345772894906
    • duration: 0:00:15.724275
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736252
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-09/1775736296",
        "key": "raw/order_items/2026-04-09/1775736296/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 569326047284283977,
        "service_name": "drive-thru",
        "span_id": 6241569075794598714,
        "trace_id": 3970152947893786129
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-09 07:06:20
    • success: True
    • trace_id: 3970152947893786129
    • duration: 0:00:15.524412
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681359
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-08/1775649882",
        "key": "raw/order_items/2026-04-08/1775649882/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8114786145632220050,
        "service_name": "drive-thru",
        "span_id": 781104433240394187,
        "trace_id": 17502672090437486806
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-08 07:04:51
    • success: True
    • trace_id: 17502672090437486806
    • duration: 0:00:15.642175
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625166
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-07/1775563492",
        "key": "raw/order_items/2026-04-07/1775563492/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 253119594038872837,
        "service_name": "drive-thru",
        "span_id": 11532728665757401204,
        "trace_id": 14490104480719369793
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-07 07:05:38
    • success: True
    • trace_id: 14490104480719369793
    • duration: 0:00:15.641168
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567318
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-06/1775477087",
        "key": "raw/order_items/2026-04-06/1775477087/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9770121185268302493,
        "service_name": "drive-thru",
        "span_id": 6422220235319538283,
        "trace_id": 6263139082589803446
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-06 07:07:06
    • success: True
    • trace_id: 6263139082589803446
    • duration: 0:00:15.520650
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161519950
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-05/1775390637",
        "key": "raw/order_items/2026-04-05/1775390637/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2162967241159329269,
        "service_name": "drive-thru",
        "span_id": 5993731561570256078,
        "trace_id": 14125851838934623424
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-05 07:04:09
    • success: True
    • trace_id: 14125851838934623424
    • duration: 0:00:15.876149
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466412
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-04/1775304395",
        "key": "raw/order_items/2026-04-04/1775304395/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12396009696794389307,
        "service_name": "drive-thru",
        "span_id": 2546732756216806203,
        "trace_id": 13483295794753689578
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-04 07:07:37
    • success: True
    • trace_id: 13483295794753689578
    • duration: 0:00:15.632532
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408543
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/order_items/2026-04-03/1775217856",
        "key": "raw/order_items/2026-04-03/1775217856/order_items.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_order_items",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7979390573219145764,
        "service_name": "drive-thru",
        "span_id": 4358778536680386287,
        "trace_id": 9588020282894654129
    }
}
    • running: False
    • schema_name_id: 1530
    • start_time: 2026-04-03 07:04:44
    • success: True
    • trace_id: 9588020282894654129
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "AC_Introductory_Discount_Months__c": "string",
    "All_Minutes_Included__c": "string",
    "All_Tracking_Numbers_Included__c": "string",
    "Asset_ID__c": "string",
    "AvailableQuantity": "string",
    "Cap__c": "string",
    "Contract_End_of_Term_Action__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Debook_Date__c": "string",
    "Debook_Reason__c": "string",
    "Description": "string",
    "EndDate": "string",
    "Escalation_Percent__c": "string",
    "Escalation_Rate__c": "string",
    "FMS_Introductory_Discount_Months__c": "string",
    "Free_Initial_Period_Days__c": "string",
    "Id": "string",
    "Included_Minutes__c": "string",
    "Included_Tracking_Numbers__c": "string",
    "Intro_Discount_Term_Months__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Legacy__c": "string",
    "ListPrice": "string",
    "List_Price_Normalized__c": "string",
    "Maximum_Usage__c": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_List_Price__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "NetSuite_Transaction__c": "string",
    "Next_Escalation_Date__c": "string",
    "Opportunity__c": "string",
    "OrderId": "string",
    "OrderItemNumber": "string",
    "OriginalOrderItemId": "string",
    "Originating_Opportunity_Product__c": "string",
    "Overage_Rate_for_Minutes__c": "string",
    "Overage_Rate_for_Tracking_Numbers__c": "string",
    "PricebookEntryId": "string",
    "Product2Id": "string",
    "Product_Category_Text__c": "string",
    "Product_Type__c": "string",
    "Quantity": "string",
    "QuoteLineItemId": "string",
    "ServiceDate": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "TotalPrice": "string",
    "UnitPrice": "string",
    "Website_Introductory_Discount_Months__c": "string"
}
  • created: 2026-04-17 07:06:03
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-17/1776427484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-03-28 12:46:19",
        "disabled": false,
        "format": "raw",
        "id": 1530,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_order_items"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AC_Introductory_Discount_Months__c": "string",
            "All_Minutes_Included__c": "string",
            "All_Tracking_Numbers_Included__c": "string",
            "Asset_ID__c": "string",
            "AvailableQuantity": "string",
            "Cap__c": "string",
            "Contract_End_of_Term_Action__c": "string",
            "Contract_Term_in_Months__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Data_Load_By__c": "string",
            "Debook_Date__c": "string",
            "Debook_Reason__c": "string",
            "Description": "string",
            "EndDate": "string",
            "Escalation_Percent__c": "string",
            "Escalation_Rate__c": "string",
            "FMS_Introductory_Discount_Months__c": "string",
            "Free_Initial_Period_Days__c": "string",
            "Id": "string",
            "Included_Minutes__c": "string",
            "Included_Tracking_Numbers__c": "string",
            "Intro_Discount_Term_Months__c": "string",
            "IsDeleted": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Legacy__c": "string",
            "ListPrice": "string",
            "List_Price_Normalized__c": "string",
            "Maximum_Usage__c": "string",
            "NetSuite_ID__c": "string",
            "NetSuite_List_Price__c": "string",
            "NetSuite_Sync_Time__c": "string",
            "NetSuite_Transaction__c": "string",
            "Next_Escalation_Date__c": "string",
            "Opportunity__c": "string",
            "OrderId": "string",
            "OrderItemNumber": "string",
            "OriginalOrderItemId": "string",
            "Originating_Opportunity_Product__c": "string",
            "Overage_Rate_for_Minutes__c": "string",
            "Overage_Rate_for_Tracking_Numbers__c": "string",
            "PricebookEntryId": "string",
            "Product2Id": "string",
            "Product_Category_Text__c": "string",
            "Product_Type__c": "string",
            "Quantity": "string",
            "QuoteLineItemId": "string",
            "ServiceDate": "string",
            "Status__c": "string",
            "SystemModstamp": "string",
            "TotalPrice": "string",
            "UnitPrice": "string",
            "Website_Introductory_Discount_Months__c": "string"
        },
        "created": "2026-04-17 07:06:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_order_items`\n(\n `Id`  string , `Product2Id`  string , `IsDeleted`  string , `OrderId`  string , `PricebookEntryId`  string , `OriginalOrderItemId`  string , `QuoteLineItemId`  string , `AvailableQuantity`  string , `Quantity`  string , `CurrencyIsoCode`  string , `UnitPrice`  string , `ListPrice`  string , `TotalPrice`  string , `ServiceDate`  string , `EndDate`  string , `Description`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `OrderItemNumber`  string , `FMS_Introductory_Discount_Months__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `NetSuite_Transaction__c`  string , `Originating_Opportunity_Product__c`  string , `Product_Category_Text__c`  string , `Product_Type__c`  string , `Status__c`  string , `Website_Introductory_Discount_Months__c`  string , `AC_Introductory_Discount_Months__c`  string , `NetSuite_List_Price__c`  string , `Opportunity__c`  string , `Debook_Date__c`  string , `Debook_Reason__c`  string , `Asset_ID__c`  string , `Included_Minutes__c`  string , `Included_Tracking_Numbers__c`  string , `Legacy__c`  string , `Maximum_Usage__c`  string , `Overage_Rate_for_Minutes__c`  string , `Overage_Rate_for_Tracking_Numbers__c`  string , `Intro_Discount_Term_Months__c`  string , `List_Price_Normalized__c`  string , `All_Minutes_Included__c`  string , `All_Tracking_Numbers_Included__c`  string , `Contract_End_of_Term_Action__c`  string , `Contract_Term_in_Months__c`  string , `Escalation_Percent__c`  string , `Escalation_Rate__c`  string , `Free_Initial_Period_Days__c`  string , `Next_Escalation_Date__c`  string , `Cap__c`  string , `Data_Load_By__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-prod/raw/order_items/2026-04-17/1776427484'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_order_items`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_order_items"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform