How viable is Solar in Canada given its weather? (I am ignorant about it and only know that it's really cold and cloudy most of the time).
Cold is fine - solar panels perform better the lower the temperature.
That's what makes Calgary ideal for solar.
A city like Calgary gets 233 days of sunny days a year. All across the prairies there is plenty of days filled with sun. British Columbia would probably not be great (like Seattle) but they could probably generate wind and hydro.
Alberta is one of the best locales for solar on the continent -- it's sunny most of the year -- and had an exploding renewables sector.
Until the far right O&G lobbyist provincial government kneecapped the sector.