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

Credits : Cameron Robert

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:

📄 REST API Scopes:


Popular Salesforce Videos