iirc congress has to approve, too. and by extension that would also include the president's signature on the bill that authorizes a multi-state compact.
https://en.wikipedia.org/wiki/Article_One_of_the_United_States_Constitution#Clause_3:_Compact_Clause