Another interpretation: "And I appeared to Abraham" and so forth, "but by My name the LORD I did not make Myself known to them" (Exodus 6:3). I did not explain to them whether it is the Explicit Name, but to you I have disclosed it, since you are going to redeem Israel, so that you may succeed. The Holy One, blessed be He, said: In this world I disclosed My name to individuals, but in the world to come I will make My name known to all Israel, as it is said, "Therefore My people shall know My name" (Isaiah 52:6).
The Hidden Name Revealed to Moses Alone
Yalkut Shimoni on Torah 176:8
דָּבָר אַחֵר, וָאֵרָא אֶל אַבְרָהָם וְגוֹ' וּשְׁמִי ה' לֹא נוֹדַעְתִּי לָהֶם. לֹא פֵּרַשְׁתִּי לָהֶם אִם מְפֹרָשׁ הוּא, וּלְךָ גִּלִּיתִי אוֹתוֹ, שֶׁאַתָּה הוֹלֵךְ לִגְאֹל אֶת יִשְׂרָאֵל, כְּדֵי שֶׁתַּצְלִיחַ. אָמַר הַקָּדוֹשׁ בָּרוּךְ הוּא, בָּעוֹלָם הַזֶּה לִיחִידִים גִּלִּיתִי שְׁמִי, אֲבָל לָעוֹלָם הַבָּא, לְכָל יִשְׂרָאֵל אֲנִי מוֹדִיעַ שְׁמִי, שֶׁנֶּאֱמַר (ישעיה נב, ו) "לָכֵן יֵדַע עַמִּי שְׁמִי".