““How great you are, Sovereign LORD! There is no one like you, and there is no God but you, as we have heard with our own ears.” 2 Samuel 7:22

Via Wikipedia
The Books of Samuel, 1 Samuel and 2 Samuel, form part of the narrative history of Israel in the Nevi'im or "prophets" section of the Hebrew Bible/Old Testament, called the Deuteronomistic history, a series of books (Joshua, Judges, Samuel and Kings) that constitute a theological history of the Israelites and aim to explain God's law for Israel under the guidance of the prophets. According to Jewish tradition, the book was written by Samuel, with additions by the prophets Gad and Nathan.Modern scholarly thinking is that the entire Deuteronomistic history was composed in the period c. 630–540 BC by combining a number of independent texts of various ages.
Samuel begins with the prophet Samuel's birth and God's call to him as a boy. The story of the Ark of the Covenant that follows tells of Israel's oppression by the Philistines, which brought about Samuel's anointing of Saul as Israel's first king. But Saul proved unworthy and God's choice turned to David, who defeated Israel's enemies and brought the Ark to Jerusalem. God then promised David and his successors an everlasting dynasty.
Were the books written by Samuel, Gad and Nathan, with extras made during exile, they would still match Wikipedia's position of having been composed c. 630 - 540 BC by combining independent texts of various ages.

Here, we hear David's praise of thanks for the promise of God to establish his house, forever.

"Then King David went in and sat before the Lord, and he said:
“Who am I, Sovereign Lord, and what is my family, that you have brought me this far? And as if this were not enough in your sight, Sovereign Lord, you have also spoken about the future of the house of your servant—and this decree, Sovereign Lord, is for a mere human!
“What more can David say to you? For you know your servant, Sovereign Lord. For the sake of your word and according to your will, you have done this great thing and made it known to your servant.
“How great you are, Sovereign Lord! There is no one like you, and there is no God but you, as we have heard with our own ears. And who is like your people Israel—the one nation on earth that God went out to redeem as a people for himself, and to make a name for himself, and to perform great and awesome wonders by driving out nations and their gods from before your people, whom you redeemed from Egypt? You have established your people Israel as your very own forever, and you, Lord, have become their God.
“And now, Lord God, keep forever the promise you have made concerning your servant and his house. Do as you promised, so that your name will be great forever. Then people will say, ‘The Lord Almighty is God over Israel!’ And the house of your servant David will be established in your sight.
“Lord Almighty, God of Israel, you have revealed this to your servant, saying, ‘I will build a house for you.’ So your servant has found courage to pray this prayer to you. Sovereign Lord, you are God! Your covenant is trustworthy, and you have promised these good things to your servant. Now be pleased to bless the house of your servant, that it may continue forever in your sight; for you, Sovereign Lord, have spoken, and with your blessing the house of your servant will be blessed forever.”"
AUAWN1016121
https://rumble.com/vnukrx-bible-quote-oct-16th-2-samuel-722.html