Download a folder as ZIP

Downloads a folder and all its contents as a single ZIP file to disk. Specify the folder path or ID in SourcePath and the local path for the ZIP in ResponseDataFile.

SELECT *
FROM download_folder
WITH (SourcePath='/folder-I-want-to-download'
     ,ResponseDataFile='C:\path\I\want\to\save\my\folder\to.zip')