Epic of Erra and Marduk's Temporary Absence

Nebuchadnezzar II, king of the Neo-Babylonian empire, most powerful man in the world, was brought low by divine madness. Who was this king who lived in the shadow of Etemenanki, whose visions were revealed by a prophet, and whose apex in pop culture is as a wealthy zucchini?