Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
For example, you have a registered dataset created using an HCatalog table with four partitions and a transformation. Then, you create a semantic model. When you process the semantic model, the full process and any subsequent incremental processes will check all directories and partitions.
...
From the Toolbox, click Datasets.
Click the Actions menu ( ⋮ ) then choose Add Dataset.
Choose the file source type: HDFS, Table, or SQL. See Creating a dataset for details on configuring the other options.
Select Lookup file to indicate that this file will be used for lookup purposes.
Click Save when you are finished. You can click Revert if needed.
Transformation
You can also specify lookup when creating a transformation. You can optionally materialize the transformation at the same time. In subsequent processes, the dataset is processed incrementally, but the output data is fully used by the semantic model or parent transformation.
To create a lookup transformation, perform the following steps:
If needed, from the Toolbox, click Utilities and select Transform Data.
Kyvos Datasets displays in a new tab in the browser.Choose a dataset.
Right-click Output and choose Properties, or double-click the Output action.
Select the Save as lookup dataset checkbox. (Scroll down if needed to see it.)
To preview the results, click Preview.
Click Save.
...
Related topics