This is the new *CloudFormation Template Reference Guide*. Please update your bookmarks and links. For help getting started with CloudFormation, see the [AWS CloudFormation User Guide](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/Welcome.html).

# AWS::DataBrew::Recipe
<a name="aws-resource-databrew-recipe"></a>

Specifies a new AWS Glue DataBrew transformation recipe.

## Syntax
<a name="aws-resource-databrew-recipe-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-resource-databrew-recipe-syntax.json"></a>

```
{
  "Type" : "AWS::DataBrew::Recipe",
  "Properties" : {
      "[Description](#cfn-databrew-recipe-description)" : String,
      "[Name](#cfn-databrew-recipe-name)" : String,
      "[Steps](#cfn-databrew-recipe-steps)" : [ RecipeStep, ... ],
      "[Tags](#cfn-databrew-recipe-tags)" : [ Tag, ... ]
    }
}
```

### YAML
<a name="aws-resource-databrew-recipe-syntax.yaml"></a>

```
Type: AWS::DataBrew::Recipe
Properties:
  [Description](#cfn-databrew-recipe-description): String
  [Name](#cfn-databrew-recipe-name): String
  [Steps](#cfn-databrew-recipe-steps): 
    - RecipeStep
  [Tags](#cfn-databrew-recipe-tags): 
    - Tag
```

## Properties
<a name="aws-resource-databrew-recipe-properties"></a>

`Description`  <a name="cfn-databrew-recipe-description"></a>
The description of the recipe.  
*Required*: No  
*Type*: String  
*Minimum*: `0`  
*Maximum*: `1024`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Name`  <a name="cfn-databrew-recipe-name"></a>
The unique name for the recipe.  
*Required*: Yes  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `255`  
*Update requires*: [Replacement](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-replacement)

`Steps`  <a name="cfn-databrew-recipe-steps"></a>
A list of steps that are defined by the recipe.  
*Required*: Yes  
*Type*: Array of [RecipeStep](aws-properties-databrew-recipe-recipestep.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Tags`  <a name="cfn-databrew-recipe-tags"></a>
Metadata tags that have been applied to the recipe.  
*Required*: No  
*Type*: Array of [Tag](aws-properties-databrew-recipe-tag.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

## Return values
<a name="aws-resource-databrew-recipe-return-values"></a>

### Ref
<a name="aws-resource-databrew-recipe-return-values-ref"></a>

When you pass the logical ID of this resource to the intrinsic `Ref` function, `Ref` returns the resource name. For example:

 `{ "Ref": "myRecipe" }` 

For an AWS Glue DataBrew recipe named `myRecipe`, `Ref` returns the name of the recipe. 

## Examples
<a name="aws-resource-databrew-recipe--examples"></a>



### Creating recipes
<a name="aws-resource-databrew-recipe--examples--Creating_recipes"></a>

The following examples create new DataBrew recipes.

#### YAML
<a name="aws-resource-databrew-recipe--examples--Creating_recipes--yaml"></a>

```
Resources:
  TestDataBrewRecipe:
    Type: AWS::DataBrew::Recipe
    Properties:
      Name: recipe-name
      Description: This is the recipe description.
      Steps:
      - Action:
          Operation: EXTRACT_PATTERN
          Parameters:
            SourceColumn: Consulate
            Pattern: A
            TargetColumn: extract_pattern
        ConditionExpressions:
        - Condition : LESS_THAN_EQUAL
          Value: 5
          TargetColumn: Target
      Tags: [{Key: key00AtCreate, Value: value001AtCreate}]
```

#### JSON
<a name="aws-resource-databrew-recipe--examples--Creating_recipes--json"></a>

```
{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Description": "This CloudFormation template specifies a DataBrew Recipe",
    "Resources": {
        "MyDataBrewRecipe": {
            "Type": "AWS::DataBrew::Recipe",
            "Properties": {
              "Name": "na-recipe-cf-test",
              "Description": "This is the recipe description.",
              "Steps":[
                {
                  "Action":{
                    "Operation":"EXTRACT_PATTERN",
                    "Parameters":{
                      "SourceColumn": "Consulate",
                      "Pattern": "A",
                      "TargetColumn": "extract_pattern"
                  }
                },
                  "ConditionExpressions":[
                    {
                      "Condition": "LESS_THAN",
                      "ConditionValue": "2",
                      "TargetColumn": "target"
                    },
                    {
                      "Condition": "GREATER_THAN",
                      "Value": "0",
                      "TargetColumn": "target"
                    }
                  ]
                }
              ],
              "Tags": [
                    {
                        "Key": "key00AtCreate",
                        "Value": "value001AtCreate"
                    }
                ]
            }
        }
    }
}
```

# AWS::DataBrew::Recipe Action
<a name="aws-properties-databrew-recipe-action"></a>

Represents a transformation and associated parameters that are used to apply a change to an AWS Glue DataBrew dataset.

## Syntax
<a name="aws-properties-databrew-recipe-action-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-action-syntax.json"></a>

```
{
  "[Operation](#cfn-databrew-recipe-action-operation)" : String,
  "[Parameters](#cfn-databrew-recipe-action-parameters)" : RecipeParameters
}
```

### YAML
<a name="aws-properties-databrew-recipe-action-syntax.yaml"></a>

```
  [Operation](#cfn-databrew-recipe-action-operation): String
  [Parameters](#cfn-databrew-recipe-action-parameters): 
    RecipeParameters
```

## Properties
<a name="aws-properties-databrew-recipe-action-properties"></a>

`Operation`  <a name="cfn-databrew-recipe-action-operation"></a>
The name of a valid DataBrew transformation to be performed on the data.  
*Required*: Yes  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Parameters`  <a name="cfn-databrew-recipe-action-parameters"></a>
Contextual parameters for the transformation.  
*Required*: No  
*Type*: [RecipeParameters](aws-properties-databrew-recipe-recipeparameters.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe ConditionExpression
<a name="aws-properties-databrew-recipe-conditionexpression"></a>

Represents an individual condition that evaluates to true or false.

Conditions are used with recipe actions. The action is only performed for column values where the condition evaluates to true.

If a recipe requires more than one condition, then the recipe must specify multiple `ConditionExpression` elements. Each condition is applied to the rows in a dataset first, before the recipe action is performed.

## Syntax
<a name="aws-properties-databrew-recipe-conditionexpression-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-conditionexpression-syntax.json"></a>

```
{
  "[Condition](#cfn-databrew-recipe-conditionexpression-condition)" : String,
  "[TargetColumn](#cfn-databrew-recipe-conditionexpression-targetcolumn)" : String,
  "[Value](#cfn-databrew-recipe-conditionexpression-value)" : String
}
```

### YAML
<a name="aws-properties-databrew-recipe-conditionexpression-syntax.yaml"></a>

```
  [Condition](#cfn-databrew-recipe-conditionexpression-condition): String
  [TargetColumn](#cfn-databrew-recipe-conditionexpression-targetcolumn): String
  [Value](#cfn-databrew-recipe-conditionexpression-value): String
```

## Properties
<a name="aws-properties-databrew-recipe-conditionexpression-properties"></a>

`Condition`  <a name="cfn-databrew-recipe-conditionexpression-condition"></a>
A specific condition to apply to a recipe action. For more information, see [Recipe structure](https://docs.aws.amazon.com/databrew/latest/dg/recipe-structure.html) in the *AWS Glue DataBrew Developer Guide*.  
*Required*: Yes  
*Type*: String  
*Pattern*: `^[A-Z\_]+$`  
*Minimum*: `1`  
*Maximum*: `128`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TargetColumn`  <a name="cfn-databrew-recipe-conditionexpression-targetcolumn"></a>
A column to apply this condition to.  
*Required*: Yes  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `1024`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Value`  <a name="cfn-databrew-recipe-conditionexpression-value"></a>
A value that the condition must evaluate to for the condition to succeed.  
*Required*: No  
*Type*: String  
*Maximum*: `1024`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe DataCatalogInputDefinition
<a name="aws-properties-databrew-recipe-datacataloginputdefinition"></a>

Represents how metadata stored in the AWS Glue Data Catalog is defined in a DataBrew dataset. 

## Syntax
<a name="aws-properties-databrew-recipe-datacataloginputdefinition-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-datacataloginputdefinition-syntax.json"></a>

```
{
  "[CatalogId](#cfn-databrew-recipe-datacataloginputdefinition-catalogid)" : String,
  "[DatabaseName](#cfn-databrew-recipe-datacataloginputdefinition-databasename)" : String,
  "[TableName](#cfn-databrew-recipe-datacataloginputdefinition-tablename)" : String,
  "[TempDirectory](#cfn-databrew-recipe-datacataloginputdefinition-tempdirectory)" : S3Location
}
```

### YAML
<a name="aws-properties-databrew-recipe-datacataloginputdefinition-syntax.yaml"></a>

```
  [CatalogId](#cfn-databrew-recipe-datacataloginputdefinition-catalogid): String
  [DatabaseName](#cfn-databrew-recipe-datacataloginputdefinition-databasename): String
  [TableName](#cfn-databrew-recipe-datacataloginputdefinition-tablename): String
  [TempDirectory](#cfn-databrew-recipe-datacataloginputdefinition-tempdirectory): 
    S3Location
```

## Properties
<a name="aws-properties-databrew-recipe-datacataloginputdefinition-properties"></a>

`CatalogId`  <a name="cfn-databrew-recipe-datacataloginputdefinition-catalogid"></a>
The unique identifier of the AWS account that holds the Data Catalog that stores the data.  
*Required*: No  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `255`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DatabaseName`  <a name="cfn-databrew-recipe-datacataloginputdefinition-databasename"></a>
The name of a database in the Data Catalog.  
*Required*: No  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `255`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TableName`  <a name="cfn-databrew-recipe-datacataloginputdefinition-tablename"></a>
The name of a database table in the Data Catalog. This table corresponds to a DataBrew dataset.  
*Required*: No  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `255`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TempDirectory`  <a name="cfn-databrew-recipe-datacataloginputdefinition-tempdirectory"></a>
Represents an Amazon location where DataBrew can store intermediate results.  
*Required*: No  
*Type*: [S3Location](aws-properties-databrew-recipe-s3location.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe Input
<a name="aws-properties-databrew-recipe-input"></a>

Represents information on how DataBrew can find data, in either the AWS Glue Data Catalog or Amazon S3.

## Syntax
<a name="aws-properties-databrew-recipe-input-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-input-syntax.json"></a>

```
{
  "[DataCatalogInputDefinition](#cfn-databrew-recipe-input-datacataloginputdefinition)" : DataCatalogInputDefinition,
  "[S3InputDefinition](#cfn-databrew-recipe-input-s3inputdefinition)" : S3Location
}
```

### YAML
<a name="aws-properties-databrew-recipe-input-syntax.yaml"></a>

```
  [DataCatalogInputDefinition](#cfn-databrew-recipe-input-datacataloginputdefinition): 
    DataCatalogInputDefinition
  [S3InputDefinition](#cfn-databrew-recipe-input-s3inputdefinition): 
    S3Location
```

## Properties
<a name="aws-properties-databrew-recipe-input-properties"></a>

`DataCatalogInputDefinition`  <a name="cfn-databrew-recipe-input-datacataloginputdefinition"></a>
The AWS Glue Data Catalog parameters for the data.  
*Required*: No  
*Type*: [DataCatalogInputDefinition](aws-properties-databrew-recipe-datacataloginputdefinition.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`S3InputDefinition`  <a name="cfn-databrew-recipe-input-s3inputdefinition"></a>
The Amazon S3 location where the data is stored.  
*Required*: No  
*Type*: [S3Location](aws-properties-databrew-recipe-s3location.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe Parameters
<a name="aws-properties-databrew-recipe-parameters"></a>

<a name="aws-properties-databrew-recipe-parameters-description"></a>The `Parameters` property type specifies Property description not available. for an [AWS::DataBrew::Recipe](aws-resource-databrew-recipe.md).

## Syntax
<a name="aws-properties-databrew-recipe-parameters-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-parameters-syntax.json"></a>

```
{
  "[Parameters](#cfn-databrew-recipe-parameters-parameters)" : RecipeParameters
}
```

### YAML
<a name="aws-properties-databrew-recipe-parameters-syntax.yaml"></a>

```
  [Parameters](#cfn-databrew-recipe-parameters-parameters): 
    RecipeParameters
```

## Properties
<a name="aws-properties-databrew-recipe-parameters-properties"></a>

`Parameters`  <a name="cfn-databrew-recipe-parameters-parameters"></a>
Contextual parameters for the transformation.  
*Required*: No  
*Type*: [RecipeParameters](aws-properties-databrew-recipe-recipeparameters.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe RecipeParameters
<a name="aws-properties-databrew-recipe-recipeparameters"></a>

Parameters that are used as inputs for various recipe actions. The parameters are specific to the context in which they're used.

## Syntax
<a name="aws-properties-databrew-recipe-recipeparameters-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-recipeparameters-syntax.json"></a>

```
{
  "[AggregateFunction](#cfn-databrew-recipe-recipeparameters-aggregatefunction)" : String,
  "[Base](#cfn-databrew-recipe-recipeparameters-base)" : String,
  "[CaseStatement](#cfn-databrew-recipe-recipeparameters-casestatement)" : String,
  "[CategoryMap](#cfn-databrew-recipe-recipeparameters-categorymap)" : String,
  "[CharsToRemove](#cfn-databrew-recipe-recipeparameters-charstoremove)" : String,
  "[CollapseConsecutiveWhitespace](#cfn-databrew-recipe-recipeparameters-collapseconsecutivewhitespace)" : String,
  "[ColumnDataType](#cfn-databrew-recipe-recipeparameters-columndatatype)" : String,
  "[ColumnRange](#cfn-databrew-recipe-recipeparameters-columnrange)" : String,
  "[Count](#cfn-databrew-recipe-recipeparameters-count)" : String,
  "[CustomCharacters](#cfn-databrew-recipe-recipeparameters-customcharacters)" : String,
  "[CustomStopWords](#cfn-databrew-recipe-recipeparameters-customstopwords)" : String,
  "[CustomValue](#cfn-databrew-recipe-recipeparameters-customvalue)" : String,
  "[DatasetsColumns](#cfn-databrew-recipe-recipeparameters-datasetscolumns)" : String,
  "[DateAddValue](#cfn-databrew-recipe-recipeparameters-dateaddvalue)" : String,
  "[DateTimeFormat](#cfn-databrew-recipe-recipeparameters-datetimeformat)" : String,
  "[DateTimeParameters](#cfn-databrew-recipe-recipeparameters-datetimeparameters)" : String,
  "[DeleteOtherRows](#cfn-databrew-recipe-recipeparameters-deleteotherrows)" : String,
  "[Delimiter](#cfn-databrew-recipe-recipeparameters-delimiter)" : String,
  "[EndPattern](#cfn-databrew-recipe-recipeparameters-endpattern)" : String,
  "[EndPosition](#cfn-databrew-recipe-recipeparameters-endposition)" : String,
  "[EndValue](#cfn-databrew-recipe-recipeparameters-endvalue)" : String,
  "[ExpandContractions](#cfn-databrew-recipe-recipeparameters-expandcontractions)" : String,
  "[Exponent](#cfn-databrew-recipe-recipeparameters-exponent)" : String,
  "[FalseString](#cfn-databrew-recipe-recipeparameters-falsestring)" : String,
  "[GroupByAggFunctionOptions](#cfn-databrew-recipe-recipeparameters-groupbyaggfunctionoptions)" : String,
  "[GroupByColumns](#cfn-databrew-recipe-recipeparameters-groupbycolumns)" : String,
  "[HiddenColumns](#cfn-databrew-recipe-recipeparameters-hiddencolumns)" : String,
  "[IgnoreCase](#cfn-databrew-recipe-recipeparameters-ignorecase)" : String,
  "[IncludeInSplit](#cfn-databrew-recipe-recipeparameters-includeinsplit)" : String,
  "[Input](#cfn-databrew-recipe-recipeparameters-input)" : Input,
  "[Interval](#cfn-databrew-recipe-recipeparameters-interval)" : String,
  "[IsText](#cfn-databrew-recipe-recipeparameters-istext)" : String,
  "[JoinKeys](#cfn-databrew-recipe-recipeparameters-joinkeys)" : String,
  "[JoinType](#cfn-databrew-recipe-recipeparameters-jointype)" : String,
  "[LeftColumns](#cfn-databrew-recipe-recipeparameters-leftcolumns)" : String,
  "[Limit](#cfn-databrew-recipe-recipeparameters-limit)" : String,
  "[LowerBound](#cfn-databrew-recipe-recipeparameters-lowerbound)" : String,
  "[MapType](#cfn-databrew-recipe-recipeparameters-maptype)" : String,
  "[ModeType](#cfn-databrew-recipe-recipeparameters-modetype)" : String,
  "[MultiLine](#cfn-databrew-recipe-recipeparameters-multiline)" : Boolean,
  "[NumRows](#cfn-databrew-recipe-recipeparameters-numrows)" : String,
  "[NumRowsAfter](#cfn-databrew-recipe-recipeparameters-numrowsafter)" : String,
  "[NumRowsBefore](#cfn-databrew-recipe-recipeparameters-numrowsbefore)" : String,
  "[OrderByColumn](#cfn-databrew-recipe-recipeparameters-orderbycolumn)" : String,
  "[OrderByColumns](#cfn-databrew-recipe-recipeparameters-orderbycolumns)" : String,
  "[Other](#cfn-databrew-recipe-recipeparameters-other)" : String,
  "[Pattern](#cfn-databrew-recipe-recipeparameters-pattern)" : String,
  "[PatternOption1](#cfn-databrew-recipe-recipeparameters-patternoption1)" : String,
  "[PatternOption2](#cfn-databrew-recipe-recipeparameters-patternoption2)" : String,
  "[PatternOptions](#cfn-databrew-recipe-recipeparameters-patternoptions)" : String,
  "[Period](#cfn-databrew-recipe-recipeparameters-period)" : String,
  "[Position](#cfn-databrew-recipe-recipeparameters-position)" : String,
  "[RemoveAllPunctuation](#cfn-databrew-recipe-recipeparameters-removeallpunctuation)" : String,
  "[RemoveAllQuotes](#cfn-databrew-recipe-recipeparameters-removeallquotes)" : String,
  "[RemoveAllWhitespace](#cfn-databrew-recipe-recipeparameters-removeallwhitespace)" : String,
  "[RemoveCustomCharacters](#cfn-databrew-recipe-recipeparameters-removecustomcharacters)" : String,
  "[RemoveCustomValue](#cfn-databrew-recipe-recipeparameters-removecustomvalue)" : String,
  "[RemoveLeadingAndTrailingPunctuation](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingpunctuation)" : String,
  "[RemoveLeadingAndTrailingQuotes](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingquotes)" : String,
  "[RemoveLeadingAndTrailingWhitespace](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingwhitespace)" : String,
  "[RemoveLetters](#cfn-databrew-recipe-recipeparameters-removeletters)" : String,
  "[RemoveNumbers](#cfn-databrew-recipe-recipeparameters-removenumbers)" : String,
  "[RemoveSourceColumn](#cfn-databrew-recipe-recipeparameters-removesourcecolumn)" : String,
  "[RemoveSpecialCharacters](#cfn-databrew-recipe-recipeparameters-removespecialcharacters)" : String,
  "[RightColumns](#cfn-databrew-recipe-recipeparameters-rightcolumns)" : String,
  "[SampleSize](#cfn-databrew-recipe-recipeparameters-samplesize)" : String,
  "[SampleType](#cfn-databrew-recipe-recipeparameters-sampletype)" : String,
  "[SecondaryInputs](#cfn-databrew-recipe-recipeparameters-secondaryinputs)" : [ SecondaryInput, ... ],
  "[SecondInput](#cfn-databrew-recipe-recipeparameters-secondinput)" : String,
  "[SheetIndexes](#cfn-databrew-recipe-recipeparameters-sheetindexes)" : [ Integer, ... ],
  "[SheetNames](#cfn-databrew-recipe-recipeparameters-sheetnames)" : [ String, ... ],
  "[SourceColumn](#cfn-databrew-recipe-recipeparameters-sourcecolumn)" : String,
  "[SourceColumn1](#cfn-databrew-recipe-recipeparameters-sourcecolumn1)" : String,
  "[SourceColumn2](#cfn-databrew-recipe-recipeparameters-sourcecolumn2)" : String,
  "[SourceColumns](#cfn-databrew-recipe-recipeparameters-sourcecolumns)" : String,
  "[StartColumnIndex](#cfn-databrew-recipe-recipeparameters-startcolumnindex)" : String,
  "[StartPattern](#cfn-databrew-recipe-recipeparameters-startpattern)" : String,
  "[StartPosition](#cfn-databrew-recipe-recipeparameters-startposition)" : String,
  "[StartValue](#cfn-databrew-recipe-recipeparameters-startvalue)" : String,
  "[StemmingMode](#cfn-databrew-recipe-recipeparameters-stemmingmode)" : String,
  "[StepCount](#cfn-databrew-recipe-recipeparameters-stepcount)" : String,
  "[StepIndex](#cfn-databrew-recipe-recipeparameters-stepindex)" : String,
  "[StopWordsMode](#cfn-databrew-recipe-recipeparameters-stopwordsmode)" : String,
  "[Strategy](#cfn-databrew-recipe-recipeparameters-strategy)" : String,
  "[TargetColumn](#cfn-databrew-recipe-recipeparameters-targetcolumn)" : String,
  "[TargetColumnNames](#cfn-databrew-recipe-recipeparameters-targetcolumnnames)" : String,
  "[TargetDateFormat](#cfn-databrew-recipe-recipeparameters-targetdateformat)" : String,
  "[TargetIndex](#cfn-databrew-recipe-recipeparameters-targetindex)" : String,
  "[TimeZone](#cfn-databrew-recipe-recipeparameters-timezone)" : String,
  "[TokenizerPattern](#cfn-databrew-recipe-recipeparameters-tokenizerpattern)" : String,
  "[TrueString](#cfn-databrew-recipe-recipeparameters-truestring)" : String,
  "[UdfLang](#cfn-databrew-recipe-recipeparameters-udflang)" : String,
  "[Units](#cfn-databrew-recipe-recipeparameters-units)" : String,
  "[UnpivotColumn](#cfn-databrew-recipe-recipeparameters-unpivotcolumn)" : String,
  "[UpperBound](#cfn-databrew-recipe-recipeparameters-upperbound)" : String,
  "[UseNewDataFrame](#cfn-databrew-recipe-recipeparameters-usenewdataframe)" : String,
  "[Value](#cfn-databrew-recipe-recipeparameters-value)" : String,
  "[Value1](#cfn-databrew-recipe-recipeparameters-value1)" : String,
  "[Value2](#cfn-databrew-recipe-recipeparameters-value2)" : String,
  "[ValueColumn](#cfn-databrew-recipe-recipeparameters-valuecolumn)" : String,
  "[ViewFrame](#cfn-databrew-recipe-recipeparameters-viewframe)" : String
}
```

### YAML
<a name="aws-properties-databrew-recipe-recipeparameters-syntax.yaml"></a>

```
  [AggregateFunction](#cfn-databrew-recipe-recipeparameters-aggregatefunction): String
  [Base](#cfn-databrew-recipe-recipeparameters-base): String
  [CaseStatement](#cfn-databrew-recipe-recipeparameters-casestatement): String
  [CategoryMap](#cfn-databrew-recipe-recipeparameters-categorymap): String
  [CharsToRemove](#cfn-databrew-recipe-recipeparameters-charstoremove): String
  [CollapseConsecutiveWhitespace](#cfn-databrew-recipe-recipeparameters-collapseconsecutivewhitespace): String
  [ColumnDataType](#cfn-databrew-recipe-recipeparameters-columndatatype): String
  [ColumnRange](#cfn-databrew-recipe-recipeparameters-columnrange): String
  [Count](#cfn-databrew-recipe-recipeparameters-count): String
  [CustomCharacters](#cfn-databrew-recipe-recipeparameters-customcharacters): String
  [CustomStopWords](#cfn-databrew-recipe-recipeparameters-customstopwords): String
  [CustomValue](#cfn-databrew-recipe-recipeparameters-customvalue): String
  [DatasetsColumns](#cfn-databrew-recipe-recipeparameters-datasetscolumns): String
  [DateAddValue](#cfn-databrew-recipe-recipeparameters-dateaddvalue): String
  [DateTimeFormat](#cfn-databrew-recipe-recipeparameters-datetimeformat): String
  [DateTimeParameters](#cfn-databrew-recipe-recipeparameters-datetimeparameters): String
  [DeleteOtherRows](#cfn-databrew-recipe-recipeparameters-deleteotherrows): String
  [Delimiter](#cfn-databrew-recipe-recipeparameters-delimiter): String
  [EndPattern](#cfn-databrew-recipe-recipeparameters-endpattern): String
  [EndPosition](#cfn-databrew-recipe-recipeparameters-endposition): String
  [EndValue](#cfn-databrew-recipe-recipeparameters-endvalue): String
  [ExpandContractions](#cfn-databrew-recipe-recipeparameters-expandcontractions): String
  [Exponent](#cfn-databrew-recipe-recipeparameters-exponent): String
  [FalseString](#cfn-databrew-recipe-recipeparameters-falsestring): 
    String
  [GroupByAggFunctionOptions](#cfn-databrew-recipe-recipeparameters-groupbyaggfunctionoptions): String
  [GroupByColumns](#cfn-databrew-recipe-recipeparameters-groupbycolumns): String
  [HiddenColumns](#cfn-databrew-recipe-recipeparameters-hiddencolumns): String
  [IgnoreCase](#cfn-databrew-recipe-recipeparameters-ignorecase): String
  [IncludeInSplit](#cfn-databrew-recipe-recipeparameters-includeinsplit): String
  [Input](#cfn-databrew-recipe-recipeparameters-input): 
    Input
  [Interval](#cfn-databrew-recipe-recipeparameters-interval): String
  [IsText](#cfn-databrew-recipe-recipeparameters-istext): String
  [JoinKeys](#cfn-databrew-recipe-recipeparameters-joinkeys): String
  [JoinType](#cfn-databrew-recipe-recipeparameters-jointype): String
  [LeftColumns](#cfn-databrew-recipe-recipeparameters-leftcolumns): String
  [Limit](#cfn-databrew-recipe-recipeparameters-limit): String
  [LowerBound](#cfn-databrew-recipe-recipeparameters-lowerbound): String
  [MapType](#cfn-databrew-recipe-recipeparameters-maptype): String
  [ModeType](#cfn-databrew-recipe-recipeparameters-modetype): String
  [MultiLine](#cfn-databrew-recipe-recipeparameters-multiline): Boolean
  [NumRows](#cfn-databrew-recipe-recipeparameters-numrows): String
  [NumRowsAfter](#cfn-databrew-recipe-recipeparameters-numrowsafter): String
  [NumRowsBefore](#cfn-databrew-recipe-recipeparameters-numrowsbefore): String
  [OrderByColumn](#cfn-databrew-recipe-recipeparameters-orderbycolumn): String
  [OrderByColumns](#cfn-databrew-recipe-recipeparameters-orderbycolumns): String
  [Other](#cfn-databrew-recipe-recipeparameters-other): String
  [Pattern](#cfn-databrew-recipe-recipeparameters-pattern): String
  [PatternOption1](#cfn-databrew-recipe-recipeparameters-patternoption1): String
  [PatternOption2](#cfn-databrew-recipe-recipeparameters-patternoption2): String
  [PatternOptions](#cfn-databrew-recipe-recipeparameters-patternoptions): String
  [Period](#cfn-databrew-recipe-recipeparameters-period): String
  [Position](#cfn-databrew-recipe-recipeparameters-position): String
  [RemoveAllPunctuation](#cfn-databrew-recipe-recipeparameters-removeallpunctuation): String
  [RemoveAllQuotes](#cfn-databrew-recipe-recipeparameters-removeallquotes): String
  [RemoveAllWhitespace](#cfn-databrew-recipe-recipeparameters-removeallwhitespace): String
  [RemoveCustomCharacters](#cfn-databrew-recipe-recipeparameters-removecustomcharacters): String
  [RemoveCustomValue](#cfn-databrew-recipe-recipeparameters-removecustomvalue): String
  [RemoveLeadingAndTrailingPunctuation](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingpunctuation): String
  [RemoveLeadingAndTrailingQuotes](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingquotes): String
  [RemoveLeadingAndTrailingWhitespace](#cfn-databrew-recipe-recipeparameters-removeleadingandtrailingwhitespace): String
  [RemoveLetters](#cfn-databrew-recipe-recipeparameters-removeletters): String
  [RemoveNumbers](#cfn-databrew-recipe-recipeparameters-removenumbers): String
  [RemoveSourceColumn](#cfn-databrew-recipe-recipeparameters-removesourcecolumn): String
  [RemoveSpecialCharacters](#cfn-databrew-recipe-recipeparameters-removespecialcharacters): String
  [RightColumns](#cfn-databrew-recipe-recipeparameters-rightcolumns): String
  [SampleSize](#cfn-databrew-recipe-recipeparameters-samplesize): String
  [SampleType](#cfn-databrew-recipe-recipeparameters-sampletype): String
  [SecondaryInputs](#cfn-databrew-recipe-recipeparameters-secondaryinputs): 
    - SecondaryInput
  [SecondInput](#cfn-databrew-recipe-recipeparameters-secondinput): String
  [SheetIndexes](#cfn-databrew-recipe-recipeparameters-sheetindexes): 
    - Integer
  [SheetNames](#cfn-databrew-recipe-recipeparameters-sheetnames): 
    - String
  [SourceColumn](#cfn-databrew-recipe-recipeparameters-sourcecolumn): String
  [SourceColumn1](#cfn-databrew-recipe-recipeparameters-sourcecolumn1): String
  [SourceColumn2](#cfn-databrew-recipe-recipeparameters-sourcecolumn2): String
  [SourceColumns](#cfn-databrew-recipe-recipeparameters-sourcecolumns): String
  [StartColumnIndex](#cfn-databrew-recipe-recipeparameters-startcolumnindex): String
  [StartPattern](#cfn-databrew-recipe-recipeparameters-startpattern): String
  [StartPosition](#cfn-databrew-recipe-recipeparameters-startposition): String
  [StartValue](#cfn-databrew-recipe-recipeparameters-startvalue): String
  [StemmingMode](#cfn-databrew-recipe-recipeparameters-stemmingmode): String
  [StepCount](#cfn-databrew-recipe-recipeparameters-stepcount): String
  [StepIndex](#cfn-databrew-recipe-recipeparameters-stepindex): String
  [StopWordsMode](#cfn-databrew-recipe-recipeparameters-stopwordsmode): String
  [Strategy](#cfn-databrew-recipe-recipeparameters-strategy): String
  [TargetColumn](#cfn-databrew-recipe-recipeparameters-targetcolumn): String
  [TargetColumnNames](#cfn-databrew-recipe-recipeparameters-targetcolumnnames): String
  [TargetDateFormat](#cfn-databrew-recipe-recipeparameters-targetdateformat): String
  [TargetIndex](#cfn-databrew-recipe-recipeparameters-targetindex): String
  [TimeZone](#cfn-databrew-recipe-recipeparameters-timezone): String
  [TokenizerPattern](#cfn-databrew-recipe-recipeparameters-tokenizerpattern): String
  [TrueString](#cfn-databrew-recipe-recipeparameters-truestring): 
    String
  [UdfLang](#cfn-databrew-recipe-recipeparameters-udflang): String
  [Units](#cfn-databrew-recipe-recipeparameters-units): String
  [UnpivotColumn](#cfn-databrew-recipe-recipeparameters-unpivotcolumn): String
  [UpperBound](#cfn-databrew-recipe-recipeparameters-upperbound): String
  [UseNewDataFrame](#cfn-databrew-recipe-recipeparameters-usenewdataframe): String
  [Value](#cfn-databrew-recipe-recipeparameters-value): String
  [Value1](#cfn-databrew-recipe-recipeparameters-value1): String
  [Value2](#cfn-databrew-recipe-recipeparameters-value2): String
  [ValueColumn](#cfn-databrew-recipe-recipeparameters-valuecolumn): String
  [ViewFrame](#cfn-databrew-recipe-recipeparameters-viewframe): String
```

## Properties
<a name="aws-properties-databrew-recipe-recipeparameters-properties"></a>

`AggregateFunction`  <a name="cfn-databrew-recipe-recipeparameters-aggregatefunction"></a>
The name of an aggregation function to apply.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Base`  <a name="cfn-databrew-recipe-recipeparameters-base"></a>
The number of digits used in a counting system.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CaseStatement`  <a name="cfn-databrew-recipe-recipeparameters-casestatement"></a>
A case statement associated with a recipe.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CategoryMap`  <a name="cfn-databrew-recipe-recipeparameters-categorymap"></a>
A category map used for one-hot encoding.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CharsToRemove`  <a name="cfn-databrew-recipe-recipeparameters-charstoremove"></a>
Characters to remove from a step that applies one-hot encoding or tokenization.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CollapseConsecutiveWhitespace`  <a name="cfn-databrew-recipe-recipeparameters-collapseconsecutivewhitespace"></a>
Remove any non-word non-punctuation character.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ColumnDataType`  <a name="cfn-databrew-recipe-recipeparameters-columndatatype"></a>
The data type of the column.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ColumnRange`  <a name="cfn-databrew-recipe-recipeparameters-columnrange"></a>
 A range of columns to which a step is applied.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Count`  <a name="cfn-databrew-recipe-recipeparameters-count"></a>
The number of times a string needs to be repeated.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CustomCharacters`  <a name="cfn-databrew-recipe-recipeparameters-customcharacters"></a>
One or more characters that can be substituted or removed, depending on the context.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CustomStopWords`  <a name="cfn-databrew-recipe-recipeparameters-customstopwords"></a>
A list of words to ignore in a step that applies word tokenization.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`CustomValue`  <a name="cfn-databrew-recipe-recipeparameters-customvalue"></a>
A list of custom values to use in a step that requires that you provide a value to finish the operation.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DatasetsColumns`  <a name="cfn-databrew-recipe-recipeparameters-datasetscolumns"></a>
A list of the dataset columns included in a project.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DateAddValue`  <a name="cfn-databrew-recipe-recipeparameters-dateaddvalue"></a>
A value that specifies how many units of time to add or subtract for a date math operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DateTimeFormat`  <a name="cfn-databrew-recipe-recipeparameters-datetimeformat"></a>
A date format to apply to a date.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DateTimeParameters`  <a name="cfn-databrew-recipe-recipeparameters-datetimeparameters"></a>
A set of parameters associated with a datetime.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DeleteOtherRows`  <a name="cfn-databrew-recipe-recipeparameters-deleteotherrows"></a>
Determines whether unmapped rows in a categorical mapping should be deleted  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Delimiter`  <a name="cfn-databrew-recipe-recipeparameters-delimiter"></a>
The delimiter to use when parsing separated values in a text file.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EndPattern`  <a name="cfn-databrew-recipe-recipeparameters-endpattern"></a>
The end pattern to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EndPosition`  <a name="cfn-databrew-recipe-recipeparameters-endposition"></a>
The end position to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EndValue`  <a name="cfn-databrew-recipe-recipeparameters-endvalue"></a>
The end value to locate.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ExpandContractions`  <a name="cfn-databrew-recipe-recipeparameters-expandcontractions"></a>
A list of word contractions and what they expand to. For eample: *can't*; *cannot*; *can not*.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Exponent`  <a name="cfn-databrew-recipe-recipeparameters-exponent"></a>
The exponent to apply in an exponential operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`FalseString`  <a name="cfn-databrew-recipe-recipeparameters-falsestring"></a>
A value that represents `FALSE`.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`GroupByAggFunctionOptions`  <a name="cfn-databrew-recipe-recipeparameters-groupbyaggfunctionoptions"></a>
Specifies options to apply to the `GROUP BY` used in an aggregation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`GroupByColumns`  <a name="cfn-databrew-recipe-recipeparameters-groupbycolumns"></a>
The columns to use in the `GROUP BY` clause.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`HiddenColumns`  <a name="cfn-databrew-recipe-recipeparameters-hiddencolumns"></a>
A list of columns to hide.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`IgnoreCase`  <a name="cfn-databrew-recipe-recipeparameters-ignorecase"></a>
Indicates that lower and upper case letters are treated equally.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`IncludeInSplit`  <a name="cfn-databrew-recipe-recipeparameters-includeinsplit"></a>
Indicates if this column is participating in a split transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Input`  <a name="cfn-databrew-recipe-recipeparameters-input"></a>
The input location to load the dataset from - Amazon S3 or AWS Glue Data Catalog.  
*Required*: No  
*Type*: [Input](aws-properties-databrew-recipe-input.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Interval`  <a name="cfn-databrew-recipe-recipeparameters-interval"></a>
The number of characters to split by.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`IsText`  <a name="cfn-databrew-recipe-recipeparameters-istext"></a>
Indicates if the content is text.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`JoinKeys`  <a name="cfn-databrew-recipe-recipeparameters-joinkeys"></a>
The keys or columns involved in a join.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`JoinType`  <a name="cfn-databrew-recipe-recipeparameters-jointype"></a>
The type of join to use, for example, `INNER JOIN`, `OUTER JOIN`, and so on.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`LeftColumns`  <a name="cfn-databrew-recipe-recipeparameters-leftcolumns"></a>
The columns on the left side of the join.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Limit`  <a name="cfn-databrew-recipe-recipeparameters-limit"></a>
The number of times to perform `split` or `replaceBy` in a string  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`LowerBound`  <a name="cfn-databrew-recipe-recipeparameters-lowerbound"></a>
The lower boundary for a value.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`MapType`  <a name="cfn-databrew-recipe-recipeparameters-maptype"></a>
The type of mappings to apply to construct a new dynamic frame.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ModeType`  <a name="cfn-databrew-recipe-recipeparameters-modetype"></a>
Determines the manner in which mode value is calculated, in case there is more than one mode value. Valid values: `NONE` \$1 `AVERAGE` \$1 `MINIMUM` \$1 `MAXIMUM`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`MultiLine`  <a name="cfn-databrew-recipe-recipeparameters-multiline"></a>
Specifies whether JSON input contains embedded new line characters.  
*Required*: No  
*Type*: Boolean  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`NumRows`  <a name="cfn-databrew-recipe-recipeparameters-numrows"></a>
The number of rows to consider in a window.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`NumRowsAfter`  <a name="cfn-databrew-recipe-recipeparameters-numrowsafter"></a>
The number of rows to consider after the current row in a window  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`NumRowsBefore`  <a name="cfn-databrew-recipe-recipeparameters-numrowsbefore"></a>
The number of rows to consider before the current row in a window  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`OrderByColumn`  <a name="cfn-databrew-recipe-recipeparameters-orderbycolumn"></a>
A column to sort the results by.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`OrderByColumns`  <a name="cfn-databrew-recipe-recipeparameters-orderbycolumns"></a>
The columns to sort the results by.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Other`  <a name="cfn-databrew-recipe-recipeparameters-other"></a>
The value to assign to unmapped cells, in categorical mapping  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Pattern`  <a name="cfn-databrew-recipe-recipeparameters-pattern"></a>
The pattern to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`PatternOption1`  <a name="cfn-databrew-recipe-recipeparameters-patternoption1"></a>
The starting pattern to split between.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`PatternOption2`  <a name="cfn-databrew-recipe-recipeparameters-patternoption2"></a>
The ending pattern to split between.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`PatternOptions`  <a name="cfn-databrew-recipe-recipeparameters-patternoptions"></a>
For splitting by multiple delimiters: A JSON-encoded string that lists the patterns in the format. For example: `[{\"pattern\":\"1\",\"includeInSplit\":true}]`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Period`  <a name="cfn-databrew-recipe-recipeparameters-period"></a>
The size of the rolling window.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Position`  <a name="cfn-databrew-recipe-recipeparameters-position"></a>
The character index within a string  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveAllPunctuation`  <a name="cfn-databrew-recipe-recipeparameters-removeallpunctuation"></a>
If `true`, removes all of the following characters: `.``.!``.,``.?`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveAllQuotes`  <a name="cfn-databrew-recipe-recipeparameters-removeallquotes"></a>
If `true`, removes all single quotes and double quotes.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveAllWhitespace`  <a name="cfn-databrew-recipe-recipeparameters-removeallwhitespace"></a>
If `true`, removes all whitespaces from the value.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveCustomCharacters`  <a name="cfn-databrew-recipe-recipeparameters-removecustomcharacters"></a>
If `true`, removes all chraracters specified by `CustomCharacters`.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveCustomValue`  <a name="cfn-databrew-recipe-recipeparameters-removecustomvalue"></a>
If `true`, removes all chraracters specified by `CustomValue`.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveLeadingAndTrailingPunctuation`  <a name="cfn-databrew-recipe-recipeparameters-removeleadingandtrailingpunctuation"></a>
If `true`, removes the following characters if they occur at the start or end of the value: `.``!``,``?`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveLeadingAndTrailingQuotes`  <a name="cfn-databrew-recipe-recipeparameters-removeleadingandtrailingquotes"></a>
If `true`, removes single quotes and double quotes from the beginning and end of the value.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveLeadingAndTrailingWhitespace`  <a name="cfn-databrew-recipe-recipeparameters-removeleadingandtrailingwhitespace"></a>
If `true`, removes all whitespaces from the beginning and end of the value.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveLetters`  <a name="cfn-databrew-recipe-recipeparameters-removeletters"></a>
If `true`, removes all uppercase and lowercase alphabetic characters (A through Z; a through z).  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveNumbers`  <a name="cfn-databrew-recipe-recipeparameters-removenumbers"></a>
If `true`, removes all numeric characters (0 through 9).  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveSourceColumn`  <a name="cfn-databrew-recipe-recipeparameters-removesourcecolumn"></a>
If `true`, the source column will be removed after un-nesting that column. (Used with nested column types, such as Map, Struct, or Array.)  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RemoveSpecialCharacters`  <a name="cfn-databrew-recipe-recipeparameters-removespecialcharacters"></a>
If `true`, removes all of the following characters: `! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RightColumns`  <a name="cfn-databrew-recipe-recipeparameters-rightcolumns"></a>
The columns on the right side of a join.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SampleSize`  <a name="cfn-databrew-recipe-recipeparameters-samplesize"></a>
The number of rows in the sample.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SampleType`  <a name="cfn-databrew-recipe-recipeparameters-sampletype"></a>
The sampling type to apply to the dataset. Valid values: `FIRST_N` \$1 `LAST_N` \$1 `RANDOM`  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SecondaryInputs`  <a name="cfn-databrew-recipe-recipeparameters-secondaryinputs"></a>
A list of secondary inputs in a UNION transform  
*Required*: No  
*Type*: Array of [SecondaryInput](aws-properties-databrew-recipe-secondaryinput.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SecondInput`  <a name="cfn-databrew-recipe-recipeparameters-secondinput"></a>
A object value to indicate the second dataset used in a join.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SheetIndexes`  <a name="cfn-databrew-recipe-recipeparameters-sheetindexes"></a>
One or more sheet numbers in the Excel file, which will be included in a dataset.  
*Required*: No  
*Type*: Array of Integer  
*Minimum*: `1`  
*Maximum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SheetNames`  <a name="cfn-databrew-recipe-recipeparameters-sheetnames"></a>
Oone or more named sheets in the Excel file, which will be included in a dataset.   
*Required*: No  
*Type*: Array of String  
*Minimum*: `1`  
*Maximum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SourceColumn`  <a name="cfn-databrew-recipe-recipeparameters-sourcecolumn"></a>
A source column needed for an operation, step, or transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SourceColumn1`  <a name="cfn-databrew-recipe-recipeparameters-sourcecolumn1"></a>
A source column needed for an operation, step, or transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SourceColumn2`  <a name="cfn-databrew-recipe-recipeparameters-sourcecolumn2"></a>
A source column needed for an operation, step, or transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SourceColumns`  <a name="cfn-databrew-recipe-recipeparameters-sourcecolumns"></a>
A list of source columns needed for an operation, step, or transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StartColumnIndex`  <a name="cfn-databrew-recipe-recipeparameters-startcolumnindex"></a>
The index number of the first column used by an operation, step, or transform.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StartPattern`  <a name="cfn-databrew-recipe-recipeparameters-startpattern"></a>
The starting pattern to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StartPosition`  <a name="cfn-databrew-recipe-recipeparameters-startposition"></a>
The starting position to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StartValue`  <a name="cfn-databrew-recipe-recipeparameters-startvalue"></a>
The starting value to locate.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StemmingMode`  <a name="cfn-databrew-recipe-recipeparameters-stemmingmode"></a>
Indicates this operation uses stems and lemmas (base words) for word tokenization.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StepCount`  <a name="cfn-databrew-recipe-recipeparameters-stepcount"></a>
The total number of transforms in this recipe.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StepIndex`  <a name="cfn-databrew-recipe-recipeparameters-stepindex"></a>
The index ID of a step.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`StopWordsMode`  <a name="cfn-databrew-recipe-recipeparameters-stopwordsmode"></a>
Indicates this operation uses stop words as part of word tokenization.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Strategy`  <a name="cfn-databrew-recipe-recipeparameters-strategy"></a>
The resolution strategy to apply in resolving ambiguities.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TargetColumn`  <a name="cfn-databrew-recipe-recipeparameters-targetcolumn"></a>
The column targeted by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TargetColumnNames`  <a name="cfn-databrew-recipe-recipeparameters-targetcolumnnames"></a>
The names to give columns altered by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TargetDateFormat`  <a name="cfn-databrew-recipe-recipeparameters-targetdateformat"></a>
The date format to convert to.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TargetIndex`  <a name="cfn-databrew-recipe-recipeparameters-targetindex"></a>
The index number of an object that is targeted by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TimeZone`  <a name="cfn-databrew-recipe-recipeparameters-timezone"></a>
The current timezone that you want to use for dates.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TokenizerPattern`  <a name="cfn-databrew-recipe-recipeparameters-tokenizerpattern"></a>
A regex expression to use when splitting text into terms, also called words or tokens.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`TrueString`  <a name="cfn-databrew-recipe-recipeparameters-truestring"></a>
A value to use to represent `TRUE`.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`UdfLang`  <a name="cfn-databrew-recipe-recipeparameters-udflang"></a>
The language that's used in the user-defined function.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Units`  <a name="cfn-databrew-recipe-recipeparameters-units"></a>
Specifies a unit of time. For example: `MINUTES`; `SECONDS`; `HOURS`; etc.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`UnpivotColumn`  <a name="cfn-databrew-recipe-recipeparameters-unpivotcolumn"></a>
Cast columns as rows, so that each value is a different row in a single column.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`UpperBound`  <a name="cfn-databrew-recipe-recipeparameters-upperbound"></a>
The upper boundary for a value.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`UseNewDataFrame`  <a name="cfn-databrew-recipe-recipeparameters-usenewdataframe"></a>
Create a new container to hold a dataset.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Value`  <a name="cfn-databrew-recipe-recipeparameters-value"></a>
A static value that can be used in a comparison, a substitution, or in another context-specific way. A `Value` can be a number, string, or other datatype, depending on the recipe action in which it's used.   
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Value1`  <a name="cfn-databrew-recipe-recipeparameters-value1"></a>
A value that's used by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Value2`  <a name="cfn-databrew-recipe-recipeparameters-value2"></a>
A value that's used by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ValueColumn`  <a name="cfn-databrew-recipe-recipeparameters-valuecolumn"></a>
The column that is provided as a value that's used by this operation.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ViewFrame`  <a name="cfn-databrew-recipe-recipeparameters-viewframe"></a>
The subset of rows currently available for viewing.  
*Required*: No  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe RecipeStep
<a name="aws-properties-databrew-recipe-recipestep"></a>

Represents a single step from a DataBrew recipe to be performed.

## Syntax
<a name="aws-properties-databrew-recipe-recipestep-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-recipestep-syntax.json"></a>

```
{
  "[Action](#cfn-databrew-recipe-recipestep-action)" : Action,
  "[ConditionExpressions](#cfn-databrew-recipe-recipestep-conditionexpressions)" : [ ConditionExpression, ... ]
}
```

### YAML
<a name="aws-properties-databrew-recipe-recipestep-syntax.yaml"></a>

```
  [Action](#cfn-databrew-recipe-recipestep-action): 
    Action
  [ConditionExpressions](#cfn-databrew-recipe-recipestep-conditionexpressions): 
    - ConditionExpression
```

## Properties
<a name="aws-properties-databrew-recipe-recipestep-properties"></a>

`Action`  <a name="cfn-databrew-recipe-recipestep-action"></a>
The particular action to be performed in the recipe step.  
*Required*: Yes  
*Type*: [Action](aws-properties-databrew-recipe-action.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ConditionExpressions`  <a name="cfn-databrew-recipe-recipestep-conditionexpressions"></a>
One or more conditions that must be met for the recipe step to succeed.  
All of the conditions in the array must be met. In other words, all of the conditions must be combined using a logical AND operation.
*Required*: No  
*Type*: Array of [ConditionExpression](aws-properties-databrew-recipe-conditionexpression.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe S3Location
<a name="aws-properties-databrew-recipe-s3location"></a>

Represents an Amazon S3 location (bucket name, bucket owner, and object key) where DataBrew can read input data, or write output from a job.

## Syntax
<a name="aws-properties-databrew-recipe-s3location-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-s3location-syntax.json"></a>

```
{
  "[Bucket](#cfn-databrew-recipe-s3location-bucket)" : String,
  "[Key](#cfn-databrew-recipe-s3location-key)" : String
}
```

### YAML
<a name="aws-properties-databrew-recipe-s3location-syntax.yaml"></a>

```
  [Bucket](#cfn-databrew-recipe-s3location-bucket): String
  [Key](#cfn-databrew-recipe-s3location-key): String
```

## Properties
<a name="aws-properties-databrew-recipe-s3location-properties"></a>

`Bucket`  <a name="cfn-databrew-recipe-s3location-bucket"></a>
The Amazon S3 bucket name.  
*Required*: Yes  
*Type*: String  
*Minimum*: `3`  
*Maximum*: `63`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Key`  <a name="cfn-databrew-recipe-s3location-key"></a>
The unique name of the object in the bucket.  
*Required*: No  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `1280`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe SecondaryInput
<a name="aws-properties-databrew-recipe-secondaryinput"></a>

Represents secondary inputs in a UNION transform.

## Syntax
<a name="aws-properties-databrew-recipe-secondaryinput-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-secondaryinput-syntax.json"></a>

```
{
  "[DataCatalogInputDefinition](#cfn-databrew-recipe-secondaryinput-datacataloginputdefinition)" : DataCatalogInputDefinition,
  "[S3InputDefinition](#cfn-databrew-recipe-secondaryinput-s3inputdefinition)" : S3Location
}
```

### YAML
<a name="aws-properties-databrew-recipe-secondaryinput-syntax.yaml"></a>

```
  [DataCatalogInputDefinition](#cfn-databrew-recipe-secondaryinput-datacataloginputdefinition): 
    DataCatalogInputDefinition
  [S3InputDefinition](#cfn-databrew-recipe-secondaryinput-s3inputdefinition): 
    S3Location
```

## Properties
<a name="aws-properties-databrew-recipe-secondaryinput-properties"></a>

`DataCatalogInputDefinition`  <a name="cfn-databrew-recipe-secondaryinput-datacataloginputdefinition"></a>
The AWS Glue Data Catalog parameters for the data.  
*Required*: No  
*Type*: [DataCatalogInputDefinition](aws-properties-databrew-recipe-datacataloginputdefinition.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`S3InputDefinition`  <a name="cfn-databrew-recipe-secondaryinput-s3inputdefinition"></a>
The Amazon S3 location where the data is stored.  
*Required*: No  
*Type*: [S3Location](aws-properties-databrew-recipe-s3location.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Recipe Tag
<a name="aws-properties-databrew-recipe-tag"></a>

<a name="aws-properties-databrew-recipe-tag-description"></a>The `Tag` property type specifies Property description not available. for an [AWS::DataBrew::Recipe](aws-resource-databrew-recipe.md).

## Syntax
<a name="aws-properties-databrew-recipe-tag-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-databrew-recipe-tag-syntax.json"></a>

```
{
  "[Key](#cfn-databrew-recipe-tag-key)" : String,
  "[Value](#cfn-databrew-recipe-tag-value)" : String
}
```

### YAML
<a name="aws-properties-databrew-recipe-tag-syntax.yaml"></a>

```
  [Key](#cfn-databrew-recipe-tag-key): String
  [Value](#cfn-databrew-recipe-tag-value): String
```

## Properties
<a name="aws-properties-databrew-recipe-tag-properties"></a>

`Key`  <a name="cfn-databrew-recipe-tag-key"></a>
Property description not available.  
*Required*: Yes  
*Type*: String  
*Minimum*: `1`  
*Maximum*: `128`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Value`  <a name="cfn-databrew-recipe-tag-value"></a>
Property description not available.  
*Required*: Yes  
*Type*: String  
*Minimum*: `0`  
*Maximum*: `256`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)