Schema Info

Schema Name: sfdl_prod_csv.salesforce_case_histories

created: 2022-10-10 16:23:58
disabled: False
format: raw
id: 1195
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718113

created: 2026-04-17 07:07:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-17/1776427636'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-17/1776427636
id: 1718113
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 162173089
updated: 2026-04-17 07:07:44

Version 1716884

created: 2026-04-16 07:07:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-16/1776341125'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-16/1776341125
id: 1716884
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 162117374
updated: 2026-04-16 07:07:47

Version 1715661

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-15/1776254945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-15/1776254945
id: 1715661
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 162061801
updated: 2026-04-15 07:09:42

Version 1714493

created: 2026-04-14 07:07:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-14/1776168463'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-14/1776168463
id: 1714493
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 162006426
updated: 2026-04-14 07:08:10

Version 1713267

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-13/1776082052'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-13/1776082052
id: 1713267
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161948358
updated: 2026-04-13 07:08:13

Version 1712077

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-12/1775995744'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-12/1775995744
id: 1712077
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161899561
updated: 2026-04-12 07:09:32

Version 1710868

created: 2026-04-11 07:07:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-11/1775909134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-11/1775909134
id: 1710868
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161846878
updated: 2026-04-11 07:07:31

Version 1709685

created: 2026-04-10 07:06:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-10/1775822787'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-10/1775822787
id: 1709685
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161792085
updated: 2026-04-10 07:07:00

Version 1708545

created: 2026-04-09 07:07:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-09/1775736426'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-09/1775736426
id: 1708545
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161736281
updated: 2026-04-09 07:07:53

Version 1707357

created: 2026-04-08 07:07:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-08/1775649992'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-08/1775649992
id: 1707357
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161681422
updated: 2026-04-08 07:07:38

Version 1706166

created: 2026-04-07 07:07:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-07/1775563588'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-07/1775563588
id: 1706166
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161625212
updated: 2026-04-07 07:07:35

Version 1704961

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-06/1775477136'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-06/1775477136
id: 1704961
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161567385
updated: 2026-04-06 07:12:14

Version 1703721

created: 2026-04-05 07:06:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-05/1775390792'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-05/1775390792
id: 1703721
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161520006
updated: 2026-04-05 07:07:04

Version 1702534

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-04/1775304403'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-04/1775304403
id: 1702534
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161466403
updated: 2026-04-04 07:07:18

Version 1701386

created: 2026-04-03 07:07:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-03/1775218046'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/case_histories/2026-04-03/1775218046
id: 1701386
processed: 1

raw_data:

{
    "CaseId": 2,
    "CreatedById": 3,
    "CreatedDate": 4,
    "DataType": 6,
    "Field": 5,
    "Id": 0,
    "IsDeleted": 1,
    "NewValue": 8,
    "OldValue": 7
}

schema_attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1195
schema_scan_id: 161408617
updated: 2026-04-03 07:08:01

Schema Scans: 15

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

Scan 162173089

duration: 0:00:14.576145

exit_message:

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

id: 162173089

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/case_histories/2026-04-17/1776427636",
        "key": "raw/case_histories/2026-04-17/1776427636/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9972386186514081946,
        "service_name": "drive-thru",
        "span_id": 6791565486991649033,
        "trace_id": 5538510887653154609
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-17 07:07:30
success: True
trace_id: 5538510887653154609

Scan 162117374

duration: 0:00:12.143188

exit_message:

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

id: 162117374

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/case_histories/2026-04-16/1776341125",
        "key": "raw/case_histories/2026-04-16/1776341125/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4794217262088003291,
        "service_name": "drive-thru",
        "span_id": 15122972606257387553,
        "trace_id": 457130022115820799
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-16 07:07:34
success: True
trace_id: 457130022115820799

Scan 162061801

duration: 0:00:12.037844

exit_message:

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

id: 162061801

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/case_histories/2026-04-15/1776254945",
        "key": "raw/case_histories/2026-04-15/1776254945/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17783594449453050087,
        "service_name": "drive-thru",
        "span_id": 7856086965099833557,
        "trace_id": 14524769803233814528
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-15 07:09:30
success: True
trace_id: 14524769803233814528

Scan 162006426

duration: 0:00:14.531671

exit_message:

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

id: 162006426

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/case_histories/2026-04-14/1776168463",
        "key": "raw/case_histories/2026-04-14/1776168463/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1501116474904483297,
        "service_name": "drive-thru",
        "span_id": 3442507694099122919,
        "trace_id": 16369822619215199301
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-14 07:07:56
success: True
trace_id: 16369822619215199301

Scan 161948358

duration: 0:00:12.003841

exit_message:

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

id: 161948358

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/case_histories/2026-04-13/1776082052",
        "key": "raw/case_histories/2026-04-13/1776082052/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3142542074799540611,
        "service_name": "drive-thru",
        "span_id": 6123616055297343945,
        "trace_id": 17823961162252084766
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-13 07:08:01
success: True
trace_id: 17823961162252084766

Scan 161899561

duration: 0:00:14.563921

exit_message:

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

id: 161899561

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/case_histories/2026-04-12/1775995744",
        "key": "raw/case_histories/2026-04-12/1775995744/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3411717861977703920,
        "service_name": "drive-thru",
        "span_id": 16987111313506592692,
        "trace_id": 6564044585114641344
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-12 07:09:17
success: True
trace_id: 6564044585114641344

Scan 161846878

duration: 0:00:14.666411

exit_message:

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

id: 161846878

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/case_histories/2026-04-11/1775909134",
        "key": "raw/case_histories/2026-04-11/1775909134/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11890009502097280472,
        "service_name": "drive-thru",
        "span_id": 9514661192905434050,
        "trace_id": 2147555432472672109
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-11 07:07:16
success: True
trace_id: 2147555432472672109

Scan 161792085

duration: 0:00:12.157727

exit_message:

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

id: 161792085

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/case_histories/2026-04-10/1775822787",
        "key": "raw/case_histories/2026-04-10/1775822787/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6227713730683868084,
        "service_name": "drive-thru",
        "span_id": 11835859427756731217,
        "trace_id": 5280115919216017356
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-10 07:06:48
success: True
trace_id: 5280115919216017356

Scan 161736281

duration: 0:00:12.028524

exit_message:

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

id: 161736281

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/case_histories/2026-04-09/1775736426",
        "key": "raw/case_histories/2026-04-09/1775736426/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4774223924821481840,
        "service_name": "drive-thru",
        "span_id": 9217873254423843890,
        "trace_id": 17192491761775086313
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-09 07:07:41
success: True
trace_id: 17192491761775086313

Scan 161681422

duration: 0:00:14.689032

exit_message:

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

id: 161681422

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/case_histories/2026-04-08/1775649992",
        "key": "raw/case_histories/2026-04-08/1775649992/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13255936182384304587,
        "service_name": "drive-thru",
        "span_id": 6799392424852201762,
        "trace_id": 16067546221064683043
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-08 07:07:23
success: True
trace_id: 16067546221064683043

Scan 161625212

duration: 0:00:12.132306

exit_message:

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

id: 161625212

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/case_histories/2026-04-07/1775563588",
        "key": "raw/case_histories/2026-04-07/1775563588/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12761509849005828393,
        "service_name": "drive-thru",
        "span_id": 655034141772088108,
        "trace_id": 5389638586114103368
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-07 07:07:23
success: True
trace_id: 5389638586114103368

Scan 161567385

duration: 0:00:12.128800

exit_message:

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

id: 161567385

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/case_histories/2026-04-06/1775477136",
        "key": "raw/case_histories/2026-04-06/1775477136/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4949429436427602773,
        "service_name": "drive-thru",
        "span_id": 10427468639162686209,
        "trace_id": 9665590545804591676
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-06 07:12:02
success: True
trace_id: 9665590545804591676

Scan 161520006

duration: 0:00:14.503616

exit_message:

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

id: 161520006

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/case_histories/2026-04-05/1775390792",
        "key": "raw/case_histories/2026-04-05/1775390792/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13405989386835400850,
        "service_name": "drive-thru",
        "span_id": 4026653297478605774,
        "trace_id": 3342985672703480328
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-05 07:06:49
success: True
trace_id: 3342985672703480328

Scan 161466403

duration: 0:00:14.518634

exit_message:

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

id: 161466403

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/case_histories/2026-04-04/1775304403",
        "key": "raw/case_histories/2026-04-04/1775304403/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12401001073624728793,
        "service_name": "drive-thru",
        "span_id": 13678587745669385787,
        "trace_id": 16246091287760467831
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-04 07:07:04
success: True
trace_id: 16246091287760467831

Scan 161408617

duration: 0:00:14.590256

exit_message:

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

id: 161408617

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/case_histories/2026-04-03/1775218046",
        "key": "raw/case_histories/2026-04-03/1775218046/case_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_case_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15760078354056669695,
        "service_name": "drive-thru",
        "span_id": 13851628592234116406,
        "trace_id": 7990679466801881380
    }
}

running: False
schema_name_id: 1195
start_time: 2026-04-03 07:07:46
success: True
trace_id: 7990679466801881380

Partitions:

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

Schema:

attributes:

{
    "Amount": "string",
    "CaseId": "string",
    "CloseDate": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "DataType": "string",
    "ExpectedRevenue": "string",
    "Field": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

created: 2026-04-17 07:07:31

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-17/1776427636'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
}

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:58",
        "disabled": false,
        "format": "raw",
        "id": 1195,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_case_histories"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "CaseId": "string",
            "CloseDate": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "DataType": "string",
            "ExpectedRevenue": "string",
            "Field": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "NewValue": "string",
            "OldValue": "string",
            "OpportunityId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2026-04-17 07:07:31",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_case_histories`\n(\n `Id`  string , `IsDeleted`  string , `CaseId`  string , `CreatedById`  string , `CreatedDate`  string , `Field`  string , `DataType`  string , `OldValue`  string , `NewValue`  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/case_histories/2026-04-17/1776427636'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_case_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_case_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}