In this case, you are just writing a file to the working directory of the driver process. It'll be under something like /home/[user] on the local file system. Anything you write to "/dbfs/..." however goes to distributed storage, even though it looks like a regular file. That would go into your 'root bucket' unless you write to a DBFS path under which another bucket has been mounted.
