How to Find Queries that Target a Data Extension in Salesforce Marketing Cloud

In this video, Cameron Robert shows how to find SQL queries in Automations that affect a specified Data Extension in Salesforce Marketing Cloud.

Key Moments:

• 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