An Exploration of the NetApp DII DWH - Columns on Table in dwh_capacity_efficiency

SQL

SELECT
    CONCAT(c.TABLE_NAME, '.', c.COLUMN_NAME) AS 'Column'
FROM
    information_schema.columns AS c
WHERE
    c.TABLE_SCHEMA LIKE '%_dwh_capacity_efficiency'

Output

date_dimension.dateYear
date_dimension.dayInMonth
date_dimension.dayInQuarter
date_dimension.dayInWeekNum
date_dimension.dayInYear
date_dimension.fullDate
date_dimension.future
date_dimension.latest
date_dimension.monthLabel
date_dimension.monthNum
date_dimension.quarter
date_dimension.quarterLabel
date_dimension.repDay
date_dimension.repMonth
date_dimension.repMonthOrLatest
date_dimension.repQuarter
date_dimension.repWeek
date_dimension.sspFlag
date_dimension.tk
date_dimension.yearLabel
efficiency_fact.backendCapacityMB
efficiency_fact.dateTk
efficiency_fact.gainMB
efficiency_fact.lossMB
efficiency_fact.potentialGainMB
efficiency_fact.potentialLossMB
efficiency_fact.rawCapacityMB
efficiency_fact.storageTechnology
efficiency_fact.storageTk
efficiency_fact.tk
storage_dimension.dataCenter
storage_dimension.dateTk
storage_dimension.family
storage_dimension.id
storage_dimension.identifier
storage_dimension.ip
storage_dimension.latest
storage_dimension.manufacturer
storage_dimension.microcodeVersion
storage_dimension.model
storage_dimension.name
storage_dimension.region
storage_dimension.serialNumber
storage_dimension.tk
storage_dimension.url