How To
Summary
This document outlines the steps to verify device metrics data in Snowflake
Objective
This document enables users to verify device metrics data in Snowflake.
Environment
Application: IBM Maximo Renewables
Modules: Trends
Scope: Reporting
Use Case: User can validate the device metrics data in the RLS_VW_SOLAR_DEVICE_METRICS_DAILY table in Snowflake
User Roles: Site Engineer, Asset Manager, Operations Manager and Stake Holders.
Steps
Preliminary check:
- In Snowflake, the Generation table, Avg_Active Power, Insolation retrieves data from Trends data. Please validate that the corresponding Inverter Daily Energy, Active Power, and Weather station POA Irradiance data are present and correctly populated in the Trends table. The remaining device metrics are calculating based on Daily Energy, Active Power, and POA Irradiance values.
- RLS_VW_SOLAR_DEVICE_METRICS_DAILY table retrieves data on an hourly basis, providing 24 hourly device‑metric data points for each day for a single asset.
- Open Snowflake and login the snowflake based on credentials shared.
To review the data in the RLS_VW_SOLAR_DEVICE_METRICS_DAILY table, use the following query in Snowflake. Specify the date range in the format shown below to retrieve data for a specific day, and include the corresponding plant ID for the required plant.
Select * from DM.PUBLIC.RLS_VW_SOLAR_DEVICE_METRICS_HOURLY
where PLANT_ID in (2473) and DATEVALUE between '2026-02-17' and '2026-02-17'
order by DATEVALUE
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
02 March 2026
UID
ibm17262127