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::Job
<a name="aws-resource-databrew-job"></a>

Specifies a new DataBrew job.

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

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

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

```
{
  "Type" : "AWS::DataBrew::Job",
  "Properties" : {
      "[DatabaseOutputs](#cfn-databrew-job-databaseoutputs)" : [ DatabaseOutput, ... ],
      "[DataCatalogOutputs](#cfn-databrew-job-datacatalogoutputs)" : [ DataCatalogOutput, ... ],
      "[DatasetName](#cfn-databrew-job-datasetname)" : String,
      "[EncryptionKeyArn](#cfn-databrew-job-encryptionkeyarn)" : String,
      "[EncryptionMode](#cfn-databrew-job-encryptionmode)" : String,
      "[JobSample](#cfn-databrew-job-jobsample)" : JobSample,
      "[LogSubscription](#cfn-databrew-job-logsubscription)" : String,
      "[MaxCapacity](#cfn-databrew-job-maxcapacity)" : Integer,
      "[MaxRetries](#cfn-databrew-job-maxretries)" : Integer,
      "[Name](#cfn-databrew-job-name)" : String,
      "[OutputLocation](#cfn-databrew-job-outputlocation)" : OutputLocation,
      "[Outputs](#cfn-databrew-job-outputs)" : [ Output, ... ],
      "[ProfileConfiguration](#cfn-databrew-job-profileconfiguration)" : ProfileConfiguration,
      "[ProjectName](#cfn-databrew-job-projectname)" : String,
      "[Recipe](#cfn-databrew-job-recipe)" : Recipe,
      "[RoleArn](#cfn-databrew-job-rolearn)" : String,
      "[Tags](#cfn-databrew-job-tags)" : [ Tag, ... ],
      "[Timeout](#cfn-databrew-job-timeout)" : Integer,
      "[Type](#cfn-databrew-job-type)" : String,
      "[ValidationConfigurations](#cfn-databrew-job-validationconfigurations)" : [ ValidationConfiguration, ... ]
    }
}
```

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

```
Type: AWS::DataBrew::Job
Properties:
  [DatabaseOutputs](#cfn-databrew-job-databaseoutputs): 
    - DatabaseOutput
  [DataCatalogOutputs](#cfn-databrew-job-datacatalogoutputs): 
    - DataCatalogOutput
  [DatasetName](#cfn-databrew-job-datasetname): String
  [EncryptionKeyArn](#cfn-databrew-job-encryptionkeyarn): String
  [EncryptionMode](#cfn-databrew-job-encryptionmode): String
  [JobSample](#cfn-databrew-job-jobsample): 
    JobSample
  [LogSubscription](#cfn-databrew-job-logsubscription): String
  [MaxCapacity](#cfn-databrew-job-maxcapacity): Integer
  [MaxRetries](#cfn-databrew-job-maxretries): Integer
  [Name](#cfn-databrew-job-name): String
  [OutputLocation](#cfn-databrew-job-outputlocation): 
    OutputLocation
  [Outputs](#cfn-databrew-job-outputs): 
    - Output
  [ProfileConfiguration](#cfn-databrew-job-profileconfiguration): 
    ProfileConfiguration
  [ProjectName](#cfn-databrew-job-projectname): String
  [Recipe](#cfn-databrew-job-recipe): 
    Recipe
  [RoleArn](#cfn-databrew-job-rolearn): String
  [Tags](#cfn-databrew-job-tags): 
    - Tag
  [Timeout](#cfn-databrew-job-timeout): Integer
  [Type](#cfn-databrew-job-type): String
  [ValidationConfigurations](#cfn-databrew-job-validationconfigurations): 
    - ValidationConfiguration
```

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

`DatabaseOutputs`  <a name="cfn-databrew-job-databaseoutputs"></a>
Represents a list of JDBC database output objects which defines the output destination for a DataBrew recipe job to write into.  
*Required*: No  
*Type*: Array of [DatabaseOutput](aws-properties-databrew-job-databaseoutput.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DataCatalogOutputs`  <a name="cfn-databrew-job-datacatalogoutputs"></a>
One or more artifacts that represent the AWS Glue Data Catalog output from running the job.  
*Required*: No  
*Type*: Array of [DataCatalogOutput](aws-properties-databrew-job-datacatalogoutput.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DatasetName`  <a name="cfn-databrew-job-datasetname"></a>
A dataset that the job is to process.  
*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)

`EncryptionKeyArn`  <a name="cfn-databrew-job-encryptionkeyarn"></a>
The Amazon Resource Name (ARN) of an encryption key that is used to protect the job output. For more information, see [Encrypting data written by DataBrew jobs](https://docs.aws.amazon.com/databrew/latest/dg/encryption-security-configuration.html)  
*Required*: No  
*Type*: String  
*Minimum*: `20`  
*Maximum*: `2048`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EncryptionMode`  <a name="cfn-databrew-job-encryptionmode"></a>
The encryption mode for the job, which can be one of the following:  
+ `SSE-KMS` - Server-side encryption with keys managed by AWS KMS.
+ `SSE-S3` - Server-side encryption with keys managed by Amazon S3.
*Required*: No  
*Type*: String  
*Allowed values*: `SSE-KMS | SSE-S3`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`JobSample`  <a name="cfn-databrew-job-jobsample"></a>
A sample configuration for profile jobs only, which determines the number of rows on which the profile job is run. If a `JobSample` value isn't provided, the default value is used. The default value is CUSTOM\$1ROWS for the mode parameter and 20,000 for the size parameter.  
*Required*: No  
*Type*: [JobSample](aws-properties-databrew-job-jobsample.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`LogSubscription`  <a name="cfn-databrew-job-logsubscription"></a>
The current status of Amazon CloudWatch logging for the job.  
*Required*: No  
*Type*: String  
*Allowed values*: `ENABLE | DISABLE`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`MaxCapacity`  <a name="cfn-databrew-job-maxcapacity"></a>
The maximum number of nodes that can be consumed when the job processes data.  
*Required*: No  
*Type*: Integer  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`MaxRetries`  <a name="cfn-databrew-job-maxretries"></a>
The maximum number of times to retry the job after a job run fails.  
*Required*: No  
*Type*: Integer  
*Minimum*: `0`  
*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-job-name"></a>
The unique name of the job.  
*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)

`OutputLocation`  <a name="cfn-databrew-job-outputlocation"></a>
The location in Amazon S3 where the job writes its output.  
*Required*: No  
*Type*: [OutputLocation](aws-properties-databrew-job-outputlocation.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Outputs`  <a name="cfn-databrew-job-outputs"></a>
One or more artifacts that represent output from running the job.  
*Required*: No  
*Type*: Array of [Output](aws-properties-databrew-job-output.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ProfileConfiguration`  <a name="cfn-databrew-job-profileconfiguration"></a>
Configuration for profile jobs. Configuration can be used to select columns, do evaluations, and override default parameters of evaluations. When configuration is undefined, the profile job will apply default settings to all supported columns.   
*Required*: No  
*Type*: [ProfileConfiguration](aws-properties-databrew-job-profileconfiguration.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ProjectName`  <a name="cfn-databrew-job-projectname"></a>
The name of the project that the job is associated with.  
*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)

`Recipe`  <a name="cfn-databrew-job-recipe"></a>
A series of data transformation steps that the job runs.  
*Required*: No  
*Type*: [Recipe](aws-properties-databrew-job-recipe.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`RoleArn`  <a name="cfn-databrew-job-rolearn"></a>
The Amazon Resource Name (ARN) of the role to be assumed for this job.  
*Required*: Yes  
*Type*: String  
*Minimum*: `20`  
*Maximum*: `2048`  
*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-job-tags"></a>
Metadata tags that have been applied to the job.  
*Required*: No  
*Type*: Array of [Tag](aws-properties-databrew-job-tag.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Timeout`  <a name="cfn-databrew-job-timeout"></a>
The job's timeout in minutes. A job that attempts to run longer than this timeout period ends with a status of `TIMEOUT`.  
*Required*: No  
*Type*: Integer  
*Minimum*: `0`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Type`  <a name="cfn-databrew-job-type"></a>
The job type of the job, which must be one of the following:  
+ `PROFILE` - A job to analyze a dataset, to determine its size, data types, data distribution, and more.
+ `RECIPE` - A job to apply one or more transformations to a dataset.
*Required*: Yes  
*Type*: String  
*Allowed values*: `PROFILE | RECIPE`  
*Update requires*: [Replacement](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-replacement)

`ValidationConfigurations`  <a name="cfn-databrew-job-validationconfigurations"></a>
List of validation configurations that are applied to the profile job.  
*Required*: No  
*Type*: Array of [ValidationConfiguration](aws-properties-databrew-job-validationconfiguration.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-job-return-values"></a>

### Ref
<a name="aws-resource-databrew-job-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": "myJob" }` 

For an AWS Glue DataBrew job named `myJob`, `Ref` returns the name of the job. 

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



### Creating jobs
<a name="aws-resource-databrew-job--examples--Creating_jobs"></a>

The following examples create new DataBrew profile jobs.

#### YAML
<a name="aws-resource-databrew-job--examples--Creating_jobs--yaml"></a>

```
Resources:
  TestDataBrewJob:
    Type: AWS::DataBrew::Job
    Properties:
      Type: PROFILE
      Name: job-name
      DatasetName: dataset-name
      RoleArn: arn:aws:iam::12345678910:role/PassRoleAdmin
      JobSample:
        Mode: 'CUSTOM_ROWS'
        Size: 50000
      OutputLocation:
        Bucket: !Join [ '', ['databrew-cfn-integration-tests-', !Ref 'AWS::Region', '-', !Ref 'AWS::AccountId' ] ]
      Tags: [{Key: key00AtCreate, Value: value001AtCreate}]
```

#### JSON
<a name="aws-resource-databrew-job--examples--Creating_jobs--json"></a>

```
{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Description": "This CloudFormation template specifies a DataBrew Profile Job",
    "Resources": {
        "MyDataBrewProfileJob": {
            "Type": "AWS::DataBrew::Job",
            "Properties": {
                "Type": "PROFILE",
                "Name": "job-test",
                "DatasetName": "dataset-test",
                "RoleArn": "arn:aws:iam::1234567891011:role/PassRoleAdmin",
                "JobSample": {
                    "Mode": "FULL_DATASET"
                },
                "OutputLocation": {
                    "Bucket": "test-output",
                    "Key": "job-output.json"
                },
                "Tags": [
                    {
                        "Key": "key00AtCreate",
                        "Value": "value001AtCreate"
                    }
                ]
            }
        }
    }
}
```

# AWS::DataBrew::Job AllowedStatistics
<a name="aws-properties-databrew-job-allowedstatistics"></a>

Configuration of statistics that are allowed to be run on columns that contain detected entities. When undefined, no statistics will be computed on columns that contain detected entities.

## Syntax
<a name="aws-properties-databrew-job-allowedstatistics-syntax"></a>

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

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

```
{
  "[Statistics](#cfn-databrew-job-allowedstatistics-statistics)" : [ String, ... ]
}
```

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

```
  [Statistics](#cfn-databrew-job-allowedstatistics-statistics): 
    - String
```

## Properties
<a name="aws-properties-databrew-job-allowedstatistics-properties"></a>

`Statistics`  <a name="cfn-databrew-job-allowedstatistics-statistics"></a>
One or more column statistics to allow for columns that contain detected entities.  
*Required*: Yes  
*Type*: Array of String  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Job ColumnSelector
<a name="aws-properties-databrew-job-columnselector"></a>

Selector of a column from a dataset for profile job configuration. One selector includes either a column name or a regular expression.

## Syntax
<a name="aws-properties-databrew-job-columnselector-syntax"></a>

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

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

```
{
  "[Name](#cfn-databrew-job-columnselector-name)" : String,
  "[Regex](#cfn-databrew-job-columnselector-regex)" : String
}
```

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

```
  [Name](#cfn-databrew-job-columnselector-name): String
  [Regex](#cfn-databrew-job-columnselector-regex): String
```

## Properties
<a name="aws-properties-databrew-job-columnselector-properties"></a>

`Name`  <a name="cfn-databrew-job-columnselector-name"></a>
The name of a column from a 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)

`Regex`  <a name="cfn-databrew-job-columnselector-regex"></a>
A regular expression for selecting a column from a 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)

# AWS::DataBrew::Job ColumnStatisticsConfiguration
<a name="aws-properties-databrew-job-columnstatisticsconfiguration"></a>

Configuration for column evaluations for a profile job. ColumnStatisticsConfiguration can be used to select evaluations and override parameters of evaluations for particular columns. 

## Syntax
<a name="aws-properties-databrew-job-columnstatisticsconfiguration-syntax"></a>

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

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

```
{
  "[Selectors](#cfn-databrew-job-columnstatisticsconfiguration-selectors)" : [ ColumnSelector, ... ],
  "[Statistics](#cfn-databrew-job-columnstatisticsconfiguration-statistics)" : StatisticsConfiguration
}
```

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

```
  [Selectors](#cfn-databrew-job-columnstatisticsconfiguration-selectors): 
    - ColumnSelector
  [Statistics](#cfn-databrew-job-columnstatisticsconfiguration-statistics): 
    StatisticsConfiguration
```

## Properties
<a name="aws-properties-databrew-job-columnstatisticsconfiguration-properties"></a>

`Selectors`  <a name="cfn-databrew-job-columnstatisticsconfiguration-selectors"></a>
List of column selectors. Selectors can be used to select columns from the dataset. When selectors are undefined, configuration will be applied to all supported columns.   
*Required*: No  
*Type*: Array of [ColumnSelector](aws-properties-databrew-job-columnselector.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Statistics`  <a name="cfn-databrew-job-columnstatisticsconfiguration-statistics"></a>
Configuration for evaluations. Statistics can be used to select evaluations and override parameters of evaluations.   
*Required*: Yes  
*Type*: [StatisticsConfiguration](aws-properties-databrew-job-statisticsconfiguration.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::Job CsvOutputOptions
<a name="aws-properties-databrew-job-csvoutputoptions"></a>

Represents a set of options that define how DataBrew will write a comma-separated value (CSV) file.

## Syntax
<a name="aws-properties-databrew-job-csvoutputoptions-syntax"></a>

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

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

```
{
  "[Delimiter](#cfn-databrew-job-csvoutputoptions-delimiter)" : String
}
```

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

```
  [Delimiter](#cfn-databrew-job-csvoutputoptions-delimiter): String
```

## Properties
<a name="aws-properties-databrew-job-csvoutputoptions-properties"></a>

`Delimiter`  <a name="cfn-databrew-job-csvoutputoptions-delimiter"></a>
A single character that specifies the delimiter used to create CSV job output.  
*Required*: No  
*Type*: 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)

# AWS::DataBrew::Job DatabaseOutput
<a name="aws-properties-databrew-job-databaseoutput"></a>

Represents a JDBC database output object which defines the output destination for a DataBrew recipe job to write into.

## Syntax
<a name="aws-properties-databrew-job-databaseoutput-syntax"></a>

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

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

```
{
  "[DatabaseOptions](#cfn-databrew-job-databaseoutput-databaseoptions)" : DatabaseTableOutputOptions,
  "[DatabaseOutputMode](#cfn-databrew-job-databaseoutput-databaseoutputmode)" : String,
  "[GlueConnectionName](#cfn-databrew-job-databaseoutput-glueconnectionname)" : String
}
```

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

```
  [DatabaseOptions](#cfn-databrew-job-databaseoutput-databaseoptions): 
    DatabaseTableOutputOptions
  [DatabaseOutputMode](#cfn-databrew-job-databaseoutput-databaseoutputmode): String
  [GlueConnectionName](#cfn-databrew-job-databaseoutput-glueconnectionname): String
```

## Properties
<a name="aws-properties-databrew-job-databaseoutput-properties"></a>

`DatabaseOptions`  <a name="cfn-databrew-job-databaseoutput-databaseoptions"></a>
Represents options that specify how and where DataBrew writes the database output generated by recipe jobs.  
*Required*: Yes  
*Type*: [DatabaseTableOutputOptions](aws-properties-databrew-job-databasetableoutputoptions.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DatabaseOutputMode`  <a name="cfn-databrew-job-databaseoutput-databaseoutputmode"></a>
The output mode to write into the database. Currently supported option: NEW\$1TABLE.  
*Required*: No  
*Type*: String  
*Allowed values*: `NEW_TABLE`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`GlueConnectionName`  <a name="cfn-databrew-job-databaseoutput-glueconnectionname"></a>
The AWS Glue connection that stores the connection information for the target database.  
*Required*: Yes  
*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)

# AWS::DataBrew::Job DatabaseTableOutputOptions
<a name="aws-properties-databrew-job-databasetableoutputoptions"></a>

Represents options that specify how and where DataBrew writes the database output generated by recipe jobs.

## Syntax
<a name="aws-properties-databrew-job-databasetableoutputoptions-syntax"></a>

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

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

```
{
  "[TableName](#cfn-databrew-job-databasetableoutputoptions-tablename)" : String,
  "[TempDirectory](#cfn-databrew-job-databasetableoutputoptions-tempdirectory)" : S3Location
}
```

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

```
  [TableName](#cfn-databrew-job-databasetableoutputoptions-tablename): String
  [TempDirectory](#cfn-databrew-job-databasetableoutputoptions-tempdirectory): 
    S3Location
```

## Properties
<a name="aws-properties-databrew-job-databasetableoutputoptions-properties"></a>

`TableName`  <a name="cfn-databrew-job-databasetableoutputoptions-tablename"></a>
A prefix for the name of a table DataBrew will create in the database.  
*Required*: Yes  
*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-job-databasetableoutputoptions-tempdirectory"></a>
Represents an Amazon S3 location (bucket name and object key) where DataBrew can store intermediate results.  
*Required*: No  
*Type*: [S3Location](aws-properties-databrew-job-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::Job DataCatalogOutput
<a name="aws-properties-databrew-job-datacatalogoutput"></a>

Represents options that specify how and where in the AWS Glue Data Catalog DataBrew writes the output generated by recipe jobs.

## Syntax
<a name="aws-properties-databrew-job-datacatalogoutput-syntax"></a>

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

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

```
{
  "[CatalogId](#cfn-databrew-job-datacatalogoutput-catalogid)" : String,
  "[DatabaseName](#cfn-databrew-job-datacatalogoutput-databasename)" : String,
  "[DatabaseOptions](#cfn-databrew-job-datacatalogoutput-databaseoptions)" : DatabaseTableOutputOptions,
  "[Overwrite](#cfn-databrew-job-datacatalogoutput-overwrite)" : Boolean,
  "[S3Options](#cfn-databrew-job-datacatalogoutput-s3options)" : S3TableOutputOptions,
  "[TableName](#cfn-databrew-job-datacatalogoutput-tablename)" : String
}
```

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

```
  [CatalogId](#cfn-databrew-job-datacatalogoutput-catalogid): String
  [DatabaseName](#cfn-databrew-job-datacatalogoutput-databasename): String
  [DatabaseOptions](#cfn-databrew-job-datacatalogoutput-databaseoptions): 
    DatabaseTableOutputOptions
  [Overwrite](#cfn-databrew-job-datacatalogoutput-overwrite): Boolean
  [S3Options](#cfn-databrew-job-datacatalogoutput-s3options): 
    S3TableOutputOptions
  [TableName](#cfn-databrew-job-datacatalogoutput-tablename): String
```

## Properties
<a name="aws-properties-databrew-job-datacatalogoutput-properties"></a>

`CatalogId`  <a name="cfn-databrew-job-datacatalogoutput-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-job-datacatalogoutput-databasename"></a>
The name of a database in the Data Catalog.  
*Required*: Yes  
*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)

`DatabaseOptions`  <a name="cfn-databrew-job-datacatalogoutput-databaseoptions"></a>
Represents options that specify how and where DataBrew writes the database output generated by recipe jobs.  
*Required*: No  
*Type*: [DatabaseTableOutputOptions](aws-properties-databrew-job-databasetableoutputoptions.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Overwrite`  <a name="cfn-databrew-job-datacatalogoutput-overwrite"></a>
A value that, if true, means that any data in the location specified for output is overwritten with new output. Not supported with DatabaseOptions.  
*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)

`S3Options`  <a name="cfn-databrew-job-datacatalogoutput-s3options"></a>
Represents options that specify how and where DataBrew writes the Amazon S3 output generated by recipe jobs.  
*Required*: No  
*Type*: [S3TableOutputOptions](aws-properties-databrew-job-s3tableoutputoptions.md)  
*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-job-datacatalogoutput-tablename"></a>
The name of a table in the Data Catalog.  
*Required*: Yes  
*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)

# AWS::DataBrew::Job EntityDetectorConfiguration
<a name="aws-properties-databrew-job-entitydetectorconfiguration"></a>

Configuration of entity detection for a profile job. When undefined, entity detection is disabled.

## Syntax
<a name="aws-properties-databrew-job-entitydetectorconfiguration-syntax"></a>

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

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

```
{
  "[AllowedStatistics](#cfn-databrew-job-entitydetectorconfiguration-allowedstatistics)" : AllowedStatistics,
  "[EntityTypes](#cfn-databrew-job-entitydetectorconfiguration-entitytypes)" : [ String, ... ]
}
```

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

```
  [AllowedStatistics](#cfn-databrew-job-entitydetectorconfiguration-allowedstatistics): 
    AllowedStatistics
  [EntityTypes](#cfn-databrew-job-entitydetectorconfiguration-entitytypes): 
    - String
```

## Properties
<a name="aws-properties-databrew-job-entitydetectorconfiguration-properties"></a>

`AllowedStatistics`  <a name="cfn-databrew-job-entitydetectorconfiguration-allowedstatistics"></a>
Configuration of statistics that are allowed to be run on columns that contain detected entities. When undefined, no statistics will be computed on columns that contain detected entities.  
*Required*: No  
*Type*: [AllowedStatistics](aws-properties-databrew-job-allowedstatistics.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EntityTypes`  <a name="cfn-databrew-job-entitydetectorconfiguration-entitytypes"></a>
Entity types to detect. Can be any of the following:  
+ USA\$1SSN
+ EMAIL
+ USA\$1ITIN
+ USA\$1PASSPORT\$1NUMBER
+ PHONE\$1NUMBER
+ USA\$1DRIVING\$1LICENSE
+ BANK\$1ACCOUNT
+ CREDIT\$1CARD
+ IP\$1ADDRESS
+ MAC\$1ADDRESS
+ USA\$1DEA\$1NUMBER
+ USA\$1HCPCS\$1CODE
+ USA\$1NATIONAL\$1PROVIDER\$1IDENTIFIER
+ USA\$1NATIONAL\$1DRUG\$1CODE
+ USA\$1HEALTH\$1INSURANCE\$1CLAIM\$1NUMBER
+ USA\$1MEDICARE\$1BENEFICIARY\$1IDENTIFIER
+ USA\$1CPT\$1CODE
+ PERSON\$1NAME
+ DATE
The Entity type group USA\$1ALL is also supported, and includes all of the above entity types except PERSON\$1NAME and DATE.  
*Required*: Yes  
*Type*: Array of String  
*Maximum*: `128`  
*Minimum*: `1 | 1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Job JobSample
<a name="aws-properties-databrew-job-jobsample"></a>

A sample configuration for profile jobs only, which determines the number of rows on which the profile job is run. If a `JobSample` value isn't provided, the default is used. The default value is CUSTOM\$1ROWS for the mode parameter and 20,000 for the size parameter.

## Syntax
<a name="aws-properties-databrew-job-jobsample-syntax"></a>

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

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

```
{
  "[Mode](#cfn-databrew-job-jobsample-mode)" : String,
  "[Size](#cfn-databrew-job-jobsample-size)" : Integer
}
```

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

```
  [Mode](#cfn-databrew-job-jobsample-mode): String
  [Size](#cfn-databrew-job-jobsample-size): Integer
```

## Properties
<a name="aws-properties-databrew-job-jobsample-properties"></a>

`Mode`  <a name="cfn-databrew-job-jobsample-mode"></a>
A value that determines whether the profile job is run on the entire dataset or a specified number of rows. This value must be one of the following:  
+ FULL\$1DATASET - The profile job is run on the entire dataset.
+ CUSTOM\$1ROWS - The profile job is run on the number of rows specified in the `Size` parameter.
*Required*: No  
*Type*: String  
*Allowed values*: `FULL_DATASET | CUSTOM_ROWS`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Size`  <a name="cfn-databrew-job-jobsample-size"></a>
The `Size` parameter is only required when the mode is CUSTOM\$1ROWS. The profile job is run on the specified number of rows. The maximum value for size is Long.MAX\$1VALUE.  
Long.MAX\$1VALUE = 9223372036854775807  
*Required*: No  
*Type*: Integer  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Job Output
<a name="aws-properties-databrew-job-output"></a>

Represents options that specify how and where in Amazon S3 DataBrew writes the output generated by recipe jobs or profile jobs.

## Syntax
<a name="aws-properties-databrew-job-output-syntax"></a>

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

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

```
{
  "[CompressionFormat](#cfn-databrew-job-output-compressionformat)" : String,
  "[Format](#cfn-databrew-job-output-format)" : String,
  "[FormatOptions](#cfn-databrew-job-output-formatoptions)" : OutputFormatOptions,
  "[Location](#cfn-databrew-job-output-location)" : S3Location,
  "[MaxOutputFiles](#cfn-databrew-job-output-maxoutputfiles)" : Integer,
  "[Overwrite](#cfn-databrew-job-output-overwrite)" : Boolean,
  "[PartitionColumns](#cfn-databrew-job-output-partitioncolumns)" : [ String, ... ]
}
```

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

```
  [CompressionFormat](#cfn-databrew-job-output-compressionformat): String
  [Format](#cfn-databrew-job-output-format): String
  [FormatOptions](#cfn-databrew-job-output-formatoptions): 
    OutputFormatOptions
  [Location](#cfn-databrew-job-output-location): 
    S3Location
  [MaxOutputFiles](#cfn-databrew-job-output-maxoutputfiles): Integer
  [Overwrite](#cfn-databrew-job-output-overwrite): Boolean
  [PartitionColumns](#cfn-databrew-job-output-partitioncolumns): 
    - String
```

## Properties
<a name="aws-properties-databrew-job-output-properties"></a>

`CompressionFormat`  <a name="cfn-databrew-job-output-compressionformat"></a>
The compression algorithm used to compress the output text of the job.  
*Required*: No  
*Type*: String  
*Allowed values*: `GZIP | LZ4 | SNAPPY | BZIP2 | DEFLATE | LZO | BROTLI | ZSTD | ZLIB`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Format`  <a name="cfn-databrew-job-output-format"></a>
The data format of the output of the job.  
*Required*: No  
*Type*: String  
*Allowed values*: `CSV | JSON | PARQUET | GLUEPARQUET | AVRO | ORC | XML | TABLEAUHYPER`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`FormatOptions`  <a name="cfn-databrew-job-output-formatoptions"></a>
Represents options that define how DataBrew formats job output files.  
*Required*: No  
*Type*: [OutputFormatOptions](aws-properties-databrew-job-outputformatoptions.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Location`  <a name="cfn-databrew-job-output-location"></a>
The location in Amazon S3 where the job writes its output.  
*Required*: Yes  
*Type*: [S3Location](aws-properties-databrew-job-s3location.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`MaxOutputFiles`  <a name="cfn-databrew-job-output-maxoutputfiles"></a>
The maximum number of files to be generated by the job and written to the output folder.  
*Required*: No  
*Type*: Integer  
*Minimum*: `1`  
*Maximum*: `999`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Overwrite`  <a name="cfn-databrew-job-output-overwrite"></a>
A value that, if true, means that any data in the location specified for output is overwritten with new output.  
*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)

`PartitionColumns`  <a name="cfn-databrew-job-output-partitioncolumns"></a>
The names of one or more partition columns for the output of the job.  
*Required*: No  
*Type*: Array of String  
*Maximum*: `200`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

# AWS::DataBrew::Job OutputFormatOptions
<a name="aws-properties-databrew-job-outputformatoptions"></a>

Represents a set of options that define the structure of comma-separated (CSV) job output.

## Syntax
<a name="aws-properties-databrew-job-outputformatoptions-syntax"></a>

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

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

```
{
  "[Csv](#cfn-databrew-job-outputformatoptions-csv)" : CsvOutputOptions
}
```

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

```
  [Csv](#cfn-databrew-job-outputformatoptions-csv): 
    CsvOutputOptions
```

## Properties
<a name="aws-properties-databrew-job-outputformatoptions-properties"></a>

`Csv`  <a name="cfn-databrew-job-outputformatoptions-csv"></a>
Represents a set of options that define the structure of comma-separated value (CSV) job output.  
*Required*: No  
*Type*: [CsvOutputOptions](aws-properties-databrew-job-csvoutputoptions.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::Job OutputLocation
<a name="aws-properties-databrew-job-outputlocation"></a>

The location in Amazon S3 or AWS Glue Data Catalog where the job writes its output.

## Syntax
<a name="aws-properties-databrew-job-outputlocation-syntax"></a>

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

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

```
{
  "[Bucket](#cfn-databrew-job-outputlocation-bucket)" : String,
  "[BucketOwner](#cfn-databrew-job-outputlocation-bucketowner)" : String,
  "[Key](#cfn-databrew-job-outputlocation-key)" : String
}
```

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

```
  [Bucket](#cfn-databrew-job-outputlocation-bucket): String
  [BucketOwner](#cfn-databrew-job-outputlocation-bucketowner): String
  [Key](#cfn-databrew-job-outputlocation-key): String
```

## Properties
<a name="aws-properties-databrew-job-outputlocation-properties"></a>

`Bucket`  <a name="cfn-databrew-job-outputlocation-bucket"></a>
The Amazon S3 bucket name.  
*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)

`BucketOwner`  <a name="cfn-databrew-job-outputlocation-bucketowner"></a>
Property description not available.  
*Required*: No  
*Type*: String  
*Minimum*: `12`  
*Maximum*: `12`  
*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-job-outputlocation-key"></a>
The unique name of the object in the bucket.  
*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::Job ProfileConfiguration
<a name="aws-properties-databrew-job-profileconfiguration"></a>

Configuration for profile jobs. Configuration can be used to select columns, do evaluations, and override default parameters of evaluations. When configuration is undefined, the profile job will apply default settings to all supported columns. 

## Syntax
<a name="aws-properties-databrew-job-profileconfiguration-syntax"></a>

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

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

```
{
  "[ColumnStatisticsConfigurations](#cfn-databrew-job-profileconfiguration-columnstatisticsconfigurations)" : [ ColumnStatisticsConfiguration, ... ],
  "[DatasetStatisticsConfiguration](#cfn-databrew-job-profileconfiguration-datasetstatisticsconfiguration)" : StatisticsConfiguration,
  "[EntityDetectorConfiguration](#cfn-databrew-job-profileconfiguration-entitydetectorconfiguration)" : EntityDetectorConfiguration,
  "[ProfileColumns](#cfn-databrew-job-profileconfiguration-profilecolumns)" : [ ColumnSelector, ... ]
}
```

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

```
  [ColumnStatisticsConfigurations](#cfn-databrew-job-profileconfiguration-columnstatisticsconfigurations): 
    - ColumnStatisticsConfiguration
  [DatasetStatisticsConfiguration](#cfn-databrew-job-profileconfiguration-datasetstatisticsconfiguration): 
    StatisticsConfiguration
  [EntityDetectorConfiguration](#cfn-databrew-job-profileconfiguration-entitydetectorconfiguration): 
    EntityDetectorConfiguration
  [ProfileColumns](#cfn-databrew-job-profileconfiguration-profilecolumns): 
    - ColumnSelector
```

## Properties
<a name="aws-properties-databrew-job-profileconfiguration-properties"></a>

`ColumnStatisticsConfigurations`  <a name="cfn-databrew-job-profileconfiguration-columnstatisticsconfigurations"></a>
List of configurations for column evaluations. ColumnStatisticsConfigurations are used to select evaluations and override parameters of evaluations for particular columns. When ColumnStatisticsConfigurations is undefined, the profile job will profile all supported columns and run all supported evaluations.   
*Required*: No  
*Type*: Array of [ColumnStatisticsConfiguration](aws-properties-databrew-job-columnstatisticsconfiguration.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`DatasetStatisticsConfiguration`  <a name="cfn-databrew-job-profileconfiguration-datasetstatisticsconfiguration"></a>
Configuration for inter-column evaluations. Configuration can be used to select evaluations and override parameters of evaluations. When configuration is undefined, the profile job will run all supported inter-column evaluations.   
*Required*: No  
*Type*: [StatisticsConfiguration](aws-properties-databrew-job-statisticsconfiguration.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`EntityDetectorConfiguration`  <a name="cfn-databrew-job-profileconfiguration-entitydetectorconfiguration"></a>
Configuration of entity detection for a profile job. When undefined, entity detection is disabled.  
*Required*: No  
*Type*: [EntityDetectorConfiguration](aws-properties-databrew-job-entitydetectorconfiguration.md)  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ProfileColumns`  <a name="cfn-databrew-job-profileconfiguration-profilecolumns"></a>
List of column selectors. ProfileColumns can be used to select columns from the dataset. When ProfileColumns is undefined, the profile job will profile all supported columns.   
*Required*: No  
*Type*: Array of [ColumnSelector](aws-properties-databrew-job-columnselector.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

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

Represents one or more actions to be performed on a DataBrew dataset.

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

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

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

```
{
  "[Name](#cfn-databrew-job-recipe-name)" : String,
  "[Version](#cfn-databrew-job-recipe-version)" : String
}
```

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

```
  [Name](#cfn-databrew-job-recipe-name): String
  [Version](#cfn-databrew-job-recipe-version): String
```

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

`Name`  <a name="cfn-databrew-job-recipe-name"></a>
The unique name for the recipe.  
*Required*: Yes  
*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)

`Version`  <a name="cfn-databrew-job-recipe-version"></a>
The identifier for the version for the 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)

# AWS::DataBrew::Job S3Location
<a name="aws-properties-databrew-job-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-job-s3location-syntax"></a>

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

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

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

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

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

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

`Bucket`  <a name="cfn-databrew-job-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)

`BucketOwner`  <a name="cfn-databrew-job-s3location-bucketowner"></a>
The AWS account ID of the bucket owner.  
*Required*: No  
*Type*: String  
*Minimum*: `12`  
*Maximum*: `12`  
*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-job-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::Job S3TableOutputOptions
<a name="aws-properties-databrew-job-s3tableoutputoptions"></a>

Represents options that specify how and where DataBrew writes the Amazon S3 output generated by recipe jobs.

## Syntax
<a name="aws-properties-databrew-job-s3tableoutputoptions-syntax"></a>

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

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

```
{
  "[Location](#cfn-databrew-job-s3tableoutputoptions-location)" : S3Location
}
```

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

```
  [Location](#cfn-databrew-job-s3tableoutputoptions-location): 
    S3Location
```

## Properties
<a name="aws-properties-databrew-job-s3tableoutputoptions-properties"></a>

`Location`  <a name="cfn-databrew-job-s3tableoutputoptions-location"></a>
Represents an Amazon S3 location (bucket name and object key) where DataBrew can write output from a job.  
*Required*: Yes  
*Type*: [S3Location](aws-properties-databrew-job-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::Job StatisticOverride
<a name="aws-properties-databrew-job-statisticoverride"></a>

Override of a particular evaluation for a profile job. 

## Syntax
<a name="aws-properties-databrew-job-statisticoverride-syntax"></a>

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

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

```
{
  "[Parameters](#cfn-databrew-job-statisticoverride-parameters)" : {Key: Value, ...},
  "[Statistic](#cfn-databrew-job-statisticoverride-statistic)" : String
}
```

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

```
  [Parameters](#cfn-databrew-job-statisticoverride-parameters): 
    Key: Value
  [Statistic](#cfn-databrew-job-statisticoverride-statistic): String
```

## Properties
<a name="aws-properties-databrew-job-statisticoverride-properties"></a>

`Parameters`  <a name="cfn-databrew-job-statisticoverride-parameters"></a>
A map that includes overrides of an evaluation’s parameters.  
*Required*: Yes  
*Type*: Object of String  
*Pattern*: `^[A-Za-z0-9]{1,128}$`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Statistic`  <a name="cfn-databrew-job-statisticoverride-statistic"></a>
The name of an evaluation  
*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)

# AWS::DataBrew::Job StatisticsConfiguration
<a name="aws-properties-databrew-job-statisticsconfiguration"></a>

Configuration of evaluations for a profile job. This configuration can be used to select evaluations and override the parameters of selected evaluations. 

## Syntax
<a name="aws-properties-databrew-job-statisticsconfiguration-syntax"></a>

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

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

```
{
  "[IncludedStatistics](#cfn-databrew-job-statisticsconfiguration-includedstatistics)" : [ String, ... ],
  "[Overrides](#cfn-databrew-job-statisticsconfiguration-overrides)" : [ StatisticOverride, ... ]
}
```

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

```
  [IncludedStatistics](#cfn-databrew-job-statisticsconfiguration-includedstatistics): 
    - String
  [Overrides](#cfn-databrew-job-statisticsconfiguration-overrides): 
    - StatisticOverride
```

## Properties
<a name="aws-properties-databrew-job-statisticsconfiguration-properties"></a>

`IncludedStatistics`  <a name="cfn-databrew-job-statisticsconfiguration-includedstatistics"></a>
List of included evaluations. When the list is undefined, all supported evaluations will be included.  
*Required*: No  
*Type*: Array of String  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`Overrides`  <a name="cfn-databrew-job-statisticsconfiguration-overrides"></a>
List of overrides for evaluations.  
*Required*: No  
*Type*: Array of [StatisticOverride](aws-properties-databrew-job-statisticoverride.md)  
*Minimum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

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

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

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

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

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

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

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

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

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

`Key`  <a name="cfn-databrew-job-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-job-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)

# AWS::DataBrew::Job ValidationConfiguration
<a name="aws-properties-databrew-job-validationconfiguration"></a>

Configuration for data quality validation. Used to select the Rulesets and Validation Mode to be used in the profile job. When ValidationConfiguration is null, the profile job will run without data quality validation.

## Syntax
<a name="aws-properties-databrew-job-validationconfiguration-syntax"></a>

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

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

```
{
  "[RulesetArn](#cfn-databrew-job-validationconfiguration-rulesetarn)" : String,
  "[ValidationMode](#cfn-databrew-job-validationconfiguration-validationmode)" : String
}
```

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

```
  [RulesetArn](#cfn-databrew-job-validationconfiguration-rulesetarn): String
  [ValidationMode](#cfn-databrew-job-validationconfiguration-validationmode): String
```

## Properties
<a name="aws-properties-databrew-job-validationconfiguration-properties"></a>

`RulesetArn`  <a name="cfn-databrew-job-validationconfiguration-rulesetarn"></a>
The Amazon Resource Name (ARN) for the ruleset to be validated in the profile job. The TargetArn of the selected ruleset should be the same as the Amazon Resource Name (ARN) of the dataset that is associated with the profile job.  
*Required*: Yes  
*Type*: String  
*Minimum*: `20`  
*Maximum*: `2048`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`ValidationMode`  <a name="cfn-databrew-job-validationconfiguration-validationmode"></a>
Mode of data quality validation. Default mode is “CHECK\$1ALL” which verifies all rules defined in the selected ruleset.  
*Required*: No  
*Type*: String  
*Allowed values*: `CHECK_ALL`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)