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::CleanRooms::IntermediateTable ComparisonControls
<a name="aws-properties-cleanrooms-intermediatetable-comparisoncontrols"></a>

Specifies how a query can compare the columns in a table, including literal comparisons and column-to-column comparisons.

## Syntax
<a name="aws-properties-cleanrooms-intermediatetable-comparisoncontrols-syntax"></a>

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

### JSON
<a name="aws-properties-cleanrooms-intermediatetable-comparisoncontrols-syntax.json"></a>

```
{
  "[AllowedColumnComparisonColumns](#cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedcolumncomparisoncolumns)" : {{[ String, ... ]}},
  "[AllowedLiteralComparisonColumns](#cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedliteralcomparisoncolumns)" : {{[ String, ... ]}}
}
```

### YAML
<a name="aws-properties-cleanrooms-intermediatetable-comparisoncontrols-syntax.yaml"></a>

```
  [AllowedColumnComparisonColumns](#cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedcolumncomparisoncolumns): {{
    - String}}
  [AllowedLiteralComparisonColumns](#cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedliteralcomparisoncolumns): {{
    - String}}
```

## Properties
<a name="aws-properties-cleanrooms-intermediatetable-comparisoncontrols-properties"></a>

`AllowedColumnComparisonColumns`  <a name="cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedcolumncomparisoncolumns"></a>
The columns that a query can compare to another column, for example, in a join, a WHERE clause, a GROUP BY clause, or a window function. AWS Clean Rooms rejects a query that uses any other column in a column-to-column comparison. Specify an empty list to block column-to-column comparison on every column.  
*Required*: Yes  
*Type*: Array of String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`AllowedLiteralComparisonColumns`  <a name="cfn-cleanrooms-intermediatetable-comparisoncontrols-allowedliteralcomparisoncolumns"></a>
The columns that a query can compare to literal values, for example, in a WHERE clause. AWS Clean Rooms rejects a query that compares any other column to a literal value. Specify an empty list to block literal comparison on every column. You can't specify a column that you also use as an identity column in an aggregation threshold.  
*Required*: Yes  
*Type*: Array of String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)