CODEWITHSUNDEEP
tableau-api
sree
sree

Reputation: 1960

Tableau extract using row store vs Column store DBs

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

Upvotes: 0

Views: 329

Answers (1)

Sam M
Sam M

Reputation: 4166

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.

Upvotes: 0

Related Questions