Read file content as Base64
Reads file content as a Base64 string. Also demonstrates saving Base64 to disk to recreate the file.
SELECT Data as BYTES_AS_BASE64_STRING, BASE64_TO_FILE('C:\My files\Employees\List.xls', Data) FILE_SAVED_TO_DISK_FROM_BASE64
FROM download_file
WITH (
-- Drive (SharePoint Document Library)
DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXXXX'
, FileId='root:/folder/test_out.csv:'
--,FileId='01SUOJPKHXMPKD2UXXXXXXXXXXXXXXXXXX' --by ID (preferred)
)
--DriveId can be retrieved by selecting from 'Drives' table.
--FileId can be retrieved by selecting from 'list_files' endpoint.