Schema Info

Schema Name: sfdl_prod_csv.salesforce_netsuite_contract_line__cs
  • created: 2023-03-28 12:46:24
  • disabled: False
  • format: raw
  • id: 1531
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_csv",
    "table": "salesforce_netsuite_contract_line__cs"
}
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 07:04:30
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-17/1776427465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-17/1776427465
    • id: 1718056
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 162173019
    • updated: 2026-04-17 07:04:44
    • created: 2026-04-16 07:05:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-16/1776341091'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-16/1776341091
    • id: 1716833
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 162117305
    • updated: 2026-04-16 07:05:17
    • created: 2026-04-15 07:10:02
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-15/1776254771'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-15/1776254771
    • id: 1715667
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 162061809
    • updated: 2026-04-15 07:10:16
    • created: 2026-04-14 07:07:02
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-14/1776168316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-14/1776168316
    • id: 1714477
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 162006392
    • updated: 2026-04-14 07:07:16
    • created: 2026-04-13 07:06:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-13/1776081920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-13/1776081920
    • id: 1713243
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161948321
    • updated: 2026-04-13 07:07:04
    • created: 2026-04-12 07:07:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-12/1775995638'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-12/1775995638
    • id: 1712046
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161899528
    • updated: 2026-04-12 07:07:40
    • created: 2026-04-11 07:04:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-11/1775909066'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-11/1775909066
    • id: 1710829
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161846838
    • updated: 2026-04-11 07:04:57
    • created: 2026-04-10 07:06:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-10/1775822729'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-10/1775822729
    • id: 1709688
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161792087
    • updated: 2026-04-10 07:07:13
    • created: 2026-04-09 07:05:48
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-09/1775736307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-09/1775736307
    • id: 1708510
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161736237
    • updated: 2026-04-09 07:06:02
    • created: 2026-04-08 07:06:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-08/1775649910'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-08/1775649910
    • id: 1707343
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161681402
    • updated: 2026-04-08 07:07:03
    • created: 2026-04-07 07:05:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-07/1775563489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-07/1775563489
    • id: 1706126
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161625164
    • updated: 2026-04-07 07:05:49
    • created: 2026-04-06 07:06:21
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-06/1775477096'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-06/1775477096
    • id: 1704906
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161567314
    • updated: 2026-04-06 07:06:34
    • created: 2026-04-05 07:05:31
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-05/1775390682'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-05/1775390682
    • id: 1703696
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161519977
    • updated: 2026-04-05 07:05:44
    • created: 2026-04-04 07:08:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-04/1775304384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-04/1775304384
    • id: 1702550
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161466420
    • updated: 2026-04-04 07:08:22
    • created: 2026-04-03 07:06:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-03/1775217861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/netsuite_contract_line__cs/2026-04-03/1775217861
    • id: 1701373
    • processed: 1
    • raw_data: 
      {
    "Amount__c": 12,
    "Bill_with_First_Recurring__c": 13,
    "Billing_Freq__c": 14,
    "Cancellation_Date__c": 15,
    "ConnectionReceivedId": 9,
    "ConnectionSentId": 10,
    "Contract_Line_for_Co_terming__c": 16,
    "Contract_Term_in_Months__c": 17,
    "CreatedById": 5,
    "CreatedDate": 4,
    "CurrencyIsoCode": 3,
    "Description__c": 18,
    "End_Date__c": 19,
    "End_of_Term_Action__c": 20,
    "Final_Billing_Period_Amount__c": 21,
    "First_Recurring_Bill_Date__c": 22,
    "Full_Annual_Value__c": 23,
    "Full_Monthly_Value__c": 24,
    "Full_Quarterly_Value__c": 25,
    "Full_Semiannual_Value__c": 26,
    "Full_Weekly_Value__c": 27,
    "Gross_Amount_Billed_to_Date__c": 28,
    "Id": 0,
    "In_Contract_Action__c": 29,
    "Initial_Billing_Period_Amount__c": 30,
    "Initial_Billing_Period_Discounted_Amount__c": 31,
    "Initial_Billing_Period_Invoice__c": 32,
    "IsDeleted": 1,
    "Item_Fulfillment__c": 33,
    "Item__c": 34,
    "LastModifiedById": 7,
    "LastModifiedDate": 6,
    "Last_Billed_Date__c": 35,
    "Name": 2,
    "NetSuite_ID__c": 36,
    "NetSuite_Sync_Time__c": 37,
    "Net_Annual_Value__c": 38,
    "Net_Monthly_Value__c": 39,
    "Net_Quarterly_Value__c": 40,
    "Net_Weekly_Value__c": 41,
    "Netsuite_Contract_Line_ID__c": 42,
    "Netsuite_Contract__c": 11,
    "Next_Bill_Date__c": 43,
    "Order_Product__c": 44,
    "Qty__c": 45,
    "Rate__c": 46,
    "Replaced_By__c": 47,
    "Replaces__c": 48,
    "Sales_Order__c": 49,
    "Start_Date__c": 50,
    "Status__c": 51,
    "SystemModstamp": 8,
    "Total_Contract_Value__c": 52,
    "Transaction_Line_Unique_ID__c": 53
}
    • schema_attributes: 
      {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
    • schema_name_id: 1531
    • schema_scan_id: 161408582
    • updated: 2026-04-03 07:06:37
Schema Scans: 15
Last at 2026-04-17 07:04:28
    • duration: 0:00:15.701635
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173019
    • 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/netsuite_contract_line__cs/2026-04-17/1776427465",
        "key": "raw/netsuite_contract_line__cs/2026-04-17/1776427465/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4594423358480073216,
        "service_name": "drive-thru",
        "span_id": 5557465552012971588,
        "trace_id": 11244070123797537854
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-17 07:04:28
    • success: True
    • trace_id: 11244070123797537854
    • duration: 0:00:15.830679
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117305
    • 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/netsuite_contract_line__cs/2026-04-16/1776341091",
        "key": "raw/netsuite_contract_line__cs/2026-04-16/1776341091/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13888498359798386302,
        "service_name": "drive-thru",
        "span_id": 3410652154018682780,
        "trace_id": 11135204412293549769
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-16 07:05:02
    • success: True
    • trace_id: 11135204412293549769
    • duration: 0:00:16.095623
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061809
    • 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/netsuite_contract_line__cs/2026-04-15/1776254771",
        "key": "raw/netsuite_contract_line__cs/2026-04-15/1776254771/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7556082735818416807,
        "service_name": "drive-thru",
        "span_id": 13032507167305010311,
        "trace_id": 9311173399457197953
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-15 07:10:00
    • success: True
    • trace_id: 9311173399457197953
    • duration: 0:00:15.883207
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006392
    • 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/netsuite_contract_line__cs/2026-04-14/1776168316",
        "key": "raw/netsuite_contract_line__cs/2026-04-14/1776168316/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15449827252191203619,
        "service_name": "drive-thru",
        "span_id": 14855514008004153662,
        "trace_id": 13268990673141088702
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-14 07:07:00
    • success: True
    • trace_id: 13268990673141088702
    • duration: 0:00:15.637999
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948321
    • 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/netsuite_contract_line__cs/2026-04-13/1776081920",
        "key": "raw/netsuite_contract_line__cs/2026-04-13/1776081920/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7477454234635554184,
        "service_name": "drive-thru",
        "span_id": 12433589934772957740,
        "trace_id": 17879522019162328058
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-13 07:06:48
    • success: True
    • trace_id: 17879522019162328058
    • duration: 0:00:15.481493
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899528
    • 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/netsuite_contract_line__cs/2026-04-12/1775995638",
        "key": "raw/netsuite_contract_line__cs/2026-04-12/1775995638/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13064710475296804228,
        "service_name": "drive-thru",
        "span_id": 15127116999760836246,
        "trace_id": 17449846656794701682
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-12 07:07:25
    • success: True
    • trace_id: 17449846656794701682
    • duration: 0:00:12.910259
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846838
    • 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/netsuite_contract_line__cs/2026-04-11/1775909066",
        "key": "raw/netsuite_contract_line__cs/2026-04-11/1775909066/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5696928145484387068,
        "service_name": "drive-thru",
        "span_id": 11290848434128620522,
        "trace_id": 15413500265593215734
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-11 07:04:44
    • success: True
    • trace_id: 15413500265593215734
    • duration: 0:00:15.449819
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792087
    • 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/netsuite_contract_line__cs/2026-04-10/1775822729",
        "key": "raw/netsuite_contract_line__cs/2026-04-10/1775822729/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10164567911805043192,
        "service_name": "drive-thru",
        "span_id": 8150760572915216389,
        "trace_id": 12584280315514350680
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-10 07:06:57
    • success: True
    • trace_id: 12584280315514350680
    • duration: 0:00:15.798454
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736237
    • 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/netsuite_contract_line__cs/2026-04-09/1775736307",
        "key": "raw/netsuite_contract_line__cs/2026-04-09/1775736307/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16375825208685816422,
        "service_name": "drive-thru",
        "span_id": 15656737789287134225,
        "trace_id": 12596366332511156317
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-09 07:05:46
    • success: True
    • trace_id: 12596366332511156317
    • duration: 0:00:15.524436
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681402
    • 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/netsuite_contract_line__cs/2026-04-08/1775649910",
        "key": "raw/netsuite_contract_line__cs/2026-04-08/1775649910/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8816394557607954751,
        "service_name": "drive-thru",
        "span_id": 1654846494431811451,
        "trace_id": 1456512682333871513
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-08 07:06:48
    • success: True
    • trace_id: 1456512682333871513
    • duration: 0:00:16.098558
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625164
    • 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/netsuite_contract_line__cs/2026-04-07/1775563489",
        "key": "raw/netsuite_contract_line__cs/2026-04-07/1775563489/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5379716889402447306,
        "service_name": "drive-thru",
        "span_id": 4234777370843123301,
        "trace_id": 13801061465796233876
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-07 07:05:33
    • success: True
    • trace_id: 13801061465796233876
    • duration: 0:00:15.638651
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567314
    • 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/netsuite_contract_line__cs/2026-04-06/1775477096",
        "key": "raw/netsuite_contract_line__cs/2026-04-06/1775477096/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9320535661083679776,
        "service_name": "drive-thru",
        "span_id": 10711587975140329701,
        "trace_id": 17707332018181113330
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-06 07:06:19
    • success: True
    • trace_id: 17707332018181113330
    • duration: 0:00:15.453068
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161519977
    • 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/netsuite_contract_line__cs/2026-04-05/1775390682",
        "key": "raw/netsuite_contract_line__cs/2026-04-05/1775390682/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11690766057585344762,
        "service_name": "drive-thru",
        "span_id": 18120722119178198323,
        "trace_id": 17347065754552399609
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-05 07:05:29
    • success: True
    • trace_id: 17347065754552399609
    • duration: 0:00:15.560777
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466420
    • 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/netsuite_contract_line__cs/2026-04-04/1775304384",
        "key": "raw/netsuite_contract_line__cs/2026-04-04/1775304384/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11189866057469241707,
        "service_name": "drive-thru",
        "span_id": 17078015170564753326,
        "trace_id": 3467737331678816465
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-04 07:08:06
    • success: True
    • trace_id: 3467737331678816465
    • duration: 0:00:15.675779
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408582
    • 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/netsuite_contract_line__cs/2026-04-03/1775217861",
        "key": "raw/netsuite_contract_line__cs/2026-04-03/1775217861/netsuite_contract_line__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_netsuite_contract_line__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10934623458881607881,
        "service_name": "drive-thru",
        "span_id": 12674585857319508398,
        "trace_id": 7864312237783063146
    }
}
    • running: False
    • schema_name_id: 1531
    • start_time: 2026-04-03 07:06:22
    • success: True
    • trace_id: 7864312237783063146
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "Amount__c": "string",
    "Bill_with_First_Recurring__c": "string",
    "Billing_Freq__c": "string",
    "Cancellation_Date__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contract_Line_for_Co_terming__c": "string",
    "Contract_Term_in_Months__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description__c": "string",
    "End_Date__c": "string",
    "End_of_Term_Action__c": "string",
    "Final_Billing_Period_Amount__c": "string",
    "First_Recurring_Bill_Date__c": "string",
    "Full_Annual_Value__c": "string",
    "Full_Monthly_Value__c": "string",
    "Full_Quarterly_Value__c": "string",
    "Full_Semiannual_Value__c": "string",
    "Full_Weekly_Value__c": "string",
    "Gross_Amount_Billed_to_Date__c": "string",
    "Id": "string",
    "In_Contract_Action__c": "string",
    "Initial_Billing_Period_Amount__c": "string",
    "Initial_Billing_Period_Discounted_Amount__c": "string",
    "Initial_Billing_Period_Invoice__c": "string",
    "IsDeleted": "string",
    "Item_Fulfillment__c": "string",
    "Item__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Last_Billed_Date__c": "string",
    "Name": "string",
    "NetSuite_ID__c": "string",
    "NetSuite_Sync_Time__c": "string",
    "Net_Annual_Value__c": "string",
    "Net_Monthly_Value__c": "string",
    "Net_Quarterly_Value__c": "string",
    "Net_Weekly_Value__c": "string",
    "Netsuite_Contract_Line_ID__c": "string",
    "Netsuite_Contract__c": "string",
    "Next_Bill_Date__c": "string",
    "Order_Product__c": "string",
    "Qty__c": "string",
    "Rate__c": "string",
    "Replaced_By__c": "string",
    "Replaces__c": "string",
    "Sales_Order__c": "string",
    "Start_Date__c": "string",
    "Status__c": "string",
    "SystemModstamp": "string",
    "Total_Contract_Value__c": "string",
    "Transaction_Line_Unique_ID__c": "string"
}
  • created: 2026-04-17 07:04:30
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-17/1776427465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
}
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:24",
        "disabled": false,
        "format": "raw",
        "id": 1531,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_netsuite_contract_line__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount__c": "string",
            "Bill_with_First_Recurring__c": "string",
            "Billing_Freq__c": "string",
            "Cancellation_Date__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Contract_Line_for_Co_terming__c": "string",
            "Contract_Term_in_Months__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Description__c": "string",
            "End_Date__c": "string",
            "End_of_Term_Action__c": "string",
            "Final_Billing_Period_Amount__c": "string",
            "First_Recurring_Bill_Date__c": "string",
            "Full_Annual_Value__c": "string",
            "Full_Monthly_Value__c": "string",
            "Full_Quarterly_Value__c": "string",
            "Full_Semiannual_Value__c": "string",
            "Full_Weekly_Value__c": "string",
            "Gross_Amount_Billed_to_Date__c": "string",
            "Id": "string",
            "In_Contract_Action__c": "string",
            "Initial_Billing_Period_Amount__c": "string",
            "Initial_Billing_Period_Discounted_Amount__c": "string",
            "Initial_Billing_Period_Invoice__c": "string",
            "IsDeleted": "string",
            "Item_Fulfillment__c": "string",
            "Item__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Last_Billed_Date__c": "string",
            "Name": "string",
            "NetSuite_ID__c": "string",
            "NetSuite_Sync_Time__c": "string",
            "Net_Annual_Value__c": "string",
            "Net_Monthly_Value__c": "string",
            "Net_Quarterly_Value__c": "string",
            "Net_Weekly_Value__c": "string",
            "Netsuite_Contract_Line_ID__c": "string",
            "Netsuite_Contract__c": "string",
            "Next_Bill_Date__c": "string",
            "Order_Product__c": "string",
            "Qty__c": "string",
            "Rate__c": "string",
            "Replaced_By__c": "string",
            "Replaces__c": "string",
            "Sales_Order__c": "string",
            "Start_Date__c": "string",
            "Status__c": "string",
            "SystemModstamp": "string",
            "Total_Contract_Value__c": "string",
            "Transaction_Line_Unique_ID__c": "string"
        },
        "created": "2026-04-17 07:04:30",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_netsuite_contract_line__cs`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Netsuite_Contract__c`  string , `Amount__c`  string , `Bill_with_First_Recurring__c`  string , `Billing_Freq__c`  string , `Cancellation_Date__c`  string , `Contract_Line_for_Co_terming__c`  string , `Contract_Term_in_Months__c`  string , `Description__c`  string , `End_Date__c`  string , `End_of_Term_Action__c`  string , `Final_Billing_Period_Amount__c`  string , `First_Recurring_Bill_Date__c`  string , `Full_Annual_Value__c`  string , `Full_Monthly_Value__c`  string , `Full_Quarterly_Value__c`  string , `Full_Semiannual_Value__c`  string , `Full_Weekly_Value__c`  string , `Gross_Amount_Billed_to_Date__c`  string , `In_Contract_Action__c`  string , `Initial_Billing_Period_Amount__c`  string , `Initial_Billing_Period_Discounted_Amount__c`  string , `Initial_Billing_Period_Invoice__c`  string , `Item_Fulfillment__c`  string , `Item__c`  string , `Last_Billed_Date__c`  string , `NetSuite_ID__c`  string , `NetSuite_Sync_Time__c`  string , `Net_Annual_Value__c`  string , `Net_Monthly_Value__c`  string , `Net_Quarterly_Value__c`  string , `Net_Weekly_Value__c`  string , `Netsuite_Contract_Line_ID__c`  string , `Next_Bill_Date__c`  string , `Order_Product__c`  string , `Qty__c`  string , `Rate__c`  string , `Replaced_By__c`  string , `Replaces__c`  string , `Sales_Order__c`  string , `Start_Date__c`  string , `Status__c`  string , `Total_Contract_Value__c`  string , `Transaction_Line_Unique_ID__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/netsuite_contract_line__cs/2026-04-17/1776427465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_netsuite_contract_line__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_netsuite_contract_line__cs"
        }
    },
    "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