Run the below query to get the column count of all tables in Redshift database.
select table_schema, table_name, count(*) from information_schema.columns
where table_schema not in ('information_schema', 'pg_catalog')
group by table_schema, table_name
order by table_schema, table_name;