_EnterpriseAttribute

Enterprise 2.0 profile attributes from Email Studio. Parent BU only (Ent. prefix). Dynamic profile columns are added when attributes are created; only _SubscriberID is fixed.

Schema last reviewed 2026-06-17

Open Interactive Workspace All data views

Opens _EnterpriseAttribute in the interactive canvas with SQL Sandbox.

Fields (1)

Field	Type	Flags	Relations	Description
`_SubscriberID`	Number	PK	—	Subscriber ID; underscore prefix is required in queries.

Example query

SELECT TOP 100
  _SubscriberID
FROM _EnterpriseAttribute

Valid in Query Studio and Automation Studio Query Activities. GROUP BY is only needed for aggregates; ORDER BY is optional but recommended with TOP so rows are meaningful. Narrow date ranges on large tracking views to avoid timeouts.