KNOWLEDGE BASE

Creating an Incremental Refresh with Multiple Unique SQL Tables


Published: 18 Sep 2017
Last Modified Date: 19 Sep 2017

Question

How to combine multiple unique SQL tables, when creating or refreshing an incremental extract in Tableau Desktop.

Environment

  • Tableau Desktop
  • MS SQL Server
  • Extracts

Answer

Option 1 

Create and refresh separate extracts (per table) and use data bending in the workbook. This option will allow each of the extracts to be refreshed incrementally independent of the others and it does not require any changes on the database side to implement. When used in a workbook together, the tables can be blended on date fields or some other non-unique field that they have in common. Additionally, each data sources can be published and used independently.

Option 2 

Work with your database administrator or your SQL Server administrator to create a a view in SQL Server that combines the three tables and provides its own unique key. This view would just be connected like any other table and an incremental extract can be made on the key of the view instead of those in the original tables.
Did this article resolve the issue?