[🇬🇧] How big a threat to Humza Yousaf is a no-confidence vote?

[Old School]

Source: https://news.google.com/articles/CBMiLmh0dHBzOi8vd3d3LmJiYy5jb20vbmV3cy9hcnRpY2xlcy9jM2c4ZHduMDFnbm_SATJodHRwczovL3d3dy5iYmMuY29tL25ld3MvYXJ0aWNsZXMvYzNnOGR3bjAxZ25vLmFtcA?hl=en-US&gl=US&ceid=US%3Aen

Scotland's first minister, Humza Yousaf, is facing a no-confidence vote after the collapse of his party's agreement with the Scottish Greens.
Mr Yousaf hopes to continue in power, leading a minority government at Holyrood, after deciding that the partnership with the Greens has "served its purpose".
But Scottish Conservative leader Douglas Ross has described him as a "lame duck" first minister and says he will lodge a no-confidence motion.
So what happens next - and how big a threat is this for Mr Yousaf?