Radak on Psalms
The Lord is great in Zion – Then He will be great in Zion because there He will be magnified above all the nations when He executes judgement on the wicked. In the midrash Shachar Tov it says: The Lord is great in Zion, when He returns His Presence to Zion, in that moment He is great.