Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Querying IoT SiteWise data using SQL statements

0

Hi, I want to fetch data from IoT Sitewise using SQL statements. For that I am using boto3 api execute_query() in AWS Lambda. The role attached to Lambda has all the required permissions. But I am getting the below error when executing. "An error occurred (ValidationException) when calling the ExecuteQuery operation: Metadata access denied. Unable to assume SiteWise Service Linked Role". With IoTSiteWiseFullAccess also this issue is seen. What is the correct way to call this api from Lambda? Is there any other permissions to be attached? Please let me know.

with rgds, Manish

Topics
Internet of Things (IoT)
Tags
AWS IoT SiteWise
Language
English
asked 2 years ago374 views
1 Answer
1
Accepted Answer

Hi. Have you met all of the required prerequisites? https://docs.aws.amazon.com/iot-sitewise/latest/userguide/sql.html#prereqs

AWS
EXPERT
answered 2 years ago
EXPERT
reviewed a year ago
  • Manish Padmajan
    2 years ago

    Thank you for the note. I had made the changes as per the link above but there was an issue with the permission attached to the lambda role. Figured the issue by checking the steps again. Now execute_query() API is working fine.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content