How do we balance our partner team’s integrations goals with the goals/priorities that product and engineering have?

Work back from what customers need, and treat integrations as product features like all others. Partner with Product and Engineering to prioritize them (P0, P1, P2 etc) and put them on the roadmap. At MotherDuck, we have such a high need for ecosystem and integrations that we staff a full-time Ecosystem Engineering team.