Refresh joined Dataset

Question & Answer
, ,
1

Hi Team,
Dataset 1 : SQL Server Direct Query
Dataset 2 : S3 with SPICE full refresh(Hourly refresh)

Currently my scenario is to join the above 2 datasets

Now my questions are

  1. If I refresh the joined dataset, then does it refresh the primary dataset as well..?
  2. If I refresh the primary datasets(Dataset 1 and 2 separately) then does it required to refreshed the joined dataset also…?
  3. Any other way to refresh the same..?

Thanks

2

Hi @manjunathdl,

  1. No, refreshing the joined dataset will not also refresh your primary/original datasets.
  2. There are cases where even after updating your primary datasets, a refresh on the joined dataset is still needed as well, it may not always be necessary but may always be the best practice.
    Make sure to refresh your primary datasets prior to the joined copy.
1 Like
3

Hi @Brett ,

Thank you for the information. We will trigger a refresh for primary datasets and once its done we will refresh the joined one.

Thanks

1 Like