I have an attribute called CardId in my all subscribers list and want to query it, but I get the following error if I do so: "The query syntax is invalid" Invalid column name 'CardId'.
This is the query I tried to execute:
Select CardId from _subscribers
Is it correct that I can’t use attributes other than the standard ones from the _dataview table in a query activity?
My workaround solution would be to export the all subscribers list (1.3 million rows), import them into a data extension and then query this data extension. But that seems a bit strange to me.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
As long as the account is an Enterprise 2.0 account, you can query Profile Attributes by accessing the _EnterpriseAttribute data view.
Data View: EnterpriseAttribute
Simply do a join onto the _EnterpriseAttribute table, and you’ll have access to all of your fields.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0