🧑🍳Join dataset with YouPrep™
Note that the JOIN / Append step are not available under a NativeSQL context. It's not possible make make a JOIN / Append with any dataset that is executed in NativeSQL. More information about steps covered on NativeSQL available here.
You will find below, the possibilities to join datasets depending on the source of the dataset, the type of the joined dataset and the storage type defined for the actual dataset.
Here are some additional informations about wording used in the table:
Live dataset from stored: a dataset created directly or indirectly from a stored dataset
Live dataset from full live: a live dataset created indirectly from a connector with only live datasets between the connector and the dataset
| Source of the dataset | Type of dataset joined | Saving storage | Managed |
|---|---|---|---|
Connector | Stored dataset | Live | |
Connector | Stored dataset | Stored | |
Connector | Live dataset from stored | Live | |
Connector | Live dataset from stored | Stored | |
Connector | Live dataset from full live | Live | |
Connector | Live dataset from live | Stored | |
Stored dataset | Stored dataset | Live | |
Stored dataset | Stored dataset | Stored | |
Stored dataset | Live dataset from stored | Live | |
Stored dataset | Live dataset from stored | Stored | |
Stored dataset | Live dataset from full live | Live | |
Stored dataset | Live dataset from full live | Stored | |
Live from stored | Stored dataset | Live | |
Live from stored | Stored dataset | Stored | |
Live from stored | Live dataset from stored | Live | |
Live from stored | Live dataset from stored | Stored | |
Live from stored | Live dataset from full live | Live | |
Live from stored | Live dataset from full live | Stored | |
Live dataset from full live | Stored dataset | Live | |
Live dataset from full live | Stored dataset | Stored | |
Live dataset from full live | Live dataset from stored | Live | |
Live dataset from full live | Live dataset from stored | Stored | |
Live dataset from full live | Live dataset from full live | Live | |
Live dataset from full live | Live dataset from full live | Stored |
Last updated