2 Replies Latest reply on Sep 19, 2013 6:05 AM by Dylan Snyder

    extracting data - multiple tables, incremental refresh

    Jonathan O'Grady

      I am working off an enormous database.  the tableau professionals have recommended that I do not access this data live, but rather extract a portion.

       

      I plugged in to the database and selected the relevant schema. I then opted for a multiple table connection, selecting seven tables. I verified joins across these tables and then extracted the data for one day. It took two hours to load.

       

      Once I had verified that the data was useful, I selected fields to hide to reduce the size of the data pool.

       

      I then decided to download two weeks worth of data. This took me eight hours. Unfortunately, while the data extract confirms that the data for two weeks has been extracted, can still only see the single original date, instead of 14 days.

       

      Help/advice would be appreciated.