Tough question and God did it a number of times, In Genesis 6 – He repented of making man….

Look carefully at that word “Repent” and interestingly same word David used in Psalms 23

Note it’s the same word David called comfort… BreAk it down to its building block in Hebrew letters – Nun = Faith + Chet = Living + Mem = Water and you get – Faith in Living Water- God was comforted in both Gen 6 and Exodus 32 when He put His faith in THE LIVING WATER – COMPLETE COMFORT