SQL Query Error: Record Type ID' is a required for the Target Data Extension. Ensure this field is specified

Question

SELECT 
c.AccountId as SubscriberID
, c.DoNotCall
, c.Email
, c.FirstName as First_Name
, c.LastName as Last_Name
, c.HasOptedOutOfEmail as Email_Opt_Out
, c.Phone
, a.id
, a.RecordTypeId as Record_Type_ID 
FROM Contact_Salesforce as c
INNER JOIN Account_Salesforce as a on c.AccountId = a.id
AND a.RecordTypeId = '01550000000Zdc9CCD'

I've specified the Record_Type_ID (pulling it from the account salesforce object) but obviously missing something here, any help would be appreciated.

What I'm trying to do is pull in contacts from the contact object and their related information as well as their record type id which is an account object value and only do so when the ids match across account and contact object AND they are '01550000000Zdc9CCD' record type Id match.

Answer 1

The Record_Type_ID alias returned by your query is not the same as Record Type ID in the error message.

Should probably be this:

SELECT 
c.AccountId as SubscriberID
, c.DoNotCall
, c.Email
, c.FirstName as First_Name
, c.LastName as Last_Name
, c.HasOptedOutOfEmail as Email_Opt_Out
, c.Phone
, a.id
, a.RecordTypeId as [Record Type ID]
FROM Contact_Salesforce as c
INNER JOIN Account_Salesforce as a on c.AccountId = a.id
AND a.RecordTypeId = '01550000000Zdc9CCD'