---
title: Checking Destinations in the Data Lake
slug: adobe-summit-2025/checking-destinations-in-the-data-lake
createdAt: 2025-03-12T20:51:43.924Z
---



After at least 30 minutes, you can even check your dataset to see if a Profile was sent to a Destination with the following:

1. Go to AEP
2. &#x20;To find it, go to Dataset on the left rail
3. In the list filter on "`dest`", open the dataset that starts with "`profile export for destination merge policy`" and copy the table name on the right rail.
4.

   ::Image[]{src="https://api.archbee.com/api/optimize/DtSMrR5N5XP-AttwqYcDD/xpOdx2qX8CkBvGwVUhbZP_image.png" size="38" width="384" height="568" position="center" showCaption="false"}

Go to Queries on the left rail

Click on Create Query on the top right.

Copy and change the SQL (as directed below) into the AEP query

1. Change the SQL using to the table name you copied above.&#x20;
   1. e.g. `FROM [TableName]` would be changed to `FROM profile_export_for_destination_merge_policy_1a0f95ac_10fb_4f9b_9` in my sandbox.

SQL for Web Event to Hub

```sql
SELECT * FROM [TableName]
WHERE extSourceSystemAudit.LASTREFERENCEDDATE >= CURRENT_DATE
AND identitymap['email'][0].ID in ('depeche.mode@dep.com')
ORDER BY extSourceSystemAudit.LASTREFERENCEDDATE DESC
LIMIT 10
```

Order Event to Hub & Web Event to Edge

```sql
SELECT * FROM [TableName]
WHERE extSourceSystemAudit.LASTREFERENCEDDATE >= CURRENT_DATE
AND identitymap['email'][0].ID in ('{{SANDBOX_NAME}}@dep.com')
ORDER BY extSourceSystemAudit.LASTREFERENCEDDATE DESC
LIMIT 10
```

