Hi Marcel Prust,
1) When connecting Live, you may want to use
connection customizations as in the attached postgres.tdc file.
Please refer to the section on Tableau Help:
2) If it works, why not?
Besides, Tableau doesn't support ODBC connection customizations on a Server for extracts.
postgresql.tdc.zip 336 bytes
Thanks, Yuri. I've seen this link already, probably, now I'll try to follow some instructions from it. But I can't understand still. How exactly does custom SQL work, using temp tables always? Or just sometimes? why does tableau somehow create temp tables, but can't delete them? Or tableau just iterates over temp tables like temporary table Tableau_1, temporary table Tableau_2, ... ? if Tableau doesn't use temp tables for live connection, what else does it use?
I'll be glad to hear the answer, if you know that! But still thank you!)
1 of 1 people found this helpful
Tableau uses temporary tables for lots of things, generally when it is faster than writing things inline in a query.
The information you are showing is just Tableau testing to see whether your database allows temporary tables. It finds out it doesn't, and then doesn't use temporary tables.
Yuriy's suggested changes prevent Tableau from doing this testing. It will speed up creating a connection slightly, but otherwise have no impact.
now, you've clarified me it entirely! Thanks