Data acquired 02.03.2026
An exploration of the NetApp Data Infrastructure Insights (DII) Data Warehouse (DWH) with SQL commands (run in the DII Reporting Portal's Cognos.)
show databases
Note: #$account.parameters.TENANT_ID# is a Cognos function used to pull the Tenant ID. If you run show databases the output below will show the true Tenant ID which is redacted here.
information_schema
performance_schema
#$account.parameters.TENANT_ID#_dwh_capacity
#$account.parameters.TENANT_ID#_dwh_capacity_efficiency
#$account.parameters.TENANT_ID#_dwh_capacity_staging
#$account.parameters.TENANT_ID#_dwh_custom
#$account.parameters.TENANT_ID#_dwh_dimensions
#$account.parameters.TENANT_ID#_dwh_fs_util
#$account.parameters.TENANT_ID#_dwh_inventory
#$account.parameters.TENANT_ID#_dwh_inventory_staging
#$account.parameters.TENANT_ID#_dwh_inventory_transient
#$account.parameters.TENANT_ID#_dwh_management
#$account.parameters.TENANT_ID#_dwh_performance
#$account.parameters.TENANT_ID#_dwh_ports
We won't look at all of the tables above. Specifically:
- performance_schema : this is a native MySQL database to do with MySQL performance.
- dwh_capacity_staging, dwh_inventory_staging & dwh_inventory_transient : these are temporary databases
- dwh_custom : this schema is for customer specific tables
We will look at information_schema as I think it is of interest. And in later posts we will look at the columns in the tables in the highlighted databases (for some reason the dwh_management post got unpublished, no idea why, it's not particularly important to look at so I deleted it.)
show full tables from information_schema
Note: Table_type = "SYSTEM VIEW" for all tables in information_schema
ADMINISTRABLE_ROLE_AUTHORIZATIONS
APPLICABLE_ROLES
AURORA_FORWARDING_PROCESSLIST
AURORA_GLOBAL_DB_INSTANCE_STATUS
AURORA_GLOBAL_DB_STATUS
CHARACTER_SETS
CHECK_CONSTRAINTS
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATIONS
COLUMN_PRIVILEGES
COLUMN_STATISTICS
COLUMNS
COLUMNS_EXTENSIONS
ENABLED_ROLES
ENGINES
EVENTS
FILES
GDRDS_COUNTERS
GDRDS_EVICTED_COUNTERS
INNODB_BUFFER_PAGE
INNODB_BUFFER_PAGE_LRU
INNODB_BUFFER_POOL_STATS
INNODB_CACHED_INDEXES
INNODB_CMP
INNODB_CMP_PER_INDEX
INNODB_CMP_PER_INDEX_RESET
INNODB_CMP_RESET
INNODB_CMPMEM
INNODB_CMPMEM_RESET
INNODB_COLUMNS
INNODB_DATAFILES
INNODB_FIELDS
INNODB_FOREIGN
INNODB_FOREIGN_COLS
INNODB_FT_BEING_DELETED
INNODB_FT_CONFIG
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_DELETED
INNODB_FT_INDEX_CACHE
INNODB_FT_INDEX_TABLE
INNODB_INDEXES
INNODB_METRICS
INNODB_SESSION_TEMP_TABLESPACES
INNODB_TABLES
INNODB_TABLESPACES
INNODB_TABLESPACES_BRIEF
INNODB_TABLESTATS
INNODB_TEMP_TABLE_INFO
INNODB_TRX
INNODB_TRX_STATUS
INNODB_VIRTUAL
KEY_COLUMN_USAGE
KEYWORDS
OPTIMIZER_TRACE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
RDS_CONTROL_PERFORMANCE_INSIGHTS_STATUS
RDS_METRICS_COUNTER
RDS_METRICS_GAUGE
RDS_METRICS_META
RDS_PROCESSLIST
REFERENTIAL_CONSTRAINTS
REPLICA_HOST_STATUS
RESOURCE_GROUPS
ROLE_COLUMN_GRANTS
ROLE_ROUTINE_GRANTS
ROLE_TABLE_GRANTS
ROUTINES
SCHEMA_PRIVILEGES
SCHEMATA
SCHEMATA_EXTENSIONS
ST_GEOMETRY_COLUMNS
ST_SPATIAL_REFERENCE_SYSTEMS
ST_UNITS_OF_MEASURE
STATISTICS
TABLE_CONSTRAINTS
TABLE_CONSTRAINTS_EXTENSIONS
TABLE_PRIVILEGES
TABLES
TABLES_EXTENSIONS
TABLESPACES
TABLESPACES_EXTENSIONS
TRIGGERS
USER_ATTRIBUTES
USER_PRIVILEGES
VIEW_ROUTINE_USAGE
VIEW_TABLE_USAGE
VIEWS
show full tables from #$account.parameters.TENANT_ID#_dwh_capacity
Table_type Tables
VIEW application_dimension
VIEW application_group_bridge
VIEW application_group_dimension
VIEW business_entity_dimension
BASE TABLE capacity_type
VIEW cardinals
BASE TABLE chargeback_fact
VIEW datastore_dimension
VIEW date_dimension
BASE TABLE disk_group_capacity_fact
BASE TABLE disk_group_capacity_future_fact
VIEW disk_group_dimension
VIEW host_dimension
VIEW host_group_bridge
VIEW host_group_dimension
BASE TABLE internal_volume_capacity_fact
VIEW internal_volume_dimension
VIEW k8s_cluster_dimension
VIEW k8s_namespace_dimension
VIEW k8s_namespace_group_bridge
VIEW k8s_namespace_group_dimension
VIEW k8s_node_dimension
VIEW k8s_pv_dimension
BASE TABLE k8s_pvc_capacity_fact
VIEW k8s_pvc_dimension
VIEW k8s_workload_dimension
BASE TABLE qtree_capacity_fact
VIEW qtree_dimension
VIEW service_level_dimension
BASE TABLE sp_time_to_fill
BASE TABLE storage_and_storage_pool_capacity_fact
BASE TABLE storage_and_storage_pool_capacity_future_fact
VIEW storage_dimension
BASE TABLE storage_node_capacity_fact
VIEW storage_node_dimension
VIEW storage_pool_dimension
VIEW tier_dimension
BASE TABLE vm_capacity_fact
VIEW vm_dimension
VIEW volume_capacity_fact
VIEW volume_dimension
BASE TABLE volume_fact_current
BASE TABLE volume_history_capacity_fact
BASE TABLE volume_last_accessed_time
show full tables from #$account.parameters.TENANT_ID#_dwh_capacity_efficiency
Table_type Tables
VIEW date_dimension
BASE TABLE efficiency_fact
VIEW storage_dimension
show full tables from #$account.parameters.TENANT_ID#_dwh_dimensions
Table_type Tables
BASE TABLE application_dimension
BASE TABLE application_group_bridge
BASE TABLE application_group_dimension
BASE TABLE business_entity_dimension
BASE TABLE cluster_switch_dimension
BASE TABLE cluster_switch_port_dimension
BASE TABLE compute_resource_dimension
BASE TABLE connected_device_dimension
BASE TABLE datastore_dimension
BASE TABLE date_dimension
BASE TABLE disk_dimension
BASE TABLE disk_group_dimension
BASE TABLE fabric_dimension
BASE TABLE file_system_dimension
BASE TABLE generic_dimension
BASE TABLE host_dimension
BASE TABLE host_group_bridge
BASE TABLE host_group_dimension
BASE TABLE internal_volume_dimension
BASE TABLE k8s_cluster_dimension
BASE TABLE k8s_namespace_dimension
BASE TABLE k8s_namespace_group_bridge
BASE TABLE k8s_namespace_group_dimension
BASE TABLE k8s_node_dimension
BASE TABLE k8s_pv_dimension
BASE TABLE k8s_pvc_dimension
BASE TABLE k8s_workload_dimension
BASE TABLE port_dimension
BASE TABLE qtree_dimension
BASE TABLE service_level_dimension
BASE TABLE storage_dimension
BASE TABLE storage_node_dimension
BASE TABLE storage_pool_dimension
BASE TABLE switch_dimension
BASE TABLE tape_dimension
BASE TABLE tier_dimension
BASE TABLE vm_dimension
BASE TABLE vmdk_dimension
BASE TABLE vmware_host_dimension
BASE TABLE volume_dimension
show full tables from #$account.parameters.TENANT_ID#_dwh_fs_util
Table_type Tables
VIEW compute_resource_dimension
VIEW date_dimension
VIEW file_system_dimension
BASE TABLE fs_util_fact
VIEW host_dimension
VIEW storage_dimension
VIEW tier_dimension
VIEW vm_dimension
show full tables from #$account.parameters.TENANT_ID#_dwh_inventory
Table_type Tables
BASE TABLE acq_acquisition_unit
BASE TABLE acq_data_source
BASE TABLE annotation_value
BASE TABLE application
BASE TABLE auto_tiering_policy
BASE TABLE auto_tiering_policy_constraint
BASE TABLE backend_lun
BASE TABLE backend_lun_to_volume
BASE TABLE backend_path
VIEW business_entity
BASE TABLE cluster_switch
BASE TABLE cluster_switch_port
BASE TABLE compute_resource
BASE TABLE disk
BASE TABLE disk_group
VIEW disk_group_to_disk
VIEW disk_group_to_storage_pool
BASE TABLE dr_internal_volume_replica
BASE TABLE dr_qtree_replica
VIEW dr_replica
BASE TABLE dr_volume_replica
BASE TABLE extended_data
BASE TABLE fabric
BASE TABLE fc_name_server_entry
BASE TABLE file_system
BASE TABLE file_system_to_virtual_disk
BASE TABLE file_system_to_volume
BASE TABLE generic_device
BASE TABLE generic_device_port
BASE TABLE host
BASE TABLE host_adapter
BASE TABLE host_port
BASE TABLE host_to_application
BASE TABLE hv_data_store
BASE TABLE hv_data_store_to_internal_volume
BASE TABLE hv_data_store_to_volume
BASE TABLE hv_datastore_to_nas_share
BASE TABLE hv_host_to_nas_share
BASE TABLE hv_lun
BASE TABLE hv_lun_to_volume
BASE TABLE hv_nas_share
BASE TABLE hv_nas_share_to_share
BASE TABLE hv_path
BASE TABLE hv_server
BASE TABLE hv_virtual_disk
BASE TABLE hv_virtual_disk_to_volume
BASE TABLE hv_virtual_machine
BASE TABLE hv_virtual_machine_to_disk
BASE TABLE internal_volume
BASE TABLE internal_volume_to_application
BASE TABLE iscsi_logical
BASE TABLE k8s_cluster
BASE TABLE k8s_label
BASE TABLE k8s_namespace
BASE TABLE k8s_node
BASE TABLE k8s_pv
BASE TABLE k8s_pvc
BASE TABLE k8s_workload
BASE TABLE k8s_workload_to_pvc
BASE TABLE logical
BASE TABLE nas_cr_logical
BASE TABLE nas_file_share
VIEW nas_logical
BASE TABLE nas_share
BASE TABLE nas_share_initiator
BASE TABLE object_to_annotation
BASE TABLE physical_path
BASE TABLE port_connectivity
BASE TABLE qtree
BASE TABLE qtree_to_application
BASE TABLE quota
VIEW service_level
BASE TABLE share_to_application
BASE TABLE storage
BASE TABLE storage_controller
BASE TABLE storage_node
VIEW storage_node_to_internal_volume
VIEW storage_node_to_port
VIEW storage_node_to_storage_pool
VIEW storage_node_to_volume
BASE TABLE storage_pool
VIEW storage_pool_to_backend_lun
VIEW storage_pool_to_disk
BASE TABLE storage_port
BASE TABLE storage_to_application
BASE TABLE switch
BASE TABLE switch_port
BASE TABLE switch_port_to_application
BASE TABLE switch_to_application
BASE TABLE tape
BASE TABLE tape_controller
BASE TABLE tape_port
VIEW tier
BASE TABLE unknown_logical
BASE TABLE violation
BASE TABLE virtual_switch
VIEW virtual_to_backend_volume
BASE TABLE vm_to_application
BASE TABLE vmware_host
BASE TABLE volume
VIEW volume_in_storage_pool
BASE TABLE volume_map
BASE TABLE volume_mask
BASE TABLE volume_to_application
BASE TABLE zone
BASE TABLE zone_member
show full tables from #$account.parameters.TENANT_ID#_dwh_management
show full tables from #$account.parameters.TENANT_ID#_dwh_performance
Table_type Tables
VIEW application_dimension
VIEW application_group_bridge
VIEW application_group_dimension
BASE TABLE application_volume_hourly_performance_fact
VIEW business_entity_dimension
VIEW capacity_volume_fact_current
VIEW cluster_switch_dimension
BASE TABLE cluster_switch_port_daily_metrics_fact
VIEW cluster_switch_port_dimension
BASE TABLE cluster_switch_port_hourly_metrics_fact
VIEW connected_device_dimension
VIEW datastore_dimension
VIEW date_dimension
BASE TABLE disk_daily_performance_fact
VIEW disk_dimension
BASE TABLE disk_hourly_performance_fact
VIEW fabric_dimension
VIEW host_dimension
VIEW host_group_bridge
VIEW host_group_dimension
BASE TABLE host_vm_daily_performance_fact
BASE TABLE host_vm_hourly_performance_fact
BASE TABLE host_volume_hourly_performance_fact
BASE TABLE internal_volume_daily_performance_fact
VIEW internal_volume_dimension
BASE TABLE internal_volume_hourly_performance_fact
BASE TABLE k8s_cluster_daily_metrics_fact
VIEW k8s_cluster_dimension
BASE TABLE k8s_cluster_hourly_metrics_fact
BASE TABLE k8s_namespace_daily_metrics_fact
VIEW k8s_namespace_dimension
VIEW k8s_namespace_group_bridge
VIEW k8s_namespace_group_dimension
BASE TABLE k8s_namespace_hourly_metrics_fact
BASE TABLE k8s_node_daily_metrics_fact
VIEW k8s_node_dimension
BASE TABLE k8s_node_hourly_metrics_fact
VIEW k8s_pv_dimension
BASE TABLE k8s_pvc_daily_metrics_fact
VIEW k8s_pvc_dimension
BASE TABLE k8s_pvc_hourly_metrics_fact
BASE TABLE k8s_workload_daily_metrics_fact
VIEW k8s_workload_dimension
BASE TABLE k8s_workload_hourly_metrics_fact
VIEW port_dimension
BASE TABLE qtree_daily_performance_fact
VIEW qtree_dimension
BASE TABLE qtree_hourly_performance_fact
VIEW service_level_dimension
VIEW storage_dimension
BASE TABLE storage_node_daily_performance_fact
VIEW storage_node_dimension
BASE TABLE storage_node_hourly_performance_fact
VIEW storage_pool_dimension
VIEW switch_dimension
BASE TABLE switch_performance_for_host_hourly_fact
BASE TABLE switch_performance_for_port_hourly_fact
BASE TABLE switch_performance_for_storage_hourly_fact
BASE TABLE switch_performance_for_tape_hourly_fact
VIEW tape_dimension
VIEW tier_dimension
BASE TABLE time_dimension
BASE TABLE vm_daily_performance_fact
VIEW vm_dimension
BASE TABLE vm_hourly_performance_fact
BASE TABLE vmdk_daily_performance_fact
VIEW vmdk_dimension
BASE TABLE vmdk_hourly_performance_fact
BASE TABLE vmware_host_daily_metrics_fact
VIEW vmware_host_dimension
BASE TABLE vmware_host_hourly_metrics_fact
BASE TABLE volume_daily_performance_fact
VIEW volume_dimension
BASE TABLE volume_hourly_performance_fact
show full tables from #$account.parameters.TENANT_ID#_dwh_ports
Table_type Tables
VIEW cardinals
BASE TABLE connected_device_dimension
VIEW date_dimension
VIEW port_dimension
BASE TABLE ports_fact
VIEW ports_fact_current
VIEW switch_dimension
Comments
Post a Comment