Schema Info
Schema Name: sfdl_prod_csv.salesforce_campaign_members
- created: 2022-10-10 16:21:33
- disabled: False
- format: raw
- id: 1164
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_csv", "table": "salesforce_campaign_members" } - type: csv
Schema Versions: 15
-
Version 1718083
- created: 2026-04-17 07:06:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-17/1776427526'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-17/1776427526
- id: 1718083
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 162173051
- updated: 2026-04-17 07:06:14
-
Version 1716880
- created: 2026-04-16 07:07:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-16/1776341117'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-16/1776341117
- id: 1716880
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 162117365
- updated: 2026-04-16 07:07:35
-
Version 1715652
- created: 2026-04-15 07:08:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-15/1776254758'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-15/1776254758
- id: 1715652
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 162061791
- updated: 2026-04-15 07:08:49
-
Version 1714483
- created: 2026-04-14 07:07:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-14/1776168350'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-14/1776168350
- id: 1714483
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 162006399
- updated: 2026-04-14 07:07:32
-
Version 1713258
- created: 2026-04-13 07:07:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-13/1776081937'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-13/1776081937
- id: 1713258
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161948341
- updated: 2026-04-13 07:07:46
-
Version 1712062
- created: 2026-04-12 07:08:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-12/1775995694'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-12/1775995694
- id: 1712062
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161899545
- updated: 2026-04-12 07:08:41
-
Version 1710869
- created: 2026-04-11 07:07:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-11/1775909070'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-11/1775909070
- id: 1710869
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161846882
- updated: 2026-04-11 07:07:43
-
Version 1709655
- created: 2026-04-10 07:05:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-10/1775822713'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-10/1775822713
- id: 1709655
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161792049
- updated: 2026-04-10 07:05:43
-
Version 1708548
- created: 2026-04-09 07:07:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-09/1775736341'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-09/1775736341
- id: 1708548
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161736289
- updated: 2026-04-09 07:08:03
-
Version 1707339
- created: 2026-04-08 07:06:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-08/1775649921'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-08/1775649921
- id: 1707339
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161681397
- updated: 2026-04-08 07:06:52
-
Version 1706165
- created: 2026-04-07 07:07:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-07/1775563528'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-07/1775563528
- id: 1706165
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161625209
- updated: 2026-04-07 07:07:31
-
Version 1704933
- created: 2026-04-06 07:09:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-06/1775477113'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-06/1775477113
- id: 1704933
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161567342
- updated: 2026-04-06 07:10:04
-
Version 1703714
- created: 2026-04-05 07:06:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-05/1775390686'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-05/1775390686
- id: 1703714
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161519998
- updated: 2026-04-05 07:06:41
-
Version 1702568
- created: 2026-04-04 07:09:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-04/1775304411'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-04/1775304411
- id: 1702568
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161466440
- updated: 2026-04-04 07:09:32
-
Version 1701360
- created: 2026-04-03 07:05:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-03/1775217875'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" ] - hive_path: s3://sfdl-csv-salesforce-prod/raw/campaign_members/2026-04-03/1775217875
- id: 1701360
- processed: 1
- raw_data:
{ "CampaignId": 2, "City": 20, "CompanyOrAccount": 33, "ContactId": 4, "Count_of_Live_SFDC_Assets__c": 45, "Country": 23, "CreatedById": 8, "CreatedDate": 7, "CurrencyIsoCode": 13, "Description": 28, "DoNotCall": 29, "Email": 24, "FMS_Count_at_Creation__c": 46, "Fax": 26, "FirstName": 16, "FirstRespondedDate": 12, "HasOptedOutOfEmail": 30, "HasOptedOutOfFax": 31, "HasResponded": 6, "Id": 0, "IsDeleted": 1, "LastModifiedById": 10, "LastModifiedDate": 9, "LastName": 17, "LeadId": 3, "LeadOrContactId": 35, "LeadOrContactOwnerId": 36, "LeadSource": 32, "MobilePhone": 27, "Name": 15, "Phone": 25, "PostalCode": 22, "Salutation": 14, "State": 21, "Status": 5, "Street": 19, "SystemModstamp": 11, "Title": 18, "Type": 34, "X21RI_Email_Send_Date__c": 44, "purecloud__Last_Attempt__c": 37, "purecloud__Last_Result__c": 38, "purecloud__Last_Sync__c": 39, "purecloud__Reconciled_Result__c": 40, "purecloud__Sort_Order__c": 41, "purecloud__Synced_to_PureCloud__c": 42, "purecloud__Time_Zone__c": 43 } - schema_attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - schema_name_id: 1164
- schema_scan_id: 161408567
- updated: 2026-04-03 07:05:55
Schema Scans: 15
Last at 2026-04-17 07:06:00
-
Scan 162173051
- duration: 0:00:13.767029
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162173051
- 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/campaign_members/2026-04-17/1776427526", "key": "raw/campaign_members/2026-04-17/1776427526/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 5294870318639923584, "service_name": "drive-thru", "span_id": 2858124749454889183, "trace_id": 18119747187503744660 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-17 07:06:00
- success: True
- trace_id: 18119747187503744660
-
Scan 162117365
- duration: 0:00:15.654459
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162117365
- 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/campaign_members/2026-04-16/1776341117", "key": "raw/campaign_members/2026-04-16/1776341117/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 12163470483707386734, "service_name": "drive-thru", "span_id": 2248293137359912702, "trace_id": 3382231051641350232 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-16 07:07:19
- success: True
- trace_id: 3382231051641350232
-
Scan 162061791
- duration: 0:00:13.016557
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162061791
- 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/campaign_members/2026-04-15/1776254758", "key": "raw/campaign_members/2026-04-15/1776254758/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 1247656748384541949, "service_name": "drive-thru", "span_id": 16816002539120974636, "trace_id": 15455666289953932307 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-15 07:08:36
- success: True
- trace_id: 15455666289953932307
-
Scan 162006399
- duration: 0:00:15.602945
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162006399
- 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/campaign_members/2026-04-14/1776168350", "key": "raw/campaign_members/2026-04-14/1776168350/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 17340290012012513981, "service_name": "drive-thru", "span_id": 950458225957456615, "trace_id": 7731211536166854499 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-14 07:07:16
- success: True
- trace_id: 7731211536166854499
-
Scan 161948341
- duration: 0:00:15.796286
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161948341
- 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/campaign_members/2026-04-13/1776081937", "key": "raw/campaign_members/2026-04-13/1776081937/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 8670441406457171914, "service_name": "drive-thru", "span_id": 7176838039086951212, "trace_id": 17712947526413690275 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-13 07:07:30
- success: True
- trace_id: 17712947526413690275
-
Scan 161899545
- duration: 0:00:13.118230
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161899545
- 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/campaign_members/2026-04-12/1775995694", "key": "raw/campaign_members/2026-04-12/1775995694/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 1019023881813071035, "service_name": "drive-thru", "span_id": 18335865888753437769, "trace_id": 17260543847113250785 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-12 07:08:28
- success: True
- trace_id: 17260543847113250785
-
Scan 161846882
- duration: 0:00:15.596457
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161846882
- 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/campaign_members/2026-04-11/1775909070", "key": "raw/campaign_members/2026-04-11/1775909070/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 10460263546855105072, "service_name": "drive-thru", "span_id": 6593793795591076759, "trace_id": 10912861746954120476 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-11 07:07:28
- success: True
- trace_id: 10912861746954120476
-
Scan 161792049
- duration: 0:00:15.419791
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161792049
- 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/campaign_members/2026-04-10/1775822713", "key": "raw/campaign_members/2026-04-10/1775822713/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 9817063001286906593, "service_name": "drive-thru", "span_id": 2588230792354932429, "trace_id": 8456635111005359955 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-10 07:05:27
- success: True
- trace_id: 8456635111005359955
-
Scan 161736289
- duration: 0:00:15.510360
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161736289
- 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/campaign_members/2026-04-09/1775736341", "key": "raw/campaign_members/2026-04-09/1775736341/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 17652248935849813275, "service_name": "drive-thru", "span_id": 8032681301824523361, "trace_id": 13205892661876954036 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-09 07:07:48
- success: True
- trace_id: 13205892661876954036
-
Scan 161681397
- duration: 0:00:13.197985
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161681397
- 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/campaign_members/2026-04-08/1775649921", "key": "raw/campaign_members/2026-04-08/1775649921/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 5347816972381770815, "service_name": "drive-thru", "span_id": 6352923302822236414, "trace_id": 4837935712315067964 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-08 07:06:38
- success: True
- trace_id: 4837935712315067964
-
Scan 161625209
- duration: 0:00:13.194113
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161625209
- 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/campaign_members/2026-04-07/1775563528", "key": "raw/campaign_members/2026-04-07/1775563528/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 11156735530501615780, "service_name": "drive-thru", "span_id": 15022272414749240106, "trace_id": 4003933381377076408 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-07 07:07:18
- success: True
- trace_id: 4003933381377076408
-
Scan 161567342
- duration: 0:00:13.155803
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161567342
- 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/campaign_members/2026-04-06/1775477113", "key": "raw/campaign_members/2026-04-06/1775477113/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 18233411755400441797, "service_name": "drive-thru", "span_id": 3060872894270208356, "trace_id": 18024809975027109539 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-06 07:09:51
- success: True
- trace_id: 18024809975027109539
-
Scan 161519998
- duration: 0:00:15.474777
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161519998
- 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/campaign_members/2026-04-05/1775390686", "key": "raw/campaign_members/2026-04-05/1775390686/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 16164749769706921829, "service_name": "drive-thru", "span_id": 8846690323676038026, "trace_id": 707487856513038238 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-05 07:06:26
- success: True
- trace_id: 707487856513038238
-
Scan 161466440
- duration: 0:00:15.553740
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161466440
- 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/campaign_members/2026-04-04/1775304411", "key": "raw/campaign_members/2026-04-04/1775304411/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 14554146893052993632, "service_name": "drive-thru", "span_id": 12410484850656822245, "trace_id": 17917922221003495348 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-04 07:09:17
- success: True
- trace_id: 17917922221003495348
-
Scan 161408567
- duration: 0:00:15.458728
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161408567
- 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/campaign_members/2026-04-03/1775217875", "key": "raw/campaign_members/2026-04-03/1775217875/campaign_members.csv.gz" }, "schema": { "name": "sfdl_prod_csv.salesforce_campaign_members", "type": "csv" }, "trace_context": { "parent_id": 9236910812253694397, "service_name": "drive-thru", "span_id": 9727640805475842910, "trace_id": 9364209123720716970 } } - running: False
- schema_name_id: 1164
- start_time: 2026-04-03 07:05:39
- success: True
- trace_id: 9364209123720716970
- attributes:
{ "Amount": "string", "CampaignId": "string", "City": "string", "CloseDate": "string", "CompanyOrAccount": "string", "ContactId": "string", "Count_of_Live_SFDC_Assets__c": "string", "Country": "string", "CreatedById": "string", "CreatedDate": "string", "CurrencyIsoCode": "string", "Description": "string", "DoNotCall": "string", "Email": "string", "ExpectedRevenue": "string", "FMS_Count_at_Creation__c": "string", "Fax": "string", "FirstName": "string", "FirstRespondedDate": "string", "ForecastCategory": "string", "HasOptedOutOfEmail": "string", "HasOptedOutOfFax": "string", "HasResponded": "string", "Id": "string", "IsDeleted": "string", "LastModifiedById": "string", "LastModifiedDate": "string", "LastName": "string", "LeadId": "string", "LeadOrContactId": "string", "LeadOrContactOwnerId": "string", "LeadSource": "string", "MobilePhone": "string", "Name": "string", "OpportunityId": "string", "Phone": "string", "PostalCode": "string", "PrevAmount": "string", "PrevCloseDate": "string", "Probability": "string", "Salutation": "string", "StageName": "string", "State": "string", "Status": "string", "Street": "string", "SystemModstamp": "string", "Title": "string", "Type": "string", "X21RI_Email_Send_Date__c": "string", "purecloud__Last_Attempt__c": "string", "purecloud__Last_Result__c": "string", "purecloud__Last_Sync__c": "string", "purecloud__Reconciled_Result__c": "string", "purecloud__Sort_Order__c": "string", "purecloud__Synced_to_PureCloud__c": "string", "purecloud__Time_Zone__c": "string" } - created: 2026-04-17 07:06:03
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-17/1776427526'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2022-10-10 16:21:33",
"disabled": false,
"format": "raw",
"id": 1164,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_csv",
"table": "salesforce_campaign_members"
},
"type": "csv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Amount": "string",
"CampaignId": "string",
"City": "string",
"CloseDate": "string",
"CompanyOrAccount": "string",
"ContactId": "string",
"Count_of_Live_SFDC_Assets__c": "string",
"Country": "string",
"CreatedById": "string",
"CreatedDate": "string",
"CurrencyIsoCode": "string",
"Description": "string",
"DoNotCall": "string",
"Email": "string",
"ExpectedRevenue": "string",
"FMS_Count_at_Creation__c": "string",
"Fax": "string",
"FirstName": "string",
"FirstRespondedDate": "string",
"ForecastCategory": "string",
"HasOptedOutOfEmail": "string",
"HasOptedOutOfFax": "string",
"HasResponded": "string",
"Id": "string",
"IsDeleted": "string",
"LastModifiedById": "string",
"LastModifiedDate": "string",
"LastName": "string",
"LeadId": "string",
"LeadOrContactId": "string",
"LeadOrContactOwnerId": "string",
"LeadSource": "string",
"MobilePhone": "string",
"Name": "string",
"OpportunityId": "string",
"Phone": "string",
"PostalCode": "string",
"PrevAmount": "string",
"PrevCloseDate": "string",
"Probability": "string",
"Salutation": "string",
"StageName": "string",
"State": "string",
"Status": "string",
"Street": "string",
"SystemModstamp": "string",
"Title": "string",
"Type": "string",
"X21RI_Email_Send_Date__c": "string",
"purecloud__Last_Attempt__c": "string",
"purecloud__Last_Result__c": "string",
"purecloud__Last_Sync__c": "string",
"purecloud__Reconciled_Result__c": "string",
"purecloud__Sort_Order__c": "string",
"purecloud__Synced_to_PureCloud__c": "string",
"purecloud__Time_Zone__c": "string"
},
"created": "2026-04-17 07:06:03",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_campaign_members`\n(\n `Id` string , `IsDeleted` string , `CampaignId` string , `LeadId` string , `ContactId` string , `Status` string , `HasResponded` string , `CreatedDate` string , `CreatedById` string , `LastModifiedDate` string , `LastModifiedById` string , `SystemModstamp` string , `FirstRespondedDate` string , `CurrencyIsoCode` string , `Salutation` string , `Name` string , `FirstName` string , `LastName` string , `Title` string , `Street` string , `City` string , `State` string , `PostalCode` string , `Country` string , `Email` string , `Phone` string , `Fax` string , `MobilePhone` string , `Description` string , `DoNotCall` string , `HasOptedOutOfEmail` string , `HasOptedOutOfFax` string , `LeadSource` string , `CompanyOrAccount` string , `Type` string , `LeadOrContactId` string , `LeadOrContactOwnerId` string , `purecloud__Last_Attempt__c` string , `purecloud__Last_Result__c` string , `purecloud__Last_Sync__c` string , `purecloud__Reconciled_Result__c` string , `purecloud__Sort_Order__c` string , `purecloud__Synced_to_PureCloud__c` string , `purecloud__Time_Zone__c` string , `X21RI_Email_Send_Date__c` string , `Count_of_Live_SFDC_Assets__c` string , `FMS_Count_at_Creation__c` 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/campaign_members/2026-04-17/1776427526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_campaign_members`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_campaign_members"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}