CODEWITHSUNDEEP
mysqlimporttableau-api
user3768495
user3768495

Reputation: 4657

partiially load data into Tableau from MySQL database

I have a MySQL database running and I've got Tableau connected to it. The issue I am having is that the table is too long - it contains years of transactions. And I only care about the transactions in the most recent 60 days. I have added a filter on the date so I can get the subset I need. However, it is super slow every time I open the workbook since it will query on the whole table and then apply the filter. So my question is:

How can I make Tableau only load the most recent 60 days of data to start with? Thanks!

Upvotes: 0

Views: 110

Answers (1)

cmcau
cmcau

Reputation: 557

I see a few possible solutions :

  1. Create a view or a materialised view in mySQL to cater for the last 60 days only
  2. Change the sheet filter to a context filter. The (normal) sheet filter won't affect the data query, but a context filter will.
  3. If it's still too slow, create an extract. You can schedule Tableau Server to update the extract every day.

Upvotes: 1

Related Questions