The names of God that appear in the Bible and Talmud are not His names as He truly is.
They are a description, rather, of the divine revelation in a particular manner, in a particular sefirah.
All that we can say about God's "great name" is that it cannot be revealed or known.
Like God Himself, His name transcends all being and comprehension.
Like the infinite Divine light, God's name cannot be apprehended.
All we can perceive is its glory and radiance as they shine upon the heavens and earth.
–Rabbi Adin Steinsaltz
From The Thirteen Petalled Rose by Rabbi Adin Steinsaltz