Schema Info

Schema Name: sfdl_prod_csv.salesforce_opportunity_team_member_histories

created: 2026-03-04 07:06:41
disabled: False
format: raw
id: 4315
is_partitioned: False
is_schema_datatyped: True

name:

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

type: csv

Schema Versions: 15

Version 1718057

created: 2026-04-17 07:04:32

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-17/1776427469
id: 1718057
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 162173020
updated: 2026-04-17 07:04:44

Version 1716841

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-16/1776341073
id: 1716841
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 162117316
updated: 2026-04-16 07:05:42

Version 1715678

created: 2026-04-15 07:11:13

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-15/1776254802
id: 1715678
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 162061823
updated: 2026-04-15 07:11:24

Version 1714478

created: 2026-04-14 07:07:08

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-14/1776168348
id: 1714478
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 162006393
updated: 2026-04-14 07:07:22

Version 1713268

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-13/1776081928
id: 1713268
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161948361
updated: 2026-04-13 07:08:16

Version 1712055

created: 2026-04-12 07:07:56

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-12/1775995672
id: 1712055
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161899538
updated: 2026-04-12 07:08:07

Version 1710818

created: 2026-04-11 07:03:58

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-11/1775909028
id: 1710818
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161846826
updated: 2026-04-11 07:04:12

Version 1709674

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-10/1775822720
id: 1709674
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161792073
updated: 2026-04-10 07:06:38

Version 1708529

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-09/1775736296
id: 1708529
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161736262
updated: 2026-04-09 07:07:01

Version 1707331

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-08/1775649890
id: 1707331
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161681387
updated: 2026-04-08 07:06:28

Version 1706114

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-07/1775563482
id: 1706114
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161625148
updated: 2026-04-07 07:05:03

Version 1704928

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-06/1775477109
id: 1704928
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161567336
updated: 2026-04-06 07:09:31

Version 1703708

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-05/1775390665
id: 1703708
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161519991
updated: 2026-04-05 07:06:21

Version 1702553

created: 2026-04-04 07:08:20

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-04/1775304388
id: 1702553
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161466424
updated: 2026-04-04 07:08:31

Version 1701379

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

ddl:

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

hive_path: s3://sfdl-csv-salesforce-prod/raw/opportunity_team_member_histories/2026-04-03/1775217880
id: 1701379
processed: 1

raw_data:

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

schema_attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

schema_name_id: 4315
schema_scan_id: 161408589
updated: 2026-04-03 07:06:52

Schema Scans: 15

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

Scan 162173020

duration: 0:00:11.791114

exit_message:

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

id: 162173020

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/opportunity_team_member_histories/2026-04-17/1776427469",
        "key": "raw/opportunity_team_member_histories/2026-04-17/1776427469/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13272414373483284620,
        "service_name": "drive-thru",
        "span_id": 15709437412958831049,
        "trace_id": 7098149623081756813
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-17 07:04:32
success: True
trace_id: 7098149623081756813

Scan 162117316

duration: 0:00:11.959784

exit_message:

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

id: 162117316

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/opportunity_team_member_histories/2026-04-16/1776341073",
        "key": "raw/opportunity_team_member_histories/2026-04-16/1776341073/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9769402032424821161,
        "service_name": "drive-thru",
        "span_id": 18113309673185824778,
        "trace_id": 5698559717221597593
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-16 07:05:30
success: True
trace_id: 5698559717221597593

Scan 162061823

duration: 0:00:11.910479

exit_message:

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

id: 162061823

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/opportunity_team_member_histories/2026-04-15/1776254802",
        "key": "raw/opportunity_team_member_histories/2026-04-15/1776254802/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3907820270876483797,
        "service_name": "drive-thru",
        "span_id": 17323250412845744468,
        "trace_id": 6071920568859528143
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-15 07:11:12
success: True
trace_id: 6071920568859528143

Scan 162006393

duration: 0:00:14.396432

exit_message:

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

id: 162006393

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/opportunity_team_member_histories/2026-04-14/1776168348",
        "key": "raw/opportunity_team_member_histories/2026-04-14/1776168348/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1441662329113895796,
        "service_name": "drive-thru",
        "span_id": 13074128612457526560,
        "trace_id": 2949448071022938238
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-14 07:07:07
success: True
trace_id: 2949448071022938238

Scan 161948361

duration: 0:00:11.765622

exit_message:

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

id: 161948361

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/opportunity_team_member_histories/2026-04-13/1776081928",
        "key": "raw/opportunity_team_member_histories/2026-04-13/1776081928/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17883093507020045390,
        "service_name": "drive-thru",
        "span_id": 9693664623239637410,
        "trace_id": 15514450532185292549
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-13 07:08:04
success: True
trace_id: 15514450532185292549

Scan 161899538

duration: 0:00:11.710634

exit_message:

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

id: 161899538

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/opportunity_team_member_histories/2026-04-12/1775995672",
        "key": "raw/opportunity_team_member_histories/2026-04-12/1775995672/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2214737096428177247,
        "service_name": "drive-thru",
        "span_id": 2395188684483904650,
        "trace_id": 11083787315553778158
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-12 07:07:55
success: True
trace_id: 11083787315553778158

Scan 161846826

duration: 0:00:14.468358

exit_message:

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

id: 161846826

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/opportunity_team_member_histories/2026-04-11/1775909028",
        "key": "raw/opportunity_team_member_histories/2026-04-11/1775909028/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1569328530331010368,
        "service_name": "drive-thru",
        "span_id": 15928098680928176414,
        "trace_id": 17312407019119742217
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-11 07:03:58
success: True
trace_id: 17312407019119742217

Scan 161792073

duration: 0:00:14.398036

exit_message:

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

id: 161792073

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/opportunity_team_member_histories/2026-04-10/1775822720",
        "key": "raw/opportunity_team_member_histories/2026-04-10/1775822720/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13874867061541551863,
        "service_name": "drive-thru",
        "span_id": 7187550243636916666,
        "trace_id": 418294602920601133
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-10 07:06:24
success: True
trace_id: 418294602920601133

Scan 161736262

duration: 0:00:14.491917

exit_message:

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

id: 161736262

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/opportunity_team_member_histories/2026-04-09/1775736296",
        "key": "raw/opportunity_team_member_histories/2026-04-09/1775736296/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10108012017935890956,
        "service_name": "drive-thru",
        "span_id": 5086550580644853542,
        "trace_id": 16407866663049665799
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-09 07:06:46
success: True
trace_id: 16407866663049665799

Scan 161681387

duration: 0:00:11.937250

exit_message:

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

id: 161681387

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/opportunity_team_member_histories/2026-04-08/1775649890",
        "key": "raw/opportunity_team_member_histories/2026-04-08/1775649890/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14343006325039184392,
        "service_name": "drive-thru",
        "span_id": 14475235065548664922,
        "trace_id": 3413128995592627081
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-08 07:06:16
success: True
trace_id: 3413128995592627081

Scan 161625148

duration: 0:00:14.460304

exit_message:

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

id: 161625148

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/opportunity_team_member_histories/2026-04-07/1775563482",
        "key": "raw/opportunity_team_member_histories/2026-04-07/1775563482/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4011131653438841636,
        "service_name": "drive-thru",
        "span_id": 5903074357902039818,
        "trace_id": 10367015553631682350
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-07 07:04:49
success: True
trace_id: 10367015553631682350

Scan 161567336

duration: 0:00:11.874835

exit_message:

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

id: 161567336

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/opportunity_team_member_histories/2026-04-06/1775477109",
        "key": "raw/opportunity_team_member_histories/2026-04-06/1775477109/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 665472666334010821,
        "service_name": "drive-thru",
        "span_id": 16744546515831852533,
        "trace_id": 2903970606629842474
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-06 07:09:19
success: True
trace_id: 2903970606629842474

Scan 161519991

duration: 0:00:14.364762

exit_message:

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

id: 161519991

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/opportunity_team_member_histories/2026-04-05/1775390665",
        "key": "raw/opportunity_team_member_histories/2026-04-05/1775390665/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7234660044360083009,
        "service_name": "drive-thru",
        "span_id": 6710109946422548124,
        "trace_id": 10343484599163341959
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-05 07:06:06
success: True
trace_id: 10343484599163341959

Scan 161466424

duration: 0:00:11.804865

exit_message:

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

id: 161466424

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/opportunity_team_member_histories/2026-04-04/1775304388",
        "key": "raw/opportunity_team_member_histories/2026-04-04/1775304388/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1895373707590215986,
        "service_name": "drive-thru",
        "span_id": 13519804256516810211,
        "trace_id": 5738554523236517001
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-04 07:08:19
success: True
trace_id: 5738554523236517001

Scan 161408589

duration: 0:00:14.487611

exit_message:

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

id: 161408589

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/opportunity_team_member_histories/2026-04-03/1775217880",
        "key": "raw/opportunity_team_member_histories/2026-04-03/1775217880/opportunity_team_member_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_opportunity_team_member_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6460560912441940197,
        "service_name": "drive-thru",
        "span_id": 14309586417552728554,
        "trace_id": 12898023731801069754
    }
}

running: False
schema_name_id: 4315
start_time: 2026-04-03 07:06:37
success: True
trace_id: 12898023731801069754

Partitions:

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

Schema:

attributes:

{
    "CreatedById": "string",
    "CreatedDate": "string",
    "DataType": "string",
    "Field": "string",
    "Id": "string",
    "IsDeleted": "string",
    "NewValue": "string",
    "OldValue": "string",
    "OpportunityTeamMemberId": "string"
}

created: 2026-04-17 07:04:32

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_opportunity_team_member_histories`\n(\n `Id`  string , `IsDeleted`  string , `OpportunityTeamMemberId`  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/opportunity_team_member_histories/2026-04-17/1776427469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_opportunity_team_member_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_opportunity_team_member_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": "2026-03-04 07:06:41",
        "disabled": false,
        "format": "raw",
        "id": 4315,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_opportunity_team_member_histories"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "CreatedById": "string",
            "CreatedDate": "string",
            "DataType": "string",
            "Field": "string",
            "Id": "string",
            "IsDeleted": "string",
            "NewValue": "string",
            "OldValue": "string",
            "OpportunityTeamMemberId": "string"
        },
        "created": "2026-04-17 07:04:32",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_opportunity_team_member_histories`\n(\n `Id`  string , `IsDeleted`  string , `OpportunityTeamMemberId`  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/opportunity_team_member_histories/2026-04-17/1776427469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_opportunity_team_member_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_opportunity_team_member_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}