Schema Info

Schema Name: sfdl_prod_csv.salesforce_entitlements

created: 2022-10-10 16:22:49
disabled: False
format: raw
id: 1185
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718087

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-17/1776427503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-17/1776427503
id: 1718087
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 162173054
updated: 2026-04-17 07:06:29

Version 1716859

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-16/1776341099'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

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

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 162117334
updated: 2026-04-16 07:06:37

Version 1715625

created: 2026-04-15 07:05:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-15/1776254710'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-15/1776254710
id: 1715625
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 162061755
updated: 2026-04-15 07:05:26

Version 1714460

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-14/1776168331'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-14/1776168331
id: 1714460
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 162006374
updated: 2026-04-14 07:06:34

Version 1713242

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-13/1776081915'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-13/1776081915
id: 1713242
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161948320
updated: 2026-04-13 07:07:00

Version 1712047

created: 2026-04-12 07:07:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-12/1775995647'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-12/1775995647
id: 1712047
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161899529
updated: 2026-04-12 07:07:46

Version 1710863

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-11/1775909087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-11/1775909087
id: 1710863
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161846870
updated: 2026-04-11 07:07:11

Version 1709641

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-10/1775822678'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-10/1775822678
id: 1709641
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161792031
updated: 2026-04-10 07:04:55

Version 1708527

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-09/1775736316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-09/1775736316
id: 1708527
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161736260
updated: 2026-04-09 07:06:54

Version 1707352

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-08/1775649934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-08/1775649934
id: 1707352
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161681414
updated: 2026-04-08 07:07:21

Version 1706143

created: 2026-04-07 07:06:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-07/1775563516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-07/1775563516
id: 1706143
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161625181
updated: 2026-04-07 07:06:32

Version 1704926

created: 2026-04-06 07:09:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-06/1775477105'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-06/1775477105
id: 1704926
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161567335
updated: 2026-04-06 07:09:31

Version 1703681

created: 2026-04-05 07:04:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-05/1775390664'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-05/1775390664
id: 1703681
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161519961
updated: 2026-04-05 07:04:55

Version 1702581

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-04/1775304425'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-04/1775304425
id: 1702581
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161466456
updated: 2026-04-04 07:10:20

Version 1701337

created: 2026-04-03 07:04:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-03/1775217844'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-03/1775217844
id: 1701337
processed: 1

raw_data:

{
    "AccountId": 10,
    "AssetId": 14,
    "BusinessHoursId": 18,
    "CasesPerEntitlement": 20,
    "ContractLineItemId": 13,
    "CreatedById": 6,
    "CreatedDate": 5,
    "CurrencyIsoCode": 3,
    "Data_Load_By__c": 25,
    "EndDate": 16,
    "Id": 0,
    "IsDeleted": 1,
    "IsPerIncident": 19,
    "LastModifiedById": 8,
    "LastModifiedDate": 7,
    "LocationId": 24,
    "Name": 2,
    "RecordTypeId": 4,
    "RemainingCases": 21,
    "ServiceContractId": 12,
    "SlaProcessId": 17,
    "StartDate": 15,
    "Status": 22,
    "SvcApptBookingWindowsId": 23,
    "SystemModstamp": 9,
    "Type": 11
}

schema_attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

schema_name_id: 1185
schema_scan_id: 161408538
updated: 2026-04-03 07:04:43

Schema Scans: 15

Last at 2026-04-17 07:06:14

Scan 162173054

duration: 0:00:14.910517

exit_message:

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

id: 162173054

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/entitlements/2026-04-17/1776427503",
        "key": "raw/entitlements/2026-04-17/1776427503/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16445123450137103767,
        "service_name": "drive-thru",
        "span_id": 14161571271357575288,
        "trace_id": 6882735417871939460
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-17 07:06:14
success: True
trace_id: 6882735417871939460

Scan 162117334

duration: 0:00:12.496120

exit_message:

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

id: 162117334

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/entitlements/2026-04-16/1776341099",
        "key": "raw/entitlements/2026-04-16/1776341099/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10820621897872198945,
        "service_name": "drive-thru",
        "span_id": 15203861543514752968,
        "trace_id": 10040130454385316508
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-16 07:06:25
success: True
trace_id: 10040130454385316508

Scan 162061755

duration: 0:00:12.481271

exit_message:

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

id: 162061755

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/entitlements/2026-04-15/1776254710",
        "key": "raw/entitlements/2026-04-15/1776254710/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17480765194990638961,
        "service_name": "drive-thru",
        "span_id": 16686716981125665568,
        "trace_id": 6468690906458152453
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-15 07:05:13
success: True
trace_id: 6468690906458152453

Scan 162006374

duration: 0:00:15.162887

exit_message:

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

id: 162006374

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/entitlements/2026-04-14/1776168331",
        "key": "raw/entitlements/2026-04-14/1776168331/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18407358581803269756,
        "service_name": "drive-thru",
        "span_id": 16870928049343515074,
        "trace_id": 7184580279405173916
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-14 07:06:19
success: True
trace_id: 7184580279405173916

Scan 161948320

duration: 0:00:15.037158

exit_message:

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

id: 161948320

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/entitlements/2026-04-13/1776081915",
        "key": "raw/entitlements/2026-04-13/1776081915/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7920480077113924194,
        "service_name": "drive-thru",
        "span_id": 15747007421420391523,
        "trace_id": 11699904913166841862
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-13 07:06:45
success: True
trace_id: 11699904913166841862

Scan 161899529

duration: 0:00:14.855698

exit_message:

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

id: 161899529

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/entitlements/2026-04-12/1775995647",
        "key": "raw/entitlements/2026-04-12/1775995647/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16846182580000968852,
        "service_name": "drive-thru",
        "span_id": 9120857307209278914,
        "trace_id": 6254869243383982388
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-12 07:07:31
success: True
trace_id: 6254869243383982388

Scan 161846870

duration: 0:00:15.118965

exit_message:

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

id: 161846870

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/entitlements/2026-04-11/1775909087",
        "key": "raw/entitlements/2026-04-11/1775909087/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3031995906655029477,
        "service_name": "drive-thru",
        "span_id": 7499406378607064013,
        "trace_id": 8098415069103547086
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-11 07:06:55
success: True
trace_id: 8098415069103547086

Scan 161792031

duration: 0:00:12.372022

exit_message:

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

id: 161792031

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/entitlements/2026-04-10/1775822678",
        "key": "raw/entitlements/2026-04-10/1775822678/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 973132614197155051,
        "service_name": "drive-thru",
        "span_id": 10982225951556395806,
        "trace_id": 1275321388605199451
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-10 07:04:43
success: True
trace_id: 1275321388605199451

Scan 161736260

duration: 0:00:15.024673

exit_message:

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

id: 161736260

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/entitlements/2026-04-09/1775736316",
        "key": "raw/entitlements/2026-04-09/1775736316/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18055292476689473035,
        "service_name": "drive-thru",
        "span_id": 8852582502251448645,
        "trace_id": 18247802022691515598
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-09 07:06:39
success: True
trace_id: 18247802022691515598

Scan 161681414

duration: 0:00:12.596316

exit_message:

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

id: 161681414

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/entitlements/2026-04-08/1775649934",
        "key": "raw/entitlements/2026-04-08/1775649934/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10306088449210006791,
        "service_name": "drive-thru",
        "span_id": 1608825440588019565,
        "trace_id": 1924494413550081076
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-08 07:07:09
success: True
trace_id: 1924494413550081076

Scan 161625181

duration: 0:00:12.432046

exit_message:

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

id: 161625181

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/entitlements/2026-04-07/1775563516",
        "key": "raw/entitlements/2026-04-07/1775563516/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5191535515763483598,
        "service_name": "drive-thru",
        "span_id": 8496918262410469011,
        "trace_id": 16667787101981847865
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-07 07:06:20
success: True
trace_id: 16667787101981847865

Scan 161567335

duration: 0:00:14.938157

exit_message:

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

id: 161567335

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/entitlements/2026-04-06/1775477105",
        "key": "raw/entitlements/2026-04-06/1775477105/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7887751966544440821,
        "service_name": "drive-thru",
        "span_id": 15931586176841220359,
        "trace_id": 14684625977545706028
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-06 07:09:17
success: True
trace_id: 14684625977545706028

Scan 161519961

duration: 0:00:14.980424

exit_message:

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

id: 161519961

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/entitlements/2026-04-05/1775390664",
        "key": "raw/entitlements/2026-04-05/1775390664/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6110621486832721117,
        "service_name": "drive-thru",
        "span_id": 9322438221927087066,
        "trace_id": 14740763559037723668
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-05 07:04:40
success: True
trace_id: 14740763559037723668

Scan 161466456

duration: 0:00:14.916903

exit_message:

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

id: 161466456

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/entitlements/2026-04-04/1775304425",
        "key": "raw/entitlements/2026-04-04/1775304425/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8724843591734957677,
        "service_name": "drive-thru",
        "span_id": 11423279342314736001,
        "trace_id": 2803364859968891025
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-04 07:10:06
success: True
trace_id: 2803364859968891025

Scan 161408538

duration: 0:00:15.144903

exit_message:

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

id: 161408538

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/entitlements/2026-04-03/1775217844",
        "key": "raw/entitlements/2026-04-03/1775217844/entitlements.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_entitlements",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5469014820313878938,
        "service_name": "drive-thru",
        "span_id": 5449344430226675088,
        "trace_id": 10958046078959073043
    }
}

running: False
schema_name_id: 1185
start_time: 2026-04-03 07:04:28
success: True
trace_id: 10958046078959073043

Partitions:

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

Schema:

attributes:

{
    "AccountId": "string",
    "Amount": "string",
    "AssetId": "string",
    "BusinessHoursId": "string",
    "CasesPerEntitlement": "string",
    "CloseDate": "string",
    "ContractLineItemId": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "EndDate": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPerIncident": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LocationId": "string",
    "Name": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "RecordTypeId": "string",
    "RemainingCases": "string",
    "ServiceContractId": "string",
    "SlaProcessId": "string",
    "StageName": "string",
    "StartDate": "string",
    "Status": "string",
    "SvcApptBookingWindowsId": "string",
    "SystemModstamp": "string",
    "Type": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-17/1776427503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
}

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:22:49",
        "disabled": false,
        "format": "raw",
        "id": 1185,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_entitlements"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "Amount": "string",
            "AssetId": "string",
            "BusinessHoursId": "string",
            "CasesPerEntitlement": "string",
            "CloseDate": "string",
            "ContractLineItemId": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Data_Load_By__c": "string",
            "EndDate": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "IsPerIncident": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LocationId": "string",
            "Name": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "RecordTypeId": "string",
            "RemainingCases": "string",
            "ServiceContractId": "string",
            "SlaProcessId": "string",
            "StageName": "string",
            "StartDate": "string",
            "Status": "string",
            "SvcApptBookingWindowsId": "string",
            "SystemModstamp": "string",
            "Type": "string"
        },
        "created": "2026-04-17 07:06:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_entitlements`\n(\n `Id`  string , `IsDeleted`  string , `Name`  string , `CurrencyIsoCode`  string , `RecordTypeId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `AccountId`  string , `Type`  string , `ServiceContractId`  string , `ContractLineItemId`  string , `AssetId`  string , `StartDate`  string , `EndDate`  string , `SlaProcessId`  string , `BusinessHoursId`  string , `IsPerIncident`  string , `CasesPerEntitlement`  string , `RemainingCases`  string , `Status`  string , `SvcApptBookingWindowsId`  string , `LocationId`  string , `Data_Load_By__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/entitlements/2026-04-17/1776427503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_entitlements`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_entitlements"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}