Querying ID mapping tables using the SQL code editor

To query ID mapping tables using the SQL code editor

1. Sign in to the AWS Management Console and open the AWS Clean Rooms console with your AWS account (if you haven't yet done so).

2. In the left navigation pane, choose Collaborations.

3. Choose the collaboration that has Your member abilities status of Run queries.

4. On the Queries tab, go to the Analysis section.

   Note

   The Analysis section only displays if the member who can receive results and the member who is responsible to pay for query compute costs have joined the collaboration as an active member.

5. On the Queries tab, under Tables, view the list of ID mapping tables (under Managed by AWS Clean Rooms) and their associated analysis rule type (ID mapping table analysis rule).

   Note

   If you don’t see the ID mapping tables that you expect in the list, it might be because the ID mapping tables haven't been successfully populated. For more information, see Populating an existing ID mapping table.

6. Build the query by typing the query into the SQL code editor.

   (Optional) If you want to use an example query	(Optional) If you want to insert a table name
   Select the three vertical dots next to the table. Under Insert in editor, choose Example JOIN statement. Note Inserting an Example JOIN statmenets appends the query already in the editor. The example JOIN statement appears. Edit the placeholder values in the query.	Select the three vertical dots next to a column. Under Insert in editor, choose Table name. Edit the placeholder values in the query.

7. Choose Run.

   Note

   You can't run the query if the member who can receive results hasn’t configured the query results settings.

8. View the Results.

   For more information, see Receiving and using query results.

9. Continue to adjust parameters and run your query again, or choose the + button to start a new query in a new tab.