How many datasets we can join/union in view explorer?

Best Answers

  • MarkSnodgrass
    Answer ✓

    There is no limit listed in the Domo documentation. Certainly, the more joins you add, the bigger hit on performance, so that will be something to consider. You can try sending an e-mail to Domo Support and see if they will give you an exact number, if there is one.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • GrantSmith
    GrantSmith Coach
    Answer ✓

    It depends on the amount of data you're using in your joins and unions. There's a 60 second timeout that will cause it to not load a card when it's attempting to query a dataset so if you have too many columns or joins in your view it may cause a timeout and cause the card to fail to load.

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

Answers

  • MarkSnodgrass
    Answer ✓

    There is no limit listed in the Domo documentation. Certainly, the more joins you add, the bigger hit on performance, so that will be something to consider. You can try sending an e-mail to Domo Support and see if they will give you an exact number, if there is one.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • GrantSmith
    GrantSmith Coach
    Answer ✓

    It depends on the amount of data you're using in your joins and unions. There's a 60 second timeout that will cause it to not load a card when it's attempting to query a dataset so if you have too many columns or joins in your view it may cause a timeout and cause the card to fail to load.

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