Dataflow returns error

Tommy
Tommy ⚪️

I have a dataflow, which the code is correct for, but it returns a "Whoops! Something went wrong" error. I've run this code in a code checker and a MySQL clone. Everything says it's good, except for Domo.

This is pretty basic functionality that Domo needs to have.

I am hoping to get a decent response that actually answers my question.

Answers

  • @Tommy, without more detail it's hard to know what might be going on. If it's a basic query, could you post it? It sounds like this is a MySQL flow and not an ETL. Also, is this a brand new flow or an existing one that you're editing?

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • Tommy
    Tommy ⚪️

    @RobSomers it is a new dataflow, and yes it is not an ETL.

    @SS_domolearner that sort of answers the question, although that's not exactly the answer I was hoping for. Why does it force added indexes to every join for it to run? if that's the case just make it do so automatically if it's required.

  • GrantSmith
    GrantSmith Indiana 🥷

    Have you tried replicating the dataflow in magic? I know it might not be ideal but typically Magic is significantly faster.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Tommy
    Tommy ⚪️

    @GrantSmith yes the Magic ETL is faster or doesn't experience errors, however as you mentioned it's not ideal. It takes longer to build out, it's much harder to transfer over as the readability is non-existent, and since it's not code, it's hard to add into a git repository for change documentation.

  • @Tommy In Magic ETL, if you highlight multiple tiles you are given the option to "Copy to Clipboard". You can then paste into your favorite text editor, I use Visual Studio Code, and you'll have the JSON code of the tiles you highlighted. This could enable you to better utilize git with Magic ETL.