Week 11: PostgreSQL & Tableau Server | DS23

by Auguste Navickyte

Ever wondered what's happening deeper within your Tableau Server when you and your colleagues are using it? Luckily, all data about your datasources, extracts, user interactions, and more are stored in a PostgreSQL database within the Tableau Server repository. If you have access to the repository, you can use this data to gain insight into Tableau Server performance.  How do you do that?

  1. Go to Connect window on Tableau, select To a Server and choose PostgreSQL
  2. Connect using your credentials
  3. Before you start digging into the tables (there are a lot of them!), I suggest having a look at this data dictionary that gives information about the available data
  4. Join tables and build views based on your preferences

I chose to look at datasources and how often they are used at our Tableau Server. For that, I joined data_connections table (to get datasources ID) with datasource_events table (to get the activity of each data source). The join was done on Datasource ID. I then visualised datasources events over time, the events across datasources, the event types and new datasources. My final dashboard for datasource performance is presented below.

© 2022 The Information Lab Ltd. All rights reserved.