To assist in building your recipe, you can associate a target with the recipe. This schema is displayed in the Target Matching bar in the Transformer page above your column histograms, so that you can track how you are progressing toward completion of the recipe.
- A target is the representation of the columns to which you are building your recipe to match. When you know the column order, names, and data types for which you are building your recipe, you can more quickly develop the recipe steps to match this schema.
- For more information, see Overview of Target Matching.
Before you create
A target is created from one of the following sources:
- An imported dataset
- A recipe in the current flow
- A dataset reference from another flow
Before you create a new target, you must identify, create, or import one of the above objects. Your target must be in a finished state.
NOTE: A target is a snapshot of the target at the time of creation. It does not inherit changes from the source after creation. To update, you must delete and recreate the target. Instructions are provided below.
Each recipe can have one and only one target. Please use the following steps to create a target for your recipe.
- Open the flow containing the recipe. In Flow View, create or select the recipe.
If a target already exists for the recipe, select Remove Target from the context menu in the right panel.
NOTE: A recipe can have one and only one target associated with it.
- After deleting the old one, from the context menu, select Assign Target to Recipe.
- Select the imported dataset, recipe, or reference to use as your target for this recipe. Click Add.
- If the target looks accurate, click OK. If not, click Cancel.
- The target is associated with your recipe.
NOTE: You cannot edit a target through Cloud Dataprep by TRIFACTA®. To make changes, delete the target and add in a modified target.
If there are have been changes to the source schema of your target, please complete the following steps to update your target.
- If the source of the target needs to be re-imported into Cloud Dataprep by TRIFACTA, please do so now.
- In Flow View, select the recipe to which the target is assigned. From the context menu for the recipe, select the following:
- Select Remove Target to remove the current target.
- Select Assign Target to Recipe to select a new target.
- See Create above for details.
After a schema has been associated with your recipe, schema information and a few example rows are displayed in the data grid of the Transformer page. These examples serve to guide your transformation operations. See Data Grid Panel.
In the Column Browser panel, you can select one or more columns and apply schema-related transformations to them. See Column Browser Panel.
- In Flow View, select the recipe whose schema you wish to remove.
In the right panel, click the context menu. Select Remove Target.
NOTE: Removing a target from a recipe does not remove the underlying dataset from the platform.
NOTE: Deleting a dataset does not remove any target based off of it. You can still perform alignment operations to match the schema. However, you cannot view example rows from the target in the Transformer page.