3 Replies Latest reply on Jul 23, 2018 8:00 AM by Matt Coles

    Tableau PostGre DB

    suresh puppala

      Hi,

       

      we are looking to pull more than 90 days data to analyze performance over a period of time and also see the if no of user views has increased by adding new worksheets from tableau server repository and what is the max limit of the data

      what is the impact if we change the settings and let us know is there a way to change the settings.

       

      Any Suggestions please let us know.

       

      Thank you!

        • 1. Re: Tableau PostGre DB
          Jeff Strauss

          Which tables are you trying to query?  I believe that this history tables (prefixed by hist_) have 183 days retention by default.  This can be changed with the tabadmin option wgserver.audit_history_expiration_days.  tabadmin configuration options .  The only impact is that your Postgres database is just a bit larger, but if you have sufficient disk space, then it should be fine.

          • 2. Re: Tableau PostGre DB
            Donna Coles

            Hi Suresh

             

            If you are talking about amending one of the existing Tableau Server Admin views, then this isn't directly possible.  However, it is possible to get a copy of the workbooks used to build these views which you can then connect to, amend and publish elsewhere.

             

            You will need to have set up access to your postgres database.  Please have a read of the following

             

            Create Custom Administrative Views

            https://tableaulove.com/admin-view-twb-files-go-tableau-server-v10/

             

            What the impact of extending to include more than 90 days will be dependent on your set up, the volume of users (and therefore amount of data being collected) and which views you actually change.  Note though, that as per the first article, there is also a limit as to how much data Tableau will store by default (183 days).  This is a figure that can also be amended, but again what the impact will be I could not say.

             

            Regards

            Donna

            • 3. Re: Tableau PostGre DB
              Matt Coles

              Performance data on how long dashboards take to load for users is stored only in http_requests. It is maintained only as long as seven days, and the extra records are removed when you run tabadmin cleanup. There is no setting to preserve that data any longer. To do so, you will need to find a solution to incrementally pull new records out into a separate location. An easy way to do this is by using an incremental extract in Tableau, and just incrementing it on the "id" field. But make sure you don't do any full refreshes, as doing so will wipe out everything accumulated so far. Since certain issues may require you to take a full refresh every now and again, it's best to back up what you've accumulated so far every month or quarter or so, and if need be, use something like Prep to union all the data together.