Make Resources from multiple Datasets

Problem

Using update_resource to bring more source data into a Resource Dataset uses more resources than desired.

Solution

Use the union verb to join the source datasets in a single worksheet before using make_resource to create the Resource Dataset.

Explanation

It is common to build a Resource based on events coming from multiple event Datastreams. It is much more efficient to union the event streams together and do make_resource once. This allows Observe to efficiently align time windows and create an optimal Resource definition.

If you start by using make_resource on one event Datastream and then use update_resource to merge in the other event streams, this will cause an expensive temporal left outer join.

Better:

Less Good: