I know you can't figure out exactly what the SQL query is until Tableau tells you a way to download that from Tableau Online, but with the query you just gave that you think is the problem query, did you test that in Databricks to see if it runs without an error?

My thought is, if it runs on Databricks directly yet Tableau it does not, then it is the Tableau support team that needs to help you with this problem. If it doesn't work on our side, then we can look at the Spark UI of that specific run to try to identify what is the problem. I see what you sent for the other queries and it seems Photon is helping with those joins, so when you run it on our side, please make sure to use the Photon enabled cluster you have been using so we can troubleshoot this further.