What is Query Service?
Query Service lets you run standard SQL over datasets in the data lake from the UI, a connected client or the API, and write results to derived datasets.
Which tool lets analysts run SQL on AEP datasets?
Query Service, available in the UI query editor, through PostgreSQL-compatible clients and through the Query Service API.
Sources: Query Service overview
Can Query Service write results back?
Yes, with CREATE TABLE AS SELECT or INSERT INTO you can produce derived datasets, and they can be Profile-enabled if they use a suitable schema.
What is Data Distiller?
Data Distiller is an add-on capability that extends Query Service with advanced SQL functions, scheduling and data preparation. Availability depends on licence.
Sources: Data Distiller overview
Are there sample queries?
Adobe publishes sample queries and templates that you can adapt, for example for identity, event and attribute analysis.
Sources: Dataset samples Query templates
Where do I check why ingestion failed?
Open the Monitoring dashboard, select the dataflow or the batch, and review the error details and failed record reports.
Which dashboard shows ingestion volume trends?
The Monitoring section shows ingestion and dataflow metrics over time, and you can build reports from observability data.
Sources: Monitor dataflows for sources in the UI Observability Insights overview
What are observability insights?
Observability insights expose operational metrics about ingestion, Profile and destinations as queryable data so you can build your own dashboards.
Sources: Observability Insights overview
How do I get alerts on failures?
Configure alert subscriptions for dataflow, source and destination events in the platform alerts, and route them to email or webhooks.
How do I debug missing Web SDK events?
Use the Adobe Experience Platform Debugger or Assurance to inspect the network call, confirm the datastream and schema, then monitor the dataset for the batch or streaming event.
Sources: Introduction to the Experience Platform Debugger Validate Web SDK implementations with Assurance Monitor dataflows for sources in the UI
How do I check dataset content before using it in CJA?
Query the dataset in Query Service to confirm that the person ID, timestamp and key fields are populated before creating a connection.
Sources: Query Service overview Customer Journey Analytics documentation
How do I troubleshoot a dataset that does not appear in CJA?
Check that the dataset is in the same sandbox, uses a supported schema class and has a person identifier, and that the connection includes it. Datasets may take time to appear.
Sources: Customer Journey Analytics documentation Customer Journey Analytics FAQ
Ask a question or join a demo
Need help applying this? Ask us via the form WhatsApp +91 82968 93895 LinkedIn: Pavan Babu Gandla
Answers are AI-assisted summaries of Adobe's public documentation and the instructors' practice, written for learning. Product behaviour changes, so confirm details in the linked official page before relying on them.
Last updated: