Additionally, it might help to see some sample SQL queries.
For each data mart, you can find sample SQL queries in the OCI Data Warehouse (DWH) User Guide at https://support.netapp.com/documentation/productlibrary/index.html?productID=60983.
Here's a sample SQL query taken from the DWH User Guide for the Storage and Storage Pool Capacity data mart. This retrieves capacity and raw capacity for all storage arrays.
SELECT
sd.name AS 'Storage Name',
SUM(spcf.capacityMB) AS 'Capacity MB',
SUM(spcf.rawCapacityMB) AS 'RawCapacity MB'
FROM
dwh_capacity.storage_and_storage_pool_capacity_fact spcf
JOIN dwh_capacity.storage_dimension sd
ON spcf.storageTk = sd.tk
JOIN dwh_capacity.date_dimension d
ON d.tk=spcf.dateTk
AND d.latest = 1
GROUP BY sd.name