8 Replies Latest reply on Mar 1, 2018 6:02 PM by Lian Norliansyah Branched from an earlier discussion.

    Pulling data from the PostgreSQL

    Benjamin Torgesen

      On a weekly basis, we extract all of the rows from HTTP_REQUESTS and load it into our Teradata data warehouse. This is about a million rows a week. We also copy a few other tables like the SITES, USERS, and SYSTEM_USERS so that we have good display data (names instead of IDs).  We've built all of our Tableau usage dashboards and cost model dashboards used by our 140+ business teams (sites) on top of the data in Teradata.  This allows for much more extensive reporting about usage and dashboard performance than the built-in maintenance reports.

       

      - Ben