AWS clean rooms, no result return from query

Hello,

If you are using Cryptographic Computing for Clean Rooms (C3R), verify that your query uses encrypted columns correctly:

• The sealed columns are only used in SELECT clauses.
• The fingerprint columns are only used in JOIN clauses (and GROUP BY clauses under certain conditions).
• That you are only JOINing fingerprint columns with the same name if the collaboration settings require it. https://docs.aws.amazon.com/clean-rooms/latest/userguide/receive-query-results.html#receive-results https://docs.aws.amazon.com/clean-rooms/latest/userguide/troubleshooting.html#troubleshoot-query-results-c3r

Please, accept this answer if it was useful to you.

Thank you.

Hello Jina, Yes, in this link https://docs.aws.amazon.com/clean-rooms/latest/userguide/security_iam_id-based-policy-examples.html#security_iam_service-with-iam-policy-best-practices you can see the best practices to use IAM with Clean Rooms

"AWS clean rooms, no result return from query" could be related with the Member who can receive results "member who can receive results specifies query results settings for the Amazon S3 destination and the query result format.There is only one member who can receive results per collaboration, and that member is immutable" https://docs.aws.amazon.com/clean-rooms/latest/userguide/glossary.html#glossary-member-who-can-receive-results