Тегилим 27:4 Мидраш: Midrash Tehillim & Aggadat Bereshit

Another thing from you, God. Solomon said (Proverbs 25:25) "Cool water to a weary soul". David was tired and his soul yearned to be in the Temple, as it says (Psalms 26:8) "I love the house where you dwell" and (Psalms 84:3) "My soul longed, and even pined for the courts of God". (Psalms 27:4) "One thing I ask from the Lord, this only do I seek: that I may dwell in the house of the Lord all the days of my life". God said to him, "You don't know who will ascend the mountain of the Lord." He should keep his hands clean and his heart pure. One who possesses these two qualities should immediately be happy and say "I have them". As it says (1 Samuel 13:14) "The Lord has sought out a man after his own heart". Therefore it is said, "Cool water to a weary soul." And it says (Psalms 119:106) "I have sworn and confirmed that I will keep your righteous laws." He receives two rewards: the reward for action and the reward for oath. Therefore it is said of you, "I have trusted." Rabbi Yitzhak said, "In your Torah there are twenty-two letters."

One time I asked God for something. Rabbi Abba bar Kahana said to ask for sovereignty. You found David asked for only one thing, while Solomon asked for two, as it says (Proverbs 30:7-8), "Two things I ask of You; do not deny them to me before I die. Remove falsehood and lies far from me; do not give me poverty or riches; provide me with food in my allotted portion." (Proverbs 30:9) "Lest, being sated, I renounce and deny You and say, 'Who is the Lord?' Or, being impoverished, I take to theft and profane the name of my God." He asked him which was the harder of the two, and he said the latter. Why did God give up on idolatry, sexual immorality, and murder, but not on desecration of His name, as it says (Ezekiel 36:39), "As for those who follow their abhorrent practices, they will suffer the consequences. I will place their conduct on their own heads, declares the Lord God," and "But you, House of Israel, shall no longer profane My holy name with your gifts and your abhorrent things."...

Another thing I asked. God replied, "At first you said, 'I asked one thing, to dwell in the house of God.' But then you said, 'To behold the beauty of God and to visit His sanctuary.' I say before you, Master of the Universe, that the servant should not be equal to his master. At first, you did not ask much of me, as it says, 'And now, Israel, what does the Lord your God ask of you, but to fear the Lord your God.' But then, you asked for many commandments, as it says, 'To walk in all His ways and to love Him.' Be content with being a servant, so that you may be like your master."...