Query data from AWS IoT SiteWise is not working in my environment.

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