Thank you for the info.

Sparse checkouts from remote repo directly or do I need to clone it in whole locally and only then can do a sparse checkouts into some work directory?

I'm 99% sure it's "clone the whole locally and then sparse checkout from there".