0

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.

1
  • Ohhh. I cant even export a list automaticly, only a DE... – Bidstrup Dec 28 '16 at 11:17
5

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.

6
  • And if it's not enterprise? (Not sure if it is) – Bidstrup Dec 28 '16 at 17:37
  • I believe you're out of luck query-wise on this one. Would a filter work to create a Group for your use case? – AnonWonderer Dec 28 '16 at 17:42
  • I need to join some other DE as well, so unfortunately groups dosnt do it :-( – Bidstrup Dec 28 '16 at 17:53
  • If it's not an E2 account, you can always get the Attributes into a DE via Tracking Data Extract and import. It's a pain, but it can be done. – Adam Spriggs Dec 30 '16 at 16:00
  • 1
    Yes - it works as you might expect - you just need the Subscriber ID value. Ex: SET @FirstName = Lookup("_EnterpriseAttribute", "FirstName", "_SubscriberID", SubscriberID). Keep in mind just like a query it only works at parent level. – AnonWonderer Jun 17 '19 at 21:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.