It's called Virtual Files on macos. In general it's a very useful feature because it keeps files local while they are being accessed which makes them super snappy to work with, and then offloads them automatically when disk space is low.

It does mean you need a separate backup process though.