Quick Server question. I have a SQL view which I am using on a Tableau workbook as an extract. The book gets published to Tableau Server. Now when I refresh the extract, does the Tableau Server take the load of running the view or does the SQL server take the load. I want to understand in terms of performance.
2 answers
I'm sure others will be able to give better detail but, basically, the Server (Tableau Server) sends the SQL request to the data source db, which executes the SQL, and sends the results to the Server which crunches the data into the extract. So, yes, your data source db naturally will be doing some work.
