Schema Info

Schema Name: sfdl_prod_csv.salesforce_attachments

created: 2022-10-10 16:21:37
disabled: False
format: raw
id: 1166
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718092

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-17/1776427507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-17/1776427507
id: 1718092
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 162173058
updated: 2026-04-17 07:06:38

Version 1716872

created: 2026-04-16 07:07:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-16/1776341119'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-16/1776341119
id: 1716872
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 162117356
updated: 2026-04-16 07:07:16

Version 1715663

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-15/1776254789'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-15/1776254789
id: 1715663
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 162061803
updated: 2026-04-15 07:09:50

Version 1714452

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-14/1776168324'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-14/1776168324
id: 1714452
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 162006367
updated: 2026-04-14 07:06:11

Version 1713265

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-13/1776081927'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-13/1776081927
id: 1713265
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161948352
updated: 2026-04-13 07:08:08

Version 1712067

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-12/1775995697'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-12/1775995697
id: 1712067
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161899551
updated: 2026-04-12 07:08:56

Version 1710839

created: 2026-04-11 07:05:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-11/1775909056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-11/1775909056
id: 1710839
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161846848
updated: 2026-04-11 07:05:33

Version 1709673

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-10/1775822737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-10/1775822737
id: 1709673
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161792072
updated: 2026-04-10 07:06:35

Version 1708495

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-09/1775736288'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-09/1775736288
id: 1708495
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161736215
updated: 2026-04-09 07:05:11

Version 1707345

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-08/1775649919'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-08/1775649919
id: 1707345
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161681404
updated: 2026-04-08 07:07:08

Version 1706168

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-07/1775563530'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-07/1775563530
id: 1706168
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161625219
updated: 2026-04-07 07:07:39

Version 1704958

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-06/1775477132'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-06/1775477132
id: 1704958
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161567375
updated: 2026-04-06 07:12:00

Version 1703711

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-05/1775390676'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-05/1775390676
id: 1703711
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161519995
updated: 2026-04-05 07:06:34

Version 1702561

created: 2026-04-04 07:08:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-04/1775304407'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-04/1775304407
id: 1702561
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161466432
updated: 2026-04-04 07:09:00

Version 1701377

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-03/1775217875'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/attachments/2026-04-03/1775217875
id: 1701377
processed: 1

raw_data:

{
    "BodyLength": 6,
    "ConnectionReceivedId": 15,
    "ConnectionSentId": 16,
    "ContentType": 5,
    "CreatedById": 9,
    "CreatedDate": 8,
    "Description": 13,
    "Id": 0,
    "IsDeleted": 1,
    "IsPartnerShared": 14,
    "IsPrivate": 4,
    "LastModifiedById": 11,
    "LastModifiedDate": 10,
    "Name": 3,
    "OwnerId": 7,
    "ParentId": 2,
    "SystemModstamp": 12
}

schema_attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

schema_name_id: 1166
schema_scan_id: 161408588
updated: 2026-04-03 07:06:48

Schema Scans: 15

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

Scan 162173058

duration: 0:00:12.289698

exit_message:

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

id: 162173058

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/attachments/2026-04-17/1776427507",
        "key": "raw/attachments/2026-04-17/1776427507/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6947936783439139094,
        "service_name": "drive-thru",
        "span_id": 14894847819936919209,
        "trace_id": 4603167623303859469
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-17 07:06:26
success: True
trace_id: 4603167623303859469

Scan 162117356

duration: 0:00:14.755007

exit_message:

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

id: 162117356

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/attachments/2026-04-16/1776341119",
        "key": "raw/attachments/2026-04-16/1776341119/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6620255517089204086,
        "service_name": "drive-thru",
        "span_id": 8244557380199681876,
        "trace_id": 11854460376767425657
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-16 07:07:01
success: True
trace_id: 11854460376767425657

Scan 162061803

duration: 0:00:14.673258

exit_message:

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

id: 162061803

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/attachments/2026-04-15/1776254789",
        "key": "raw/attachments/2026-04-15/1776254789/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 499291753083922342,
        "service_name": "drive-thru",
        "span_id": 18119292829457570749,
        "trace_id": 6889683912790368399
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-15 07:09:36
success: True
trace_id: 6889683912790368399

Scan 162006367

duration: 0:00:14.803257

exit_message:

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

id: 162006367

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/attachments/2026-04-14/1776168324",
        "key": "raw/attachments/2026-04-14/1776168324/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12562747344333236678,
        "service_name": "drive-thru",
        "span_id": 12835018063446586226,
        "trace_id": 13117765803162743902
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-14 07:05:57
success: True
trace_id: 13117765803162743902

Scan 161948352

duration: 0:00:14.948764

exit_message:

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

id: 161948352

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/attachments/2026-04-13/1776081927",
        "key": "raw/attachments/2026-04-13/1776081927/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14998125644620715171,
        "service_name": "drive-thru",
        "span_id": 8635245753775507130,
        "trace_id": 7259701984817920962
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-13 07:07:53
success: True
trace_id: 7259701984817920962

Scan 161899551

duration: 0:00:14.809462

exit_message:

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

id: 161899551

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/attachments/2026-04-12/1775995697",
        "key": "raw/attachments/2026-04-12/1775995697/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4502200097738795659,
        "service_name": "drive-thru",
        "span_id": 12360834940726124559,
        "trace_id": 9924889188597522034
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-12 07:08:42
success: True
trace_id: 9924889188597522034

Scan 161846848

duration: 0:00:14.827516

exit_message:

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

id: 161846848

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/attachments/2026-04-11/1775909056",
        "key": "raw/attachments/2026-04-11/1775909056/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13717259982474766310,
        "service_name": "drive-thru",
        "span_id": 16840449245127135053,
        "trace_id": 7823151486633346933
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-11 07:05:18
success: True
trace_id: 7823151486633346933

Scan 161792072

duration: 0:00:12.105906

exit_message:

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

id: 161792072

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/attachments/2026-04-10/1775822737",
        "key": "raw/attachments/2026-04-10/1775822737/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4198591547680294037,
        "service_name": "drive-thru",
        "span_id": 13336524419403596259,
        "trace_id": 11963688493098294954
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-10 07:06:23
success: True
trace_id: 11963688493098294954

Scan 161736215

duration: 0:00:12.355281

exit_message:

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

id: 161736215

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/attachments/2026-04-09/1775736288",
        "key": "raw/attachments/2026-04-09/1775736288/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10896465985478079677,
        "service_name": "drive-thru",
        "span_id": 6491124439135304080,
        "trace_id": 8239691043145006342
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-09 07:04:59
success: True
trace_id: 8239691043145006342

Scan 161681404

duration: 0:00:14.976368

exit_message:

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

id: 161681404

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/attachments/2026-04-08/1775649919",
        "key": "raw/attachments/2026-04-08/1775649919/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7851981824280488140,
        "service_name": "drive-thru",
        "span_id": 16320230633801704806,
        "trace_id": 16570414464578922032
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-08 07:06:53
success: True
trace_id: 16570414464578922032

Scan 161625219

duration: 0:00:12.303025

exit_message:

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

id: 161625219

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/attachments/2026-04-07/1775563530",
        "key": "raw/attachments/2026-04-07/1775563530/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9913755916354220878,
        "service_name": "drive-thru",
        "span_id": 11289431170591097643,
        "trace_id": 10944680404553029491
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-07 07:07:27
success: True
trace_id: 10944680404553029491

Scan 161567375

duration: 0:00:14.789580

exit_message:

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

id: 161567375

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/attachments/2026-04-06/1775477132",
        "key": "raw/attachments/2026-04-06/1775477132/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6986332225283990319,
        "service_name": "drive-thru",
        "span_id": 13959629678800099759,
        "trace_id": 15587610751877270106
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-06 07:11:46
success: True
trace_id: 15587610751877270106

Scan 161519995

duration: 0:00:14.789919

exit_message:

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

id: 161519995

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/attachments/2026-04-05/1775390676",
        "key": "raw/attachments/2026-04-05/1775390676/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2244119336532229847,
        "service_name": "drive-thru",
        "span_id": 1630730229024526174,
        "trace_id": 12756614088026309500
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-05 07:06:20
success: True
trace_id: 12756614088026309500

Scan 161466432

duration: 0:00:12.248919

exit_message:

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

id: 161466432

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/attachments/2026-04-04/1775304407",
        "key": "raw/attachments/2026-04-04/1775304407/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1875860542928544521,
        "service_name": "drive-thru",
        "span_id": 776047679112822215,
        "trace_id": 15774118463713455580
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-04 07:08:48
success: True
trace_id: 15774118463713455580

Scan 161408588

duration: 0:00:14.859968

exit_message:

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

id: 161408588

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/attachments/2026-04-03/1775217875",
        "key": "raw/attachments/2026-04-03/1775217875/attachments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_attachments",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4082005979662600547,
        "service_name": "drive-thru",
        "span_id": 10037918824185187124,
        "trace_id": 4255697037687926773
    }
}

running: False
schema_name_id: 1166
start_time: 2026-04-03 07:06:33
success: True
trace_id: 4255697037687926773

Partitions:

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

Schema:

attributes:

{
    "Amount": "string",
    "BodyLength": "string",
    "CloseDate": "string",
    "ConnectionReceivedId": "string",
    "ConnectionSentId": "string",
    "ContentType": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Description": "string",
    "ExpectedRevenue": "string",
    "ForecastCategory": "string",
    "Id": "string",
    "IsDeleted": "string",
    "IsPartnerShared": "string",
    "IsPrivate": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "Name": "string",
    "OpportunityId": "string",
    "OwnerId": "string",
    "ParentId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "StageName": "string",
    "SystemModstamp": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-17/1776427507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
}

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:21:37",
        "disabled": false,
        "format": "raw",
        "id": 1166,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_attachments"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Amount": "string",
            "BodyLength": "string",
            "CloseDate": "string",
            "ConnectionReceivedId": "string",
            "ConnectionSentId": "string",
            "ContentType": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Description": "string",
            "ExpectedRevenue": "string",
            "ForecastCategory": "string",
            "Id": "string",
            "IsDeleted": "string",
            "IsPartnerShared": "string",
            "IsPrivate": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "Name": "string",
            "OpportunityId": "string",
            "OwnerId": "string",
            "ParentId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "StageName": "string",
            "SystemModstamp": "string"
        },
        "created": "2026-04-17 07:06:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_attachments`\n(\n `Id`  string , `IsDeleted`  string , `ParentId`  string , `Name`  string , `IsPrivate`  string , `ContentType`  string , `BodyLength`  string , `OwnerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `Description`  string , `IsPartnerShared`  string , `ConnectionReceivedId`  string , `ConnectionSentId`  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/attachments/2026-04-17/1776427507'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_attachments`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_attachments"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}