SNOW-995960: file upload status and transfer

[sfc-gh-lleszewski]

Description

Users want to monitor both the file transfer status and the transfer speed. Currently, when a user uploads files, there's no visibility into the process, requiring them to access Snowflake directly to check how many files have been uploaded and their current status. Additional options such as '--verbose' or '-debug' don't provide any further information for the Snowflake stage during the file upload

Context

This feature is crucial for monitoring transfer status. Its absence necessitates users to directly access Snowflake to track the number of transferred files and also force the use of third-party tools to monitor transfer speed.

[sfc-gh-vtimofeenko]

To add to this: uploading a single large file just shows empty screen until the file is complete, so the user does not know if anything useful is happening. As part of "transfer status" snow should emit something like "Starting upload of $filename" to stdout