3

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 May 4 '16 at 8:57
  • @ma_wi appexchange.salesforce.com/… – mario ruiz Mar 11 at 0:11
5

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.

Reference:

Query Activity (System Data Views)

| improve this answer | |
  • 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 May 4 '16 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 May 4 '16 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. – Adam Spriggs May 4 '16 at 11:19
  • 1
    @AdamSpriggs any news about a tool to show SQL runtime execution? – Átila Castro Alves Jun 12 '18 at 17:24
  • @ÁtilaCastroAlves appexchange.salesforce.com/… – mario ruiz Mar 11 at 0:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.