View a markdown version of this page

AWS::CleanRooms::IntermediateTable ComparisonControls - AWS CloudFormation

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.

AWS::CleanRooms::IntermediateTable ComparisonControls

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

Syntax

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

JSON

{ "AllowedColumnComparisonColumns" : [ String, ... ], "AllowedLiteralComparisonColumns" : [ String, ... ] }

Properties

AllowedColumnComparisonColumns

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

AllowedLiteralComparisonColumns

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