It is worth mentioning that Query Studio creates a new folder in your Data Extensions folder, called “QueryStudioResults”: Unfortunately, the Query Studio is still missing a debugging feature, which would show syntax errors in your query: It’s nice to see a description of the validation error in the results, but if you have more than one error, you will have to correct them one by one, as the validation tool only displays the first error it encounters: I ran a few tests and made a few mistakes on purpose to see how the validation feature works. The validation function, according to Salesforce, will cross check for required fields, field lengths, and mismatched field data types. You can also validate your query to check if query results can be inserted into target data extension – once you execute your query, choose a target data extension from the Data Extension search box, choose Data Action and click on Validate Data.Click the Run button or use the keyboard shortcut CTRL + Enter to run your query – you will see a timer next to the Run button, showing you how long the query takes to execute.From the Query search box at the top, you can choose an existing query that you wish to run, or you can write your own query in the query editor window.The user interface of Query Studio is quite simple:
After you install the app, you need to log out and log back in, to be able to access it from the App Exchange menu:
You can get Query Studio for Marketing Cloud for free from Salesforce AppExchange and install in a couple of clicks.
The app allows you to quickly run queries with a similar experience to SQL Server Studio or MySQL workbench. Salesforce has decided to make things a bit easier for Marketing Cloud users and launched a new app last month called Query Studio for Marketing Cloud. It can be very time consuming and frustrating to work on more complicated queries as each time your run your query, you need to go to Data Extensions to check the results. The current SQL query editor in Automation Studio is very rudimentary and makes it almost impossible to debug SQL queries. The ability to write and automate SQL queries in Automation Studio is an indispensable feature when it comes to working with data in Salesforce Marketing Cloud.