Example queries - AWS IoT SiteWise
Metadata filteringValue filtering

Example queries

Metadata filtering

The following example is for metadata filtering with a SELECT statement with the AWS IoT SiteWise query language:


SELECT a.asset_name, p.property_name 
FROM asset a, asset_property p 
WHERE a.asset_id = p.asset_id AND a.asset_name LIKE '%windmill%'

Value filtering

The following is an example of value filtering using a SELECT statement with the AWS IoT SiteWise query language:


SELECT a.asset_name FROM asset a, raw_time_series r 
WHERE a.asset_id = r.asset_id AND r.int_value > 30  AND r.event_timestamp > 1234567890 AND r.event_timestamp < 1234567891