Skip to content

Instantly share code, notes, and snippets.

@danieldrasdo

danieldrasdo/sfmc-sql-enterprise-attributes.sql

Forked from wvpv/sfmc-sql-enterprise-attributes.sql
Last active December 20, 2017 21:49
Show Gist options
  • Save danieldrasdo/3203fe17a40893eff88c27daf76cd188 to your computer and use it in GitHub Desktop.
Save danieldrasdo/3203fe17a40893eff88c27daf76cd188 to your computer and use it in GitHub Desktop.
Download ZIP
SFMC SQL select profile attributes values from the EnterpriseAtrributes data view
Raw
sfmc-sql-enterprise-attributes.sql
select
a.customerID
, s.emailAddress
from _EnterpriseAttribute a with (nolock)
inner join _Subscribers s with (nolock) on (s.subscriberID = a._SubscriberID)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment