2 of 2 people found this helpful
See the following knoledgebase article which goes into why Tableau creates these temp tables and how to get rid of them: Temp Tables in Tableau Desktop and Tableau Server | Tableau Software
In my opinion, there is really no reason that the user used to connect to a database would have anything other than purely read-only access to the database. It is certainly the most secure option. So, I'd suggest changing that user's permissions so that it is read-only. Then it should not be able to create those temp tables.
Thanks for your help.
If this answers your question, would you be so kind as to mark the response as the "correct answer"? This will close the thread and will also make it easier for others with similar problems in the future. Thanks!
Hi, if we don't allow creation of temp tables, where will Tableau then store the information that it usually stores in the temp tables?