Schema Info

Schema Name: sfdl_prod_csv.salesforce_incident__cs

created: 2022-10-10 16:23:31
disabled: False
format: raw
id: 1193
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_csv",
    "table": "salesforce_incident__cs"
}

type: csv

Schema Versions: 15

Version 1718058

created: 2026-04-17 07:04:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-17/1776427479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-17/1776427479
id: 1718058
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 162173021
updated: 2026-04-17 07:04:56

Version 1716862

created: 2026-04-16 07:06:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-16/1776341099'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-16/1776341099
id: 1716862
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 162117337
updated: 2026-04-16 07:06:46

Version 1715662

created: 2026-04-15 07:09:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-15/1776254783'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-15/1776254783
id: 1715662
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 162061802
updated: 2026-04-15 07:09:44

Version 1714487

created: 2026-04-14 07:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-14/1776168311'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-14/1776168311
id: 1714487
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 162006408
updated: 2026-04-14 07:07:46

Version 1713231

created: 2026-04-13 07:06:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-13/1776081911'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-13/1776081911
id: 1713231
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161948309
updated: 2026-04-13 07:06:19

Version 1712049

created: 2026-04-12 07:07:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-12/1775995648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-12/1775995648
id: 1712049
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161899531
updated: 2026-04-12 07:07:49

Version 1710819

created: 2026-04-11 07:04:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-11/1775909035'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-11/1775909035
id: 1710819
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161846827
updated: 2026-04-11 07:04:17

Version 1709689

created: 2026-04-10 07:07:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-10/1775822724'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-10/1775822724
id: 1709689
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161792094
updated: 2026-04-10 07:07:15

Version 1708512

created: 2026-04-09 07:05:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-09/1775736309'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-09/1775736309
id: 1708512
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161736241
updated: 2026-04-09 07:06:04

Version 1707351

created: 2026-04-08 07:07:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-08/1775649923'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-08/1775649923
id: 1707351
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161681413
updated: 2026-04-08 07:07:20

Version 1706119

created: 2026-04-07 07:05:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-07/1775563496'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-07/1775563496
id: 1706119
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161625153
updated: 2026-04-07 07:05:19

Version 1704949

created: 2026-04-06 07:11:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-06/1775477106'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-06/1775477106
id: 1704949
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161567365
updated: 2026-04-06 07:11:32

Version 1703691

created: 2026-04-05 07:05:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-05/1775390652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-05/1775390652
id: 1703691
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161519973
updated: 2026-04-05 07:05:31

Version 1702577

created: 2026-04-04 07:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-04/1775304422'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-04/1775304422
id: 1702577
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161466452
updated: 2026-04-04 07:10:05

Version 1701381

created: 2026-04-03 07:06:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-03/1775217885'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/incident__cs/2026-04-03/1775217885
id: 1701381
processed: 1

raw_data:

{
    "AccountId__c": 12,
    "CaseId__c": 13,
    "ConnectionReceivedId": 10,
    "ConnectionSentId": 11,
    "ContactId__c": 14,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 4,
    "Id": 0,
    "IncidentNotes__c": 15,
    "IsDeleted": 2,
    "IssueResolved__c": 16,
    "JiraIssueId__c": 17,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "Name": 3,
    "OwnerId": 1,
    "SystemModstamp": 9
}

schema_attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1193
schema_scan_id: 161408591
updated: 2026-04-03 07:06:52

Schema Scans: 15

Last at 2026-04-17 07:04:44

Scan 162173021

duration: 0:00:12.063070

exit_message:

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

id: 162173021

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/incident__cs/2026-04-17/1776427479",
        "key": "raw/incident__cs/2026-04-17/1776427479/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7716985253805125117,
        "service_name": "drive-thru",
        "span_id": 14315158068346542743,
        "trace_id": 18217504918512606943
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-17 07:04:44
success: True
trace_id: 18217504918512606943

Scan 162117337

duration: 0:00:14.780847

exit_message:

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

id: 162117337

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/incident__cs/2026-04-16/1776341099",
        "key": "raw/incident__cs/2026-04-16/1776341099/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1314916045101317562,
        "service_name": "drive-thru",
        "span_id": 14968225261714505827,
        "trace_id": 12133782868046568551
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-16 07:06:31
success: True
trace_id: 12133782868046568551

Scan 162061802

duration: 0:00:14.643867

exit_message:

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

id: 162061802

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/incident__cs/2026-04-15/1776254783",
        "key": "raw/incident__cs/2026-04-15/1776254783/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6409236162653929461,
        "service_name": "drive-thru",
        "span_id": 15593421033037745576,
        "trace_id": 13275281619780146853
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-15 07:09:30
success: True
trace_id: 13275281619780146853

Scan 162006408

duration: 0:00:14.757751

exit_message:

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

id: 162006408

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/incident__cs/2026-04-14/1776168311",
        "key": "raw/incident__cs/2026-04-14/1776168311/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5816151777229837975,
        "service_name": "drive-thru",
        "span_id": 15684229909283169164,
        "trace_id": 12821130784118240368
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-14 07:07:31
success: True
trace_id: 12821130784118240368

Scan 161948309

duration: 0:00:12.260475

exit_message:

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

id: 161948309

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/incident__cs/2026-04-13/1776081911",
        "key": "raw/incident__cs/2026-04-13/1776081911/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 37004572706661378,
        "service_name": "drive-thru",
        "span_id": 7748632088649464536,
        "trace_id": 17280507500705665908
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-13 07:06:07
success: True
trace_id: 17280507500705665908

Scan 161899531

duration: 0:00:14.759789

exit_message:

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

id: 161899531

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/incident__cs/2026-04-12/1775995648",
        "key": "raw/incident__cs/2026-04-12/1775995648/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15868368159130995585,
        "service_name": "drive-thru",
        "span_id": 8573718468449099540,
        "trace_id": 8229507333989492567
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-12 07:07:35
success: True
trace_id: 8229507333989492567

Scan 161846827

duration: 0:00:14.698841

exit_message:

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

id: 161846827

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/incident__cs/2026-04-11/1775909035",
        "key": "raw/incident__cs/2026-04-11/1775909035/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16266321520566175048,
        "service_name": "drive-thru",
        "span_id": 13276278188194246036,
        "trace_id": 12247839496717505130
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-11 07:04:02
success: True
trace_id: 12247839496717505130

Scan 161792094

duration: 0:00:12.207998

exit_message:

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

id: 161792094

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/incident__cs/2026-04-10/1775822724",
        "key": "raw/incident__cs/2026-04-10/1775822724/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15796875116052891508,
        "service_name": "drive-thru",
        "span_id": 1216954814320568089,
        "trace_id": 12946851605156154441
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-10 07:07:03
success: True
trace_id: 12946851605156154441

Scan 161736241

duration: 0:00:14.713817

exit_message:

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

id: 161736241

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/incident__cs/2026-04-09/1775736309",
        "key": "raw/incident__cs/2026-04-09/1775736309/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10263859080174696887,
        "service_name": "drive-thru",
        "span_id": 4778692668490756629,
        "trace_id": 3776530951261486240
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-09 07:05:50
success: True
trace_id: 3776530951261486240

Scan 161681413

duration: 0:00:12.286531

exit_message:

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

id: 161681413

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/incident__cs/2026-04-08/1775649923",
        "key": "raw/incident__cs/2026-04-08/1775649923/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4440021431807688376,
        "service_name": "drive-thru",
        "span_id": 3817886981294568097,
        "trace_id": 5032230995140472687
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-08 07:07:08
success: True
trace_id: 5032230995140472687

Scan 161625153

duration: 0:00:12.274505

exit_message:

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

id: 161625153

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/incident__cs/2026-04-07/1775563496",
        "key": "raw/incident__cs/2026-04-07/1775563496/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11436180699021335180,
        "service_name": "drive-thru",
        "span_id": 9655970616054727417,
        "trace_id": 1162415848745257843
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-07 07:05:07
success: True
trace_id: 1162415848745257843

Scan 161567365

duration: 0:00:12.302912

exit_message:

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

id: 161567365

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/incident__cs/2026-04-06/1775477106",
        "key": "raw/incident__cs/2026-04-06/1775477106/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9678686067763771668,
        "service_name": "drive-thru",
        "span_id": 13290674435519682812,
        "trace_id": 16319767475940870905
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-06 07:11:19
success: True
trace_id: 16319767475940870905

Scan 161519973

duration: 0:00:14.767441

exit_message:

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

id: 161519973

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/incident__cs/2026-04-05/1775390652",
        "key": "raw/incident__cs/2026-04-05/1775390652/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6492896496417434972,
        "service_name": "drive-thru",
        "span_id": 842923425312197008,
        "trace_id": 13669989097814469880
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-05 07:05:17
success: True
trace_id: 13669989097814469880

Scan 161466452

duration: 0:00:14.582277

exit_message:

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

id: 161466452

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/incident__cs/2026-04-04/1775304422",
        "key": "raw/incident__cs/2026-04-04/1775304422/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2593301469083439895,
        "service_name": "drive-thru",
        "span_id": 17239831034480264366,
        "trace_id": 6684366922801516574
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-04 07:09:51
success: True
trace_id: 6684366922801516574

Scan 161408591

duration: 0:00:12.332420

exit_message:

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

id: 161408591

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/incident__cs/2026-04-03/1775217885",
        "key": "raw/incident__cs/2026-04-03/1775217885/incident__cs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_incident__cs",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10924104955777297540,
        "service_name": "drive-thru",
        "span_id": 4880870497380962661,
        "trace_id": 7579546400778023726
    }
}

running: False
schema_name_id: 1193
start_time: 2026-04-03 07:06:40
success: True
trace_id: 7579546400778023726

Partitions:

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

Schema:

attributes:

{
    "AccountId__c": "string",
    "Amount": "string",
    "CaseId__c": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContactId__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IncidentNotes__c": "string",
    "IsDeleted": "string",
    "IssueResolved__c": "string",
    "JiraIssueId__c": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

created: 2026-04-17 07:04:45

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-17/1776427479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__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:23:31",
        "disabled": false,
        "format": "raw",
        "id": 1193,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_incident__cs"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId__c": "string",
            "Amount": "string",
            "CaseId__c": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "ContactId__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IncidentNotes__c": "string",
            "IsDeleted": "string",
            "IssueResolved__c": "string",
            "JiraIssueId__c": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "OpportunityId": "string",
            "OwnerId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2026-04-17 07:04:45",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_incident__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 , `AccountId__c`  string , `CaseId__c`  string , `ContactId__c`  string , `IncidentNotes__c`  string , `IssueResolved__c`  string , `JiraIssueId__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/incident__cs/2026-04-17/1776427479'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_incident__cs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_incident__cs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}