AWS clean rooms - An error occurred while the query was running

Question

I am new to Clean Rooms. I have created a collaboration from Account A, having Account B (can Run queries & Receive results) as the executor, when I try to run query on Configured tables from Account B, after a minute I am getting an error as follows - An error occurred while the query was running.

There is no detailed log even in Cloudwatch or S3. How can I troubleshoot from this point.

Thanks in advance.

There is no detailed log even in Cloudwatch or S3. How can I troubleshoot from this point.

Thanks in advance.

Accepted Answer

If the error occurs solely on the side of Account B, it could be due to an improperly defined cross-account policy. Please ensure that the roles in your Account A, which Account B assumes to run queries and receive results, are correctly configured. You can refer to the tutorial on cross-account roles at https://docs.aws.amazon.com/IAM/latest/UserGuide/tutorial_cross-account-with-roles.html for guidance.

For troubleshooting, you can also attempt to assume the role from the same Account A and execute queries to verify if the issue lies within the role configuration.

AWS clean rooms - An error occurred while the query was running

Contenus pertinents