title: Large CSV file with Tableau Desktop
body: <p>I've a 100GB CSV file (200 million rows X 60 columns) which I'm using to create dashboards in Tableau Desktop via extract. I've been facing a performance issue and it takes about 2 minutes to refresh the dashboard when I select/deselect any of the dimension filters. Can using Tableau Server solve this? If yes, how many nodes should I configure and what configuration for each of them?</p>
  
  <p>Can it also be an issue with the cache settings?</p>
  
  <p>I was also thinking of putting this data into a columnar database like Redshift and then use live connection so that Redshift querying engine is used instead of Tableau. Is that an overkill for this kind of small dataset?</p>