Forum Discussion
Dataflows - Only Refresh Specific Tables
Hi there,
Within dataflow, is it possible to set up refresh only for group of tables and keep the other tables as is. The purpose is, in the same entity I have lookup tables and Fact Tables. Lookup tables don't change so I don't need to refresh those, the only changing table is fact table.
Thanks
Duygu
Hi Anonymous
Linked Entities refresh differently if they are together in the workspace or in separate workspaces. If all together in the same workspace, refreshing the main Dataflow will also force the linked entities to refresh. If the linked entities are in other workspaces, refreshing the dataflow will not force a refresh in the linked entities. Be aware that Linked Entities require a Premium licence. In this case I'd just go with two separate Dataflows, not linked, with different refresh schedules. Simpler, cheaper and gets the job done.
Hope this helps
Stuart
6 Replies
Hi Anonymous
No, as far as I'm aware refresh is set for the Dataflow and not for individual tables in it.
In this scenario I'd have two Dataflows, one with the Fact table and one with the Dimension (lookup) tables. You can then set a different refresh time for each Dataflow.
Hope this helps
Stuart
Hi Anonymous
Linked Entities refresh differently if they are together in the workspace or in separate workspaces. If all together in the same workspace, refreshing the main Dataflow will also force the linked entities to refresh. If the linked entities are in other workspaces, refreshing the dataflow will not force a refresh in the linked entities. Be aware that Linked Entities require a Premium licence. In this case I'd just go with two separate Dataflows, not linked, with different refresh schedules. Simpler, cheaper and gets the job done.
Hope this helps
Stuart