Hello, I have the following error when creating a data set from Athena, using the Athena connector for Dynamo? [Simba] AthenaJDBC An error has been thrown from the AWS Athena client. Failed to invoke lambda function due to com.amazonaws.services.lambda.model.AWSLambdaException: User: arn:aws:sts::as…

At the moment, giving Lambda execution permissions to the aws-quicksight-service-role-v0/ role manually has been solved. Are these the best practices?

Hi @Luis , Validate if you have allowed Quick Sight has access to lambda functions ( Manage Quick Sight > Security & permissions : Amazon Athena ) [Screenshot 2023-03-07 at 11.15.39] Kind regards, Koushik

When accessing, it does not list any Lambda, the lambda was created in Ohio with the respective template. [image]

I believe it has to be in same region as Athena. Test by creating the lambda function in us-east-1 and check if you are able to see the function.

@Koushik_Muthanna Athena is used in Ohio like Lambda and Dynamo, Quick Sight management is done in Northern Virginia, how can this be resolved?

Hi @Luis , can you try to move your lambda function to Northern Virginia, and enable the lambda function to access the Dynamo table across region? We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.”

Using Athena data connectors to visualize DynamoDB data with AWS Quick Sight

Q&A

yingliao422 March 17, 2023, 6:31pm 9

That works well as a solution!

Topic		Replies	Views
Cross AWS Account Enterprise Athena With Dynamo DB and Lambda Q&A data-source , quick-sight , Business-Intelligence-Engineer	1	271	August 2, 2024
Lambda function not appearing for Athena Connector Q&A direct-query , error , quick-sight	6	1227	February 25, 2025
Quick Sight で DynamoDB のデータを可視化するためのフェデレーテッドクエリ用 Lambda を選択できない日本語で質問 \| Q&A admin , error , feature-request , Japanese	3	169	April 3, 2025
Adding permissions for Lambda access - JSON Q&A api , developer , quick-sight	3	1094	February 25, 2025
DynamoDB Athena Failed to get metadata for table Q&A developer , error , quick-sight	6	282	November 27, 2024

Using Athena data connectors to visualize DynamoDB data with AWS Quick Sight

Related topics