2 Replies Latest reply on Feb 20, 2018 8:33 AM by Kary K

    Dashboards built on Database Views/Tables

    Kary K

      Hello All,

       

      I would like to know the difference between creating tableau dashboards using a Database view and using a Database table.

      How would the dashboard be effected and how would the database be effected and what are the pros and cons of connecting to views and tables?

       

      It would be of great help if anyone shared this knowledge with me.

       

       

      Thanks in advance,

      Kary

        • 1. Re: Dashboards built on Database Views/Tables
          Wilson Po

          Hi Kary,

           

          From a Tableau perspective, there really isn't any difference - Tableau handles both objects almost identically and neither really impact functionality.  The biggest consideration is really the ongoing management of the data source - there are situations were a view is poorly optimized and querying from it results slower performance when compared to connecting directly to the tables.  Tableau might have less awareness of the schema to optimize its queries by itself; referential integrity or join culling would be dependent on set up in the database to manage.  On the other hand, I have also found views to make it easier to update the data source for Tableau without needing to open the workbook.  Changes to view (such as adding tables to the schema, adding additional columns, etc.) reflect directly in the workbook, and can make it easier to manage if the tables inside the view need to be updated over time.  Similar to other reporting tools, having the extra abstraction layer can help keep things consistent for the workbook even if updates are occurring in database.  

          1 of 1 people found this helpful
          • 2. Re: Dashboards built on Database Views/Tables
            Kary K

            Thanks Wilson!