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
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
(optional) Specify a user-friendly Description value.
For Type, select the type of parameter.
Variable Type Parameter
Variable type parameters are single values that can be one of the following formats:
String |
|
Dataprep by Trifacta patterns | `{letter}+` |
Regular expression | /[a-zA-z]+/ |
Selector type parameter
Selector type parameters are lists of one or more permitted values.
Parameter Value
Under Choices, enter a value.
The first value that you add is the default value.
3. Click Save.
The parameter is now available to be referenced in your recipe.
Utilizing Parameters within recipe
You can reference a parameter within your recipe in the following ways -
a) By entering a dollar sign ($) followed by the parameter name
$paramRegion
b)By entering a dollar sign and enclosing in curly brackets, ie. ${Parameter Name} if the parameter name contains a space, the curly brackets are required.
Example - Using a Static Parameter within recipe
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 user name is equal to value of the parameter.
Example - Using a Pattern based parameter within the recipe
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.