Schema Info

Schema Name: sfdl_prod_csv.salesforce_contact_histories

created: 2022-10-10 16:22:28
disabled: False
format: raw
id: 1181
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718095

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-17/1776427513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-17/1776427513
id: 1718095
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 162173065
updated: 2026-04-17 07:06:50

Version 1716856

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-16/1776341109'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-16/1776341109
id: 1716856
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 162117331
updated: 2026-04-16 07:06:31

Version 1715654

created: 2026-04-15 07:08:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-15/1776254793'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-15/1776254793
id: 1715654
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 162061793
updated: 2026-04-15 07:09:04

Version 1714444

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-14/1776168288'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-14/1776168288
id: 1714444
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 162006357
updated: 2026-04-14 07:05:42

Version 1713214

created: 2026-04-13 07:04:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-13/1776081885'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-13/1776081885
id: 1713214
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161948287
updated: 2026-04-13 07:05:12

Version 1712057

created: 2026-04-12 07:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-12/1775995686'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-12/1775995686
id: 1712057
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161899541
updated: 2026-04-12 07:08:25

Version 1710860

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-11/1775909042'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-11/1775909042
id: 1710860
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161846868
updated: 2026-04-11 07:06:57

Version 1709639

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-10/1775822656'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-10/1775822656
id: 1709639
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161792029
updated: 2026-04-10 07:04:48

Version 1708509

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-09/1775736320'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-09/1775736320
id: 1708509
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161736235
updated: 2026-04-09 07:05:53

Version 1707340

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-08/1775649914'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-08/1775649914
id: 1707340
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161681398
updated: 2026-04-08 07:06:55

Version 1706138

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-07/1775563492'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-07/1775563492
id: 1706138
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161625174
updated: 2026-04-07 07:06:20

Version 1704960

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-06/1775477133'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-06/1775477133
id: 1704960
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161567377
updated: 2026-04-06 07:12:01

Version 1703720

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-05/1775390687'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-05/1775390687
id: 1703720
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161520005
updated: 2026-04-05 07:07:01

Version 1702564

created: 2026-04-04 07:09:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-04/1775304403'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

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

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161466436
updated: 2026-04-04 07:09:14

Version 1701342

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-03/1775217872'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/contact_histories/2026-04-03/1775217872
id: 1701342
processed: 1

raw_data:

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

schema_attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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: 1181
schema_scan_id: 161408544
updated: 2026-04-03 07:05:01

Schema Scans: 15

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

Scan 162173065

duration: 0:00:12.022088

exit_message:

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

id: 162173065

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/contact_histories/2026-04-17/1776427513",
        "key": "raw/contact_histories/2026-04-17/1776427513/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6914546769141030252,
        "service_name": "drive-thru",
        "span_id": 8576676516951910825,
        "trace_id": 10887861735186107641
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-17 07:06:38
success: True
trace_id: 10887861735186107641

Scan 162117331

duration: 0:00:14.668500

exit_message:

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

id: 162117331

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/contact_histories/2026-04-16/1776341109",
        "key": "raw/contact_histories/2026-04-16/1776341109/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12227684092140963661,
        "service_name": "drive-thru",
        "span_id": 5912637798296532165,
        "trace_id": 3969308825420500461
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-16 07:06:16
success: True
trace_id: 3969308825420500461

Scan 162061793

duration: 0:00:14.602976

exit_message:

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

id: 162061793

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/contact_histories/2026-04-15/1776254793",
        "key": "raw/contact_histories/2026-04-15/1776254793/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2829376232359245293,
        "service_name": "drive-thru",
        "span_id": 5640606202399051042,
        "trace_id": 6777918210724616283
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-15 07:08:49
success: True
trace_id: 6777918210724616283

Scan 162006357

duration: 0:00:12.086657

exit_message:

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

id: 162006357

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/contact_histories/2026-04-14/1776168288",
        "key": "raw/contact_histories/2026-04-14/1776168288/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9458836047459084849,
        "service_name": "drive-thru",
        "span_id": 13291835473377744219,
        "trace_id": 3754587210184267540
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-14 07:05:30
success: True
trace_id: 3754587210184267540

Scan 161948287

duration: 0:00:14.514042

exit_message:

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

id: 161948287

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/contact_histories/2026-04-13/1776081885",
        "key": "raw/contact_histories/2026-04-13/1776081885/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10038056630027811501,
        "service_name": "drive-thru",
        "span_id": 5944311838639219024,
        "trace_id": 2158121212606199267
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-13 07:04:57
success: True
trace_id: 2158121212606199267

Scan 161899541

duration: 0:00:14.483701

exit_message:

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

id: 161899541

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/contact_histories/2026-04-12/1775995686",
        "key": "raw/contact_histories/2026-04-12/1775995686/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15742595104612045517,
        "service_name": "drive-thru",
        "span_id": 6853099299282174537,
        "trace_id": 11096614835686074994
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-12 07:08:10
success: True
trace_id: 11096614835686074994

Scan 161846868

duration: 0:00:14.841823

exit_message:

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

id: 161846868

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/contact_histories/2026-04-11/1775909042",
        "key": "raw/contact_histories/2026-04-11/1775909042/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10840406593703713576,
        "service_name": "drive-thru",
        "span_id": 16982283710639297968,
        "trace_id": 8025836968216211050
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-11 07:06:43
success: True
trace_id: 8025836968216211050

Scan 161792029

duration: 0:00:12.335584

exit_message:

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

id: 161792029

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/contact_histories/2026-04-10/1775822656",
        "key": "raw/contact_histories/2026-04-10/1775822656/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1733205811992508010,
        "service_name": "drive-thru",
        "span_id": 487842194508511701,
        "trace_id": 6394145054874651675
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-10 07:04:36
success: True
trace_id: 6394145054874651675

Scan 161736235

duration: 0:00:14.573309

exit_message:

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

id: 161736235

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/contact_histories/2026-04-09/1775736320",
        "key": "raw/contact_histories/2026-04-09/1775736320/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10177521511539683904,
        "service_name": "drive-thru",
        "span_id": 12988579826338650633,
        "trace_id": 11543414480072353673
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-09 07:05:38
success: True
trace_id: 11543414480072353673

Scan 161681398

duration: 0:00:14.632936

exit_message:

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

id: 161681398

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/contact_histories/2026-04-08/1775649914",
        "key": "raw/contact_histories/2026-04-08/1775649914/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16265905379398386683,
        "service_name": "drive-thru",
        "span_id": 17607195715305932716,
        "trace_id": 10415331435416497614
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-08 07:06:40
success: True
trace_id: 10415331435416497614

Scan 161625174

duration: 0:00:14.550431

exit_message:

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

id: 161625174

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/contact_histories/2026-04-07/1775563492",
        "key": "raw/contact_histories/2026-04-07/1775563492/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13876611609921115862,
        "service_name": "drive-thru",
        "span_id": 1980166225851621439,
        "trace_id": 15931387304816309570
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-07 07:06:05
success: True
trace_id: 15931387304816309570

Scan 161567377

duration: 0:00:12.169021

exit_message:

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

id: 161567377

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/contact_histories/2026-04-06/1775477133",
        "key": "raw/contact_histories/2026-04-06/1775477133/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12563141251880435566,
        "service_name": "drive-thru",
        "span_id": 15636160410114338961,
        "trace_id": 14546019601348902997
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-06 07:11:49
success: True
trace_id: 14546019601348902997

Scan 161520005

duration: 0:00:14.587683

exit_message:

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

id: 161520005

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/contact_histories/2026-04-05/1775390687",
        "key": "raw/contact_histories/2026-04-05/1775390687/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12472301783084816849,
        "service_name": "drive-thru",
        "span_id": 10931068897944607548,
        "trace_id": 16325245493739069556
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-05 07:06:47
success: True
trace_id: 16325245493739069556

Scan 161466436

duration: 0:00:12.080691

exit_message:

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

id: 161466436

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/contact_histories/2026-04-04/1775304403",
        "key": "raw/contact_histories/2026-04-04/1775304403/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10853836020012597127,
        "service_name": "drive-thru",
        "span_id": 6982734188490743468,
        "trace_id": 13891304243149921850
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-04 07:09:02
success: True
trace_id: 13891304243149921850

Scan 161408544

duration: 0:00:14.587163

exit_message:

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

id: 161408544

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/contact_histories/2026-04-03/1775217872",
        "key": "raw/contact_histories/2026-04-03/1775217872/contact_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_contact_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2398659240673937402,
        "service_name": "drive-thru",
        "span_id": 6648439649287867675,
        "trace_id": 14659688569805334370
    }
}

running: False
schema_name_id: 1181
start_time: 2026-04-03 07:04:46
success: True
trace_id: 14659688569805334370

Partitions:

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

Schema:

attributes:

{
    "Amount": "string",
    "CloseDate": "string",
    "ContactId": "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:06:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-17/1776427513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_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:22:28",
        "disabled": false,
        "format": "raw",
        "id": 1181,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_contact_histories"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "CloseDate": "string",
            "ContactId": "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:06:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_contact_histories`\n(\n `Id`  string , `IsDeleted`  string , `ContactId`  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/contact_histories/2026-04-17/1776427513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_contact_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_contact_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}