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.