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": []
}
]
}
[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