Querying configured tables using an analysis template
This procedure demonstrates how to use an analysis template in the AWS Clean Rooms console to query configured tables with the Custom analysis rule.
To use an analysis template to query configured tables with the Custom analysis rule
-
Sign in to the AWS Management Console and open the AWS Clean Rooms console
with your AWS account (if you have not yet done so). -
In the left navigation pane, choose Collaborations.
-
Choose the collaboration that has Your member abilities status of Query.
-
On the Queries tab, under Tables, view the tables and their associated analysis rule type (Custom analysis rule).
Note
If you don’t see the tables that you expect in the list, it might be for the following reasons:
-
The tables haven't been associated.
-
The tables don't have an analysis rule configured.
-
-
Under the Analysis section, select the analysis template from the dropdown list.
-
Enter the value of the parameters from the analysis template you want to use in the query. The value must be in the parameter's specified data type. You can use different values each time you run the analysis template. Empty or NULL values for the parameter aren't supported. Using parameters in LIMIT clause is also not supported.
-
Choose Run.
Note
You can't run the query if the member who can receive results hasn’t configured the query results settings.
-
Continue to adjust parameters and run your query again, or choose the + button to start a new query in a new tab.