Determines if the local file path in DownloadObjects Stored Procedure should be encoded.
Determines if the local file path in DownloadObjects Stored Procedure should be encoded. Ex.
In the following query:
EXECUTE DownloadObjects Object='SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv', Bucket='actiantest', LocalFolderPath='C:\Users\User\Desktop\test'The final destination of the file will be C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table%2F20201106023735184_0.csv if EncodeFilename=true and C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv if EncodeFilename=false. In addition you can use CreateFoldersOnDownload connection property if and only if EncodeFilename=false. If CreateFoldersOnDownload is set to true it will automatically create the folder in which the file is going to be downloaded.