SQL
SELECT
CONCAT(c.TABLE_NAME, '.', c.COLUMN_NAME) AS 'Column'
FROM
information_schema.columns AS c
WHERE
c.TABLE_SCHEMA LIKE '%_dwh_fs_util'
Output
compute_resource_dimension.dateTk
compute_resource_dimension.domain
compute_resource_dimension.id
compute_resource_dimension.identifier
compute_resource_dimension.ip
compute_resource_dimension.latest
compute_resource_dimension.name
compute_resource_dimension.os
compute_resource_dimension.tk
compute_resource_dimension.type
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
file_system_dimension.computeResourceIdentifier
file_system_dimension.dateTk
file_system_dimension.hardwareId
file_system_dimension.id
file_system_dimension.latest
file_system_dimension.location
file_system_dimension.name
file_system_dimension.tk
file_system_dimension.type
fs_util_fact.computeResourceTk
fs_util_fact.dateTk
fs_util_fact.fsTk
fs_util_fact.hostTk
fs_util_fact.sizeMB
fs_util_fact.storageTk
fs_util_fact.tierTk
fs_util_fact.tk
fs_util_fact.usedMB
fs_util_fact.vmTk
host_dimension.dataCenter
host_dimension.dateTk
host_dimension.id
host_dimension.identifier
host_dimension.ip
host_dimension.latest
host_dimension.manufacturer
host_dimension.model
host_dimension.name
host_dimension.os
host_dimension.tk
host_dimension.url
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
tier_dimension.cost
tier_dimension.dateTk
tier_dimension.id
tier_dimension.latest
tier_dimension.name
tier_dimension.sequence
tier_dimension.tk
vm_dimension.dateTk
vm_dimension.id
vm_dimension.ips
vm_dimension.latest
vm_dimension.name
vm_dimension.naturalKey
vm_dimension.os
vm_dimension.tk
vm_dimension.url
vm_dimension.virtualCenterIp
Comments
Post a Comment