Sometimes it’s quite a challenge to find specific records in huge Data Extensions. Or maybe you want to do a quick test run of a new Automation that you have built. And sometimes you want to take a peak into the hidden Data Views Marketing Cloud has to offer!
If you’re still looking for a solution to these or other database/query related problems, you haven’t found Query Studio for Marketing Cloud yet.
TMI… where can I find it? Click here!
Query Studio allows you to run queries on your Marketing Cloud data just like in SQL Server Studio. It’s great when you are developing new queries for Automations or to just create a single export.
Every query you run will create a temporary Data Extension with the results. So you can compare the results of one or more queries you ran.
You can do almost anything that you would normally do in for example SQL Server Studio:
- Join tables
- Rename columns
- Convert data types
- Calculations/Aggregations
- Add row numbers
- Group/Filter/Sort
The only thing you can’t do, is query all columns without specifying (SELECT * FROM X).
Also, you have a nice Object Explorer. In case you can’t remember the column names from your Data Extension. Search for the Data Extension name you want to query and Query Studio will provide you with a list on column names and types.
And best of all: Query Studio is completely free, as are all the apps created by Salesforce Labs.
