Schema Info

Schema Name: sfdl_prod_csv.salesforce_csat_response__cs
  • created: 2022-10-10 16:21:22
  • disabled: False
  • format: raw
  • id: 1161
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_csv",
    "table": "salesforce_csat_response__cs"
}
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 07:05:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-17/1776427483'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-17/1776427483
    • id: 1718072
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 162173038
    • updated: 2026-04-17 07:05:37
    • created: 2026-04-16 07:07:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-16/1776341126'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-16/1776341126
    • id: 1716885
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 162117373
    • updated: 2026-04-16 07:07:47
    • created: 2026-04-15 07:05:27
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-15/1776254718'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-15/1776254718
    • id: 1715627
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 162061757
    • updated: 2026-04-15 07:05:38
    • created: 2026-04-14 07:05:17
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-14/1776168305'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-14/1776168305
    • id: 1714440
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 162006352
    • updated: 2026-04-14 07:05:28
    • created: 2026-04-13 07:05:18
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-13/1776081876'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-13/1776081876
    • id: 1713219
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161948296
    • updated: 2026-04-13 07:05:31
    • created: 2026-04-12 07:09:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-12/1775995725'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-12/1775995725
    • id: 1712078
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161899562
    • updated: 2026-04-12 07:09:34
    • created: 2026-04-11 07:05:26
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-11/1775909052'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-11/1775909052
    • id: 1710841
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161846849
    • updated: 2026-04-11 07:05:37
    • created: 2026-04-10 07:04:29
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-10/1775822649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-10/1775822649
    • id: 1709636
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161792021
    • updated: 2026-04-10 07:04:43
    • created: 2026-04-09 07:07:33
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-09/1775736341'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-09/1775736341
    • id: 1708543
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161736279
    • updated: 2026-04-09 07:07:46
    • created: 2026-04-08 07:07:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-08/1775649934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-08/1775649934
    • id: 1707356
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161681421
    • updated: 2026-04-08 07:07:35
    • created: 2026-04-07 07:07:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-07/1775563516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-07/1775563516
    • id: 1706163
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161625206
    • updated: 2026-04-07 07:07:22
    • created: 2026-04-06 07:11:34
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-06/1775477114'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-06/1775477114
    • id: 1704955
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161567371
    • updated: 2026-04-06 07:11:45
    • created: 2026-04-05 07:05:46
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-05/1775390673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-05/1775390673
    • id: 1703700
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161519982
    • updated: 2026-04-05 07:06:00
    • created: 2026-04-04 07:08:42
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-04/1775304406'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-04/1775304406
    • id: 1702558
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161466429
    • updated: 2026-04-04 07:08:53
    • created: 2026-04-03 07:06:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-03/1775217858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__cs"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/csat_response__cs/2026-04-03/1775217858
    • id: 1701372
    • processed: 1
    • raw_data: 
      {
    "Account__c": 12,
    "Agent_Knowledge__c": 13,
    "Case__c": 14,
    "Combined_Score_DMS__c": 47,
    "Combined_Score__c": 28,
    "Comment__c": 15,
    "Communication_Timeliness__c": 16,
    "Completion_Time__c": 17,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "Contact__c": 18,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Expectations_Met__c": 41,
    "GetFeedback_ID__c": 19,
    "GetFeedback_Response_URL__c": 20,
    "Id": 0,
    "Implementation_Combined_Score__c": 31,
    "Implementation_Comment__c": 32,
    "Implementation_Facility_Readiness__c": 33,
    "Implementation_Overall_Experience__c": 34,
    "Implementation_Product_Score__c": 35,
    "Implementation_Schoolable_Satisfaction__c": 36,
    "Implementation_Software_Capabilities__c": 39,
    "Implementation_Specialist_Responsive__c": 38,
    "Implementation_Speed_of_Launch__c": 37,
    "Implementation_Support_Score__c": 40,
    "IsDeleted": 2,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Likely_to_Recommend__c": 42,
    "NPS__c": 21,
    "Name": 3,
    "OwnerId": 1,
    "Product_Functionality__c": 22,
    "Product_Satisfaction__c": 43,
    "Product_Score_DMS__c": 45,
    "Product_Score__c": 30,
    "Product_Stability__c": 23,
    "Product_Suggestions__c": 44,
    "Resolution_Speed__c": 24,
    "Start_Time__c": 25,
    "Support_Score_DMS__c": 46,
    "Support_Score__c": 29,
    "Survey_Name__c": 26,
    "SystemModstamp": 9,
    "User__c": 27
}
    • schema_attributes: 
      {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
    • schema_name_id: 1161
    • schema_scan_id: 161408581
    • updated: 2026-04-03 07:06:33
Schema Scans: 15
Last at 2026-04-17 07:05:23
    • duration: 0:00:13.089857
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173038
    • 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/csat_response__cs/2026-04-17/1776427483",
        "key": "raw/csat_response__cs/2026-04-17/1776427483/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12661207640106520189,
        "service_name": "drive-thru",
        "span_id": 2560094011828459308,
        "trace_id": 13332078370903881196
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-17 07:05:23
    • success: True
    • trace_id: 13332078370903881196
    • duration: 0:00:12.983886
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117373
    • 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/csat_response__cs/2026-04-16/1776341126",
        "key": "raw/csat_response__cs/2026-04-16/1776341126/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10590352341282384706,
        "service_name": "drive-thru",
        "span_id": 14163530294838994641,
        "trace_id": 8124457241239200487
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-16 07:07:34
    • success: True
    • trace_id: 8124457241239200487
    • duration: 0:00:13.074093
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061757
    • 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/csat_response__cs/2026-04-15/1776254718",
        "key": "raw/csat_response__cs/2026-04-15/1776254718/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10504902615979968788,
        "service_name": "drive-thru",
        "span_id": 1793489872598886541,
        "trace_id": 6022461520396612462
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-15 07:05:25
    • success: True
    • trace_id: 6022461520396612462
    • duration: 0:00:12.934132
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006352
    • 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/csat_response__cs/2026-04-14/1776168305",
        "key": "raw/csat_response__cs/2026-04-14/1776168305/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10828273134194322364,
        "service_name": "drive-thru",
        "span_id": 8357743174795959158,
        "trace_id": 16292549697413750114
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-14 07:05:15
    • success: True
    • trace_id: 16292549697413750114
    • duration: 0:00:15.515657
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948296
    • 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/csat_response__cs/2026-04-13/1776081876",
        "key": "raw/csat_response__cs/2026-04-13/1776081876/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14148667001521791690,
        "service_name": "drive-thru",
        "span_id": 12121794746895864633,
        "trace_id": 6734779630962264423
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-13 07:05:16
    • success: True
    • trace_id: 6734779630962264423
    • duration: 0:00:15.577636
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899562
    • 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/csat_response__cs/2026-04-12/1775995725",
        "key": "raw/csat_response__cs/2026-04-12/1775995725/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17997734749015631251,
        "service_name": "drive-thru",
        "span_id": 11719691128797806310,
        "trace_id": 15154495569222508344
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-12 07:09:18
    • success: True
    • trace_id: 15154495569222508344
    • duration: 0:00:12.998262
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846849
    • 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/csat_response__cs/2026-04-11/1775909052",
        "key": "raw/csat_response__cs/2026-04-11/1775909052/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1862988109512591720,
        "service_name": "drive-thru",
        "span_id": 6270813777971951129,
        "trace_id": 15913934048374286783
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-11 07:05:24
    • success: True
    • trace_id: 15913934048374286783
    • duration: 0:00:15.602086
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792021
    • 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/csat_response__cs/2026-04-10/1775822649",
        "key": "raw/csat_response__cs/2026-04-10/1775822649/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13265064340649908270,
        "service_name": "drive-thru",
        "span_id": 11488108729097649494,
        "trace_id": 1238683596040801822
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-10 07:04:27
    • success: True
    • trace_id: 1238683596040801822
    • duration: 0:00:15.592120
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736279
    • 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/csat_response__cs/2026-04-09/1775736341",
        "key": "raw/csat_response__cs/2026-04-09/1775736341/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4631023383606065846,
        "service_name": "drive-thru",
        "span_id": 15264017039975095474,
        "trace_id": 12763123340587919860
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-09 07:07:31
    • success: True
    • trace_id: 12763123340587919860
    • duration: 0:00:13.165142
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681421
    • 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/csat_response__cs/2026-04-08/1775649934",
        "key": "raw/csat_response__cs/2026-04-08/1775649934/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16865261556231127494,
        "service_name": "drive-thru",
        "span_id": 906962322297152753,
        "trace_id": 10956587249631918825
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-08 07:07:22
    • success: True
    • trace_id: 10956587249631918825
    • duration: 0:00:12.979562
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625206
    • 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/csat_response__cs/2026-04-07/1775563516",
        "key": "raw/csat_response__cs/2026-04-07/1775563516/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16377939854431894465,
        "service_name": "drive-thru",
        "span_id": 66034499130263909,
        "trace_id": 12632578268639042307
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-07 07:07:09
    • success: True
    • trace_id: 12632578268639042307
    • duration: 0:00:13.122558
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567371
    • 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/csat_response__cs/2026-04-06/1775477114",
        "key": "raw/csat_response__cs/2026-04-06/1775477114/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12079283079393381952,
        "service_name": "drive-thru",
        "span_id": 8895295571791779241,
        "trace_id": 15737018547086102332
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-06 07:11:32
    • success: True
    • trace_id: 15737018547086102332
    • duration: 0:00:15.432328
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161519982
    • 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/csat_response__cs/2026-04-05/1775390673",
        "key": "raw/csat_response__cs/2026-04-05/1775390673/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1369467964713945785,
        "service_name": "drive-thru",
        "span_id": 10050699785642769695,
        "trace_id": 5296869917758059369
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-05 07:05:45
    • success: True
    • trace_id: 5296869917758059369
    • duration: 0:00:12.997627
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466429
    • 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/csat_response__cs/2026-04-04/1775304406",
        "key": "raw/csat_response__cs/2026-04-04/1775304406/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8284539751952628020,
        "service_name": "drive-thru",
        "span_id": 14621224184285469731,
        "trace_id": 378785285773013133
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-04 07:08:40
    • success: True
    • trace_id: 378785285773013133
    • duration: 0:00:15.756082
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408581
    • 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/csat_response__cs/2026-04-03/1775217858",
        "key": "raw/csat_response__cs/2026-04-03/1775217858/csat_response__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_csat_response__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15445077053102526401,
        "service_name": "drive-thru",
        "span_id": 1569507846743725704,
        "trace_id": 10259171223078938749
    }
}
    • running: False
    • schema_name_id: 1161
    • start_time: 2026-04-03 07:06:18
    • success: True
    • trace_id: 10259171223078938749
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "Account__c": "string",
    "Agent_Knowledge__c": "string",
    "Amount": "string",
    "Case__c": "string",
    "CloseDate": "string",
    "Combined_Score_DMS__c": "string",
    "Combined_Score__c": "string",
    "Comment__c": "string",
    "Communication_Timeliness__c": "string",
    "Completion_Time__c": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Expectations_Met__c": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "GetFeedback_ID__c": "string",
    "GetFeedback_Response_URL__c": "string",
    "Id": "string",
    "Implementation_Combined_Score__c": "string",
    "Implementation_Comment__c": "string",
    "Implementation_Facility_Readiness__c": "string",
    "Implementation_Overall_Experience__c": "string",
    "Implementation_Product_Score__c": "string",
    "Implementation_Schoolable_Satisfaction__c": "string",
    "Implementation_Software_Capabilities__c": "string",
    "Implementation_Specialist_Responsive__c": "string",
    "Implementation_Speed_of_Launch__c": "string",
    "Implementation_Support_Score__c": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Likely_to_Recommend__c": "string",
    "NPS__c": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "Product_Functionality__c": "string",
    "Product_Satisfaction__c": "string",
    "Product_Score_DMS__c": "string",
    "Product_Score__c": "string",
    "Product_Stability__c": "string",
    "Product_Suggestions__c": "string",
    "Resolution_Speed__c": "string",
    "StageName": "string",
    "Start_Time__c": "string",
    "Support_Score_DMS__c": "string",
    "Support_Score__c": "string",
    "Survey_Name__c": "string",
    "SystemModstamp": "string",
    "User__c": "string"
}
  • created: 2026-04-17 07:05:25
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-17/1776427483'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__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": "2022-10-10 16:21:22",
        "disabled": false,
        "format": "raw",
        "id": 1161,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_csat_response__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Account__c": "string",
            "Agent_Knowledge__c": "string",
            "Amount": "string",
            "Case__c": "string",
            "CloseDate": "string",
            "Combined_Score_DMS__c": "string",
            "Combined_Score__c": "string",
            "Comment__c": "string",
            "Communication_Timeliness__c": "string",
            "Completion_Time__c": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "Contact__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Expectations_Met__c": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "GetFeedback_ID__c": "string",
            "GetFeedback_Response_URL__c": "string",
            "Id": "string",
            "Implementation_Combined_Score__c": "string",
            "Implementation_Comment__c": "string",
            "Implementation_Facility_Readiness__c": "string",
            "Implementation_Overall_Experience__c": "string",
            "Implementation_Product_Score__c": "string",
            "Implementation_Schoolable_Satisfaction__c": "string",
            "Implementation_Software_Capabilities__c": "string",
            "Implementation_Specialist_Responsive__c": "string",
            "Implementation_Speed_of_Launch__c": "string",
            "Implementation_Support_Score__c": "string",
            "IsDeleted": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Likely_to_Recommend__c": "string",
            "NPS__c": "string",
            "Name": "string",
            "OpportunityId": "string",
            "OwnerId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "Product_Functionality__c": "string",
            "Product_Satisfaction__c": "string",
            "Product_Score_DMS__c": "string",
            "Product_Score__c": "string",
            "Product_Stability__c": "string",
            "Product_Suggestions__c": "string",
            "Resolution_Speed__c": "string",
            "StageName": "string",
            "Start_Time__c": "string",
            "Support_Score_DMS__c": "string",
            "Support_Score__c": "string",
            "Survey_Name__c": "string",
            "SystemModstamp": "string",
            "User__c": "string"
        },
        "created": "2026-04-17 07:05:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_csat_response__cs`\n(\n `Id`  string , `OwnerId`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  string , `Account__c`  string , `Agent_Knowledge__c`  string , `Case__c`  string , `Comment__c`  string , `Communication_Timeliness__c`  string , `Completion_Time__c`  string , `Contact__c`  string , `GetFeedback_ID__c`  string , `GetFeedback_Response_URL__c`  string , `NPS__c`  string , `Product_Functionality__c`  string , `Product_Stability__c`  string , `Resolution_Speed__c`  string , `Start_Time__c`  string , `Survey_Name__c`  string , `User__c`  string , `Combined_Score__c`  string , `Support_Score__c`  string , `Product_Score__c`  string , `Implementation_Combined_Score__c`  string , `Implementation_Comment__c`  string , `Implementation_Facility_Readiness__c`  string , `Implementation_Overall_Experience__c`  string , `Implementation_Product_Score__c`  string , `Implementation_Schoolable_Satisfaction__c`  string , `Implementation_Speed_of_Launch__c`  string , `Implementation_Specialist_Responsive__c`  string , `Implementation_Software_Capabilities__c`  string , `Implementation_Support_Score__c`  string , `Expectations_Met__c`  string , `Likely_to_Recommend__c`  string , `Product_Satisfaction__c`  string , `Product_Suggestions__c`  string , `Product_Score_DMS__c`  string , `Support_Score_DMS__c`  string , `Combined_Score_DMS__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/csat_response__cs/2026-04-17/1776427483'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_csat_response__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_csat_response__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