Upload file to shared drive folder (overwrite if exists)

Uploads a local file to a folder in a shared drive (or to My Drive if DriveId is left blank). Supply the source file path (DiskFilePath), target file name, and parent folder ID. You can choose to overwrite existing files or fail if the file exists.

SELECT *
FROM upload_file_overwrite
WITH(
	DriveId='',
	DiskFilePath='C:\temp\dump.csv',
	FileName='dump.csv',
	ParentFolderId='root'
	--, FileOverwriteMode='AlwaysOverwrite'
	--, FileOverwriteMode='FailIfExists'
)