Loading

Creating an Incremental Refresh with Multiple Unique SQL Tables

Дата публикации: Apr 13, 2024
Задача
How to combine multiple unique SQL tables, when creating or refreshing an incremental extract in Tableau Desktop.
Действия

Option 1 

Create and refresh separate extracts (per table) and use data blending 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 together in a workbook, 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 multiple 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.
Дополнительные ресурсы

Blend Your Data
Extract Your Data

 

Номер статьи базы знаний

001456657

 
Загрузка
Salesforce Help | Article