In this video, Cameron Robert shows how to find SQL queries in Automations that affect a specified Data Extension in Salesforce Marketing Cloud.
- Introduction (0:00)
- Manually find queries based on Targeted Data Extension (0:13)
- SSJS Code Setup Instructions (1:07)
- Query Finder Code Test 1 (2:27)
- Query Finder Code Test 2 (2:50)
- Summary (3:31)
⚠️NOTE: Use this code at your own risk. CloudPages are public and can be a security risk if not managed properly. Make sure you understand the risks before deploying unfamiliar code.
📄 SSJS Code: https://github.com/camrobert/SalesforceMarketingCloud/blob/main/Tools/Find%20Queries%20that%20target%20Data%20Extension
📄 REST API Scopes: https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/rest-permissions-and-scopes.html