(View in full screen)

Parameterization can be used in cases where you might need to make minor tweaks to your recipe when executing a job. You can create variables in the recipe to be overridden with different values.

At flow level, you can create parameters to reference in your recipes.

Creating Flow Parameters

a) From within the Transformer view

In the Transformer, click on the Parameters icon on the top right corner.

b) From Flow View

In the flow view, click on the More(...) menu and select Parameters

The Manage Parameters dialog opens.

Creating Parameters

  1. In the Manage Parameters dialog that opens, click on Add Parameter

2. Enter a name and a default value for your parameter

  • Parameter names can contain alpha-numeric and spaces.

  • Parameter names are case sensitive and cannot be edited once created

  • Parameter values are evaluated as String type

3. Click Save and Close the dialog.

The parameter is now available to be referenced in your recipe.

Utilizing Parameters within recipe

You can reference a parameter within your recipe by entering a dollar sign ($) followed by the parameter name in curly brackets, ie. ${ParameterName} in your transformation step.

Example - Using a Static Parameter within recipe

  1. Create a parameter using a specified value. Here we define Parameter-Static as "Lancaster"

2. In the recipe, add a new step. Here, we are using the ${Parameter-Static} parameter to filter our data to only keep rows where the city name is equal to value of the parameter. Only rows where the Address_City is Lancaster will be kept.

Example - Using a Pattern based parameter within the recipe

  1. Create a parameter where the value is defined using a Trifacta Pattern. Here Parameter-Pattern is `{digit}{4}` (a 4 digit pattern).

Note- To learn more about Trifacta Patterns, read this detailed article

2. In the recipe, add a step. Here we extracting values from Address_Street_Number that match the specified pattern of 4 sequential digits.

For more examples on how to use parameters in your recipe, check out this article.

More Info

To learn about creating Flow Parameters, read this detailed documentation guide.

Did this answer your question?