Query data from AWS IoT SiteWise is not working in my environment.
0
I tried SiteWise's query function, but it doesn't work. Please let me know if there are any settings missing.
Reference document https://docs.aws.amazon.com/iot-sitewise/latest/userguide/query-industrial-data.html
- Region Singapore
- Verification environment: CloudShell
- Check AWSServiceRoleForIoTSiteWise Role
[cloudshell-user@ip-10-6-82-184 ~]$ aws iam get-role --role-name AWSServiceRoleForIoTSiteWise { "Role": { "Path": "/aws-service-role/iotsitewise.amazonaws.com/", "RoleName": "AWSServiceRoleForIoTSiteWise", "RoleId": "AROAQCFYCUBCDOMBMZOO2", "Arn": "arn:aws:iam::004681015364:role/aws-service-role/iotsitewise.amazonaws.com/AWSServiceRoleForIoTSiteWise", "CreateDate": "2024-01-09T02:14:46+00:00", "AssumeRolePolicyDocument": { "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Principal": { "Service": "iotsitewise.amazonaws.com" }, "Action": "sts:AssumeRole" } ] }, "MaxSessionDuration": 3600, "RoleLastUsed": { "LastUsedDate": "2024-01-19T07:04:33+00:00", "Region": "ap-southeast-1" } } }
[cloudshell-user@ip-10-6-82-184 ~]$ aws iam list-attached-role-policies --role-name AWSServiceRoleForIoTSiteWise { "AttachedPolicies": [ { "PolicyName": "AWSServiceRoleForIoTSiteWise", "PolicyArn": "arn:aws:iam::aws:policy/aws-service-role/AWSServiceRoleForIoTSiteWise" } ] }
- Check AWSServiceRoleForIoTTwinMaker Role
[cloudshell-user@ip-10-6-82-184 ~]$ aws iam get-role --role-name AWSServiceRoleForIoTTwinMaker { "Role": { "Path": "/aws-service-role/iottwinmaker.amazonaws.com/", "RoleName": "AWSServiceRoleForIoTTwinMaker", "RoleId": "AROAQCFYCUBCHPS23IL4J", "Arn": "arn:aws:iam::004681015364:role/aws-service-role/iottwinmaker.amazonaws.com/AWSServiceRoleForIoTTwinMaker", "CreateDate": "2023-12-25T10:19:29+00:00", "AssumeRolePolicyDocument": { "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Principal": { "Service": "iottwinmaker.amazonaws.com" }, "Action": "sts:AssumeRole" } ] }, "MaxSessionDuration": 3600, "RoleLastUsed": { "LastUsedDate": "2024-01-19T07:04:25+00:00", "Region": "ap-southeast-1" } } }
[cloudshell-user@ip-10-6-82-184 ~]$ aws iam list-attached-role-policies --role-name AWSServiceRoleForIoTTwinMaker { "AttachedPolicies": [ { "PolicyName": "AWSIoTTwinMakerServiceRolePolicy", "PolicyArn": "arn:aws:iam::aws:policy/aws-service-role/AWSIoTTwinMakerServiceRolePolicy" } ] }
- Check IoTSiteWiseDefaultWorkspace workspace of TwinMaker
[cloudshell-user@ip-10-6-82-184 ~]$ aws iottwinmaker get-workspace --workspace-id IoTSiteWiseDefaultWorkspace { "workspaceId": "IoTSiteWiseDefaultWorkspace", "arn": "arn:aws:iottwinmaker:ap-southeast-1:004681015364:workspace/IoTSiteWiseDefaultWorkspace", "description": "", "linkedServices": [ "IOTSITEWISE" ], "creationDateTime": "2024-01-09T02:14:49.817000+00:00", "updateDateTime": "2024-01-09T02:14:49.817000+00:00" }
- Check exists of sitewise asset
[cloudshell-user@ip-10-6-82-184 ~]$ aws iotsitewise list-assets --asset-model-id c3f3efb4-60e9-4dab-9103-28df30223331 { "assetSummaries": [ { "id": "79f1f9fd-b351-43fc-865e-ced8aad6a454", "arn": "arn:aws:iotsitewise:ap-southeast-1:004681015364:asset/79f1f9fd-b351-43fc-865e-ced8aad6a454", "name": "TEST_ASSET", "assetModelId": "c3f3efb4-60e9-4dab-9103-28df30223331", "creationDate": "2024-01-19T07:04:14+00:00", "lastUpdateDate": "2024-01-19T07:04:14+00:00", "status": { "state": "ACTIVE" }, "hierarchies": [] } ] }
- Run ExecuteQuery API
[cloudshell-user@ip-10-6-82-184 ~]$ aws iotsitewise execute-query --query-statement "SELECT asset_name FROM asset" { "rows": [], "columns": [ { "name": "asset_name", "type": { "scalarType": "STRING" } } ] }
Response of "rows" is empty
feita há 4 meses74 visualizaçõeslg...
Sem respostas
- Mais recentes
- Mais votos
- Mais comentários
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos