Use the below query to determine the size of all schemas in Redshift database.
SELECT schema, SUM(size) as "size in MB" FROM SVV_TABLE_INFO GROUP BY schema order by 2 desc;
Use the below query to determine the size of all schemas in Redshift database.
SELECT schema, SUM(size) as "size in MB" FROM SVV_TABLE_INFO GROUP BY schema order by 2 desc;