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, ... ]}
YAML
AllowedColumnComparisonColumns:- StringAllowedLiteralComparisonColumns:- 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