I'm wondering if there is any sort of developer console where you can test sql queries. Testing queries by always looking into the regarding data extension takes quite a lot of time.

Anyone having experiences or workaround for this kind of issue?

  • 1
    ohh I miss this feature so much! It a pain to make Queries in ExactTarget. I should be like in Responsys, where it makes the output Data Extension for you, and you can check midways the count of the query.
    – Bidstrup
    Commented May 4, 2016 at 8:57
  • @ma_wi appexchange.salesforce.com/…
    – mario ruiz
    Commented Mar 11, 2020 at 0:11

1 Answer 1


I'd recommend writing and testing your Query Activities outside of the platform using a local installation Microsoft SQL Server or SQLFiddle (using MS SQL Server 2008). It doesn't make sense for all queries, but with a query that has some complexity to it, I build and test it locally.

As you may have noticed, if you query has any kind of runtime error, you'll have to contact SFMC Support to determine the source of the error.

Also, if you're dealing with the System Data Views, expect and plan for your queries to exceed the 30 minute timeout threshold. Give each data view it's own query if you need that data in your final result-set.


Query Activity (System Data Views)

  • Thanks for your quick response, Adam. I hoped there was some tool like the developer workbench for Sales Cloud where you can test queries on live production data, but in this case I'll work with the given tools.
    – ma_wi
    Commented May 4, 2016 at 8:57
  • Yeah I wish there was as well. Waiting for 30 minutes to see if the query worked and is slow or failed makes development time days instead of hours
    – BDOB83
    Commented May 4, 2016 at 10:27
  • 1
    I've heard from some of the Product Development folks that they're planning to show SQL runtime errors in the interface. That'll be nice. Commented May 4, 2016 at 11:19
  • 1
    @AdamSpriggs any news about a tool to show SQL runtime execution? Commented Jun 12, 2018 at 17:24
  • @ÁtilaCastroAlves appexchange.salesforce.com/…
    – mario ruiz
    Commented Mar 11, 2020 at 0:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .