← Back to the glossary
Adobe Experience Platform
Query Service
Adobe Experience Platform Query Service
Query Service runs SQL against the datasets in the AEP data lake. It is used to explore data, validate ingestion, build derived tables, and feed reporting.
- When it applies
- It fits for checking that what is being ingested is what you assumed, measuring identity health, and rebuilding state that no application writes by itself.
- What it is confused with
- It does not query the unified profile. It queries the data lake, which holds what was ingested as it arrived. An attribute computed or written by a journey can exist in the profile and appear in no query at all.
- Architecture consequence
- That gap has to be measured, not assumed. It is what forces a reconciliation design when the business needs in SQL a state that only lives in the profile.