I am not sure whether I fully understand your questions:
You would first make a live data connection to Redshift for initial current data.
Once you have all joins, etc, you need to create the visualization, you would then create an extract. When creating this extract for optimal performance: hiding any unused fields, selecting least level of granularity when working with dates for example, etc. will all contribute to improving performance. The published workbook would point to this extract as the data source instead of a live connection.
Your extract will not be updated automatically, but you can leverage Tableau Server to periodically run a job to refresh the data from Redshift to update the data as needed.
I hope this helps.
Thank you for the prompt reply.
I have my data source on tableau server already. It is an extract which is scheduled to refresh daily. I created a workbook to connect to that tableau server extract.
As you can see in the thread below, even if you have an extract data source on tableau server, you can have a LIVE connection to it in your workbook:
So my question is, instead of having a LIVE connection to an extract Tableau Server data source, would it make a difference to my dashboard performance if I extracted the data source to my workbook?
Ah, OK. I think I better understand now. Assuming you are pointing to an optimized Tableau Data Extract, it may not make a difference.
Below is link corresponding to documentation to test performance:
Also, below is another thread similar to the one you found that may help:
I believe Will is correct, creating an extract of an extract would not get you any performance gains.
Doing that would also prevent your workbook from updating automatically once the original Redshift extract is updated. You would have to schedule a second refresh for the extract your workbook connects that would occur sometime after the Redshift extract has successfully updated. So not only would you not see any performance gains, but you would also be creating additional steps in the refresh process.
Hope that helps,