read directly from remote paths with zarr streaming fallback

[valentin-pinkau]

Detailed Description

• when opening remote datasets, we can read directly from the remote paths and use zarr streaming as a fallback.
• this is a performance optimization to prevent zarr streaming when not necessary.