1 of 1 people found this helpful
Hey Keelan -
There's no official guidance on your specific question, but my experience is that using a data server data source takes a touch longer on connection (maybe 1-2 seconds). After that, no difference.
This sort of makes sense if you think about it. A local data source does this:
Viz => RedShift
A data server data source does this:
Viz => Tableau Data Server Component => RedShift
There's an extra "layer" we traverse there...
My advice is to try things out for yourself and see what "your" difference is. Then, decide if the easy of administration you get with a data server data source is worth the potential "extra connection time"
Hope this helps a little?
In my experience, basing on your scenario I will take local workbook.
If your data source's data changes rapidly then I leave it to local than Server. However, an extract is made either in Scheduled way or manually when you have data appended to your data source. This way the data is sure. In this approach, one need not be watchful about calculations, etc..