Schema Info

Schema Name: sfdl_prod_salesforce.sitelink_case

created: 2018-10-26 15:23:05
disabled: False
format: raw
id: 564
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_salesforce",
    "table": "sitelink_case"
}

type: salesforce

Schema Versions: 1

Version 50080

created: 2018-10-26 15:23:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_case`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_case`\n(\n `Vanilla__ForumUrl__c`  string , `Billing_Contact_Phone__c`  string , `Parent_Case_Status__c`  string , `Reference_Opportunity__c`  string , `Conversion_Scheduled_Date__c`  date , `Site_Contact__c`  string , `IsClosedOnCreate`  boolean , `NDA_Signed__c`  boolean , `ClosedDate`  timestamp , `IsEscalated`  boolean , `TC1_Name__c`  string , `Include_In_Immediate_Release__c`  boolean , `Reason`  string , `Database__c`  string , `CaseOwnerDivision__c`  string , `Last_Touched_Days__c`  double , `IsDeleted`  boolean , `AccountId`  string , `Last_Touched_Date__c`  timestamp , `SuppliedEmail`  string , `Days_Opened_to_Complete__c`  double , `TC2_Name__c`  string , `LastReferencedDate`  timestamp , `RecordTypeId`  string , `Origin`  string , `Original_Tech_Owner__c`  string , `Conversion_Complete_Date__c`  date , `Account_Units_Rented__c`  double , `Billing_Contact__c`  string , `Assigned_Tech__c`  string , `Subject`  string , `Department__c`  string , `Total_Unit_Count__c`  double , `Product__c`  string , `Estimated_Hours__c`  double , `SuppliedCompany`  string , `HasCommentsUnreadByOwner`  boolean , `Priority`  string , `Invoice__c`  string , `Priority_Flag__c`  string , `OwnerId`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  string , `Site_Address__c`  string , `SiteLink_Store_Domain__c`  string , `Quoted_Price__c`  string , `SuppliedPhone`  string , `Paid_On__c`  date , `TM_Decryption__c`  string , `ContactId`  string , `Site_Contact_Phone__c`  string , `Quoted_Rate_Comp__c`  string , `Current_Gate_System__c`  string , `Max_Units__c`  string , `SF_Demand_in_scope_new_customer__c`  boolean , `Total_Minutes__c`  double , `Site_Contact_Email__c`  string , `ParentId`  string , `Actual_Hours_User__c`  string , `Escalation_Reason__c`  string , `Billing_Address__c`  string , `SFDemandinScopeExistingSFCustome__c`  boolean , `SubCategory__c`  string , `TC2_Phone__c`  string , `Owner_Department__c`  string , `SubType_3_c__c`  string , `attributes`  string , `Customer_Comments__c`  string , `Actual_Hours__c`  double , `Account_Billing_Type__c`  string , `SiteLink_Store__c`  string , `Due_Date__c`  date , `Corp_Code_Search__c`  string , `Internal_Instructions__c`  string , `Australia__c`  string , `Corp_Code__c`  string , `Status`  string , `CaseNumber`  string , `Technician_Note__c`  string , `LastModifiedDate`  timestamp , `dCreated__c`  timestamp , `EnableCustomInsurance__c`  boolean , `Tentative_Conversion_Date__c`  date , `TC1_Phone__c`  string , `ConnectionSentId`  string , `Version_History_Comment__c`  string , `BusinessHoursId`  string , `Last_Time_Entry_Date__c`  timestamp , `Survey_Follow_up__c`  string , `Merchandise_Tax__c`  string , `Billing_Contact_Email__c`  string , `LastModifiedById`  string , `CurrencyIsoCode`  string , `Escalation__c`  boolean , `Current_Software__c`  string , `SubType_2__c`  string , `Deployed_In_Version__c`  string , `Type__c`  string , `IsClosed`  boolean , `Contact_Account_Name_Populated__c`  string , `Days_Scheduled_to_Completed__c`  double , `Opportunity__c`  string , `Days_Assigned_to_Complete__c`  double , `Planned_In_Version__c`  string , `SubType_1__c`  string , `Last_Comment_Date__c`  timestamp , `Strategic_Goal__c`  boolean , `TC2_Email__c`  string , `Includes_Script_To_Be_Run__c`  boolean , `Invoiced_Date__c`  date , `Location_Code__c`  string , `Account_Note__c`  string , `Development_Priority__c`  string , `Description`  string , `Version_History_Status__c`  string , `Files_Stored_Procedures_Update__c`  string , `IsSelfServiceClosed`  boolean , `Quoted_Date__c`  date , `CreatedById`  string , `Category__c`  string , `IsVisibleInSelfService`  boolean , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `TC1_Email__c`  string , `SuppliedName`  string , `Date_Assigned_to_Tech__c`  date , `AssetId`  string , `CreatedDate`  timestamp , `IGD__Collection_Id__c`  string , `ConnectionReceivedId`  string , `Customer_Priority__c`  string , `UniqueCasecount__c`  double , `Parent_Account_Note__c`  string , `National_Account__c`  boolean , `Age_Days__c`  double , `Approved_for_Development__c`  boolean , `HasSelfServiceComments`  boolean , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  string , `Mobile_Storage__c`  string , `Version_History_Include_Video__c`  boolean , `Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Case/2018-10-26/1540585381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_case"
]

hive_path: s3://sfdl-salesforce-sitelink-prod/raw/Case/2018-10-26/1540585381
id: 50080
processed: 1

raw_data:

{
    "AccountId": 17,
    "Account_Billing_Type__c": 69,
    "Account_Note__c": 111,
    "Account_Units_Rented__c": 27,
    "Actual_Hours_User__c": 58,
    "Actual_Hours__c": 68,
    "Age_Days__c": 134,
    "Approved_for_Development__c": 135,
    "AssetId": 126,
    "Assigned_Tech__c": 29,
    "Australia__c": 74,
    "Billing_Address__c": 60,
    "Billing_Contact_Email__c": 90,
    "Billing_Contact_Phone__c": 1,
    "Billing_Contact__c": 28,
    "BusinessHoursId": 86,
    "CaseNumber": 77,
    "CaseOwnerDivision__c": 14,
    "Category__c": 119,
    "ClosedDate": 8,
    "ConnectionReceivedId": 129,
    "ConnectionSentId": 84,
    "ContactId": 49,
    "Contact_Account_Name_Populated__c": 99,
    "Conversion_Complete_Date__c": 26,
    "Conversion_Scheduled_Date__c": 4,
    "Corp_Code_Search__c": 72,
    "Corp_Code__c": 75,
    "CreatedById": 118,
    "CreatedDate": 127,
    "CurrencyIsoCode": 92,
    "Current_Gate_System__c": 52,
    "Current_Software__c": 94,
    "Customer_Comments__c": 67,
    "Customer_Priority__c": 130,
    "Database__c": 13,
    "Date_Assigned_to_Tech__c": 125,
    "Days_Assigned_to_Complete__c": 102,
    "Days_Opened_to_Complete__c": 20,
    "Days_Scheduled_to_Completed__c": 100,
    "Department__c": 31,
    "Deployed_In_Version__c": 96,
    "Description": 113,
    "Development_Priority__c": 112,
    "Due_Date__c": 71,
    "EnableCustomInsurance__c": 81,
    "Escalation_Reason__c": 59,
    "Escalation__c": 93,
    "Estimated_Hours__c": 34,
    "Files_Stored_Procedures_Update__c": 115,
    "HasCommentsUnreadByOwner": 36,
    "HasSelfServiceComments": 136,
    "IGD__Collection_Id__c": 128,
    "Id": 141,
    "Include_In_Immediate_Release__c": 11,
    "Includes_Script_To_Be_Run__c": 108,
    "Insurance_Tax__c": 138,
    "Internal_Instructions__c": 73,
    "Invoice__c": 38,
    "Invoiced_Date__c": 109,
    "IsClosed": 98,
    "IsClosedOnCreate": 6,
    "IsDeleted": 16,
    "IsEscalated": 9,
    "IsSelfServiceClosed": 116,
    "IsVisibleInSelfService": 120,
    "LastModifiedById": 91,
    "LastModifiedDate": 79,
    "LastReferencedDate": 22,
    "LastViewedDate": 122,
    "Last_Comment_Date__c": 105,
    "Last_Time_Entry_Date__c": 87,
    "Last_Touched_Date__c": 18,
    "Last_Touched_Days__c": 15,
    "Location_Code__c": 110,
    "Max_Units__c": 53,
    "Merchandise_Tax__c": 89,
    "Mobile_Storage__c": 139,
    "NDA_Signed__c": 7,
    "National_Account__c": 133,
    "Opportunity__c": 101,
    "Origin": 24,
    "Original_Tech_Owner__c": 25,
    "OwnerId": 40,
    "Owner_Department__c": 64,
    "Paid_On__c": 47,
    "ParentId": 57,
    "Parent_Account_Note__c": 132,
    "Parent_Case_Status__c": 2,
    "Planned_In_Version__c": 103,
    "Priority": 37,
    "Priority_Flag__c": 39,
    "Product__c": 33,
    "Quoted_Date__c": 117,
    "Quoted_Price__c": 45,
    "Quoted_Rate_Comp__c": 51,
    "Reason": 12,
    "RecordTypeId": 23,
    "Reference_Opportunity__c": 3,
    "SFDemandinScopeExistingSFCustome__c": 61,
    "SF_Demand_in_scope_new_customer__c": 54,
    "SiteLink_Store_Domain__c": 44,
    "SiteLink_Store__c": 70,
    "Site_Address__c": 43,
    "Site_Contact_Email__c": 56,
    "Site_Contact_Phone__c": 50,
    "Site_Contact__c": 5,
    "Status": 76,
    "Strategic_Goal__c": 106,
    "SubCategory__c": 62,
    "SubType_1__c": 104,
    "SubType_2__c": 95,
    "SubType_3_c__c": 65,
    "Subject": 30,
    "SuppliedCompany": 35,
    "SuppliedEmail": 19,
    "SuppliedName": 124,
    "SuppliedPhone": 46,
    "Survey_Follow_up__c": 88,
    "SystemModstamp": 121,
    "TC1_Email__c": 123,
    "TC1_Name__c": 10,
    "TC1_Phone__c": 83,
    "TC2_Email__c": 107,
    "TC2_Name__c": 21,
    "TC2_Phone__c": 63,
    "TM_Decryption__c": 48,
    "Technician_Note__c": 78,
    "Tenant_Insurance_Co__c": 137,
    "Tentative_Conversion_Date__c": 82,
    "Total_Minutes__c": 55,
    "Total_Unit_Count__c": 32,
    "Type": 41,
    "Type__c": 97,
    "UniqueCasecount__c": 131,
    "Unit_Rent_Tax_Rate__c": 42,
    "Vanilla__ForumUrl__c": 0,
    "Version_History_Comment__c": 85,
    "Version_History_Include_Video__c": 140,
    "Version_History_Status__c": 114,
    "attributes": 66,
    "dCreated__c": 80
}

schema_attributes:

{
    "AccountId": "string",
    "Account_Billing_Type__c": "string",
    "Account_Note__c": "string",
    "Account_Units_Rented__c": "double",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "double",
    "Age_Days__c": "double",
    "Approved_for_Development__c": "boolean",
    "AssetId": "string",
    "Assigned_Tech__c": "string",
    "Australia__c": "string",
    "Billing_Address__c": "string",
    "Billing_Contact_Email__c": "string",
    "Billing_Contact_Phone__c": "string",
    "Billing_Contact__c": "string",
    "BusinessHoursId": "string",
    "CaseNumber": "string",
    "CaseOwnerDivision__c": "string",
    "Category__c": "string",
    "ClosedDate": "timestamp",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId": "string",
    "Contact_Account_Name_Populated__c": "string",
    "Conversion_Complete_Date__c": "date",
    "Conversion_Scheduled_Date__c": "date",
    "Corp_Code_Search__c": "string",
    "Corp_Code__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Gate_System__c": "string",
    "Current_Software__c": "string",
    "Customer_Comments__c": "string",
    "Customer_Priority__c": "string",
    "Database__c": "string",
    "Date_Assigned_to_Tech__c": "date",
    "Days_Assigned_to_Complete__c": "double",
    "Days_Opened_to_Complete__c": "double",
    "Days_Scheduled_to_Completed__c": "double",
    "Department__c": "string",
    "Deployed_In_Version__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "Due_Date__c": "date",
    "EnableCustomInsurance__c": "boolean",
    "Escalation_Reason__c": "string",
    "Escalation__c": "boolean",
    "Estimated_Hours__c": "double",
    "Files_Stored_Procedures_Update__c": "string",
    "HasCommentsUnreadByOwner": "boolean",
    "HasSelfServiceComments": "boolean",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "Include_In_Immediate_Release__c": "boolean",
    "Includes_Script_To_Be_Run__c": "boolean",
    "Insurance_Tax__c": "string",
    "Internal_Instructions__c": "string",
    "Invoice__c": "string",
    "Invoiced_Date__c": "date",
    "IsClosed": "boolean",
    "IsClosedOnCreate": "boolean",
    "IsDeleted": "boolean",
    "IsEscalated": "boolean",
    "IsSelfServiceClosed": "boolean",
    "IsVisibleInSelfService": "boolean",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "Last_Comment_Date__c": "timestamp",
    "Last_Time_Entry_Date__c": "timestamp",
    "Last_Touched_Date__c": "timestamp",
    "Last_Touched_Days__c": "double",
    "Location_Code__c": "string",
    "Max_Units__c": "string",
    "Merchandise_Tax__c": "string",
    "Mobile_Storage__c": "string",
    "NDA_Signed__c": "boolean",
    "National_Account__c": "boolean",
    "Opportunity__c": "string",
    "Origin": "string",
    "Original_Tech_Owner__c": "string",
    "OwnerId": "string",
    "Owner_Department__c": "string",
    "Paid_On__c": "date",
    "ParentId": "string",
    "Parent_Account_Note__c": "string",
    "Parent_Case_Status__c": "string",
    "Planned_In_Version__c": "string",
    "Priority": "string",
    "Priority_Flag__c": "string",
    "Product__c": "string",
    "Quoted_Date__c": "date",
    "Quoted_Price__c": "string",
    "Quoted_Rate_Comp__c": "string",
    "Reason": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "boolean",
    "SF_Demand_in_scope_new_customer__c": "boolean",
    "SiteLink_Store_Domain__c": "string",
    "SiteLink_Store__c": "string",
    "Site_Address__c": "string",
    "Site_Contact_Email__c": "string",
    "Site_Contact_Phone__c": "string",
    "Site_Contact__c": "string",
    "Status": "string",
    "Strategic_Goal__c": "boolean",
    "SubCategory__c": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Survey_Follow_up__c": "string",
    "SystemModstamp": "timestamp",
    "TC1_Email__c": "string",
    "TC1_Name__c": "string",
    "TC1_Phone__c": "string",
    "TC2_Email__c": "string",
    "TC2_Name__c": "string",
    "TC2_Phone__c": "string",
    "TM_Decryption__c": "string",
    "Technician_Note__c": "string",
    "Tenant_Insurance_Co__c": "string",
    "Tentative_Conversion_Date__c": "date",
    "Total_Minutes__c": "double",
    "Total_Unit_Count__c": "double",
    "Type": "string",
    "Type__c": "string",
    "UniqueCasecount__c": "double",
    "Unit_Rent_Tax_Rate__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Version_History_Comment__c": "string",
    "Version_History_Include_Video__c": "boolean",
    "Version_History_Status__c": "string",
    "attributes": "string",
    "dCreated__c": "timestamp"
}

schema_name_id: 564
schema_scan_id: 19541040
updated: 2018-10-26 15:23:17

Schema Scans: 1

Last at 2018-10-26 15:23:05

Scan 19541040

duration: 0:00:14.685305

exit_message:

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

id: 19541040

payload:

{
    "datatype_dict": {
        "AccountId": "string",
        "Account_Billing_Type__c": "string",
        "Account_Note__c": "string",
        "Account_Units_Rented__c": "double",
        "Actual_Hours_User__c": "string",
        "Actual_Hours__c": "double",
        "Age_Days__c": "double",
        "Approved_for_Development__c": "boolean",
        "AssetId": "string",
        "Assigned_Tech__c": "string",
        "Australia__c": "string",
        "Billing_Address__c": "string",
        "Billing_Contact_Email__c": "string",
        "Billing_Contact_Phone__c": "string",
        "Billing_Contact__c": "string",
        "BusinessHoursId": "string",
        "CaseNumber": "string",
        "CaseOwnerDivision__c": "string",
        "Category__c": "string",
        "ClosedDate": "timestamp",
        "ConnectionReceivedId": "string",
        "ConnectionSentId": "string",
        "ContactId": "string",
        "Contact_Account_Name_Populated__c": "string",
        "Conversion_Complete_Date__c": "date",
        "Conversion_Scheduled_Date__c": "date",
        "Corp_Code_Search__c": "string",
        "Corp_Code__c": "string",
        "CreatedById": "string",
        "CreatedDate": "timestamp",
        "CurrencyIsoCode": "string",
        "Current_Gate_System__c": "string",
        "Current_Software__c": "string",
        "Customer_Comments__c": "string",
        "Customer_Priority__c": "string",
        "Database__c": "string",
        "Date_Assigned_to_Tech__c": "date",
        "Days_Assigned_to_Complete__c": "double",
        "Days_Opened_to_Complete__c": "double",
        "Days_Scheduled_to_Completed__c": "double",
        "Department__c": "string",
        "Deployed_In_Version__c": "string",
        "Description": "string",
        "Development_Priority__c": "string",
        "Due_Date__c": "date",
        "EnableCustomInsurance__c": "boolean",
        "Escalation_Reason__c": "string",
        "Escalation__c": "boolean",
        "Estimated_Hours__c": "double",
        "Files_Stored_Procedures_Update__c": "string",
        "HasCommentsUnreadByOwner": "boolean",
        "HasSelfServiceComments": "boolean",
        "IGD__Collection_Id__c": "string",
        "Id": "string",
        "Include_In_Immediate_Release__c": "boolean",
        "Includes_Script_To_Be_Run__c": "boolean",
        "Insurance_Tax__c": "string",
        "Internal_Instructions__c": "string",
        "Invoice__c": "string",
        "Invoiced_Date__c": "date",
        "IsClosed": "boolean",
        "IsClosedOnCreate": "boolean",
        "IsDeleted": "boolean",
        "IsEscalated": "boolean",
        "IsSelfServiceClosed": "boolean",
        "IsVisibleInSelfService": "boolean",
        "LastModifiedById": "string",
        "LastModifiedDate": "timestamp",
        "LastReferencedDate": "timestamp",
        "LastViewedDate": "timestamp",
        "Last_Comment_Date__c": "timestamp",
        "Last_Time_Entry_Date__c": "timestamp",
        "Last_Touched_Date__c": "timestamp",
        "Last_Touched_Days__c": "double",
        "Location_Code__c": "string",
        "Max_Units__c": "string",
        "Merchandise_Tax__c": "string",
        "Mobile_Storage__c": "string",
        "NDA_Signed__c": "boolean",
        "National_Account__c": "boolean",
        "Opportunity__c": "string",
        "Origin": "string",
        "Original_Tech_Owner__c": "string",
        "OwnerId": "string",
        "Owner_Department__c": "string",
        "Paid_On__c": "date",
        "ParentId": "string",
        "Parent_Account_Note__c": "string",
        "Parent_Case_Status__c": "string",
        "Planned_In_Version__c": "string",
        "Priority": "string",
        "Priority_Flag__c": "string",
        "Product__c": "string",
        "Quoted_Date__c": "date",
        "Quoted_Price__c": "string",
        "Quoted_Rate_Comp__c": "string",
        "Reason": "string",
        "RecordTypeId": "string",
        "Reference_Opportunity__c": "string",
        "SFDemandinScopeExistingSFCustome__c": "boolean",
        "SF_Demand_in_scope_new_customer__c": "boolean",
        "SiteLink_Store_Domain__c": "string",
        "SiteLink_Store__c": "string",
        "Site_Address__c": "string",
        "Site_Contact_Email__c": "string",
        "Site_Contact_Phone__c": "string",
        "Site_Contact__c": "string",
        "Status": "string",
        "Strategic_Goal__c": "boolean",
        "SubCategory__c": "string",
        "SubType_1__c": "string",
        "SubType_2__c": "string",
        "SubType_3_c__c": "string",
        "Subject": "string",
        "SuppliedCompany": "string",
        "SuppliedEmail": "string",
        "SuppliedName": "string",
        "SuppliedPhone": "string",
        "Survey_Follow_up__c": "string",
        "SystemModstamp": "timestamp",
        "TC1_Email__c": "string",
        "TC1_Name__c": "string",
        "TC1_Phone__c": "string",
        "TC2_Email__c": "string",
        "TC2_Name__c": "string",
        "TC2_Phone__c": "string",
        "TM_Decryption__c": "string",
        "Technician_Note__c": "string",
        "Tenant_Insurance_Co__c": "string",
        "Tentative_Conversion_Date__c": "date",
        "Total_Minutes__c": "double",
        "Total_Unit_Count__c": "double",
        "Type": "string",
        "Type__c": "string",
        "UniqueCasecount__c": "double",
        "Unit_Rent_Tax_Rate__c": "string",
        "Vanilla__ForumUrl__c": "string",
        "Version_History_Comment__c": "string",
        "Version_History_Include_Video__c": "boolean",
        "Version_History_Status__c": "string",
        "dCreated__c": "timestamp"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-salesforce-sitelink-prod",
        "hive_path": "s3://sfdl-salesforce-sitelink-prod/raw/Case/2018-10-26/1540585381",
        "key": "raw/Case/2018-10-26/1540585381/file0.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_salesforce.sitelink_Case",
        "type": "salesforce"
    }
}

running: False
schema_name_id: 564
start_time: 2018-10-26 15:23:05
success: True
trace_id: 16441622582280673683

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "AccountId": "string",
    "Account_Billing_Type__c": "string",
    "Account_Note__c": "string",
    "Account_Units_Rented__c": "double",
    "Actual_Hours_User__c": "string",
    "Actual_Hours__c": "double",
    "Age_Days__c": "double",
    "Approved_for_Development__c": "boolean",
    "AssetId": "string",
    "Assigned_Tech__c": "string",
    "Australia__c": "string",
    "Billing_Address__c": "string",
    "Billing_Contact_Email__c": "string",
    "Billing_Contact_Phone__c": "string",
    "Billing_Contact__c": "string",
    "BusinessHoursId": "string",
    "CaseNumber": "string",
    "CaseOwnerDivision__c": "string",
    "Category__c": "string",
    "ClosedDate": "timestamp",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId": "string",
    "Contact_Account_Name_Populated__c": "string",
    "Conversion_Complete_Date__c": "date",
    "Conversion_Scheduled_Date__c": "date",
    "Corp_Code_Search__c": "string",
    "Corp_Code__c": "string",
    "CreatedById": "string",
    "CreatedDate": "timestamp",
    "CurrencyIsoCode": "string",
    "Current_Gate_System__c": "string",
    "Current_Software__c": "string",
    "Customer_Comments__c": "string",
    "Customer_Priority__c": "string",
    "Database__c": "string",
    "Date_Assigned_to_Tech__c": "date",
    "Days_Assigned_to_Complete__c": "double",
    "Days_Opened_to_Complete__c": "double",
    "Days_Scheduled_to_Completed__c": "double",
    "Department__c": "string",
    "Deployed_In_Version__c": "string",
    "Description": "string",
    "Development_Priority__c": "string",
    "Due_Date__c": "date",
    "EnableCustomInsurance__c": "boolean",
    "Escalation_Reason__c": "string",
    "Escalation__c": "boolean",
    "Estimated_Hours__c": "double",
    "Files_Stored_Procedures_Update__c": "string",
    "HasCommentsUnreadByOwner": "boolean",
    "HasSelfServiceComments": "boolean",
    "IGD__Collection_Id__c": "string",
    "Id": "string",
    "Include_In_Immediate_Release__c": "boolean",
    "Includes_Script_To_Be_Run__c": "boolean",
    "Insurance_Tax__c": "string",
    "Internal_Instructions__c": "string",
    "Invoice__c": "string",
    "Invoiced_Date__c": "date",
    "IsClosed": "boolean",
    "IsClosedOnCreate": "boolean",
    "IsDeleted": "boolean",
    "IsEscalated": "boolean",
    "IsSelfServiceClosed": "boolean",
    "IsVisibleInSelfService": "boolean",
    "LastModifiedById": "string",
    "LastModifiedDate": "timestamp",
    "LastReferencedDate": "timestamp",
    "LastViewedDate": "timestamp",
    "Last_Comment_Date__c": "timestamp",
    "Last_Time_Entry_Date__c": "timestamp",
    "Last_Touched_Date__c": "timestamp",
    "Last_Touched_Days__c": "double",
    "Location_Code__c": "string",
    "Max_Units__c": "string",
    "Merchandise_Tax__c": "string",
    "Mobile_Storage__c": "string",
    "NDA_Signed__c": "boolean",
    "National_Account__c": "boolean",
    "Opportunity__c": "string",
    "Origin": "string",
    "Original_Tech_Owner__c": "string",
    "OwnerId": "string",
    "Owner_Department__c": "string",
    "Paid_On__c": "date",
    "ParentId": "string",
    "Parent_Account_Note__c": "string",
    "Parent_Case_Status__c": "string",
    "Planned_In_Version__c": "string",
    "Priority": "string",
    "Priority_Flag__c": "string",
    "Product__c": "string",
    "Quoted_Date__c": "date",
    "Quoted_Price__c": "string",
    "Quoted_Rate_Comp__c": "string",
    "Reason": "string",
    "RecordTypeId": "string",
    "Reference_Opportunity__c": "string",
    "SFDemandinScopeExistingSFCustome__c": "boolean",
    "SF_Demand_in_scope_new_customer__c": "boolean",
    "SiteLink_Store_Domain__c": "string",
    "SiteLink_Store__c": "string",
    "Site_Address__c": "string",
    "Site_Contact_Email__c": "string",
    "Site_Contact_Phone__c": "string",
    "Site_Contact__c": "string",
    "Status": "string",
    "Strategic_Goal__c": "boolean",
    "SubCategory__c": "string",
    "SubType_1__c": "string",
    "SubType_2__c": "string",
    "SubType_3_c__c": "string",
    "Subject": "string",
    "SuppliedCompany": "string",
    "SuppliedEmail": "string",
    "SuppliedName": "string",
    "SuppliedPhone": "string",
    "Survey_Follow_up__c": "string",
    "SystemModstamp": "timestamp",
    "TC1_Email__c": "string",
    "TC1_Name__c": "string",
    "TC1_Phone__c": "string",
    "TC2_Email__c": "string",
    "TC2_Name__c": "string",
    "TC2_Phone__c": "string",
    "TM_Decryption__c": "string",
    "Technician_Note__c": "string",
    "Tenant_Insurance_Co__c": "string",
    "Tentative_Conversion_Date__c": "date",
    "Total_Minutes__c": "double",
    "Total_Unit_Count__c": "double",
    "Type": "string",
    "Type__c": "string",
    "UniqueCasecount__c": "double",
    "Unit_Rent_Tax_Rate__c": "string",
    "Vanilla__ForumUrl__c": "string",
    "Version_History_Comment__c": "string",
    "Version_History_Include_Video__c": "boolean",
    "Version_History_Status__c": "string",
    "attributes": "string",
    "dCreated__c": "timestamp"
}

created: 2018-10-26 15:23:06

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_case`\n(\n `Vanilla__ForumUrl__c`  string , `Billing_Contact_Phone__c`  string , `Parent_Case_Status__c`  string , `Reference_Opportunity__c`  string , `Conversion_Scheduled_Date__c`  date , `Site_Contact__c`  string , `IsClosedOnCreate`  boolean , `NDA_Signed__c`  boolean , `ClosedDate`  timestamp , `IsEscalated`  boolean , `TC1_Name__c`  string , `Include_In_Immediate_Release__c`  boolean , `Reason`  string , `Database__c`  string , `CaseOwnerDivision__c`  string , `Last_Touched_Days__c`  double , `IsDeleted`  boolean , `AccountId`  string , `Last_Touched_Date__c`  timestamp , `SuppliedEmail`  string , `Days_Opened_to_Complete__c`  double , `TC2_Name__c`  string , `LastReferencedDate`  timestamp , `RecordTypeId`  string , `Origin`  string , `Original_Tech_Owner__c`  string , `Conversion_Complete_Date__c`  date , `Account_Units_Rented__c`  double , `Billing_Contact__c`  string , `Assigned_Tech__c`  string , `Subject`  string , `Department__c`  string , `Total_Unit_Count__c`  double , `Product__c`  string , `Estimated_Hours__c`  double , `SuppliedCompany`  string , `HasCommentsUnreadByOwner`  boolean , `Priority`  string , `Invoice__c`  string , `Priority_Flag__c`  string , `OwnerId`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  string , `Site_Address__c`  string , `SiteLink_Store_Domain__c`  string , `Quoted_Price__c`  string , `SuppliedPhone`  string , `Paid_On__c`  date , `TM_Decryption__c`  string , `ContactId`  string , `Site_Contact_Phone__c`  string , `Quoted_Rate_Comp__c`  string , `Current_Gate_System__c`  string , `Max_Units__c`  string , `SF_Demand_in_scope_new_customer__c`  boolean , `Total_Minutes__c`  double , `Site_Contact_Email__c`  string , `ParentId`  string , `Actual_Hours_User__c`  string , `Escalation_Reason__c`  string , `Billing_Address__c`  string , `SFDemandinScopeExistingSFCustome__c`  boolean , `SubCategory__c`  string , `TC2_Phone__c`  string , `Owner_Department__c`  string , `SubType_3_c__c`  string , `attributes`  string , `Customer_Comments__c`  string , `Actual_Hours__c`  double , `Account_Billing_Type__c`  string , `SiteLink_Store__c`  string , `Due_Date__c`  date , `Corp_Code_Search__c`  string , `Internal_Instructions__c`  string , `Australia__c`  string , `Corp_Code__c`  string , `Status`  string , `CaseNumber`  string , `Technician_Note__c`  string , `LastModifiedDate`  timestamp , `dCreated__c`  timestamp , `EnableCustomInsurance__c`  boolean , `Tentative_Conversion_Date__c`  date , `TC1_Phone__c`  string , `ConnectionSentId`  string , `Version_History_Comment__c`  string , `BusinessHoursId`  string , `Last_Time_Entry_Date__c`  timestamp , `Survey_Follow_up__c`  string , `Merchandise_Tax__c`  string , `Billing_Contact_Email__c`  string , `LastModifiedById`  string , `CurrencyIsoCode`  string , `Escalation__c`  boolean , `Current_Software__c`  string , `SubType_2__c`  string , `Deployed_In_Version__c`  string , `Type__c`  string , `IsClosed`  boolean , `Contact_Account_Name_Populated__c`  string , `Days_Scheduled_to_Completed__c`  double , `Opportunity__c`  string , `Days_Assigned_to_Complete__c`  double , `Planned_In_Version__c`  string , `SubType_1__c`  string , `Last_Comment_Date__c`  timestamp , `Strategic_Goal__c`  boolean , `TC2_Email__c`  string , `Includes_Script_To_Be_Run__c`  boolean , `Invoiced_Date__c`  date , `Location_Code__c`  string , `Account_Note__c`  string , `Development_Priority__c`  string , `Description`  string , `Version_History_Status__c`  string , `Files_Stored_Procedures_Update__c`  string , `IsSelfServiceClosed`  boolean , `Quoted_Date__c`  date , `CreatedById`  string , `Category__c`  string , `IsVisibleInSelfService`  boolean , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `TC1_Email__c`  string , `SuppliedName`  string , `Date_Assigned_to_Tech__c`  date , `AssetId`  string , `CreatedDate`  timestamp , `IGD__Collection_Id__c`  string , `ConnectionReceivedId`  string , `Customer_Priority__c`  string , `UniqueCasecount__c`  double , `Parent_Account_Note__c`  string , `National_Account__c`  boolean , `Age_Days__c`  double , `Approved_for_Development__c`  boolean , `HasSelfServiceComments`  boolean , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  string , `Mobile_Storage__c`  string , `Version_History_Include_Video__c`  boolean , `Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Case/2018-10-26/1540585381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_case`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_case"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-10-26 15:23:05",
        "disabled": false,
        "format": "raw",
        "id": 564,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_salesforce",
            "table": "sitelink_case"
        },
        "type": "salesforce"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "Account_Billing_Type__c": "string",
            "Account_Note__c": "string",
            "Account_Units_Rented__c": "double",
            "Actual_Hours_User__c": "string",
            "Actual_Hours__c": "double",
            "Age_Days__c": "double",
            "Approved_for_Development__c": "boolean",
            "AssetId": "string",
            "Assigned_Tech__c": "string",
            "Australia__c": "string",
            "Billing_Address__c": "string",
            "Billing_Contact_Email__c": "string",
            "Billing_Contact_Phone__c": "string",
            "Billing_Contact__c": "string",
            "BusinessHoursId": "string",
            "CaseNumber": "string",
            "CaseOwnerDivision__c": "string",
            "Category__c": "string",
            "ClosedDate": "timestamp",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "ContactId": "string",
            "Contact_Account_Name_Populated__c": "string",
            "Conversion_Complete_Date__c": "date",
            "Conversion_Scheduled_Date__c": "date",
            "Corp_Code_Search__c": "string",
            "Corp_Code__c": "string",
            "CreatedById": "string",
            "CreatedDate": "timestamp",
            "CurrencyIsoCode": "string",
            "Current_Gate_System__c": "string",
            "Current_Software__c": "string",
            "Customer_Comments__c": "string",
            "Customer_Priority__c": "string",
            "Database__c": "string",
            "Date_Assigned_to_Tech__c": "date",
            "Days_Assigned_to_Complete__c": "double",
            "Days_Opened_to_Complete__c": "double",
            "Days_Scheduled_to_Completed__c": "double",
            "Department__c": "string",
            "Deployed_In_Version__c": "string",
            "Description": "string",
            "Development_Priority__c": "string",
            "Due_Date__c": "date",
            "EnableCustomInsurance__c": "boolean",
            "Escalation_Reason__c": "string",
            "Escalation__c": "boolean",
            "Estimated_Hours__c": "double",
            "Files_Stored_Procedures_Update__c": "string",
            "HasCommentsUnreadByOwner": "boolean",
            "HasSelfServiceComments": "boolean",
            "IGD__Collection_Id__c": "string",
            "Id": "string",
            "Include_In_Immediate_Release__c": "boolean",
            "Includes_Script_To_Be_Run__c": "boolean",
            "Insurance_Tax__c": "string",
            "Internal_Instructions__c": "string",
            "Invoice__c": "string",
            "Invoiced_Date__c": "date",
            "IsClosed": "boolean",
            "IsClosedOnCreate": "boolean",
            "IsDeleted": "boolean",
            "IsEscalated": "boolean",
            "IsSelfServiceClosed": "boolean",
            "IsVisibleInSelfService": "boolean",
            "LastModifiedById": "string",
            "LastModifiedDate": "timestamp",
            "LastReferencedDate": "timestamp",
            "LastViewedDate": "timestamp",
            "Last_Comment_Date__c": "timestamp",
            "Last_Time_Entry_Date__c": "timestamp",
            "Last_Touched_Date__c": "timestamp",
            "Last_Touched_Days__c": "double",
            "Location_Code__c": "string",
            "Max_Units__c": "string",
            "Merchandise_Tax__c": "string",
            "Mobile_Storage__c": "string",
            "NDA_Signed__c": "boolean",
            "National_Account__c": "boolean",
            "Opportunity__c": "string",
            "Origin": "string",
            "Original_Tech_Owner__c": "string",
            "OwnerId": "string",
            "Owner_Department__c": "string",
            "Paid_On__c": "date",
            "ParentId": "string",
            "Parent_Account_Note__c": "string",
            "Parent_Case_Status__c": "string",
            "Planned_In_Version__c": "string",
            "Priority": "string",
            "Priority_Flag__c": "string",
            "Product__c": "string",
            "Quoted_Date__c": "date",
            "Quoted_Price__c": "string",
            "Quoted_Rate_Comp__c": "string",
            "Reason": "string",
            "RecordTypeId": "string",
            "Reference_Opportunity__c": "string",
            "SFDemandinScopeExistingSFCustome__c": "boolean",
            "SF_Demand_in_scope_new_customer__c": "boolean",
            "SiteLink_Store_Domain__c": "string",
            "SiteLink_Store__c": "string",
            "Site_Address__c": "string",
            "Site_Contact_Email__c": "string",
            "Site_Contact_Phone__c": "string",
            "Site_Contact__c": "string",
            "Status": "string",
            "Strategic_Goal__c": "boolean",
            "SubCategory__c": "string",
            "SubType_1__c": "string",
            "SubType_2__c": "string",
            "SubType_3_c__c": "string",
            "Subject": "string",
            "SuppliedCompany": "string",
            "SuppliedEmail": "string",
            "SuppliedName": "string",
            "SuppliedPhone": "string",
            "Survey_Follow_up__c": "string",
            "SystemModstamp": "timestamp",
            "TC1_Email__c": "string",
            "TC1_Name__c": "string",
            "TC1_Phone__c": "string",
            "TC2_Email__c": "string",
            "TC2_Name__c": "string",
            "TC2_Phone__c": "string",
            "TM_Decryption__c": "string",
            "Technician_Note__c": "string",
            "Tenant_Insurance_Co__c": "string",
            "Tentative_Conversion_Date__c": "date",
            "Total_Minutes__c": "double",
            "Total_Unit_Count__c": "double",
            "Type": "string",
            "Type__c": "string",
            "UniqueCasecount__c": "double",
            "Unit_Rent_Tax_Rate__c": "string",
            "Vanilla__ForumUrl__c": "string",
            "Version_History_Comment__c": "string",
            "Version_History_Include_Video__c": "boolean",
            "Version_History_Status__c": "string",
            "attributes": "string",
            "dCreated__c": "timestamp"
        },
        "created": "2018-10-26 15:23:06",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_salesforce`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_salesforce.sitelink_case`\n(\n `Vanilla__ForumUrl__c`  string , `Billing_Contact_Phone__c`  string , `Parent_Case_Status__c`  string , `Reference_Opportunity__c`  string , `Conversion_Scheduled_Date__c`  date , `Site_Contact__c`  string , `IsClosedOnCreate`  boolean , `NDA_Signed__c`  boolean , `ClosedDate`  timestamp , `IsEscalated`  boolean , `TC1_Name__c`  string , `Include_In_Immediate_Release__c`  boolean , `Reason`  string , `Database__c`  string , `CaseOwnerDivision__c`  string , `Last_Touched_Days__c`  double , `IsDeleted`  boolean , `AccountId`  string , `Last_Touched_Date__c`  timestamp , `SuppliedEmail`  string , `Days_Opened_to_Complete__c`  double , `TC2_Name__c`  string , `LastReferencedDate`  timestamp , `RecordTypeId`  string , `Origin`  string , `Original_Tech_Owner__c`  string , `Conversion_Complete_Date__c`  date , `Account_Units_Rented__c`  double , `Billing_Contact__c`  string , `Assigned_Tech__c`  string , `Subject`  string , `Department__c`  string , `Total_Unit_Count__c`  double , `Product__c`  string , `Estimated_Hours__c`  double , `SuppliedCompany`  string , `HasCommentsUnreadByOwner`  boolean , `Priority`  string , `Invoice__c`  string , `Priority_Flag__c`  string , `OwnerId`  string , `Type`  string , `Unit_Rent_Tax_Rate__c`  string , `Site_Address__c`  string , `SiteLink_Store_Domain__c`  string , `Quoted_Price__c`  string , `SuppliedPhone`  string , `Paid_On__c`  date , `TM_Decryption__c`  string , `ContactId`  string , `Site_Contact_Phone__c`  string , `Quoted_Rate_Comp__c`  string , `Current_Gate_System__c`  string , `Max_Units__c`  string , `SF_Demand_in_scope_new_customer__c`  boolean , `Total_Minutes__c`  double , `Site_Contact_Email__c`  string , `ParentId`  string , `Actual_Hours_User__c`  string , `Escalation_Reason__c`  string , `Billing_Address__c`  string , `SFDemandinScopeExistingSFCustome__c`  boolean , `SubCategory__c`  string , `TC2_Phone__c`  string , `Owner_Department__c`  string , `SubType_3_c__c`  string , `attributes`  string , `Customer_Comments__c`  string , `Actual_Hours__c`  double , `Account_Billing_Type__c`  string , `SiteLink_Store__c`  string , `Due_Date__c`  date , `Corp_Code_Search__c`  string , `Internal_Instructions__c`  string , `Australia__c`  string , `Corp_Code__c`  string , `Status`  string , `CaseNumber`  string , `Technician_Note__c`  string , `LastModifiedDate`  timestamp , `dCreated__c`  timestamp , `EnableCustomInsurance__c`  boolean , `Tentative_Conversion_Date__c`  date , `TC1_Phone__c`  string , `ConnectionSentId`  string , `Version_History_Comment__c`  string , `BusinessHoursId`  string , `Last_Time_Entry_Date__c`  timestamp , `Survey_Follow_up__c`  string , `Merchandise_Tax__c`  string , `Billing_Contact_Email__c`  string , `LastModifiedById`  string , `CurrencyIsoCode`  string , `Escalation__c`  boolean , `Current_Software__c`  string , `SubType_2__c`  string , `Deployed_In_Version__c`  string , `Type__c`  string , `IsClosed`  boolean , `Contact_Account_Name_Populated__c`  string , `Days_Scheduled_to_Completed__c`  double , `Opportunity__c`  string , `Days_Assigned_to_Complete__c`  double , `Planned_In_Version__c`  string , `SubType_1__c`  string , `Last_Comment_Date__c`  timestamp , `Strategic_Goal__c`  boolean , `TC2_Email__c`  string , `Includes_Script_To_Be_Run__c`  boolean , `Invoiced_Date__c`  date , `Location_Code__c`  string , `Account_Note__c`  string , `Development_Priority__c`  string , `Description`  string , `Version_History_Status__c`  string , `Files_Stored_Procedures_Update__c`  string , `IsSelfServiceClosed`  boolean , `Quoted_Date__c`  date , `CreatedById`  string , `Category__c`  string , `IsVisibleInSelfService`  boolean , `SystemModstamp`  timestamp , `LastViewedDate`  timestamp , `TC1_Email__c`  string , `SuppliedName`  string , `Date_Assigned_to_Tech__c`  date , `AssetId`  string , `CreatedDate`  timestamp , `IGD__Collection_Id__c`  string , `ConnectionReceivedId`  string , `Customer_Priority__c`  string , `UniqueCasecount__c`  double , `Parent_Account_Note__c`  string , `National_Account__c`  boolean , `Age_Days__c`  double , `Approved_for_Development__c`  boolean , `HasSelfServiceComments`  boolean , `Tenant_Insurance_Co__c`  string , `Insurance_Tax__c`  string , `Mobile_Storage__c`  string , `Version_History_Include_Video__c`  boolean , `Id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-salesforce-sitelink-prod/raw/Case/2018-10-26/1540585381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_salesforce.sitelink_case`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_salesforce.sitelink_case"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}