EncodeFilename
Determines if the local file path in DownloadObjects Stored Procedure should be encoded.
Data Type
bool
Default Value
true
Remarks
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\amazons3test'
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.