Row Groups
You can use row_groups.sql script or as an alternative a stored procedure cstore_GetRowGroups for getting detailed information on the Columnstore Row Groups.
@indexType char(2) = NULL Allows to filter Columnstore Indexes by their type, with possible values (CC for 'Clustered', NC for 'Nonclustered' or NULL for both)
@compressionType varchar(15) = NULL Allows to filter by the compression type with following values 'ARCHIVE', 'COLUMNSTORE' or NULL for both.
@minTotalRows bigint = 000000 Minimum number of rows for a table to be included into the results. The default value is 0 rows.
@minSizeInGB Decimal(16,3) = 0.00 Minimum size in GB for a table to be included. The default value is 0.00 GB :).
@tableNamePattern nvarchar(256) = NULL Allows to show data filtered down to the specified table name pattern.
@schemaName nvarchar(256) = NULL Allows to show data filtered down to the specified schema.