Using Tableau Output tool with the Update Option

Question

Hi,

Another team in my business is having an issue as they are trying to upload around 6 million rows of data from Alteryx to Tableau Online every day (and its taking around 50 minutes!).  We have asked why they upload 6 million records daily and its because some of them are backdated records going back years.  I think this might be due to something like a client changing their name and they then change all records of that client to the new name,  Anyway, what we are thinking is that they should only upload the updated records but I'm not sure how that works - we can obviously identify what records should be updated, but is it as simple as choosing the Update option and then only passing those records to the Tableau Output tool with the Update/Upsert option selected?

patrick_mcauliffe · Accepted Answer

Think of Tableau Data Extracts (or the Hyper files) that Tableau uses on the backend more like Excel files than like an indexed database.

You're pretty much stuck with a full overwrite every time (if you want to update).  You're better off setting up a SQL instance in the cloud and having Tableau Online connect to that.