/*Dsiplay the size of each schema in Redshift*/
SELECT
schemaname,
SUM(megabytes) as total_mb
FROM
admin.v_space_used_per_tbl
GROUP BY
schemaname;
/*Dsiplay the size of each schema in Redshift*/
SELECT
schemaname,
SUM(megabytes) as total_mb
FROM
admin.v_space_used_per_tbl
GROUP BY
schemaname;