View a markdown version of this page

AWS::CleanRooms::ConfiguredTable ComparisonControls - Amazon CloudFormation
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

This is the new Amazon CloudFormation Template Reference Guide. Please update your bookmarks and links. For help getting started with CloudFormation, see the Amazon CloudFormation User Guide.

AWS::CleanRooms::ConfiguredTable 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 Amazon 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. Amazon 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. Amazon 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