Schema Info

Schema Name: sfdl_prod_csv.salesforce_account_histories

created: 2022-10-10 16:22:00
disabled: False
format: raw
id: 1173
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718106

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-17/1776427521
id: 1718106
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 162173078
updated: 2026-04-17 07:07:17

Version 1716854

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-16/1776341095
id: 1716854
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 162117327
updated: 2026-04-16 07:06:26

Version 1715630

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-15/1776254731
id: 1715630
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 162061762
updated: 2026-04-15 07:06:05

Version 1714467

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-14/1776168335
id: 1714467
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 162006381
updated: 2026-04-14 07:06:48

Version 1713248

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-13/1776081892
id: 1713248
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161948327
updated: 2026-04-13 07:07:17

Version 1712072

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-12/1775995721
id: 1712072
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161899557
updated: 2026-04-12 07:09:18

Version 1710822

created: 2026-04-11 07:04:18

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-11/1775909048
id: 1710822
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161846831
updated: 2026-04-11 07:04:29

Version 1709684

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-10/1775822727
id: 1709684
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161792084
updated: 2026-04-10 07:06:59

Version 1708542

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-09/1775736333
id: 1708542
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161736278
updated: 2026-04-09 07:07:45

Version 1707362

created: 2026-04-08 07:07:40

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-08/1775649928
id: 1707362
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161681432
updated: 2026-04-08 07:07:51

Version 1706156

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-07/1775563523
id: 1706156
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161625198
updated: 2026-04-07 07:07:09

Version 1704956

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-06/1775477113
id: 1704956
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161567373
updated: 2026-04-06 07:11:49

Version 1703710

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-05/1775390673
id: 1703710
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161519993
updated: 2026-04-05 07:06:26

Version 1702549

created: 2026-04-04 07:08:01

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-04/1775304415
id: 1702549
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161466419
updated: 2026-04-04 07:08:14

Version 1701338

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/account_histories/2026-04-03/1775217850
id: 1701338
processed: 1

raw_data:

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

schema_attributes:

{
    "AccountId": "string",
    "Amount": "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: 1173
schema_scan_id: 161408539
updated: 2026-04-03 07:04:44

Schema Scans: 15

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

Scan 162173078

duration: 0:00:12.054279

exit_message:

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

id: 162173078

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/account_histories/2026-04-17/1776427521",
        "key": "raw/account_histories/2026-04-17/1776427521/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3419804187625646676,
        "service_name": "drive-thru",
        "span_id": 10583524104738467164,
        "trace_id": 10986604697694477865
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-17 07:07:05
success: True
trace_id: 10986604697694477865

Scan 162117327

duration: 0:00:14.712371

exit_message:

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

id: 162117327

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/account_histories/2026-04-16/1776341095",
        "key": "raw/account_histories/2026-04-16/1776341095/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12347458013221965144,
        "service_name": "drive-thru",
        "span_id": 16593859727400939347,
        "trace_id": 11886913555779534482
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-16 07:06:11
success: True
trace_id: 11886913555779534482

Scan 162061762

duration: 0:00:14.447266

exit_message:

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

id: 162061762

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/account_histories/2026-04-15/1776254731",
        "key": "raw/account_histories/2026-04-15/1776254731/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1144704665090700001,
        "service_name": "drive-thru",
        "span_id": 4778560401684941861,
        "trace_id": 7285883890106821089
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-15 07:05:50
success: True
trace_id: 7285883890106821089

Scan 162006381

duration: 0:00:12.019371

exit_message:

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

id: 162006381

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/account_histories/2026-04-14/1776168335",
        "key": "raw/account_histories/2026-04-14/1776168335/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5881993447291409902,
        "service_name": "drive-thru",
        "span_id": 11356435808208014414,
        "trace_id": 16829369032249427018
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-14 07:06:36
success: True
trace_id: 16829369032249427018

Scan 161948327

duration: 0:00:14.680904

exit_message:

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

id: 161948327

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/account_histories/2026-04-13/1776081892",
        "key": "raw/account_histories/2026-04-13/1776081892/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14363505911026862331,
        "service_name": "drive-thru",
        "span_id": 16171328530603360778,
        "trace_id": 17125163455265990867
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-13 07:07:03
success: True
trace_id: 17125163455265990867

Scan 161899557

duration: 0:00:14.405953

exit_message:

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

id: 161899557

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/account_histories/2026-04-12/1775995721",
        "key": "raw/account_histories/2026-04-12/1775995721/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14655575648048281142,
        "service_name": "drive-thru",
        "span_id": 14734275379699723426,
        "trace_id": 14708916314493670906
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-12 07:09:04
success: True
trace_id: 14708916314493670906

Scan 161846831

duration: 0:00:11.929370

exit_message:

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

id: 161846831

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/account_histories/2026-04-11/1775909048",
        "key": "raw/account_histories/2026-04-11/1775909048/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17688259179556405182,
        "service_name": "drive-thru",
        "span_id": 8792280755805984790,
        "trace_id": 14736853468821390553
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-11 07:04:17
success: True
trace_id: 14736853468821390553

Scan 161792084

duration: 0:00:12.280145

exit_message:

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

id: 161792084

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/account_histories/2026-04-10/1775822727",
        "key": "raw/account_histories/2026-04-10/1775822727/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4140846968812113744,
        "service_name": "drive-thru",
        "span_id": 4439872795933203078,
        "trace_id": 11278924186432067876
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-10 07:06:47
success: True
trace_id: 11278924186432067876

Scan 161736278

duration: 0:00:14.574679

exit_message:

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

id: 161736278

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/account_histories/2026-04-09/1775736333",
        "key": "raw/account_histories/2026-04-09/1775736333/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17059022787354344464,
        "service_name": "drive-thru",
        "span_id": 12329627845334790541,
        "trace_id": 15005880111255669728
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-09 07:07:30
success: True
trace_id: 15005880111255669728

Scan 161681432

duration: 0:00:11.986402

exit_message:

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

id: 161681432

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/account_histories/2026-04-08/1775649928",
        "key": "raw/account_histories/2026-04-08/1775649928/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1196278857454489598,
        "service_name": "drive-thru",
        "span_id": 4939874378705330390,
        "trace_id": 7129496899078441432
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-08 07:07:39
success: True
trace_id: 7129496899078441432

Scan 161625198

duration: 0:00:14.677758

exit_message:

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

id: 161625198

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/account_histories/2026-04-07/1775563523",
        "key": "raw/account_histories/2026-04-07/1775563523/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5212305677794829871,
        "service_name": "drive-thru",
        "span_id": 16445659735043460404,
        "trace_id": 5106508351817337628
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-07 07:06:55
success: True
trace_id: 5106508351817337628

Scan 161567373

duration: 0:00:12.052883

exit_message:

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

id: 161567373

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/account_histories/2026-04-06/1775477113",
        "key": "raw/account_histories/2026-04-06/1775477113/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16676417388960472766,
        "service_name": "drive-thru",
        "span_id": 2117820991927258856,
        "trace_id": 6346766696977822547
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-06 07:11:37
success: True
trace_id: 6346766696977822547

Scan 161519993

duration: 0:00:12.127044

exit_message:

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

id: 161519993

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/account_histories/2026-04-05/1775390673",
        "key": "raw/account_histories/2026-04-05/1775390673/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16478799759044916278,
        "service_name": "drive-thru",
        "span_id": 11276623362304408504,
        "trace_id": 909742313978840877
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-05 07:06:13
success: True
trace_id: 909742313978840877

Scan 161466419

duration: 0:00:14.589070

exit_message:

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

id: 161466419

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/account_histories/2026-04-04/1775304415",
        "key": "raw/account_histories/2026-04-04/1775304415/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10899264469961756504,
        "service_name": "drive-thru",
        "span_id": 7139642648945045373,
        "trace_id": 12870715149792990289
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-04 07:08:00
success: True
trace_id: 12870715149792990289

Scan 161408539

duration: 0:00:14.527706

exit_message:

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

id: 161408539

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/account_histories/2026-04-03/1775217850",
        "key": "raw/account_histories/2026-04-03/1775217850/account_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_account_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1357603504521288265,
        "service_name": "drive-thru",
        "span_id": 10532687055957916049,
        "trace_id": 7661263766021269191
    }
}

running: False
schema_name_id: 1173
start_time: 2026-04-03 07:04:30
success: True
trace_id: 7661263766021269191

Partitions:

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

Schema:

attributes:

{
    "AccountId": "string",
    "Amount": "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:06

ddl:

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