Tableau extract using row store vs Column store DBs

Question

I am creating a .TDE(tableau extract) from a table in sql server which has around 180+ columns and 60 million records and is taking around 4 hours in current infra of 16GB RAM and 12 cores

I was looking for any other way by which this can be done faster. I would like to know if I could load my data into any column store DB which can connect to tableau and then create a TDE from the data in the column store DB can make a bit better in performance.

If yes, please suggest any such column store DB

In Desktop, turn on Performance Recording and then generate the extract. When it's done generating, turn off Performance Recording. Tableau will then open a new workbook with visualizations of how long each part of the TDE build process takes. For example, it breaks out the database sql call, the tableau data engine call, and a few other things. At the very least, this will tell you if it's Tableau slowing you down or your database. — Sam M

Sam M Sam M · Accepted Answer · 2017-10-27T03:07:38

The Tableau SDK is a way to build TDE files without having to use Desktop. You can try it and see if you get better performance.

Does your TDE need all 180+ columns? You can get a noticeable performance improvement if your TDE contains only the columns you need.

Tableau extract using row store vs Column store DBs

1 Answers