By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre: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
Manish Padmajan
asked 21 days ago42 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

profile pictureAWS
EXPERT
Greg_B
answered 21 days ago
  • Manish Padmajan
    20 days 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.

Guidelines for Answering Questions

Relevant content