UploadFile
Uploads a file from a local system to Azure Data Lake Storage by providing the target path and the local file path.
Stored Procedure Specific Information
The behavior of this stored procedure depends on the nature of the FilePath parameter and is influenced by the MaxThreads connection property, which defines the maximum number of threads to use during the upload process:
- If FilePath points to a single file, the driver uploads it in parallel chunks. The size of each chunk is determined by the ChunkSize connection property, and the upload is distributed across multiple threads based on the value of MaxThreads.
- If FilePath points to a directory, the driver uploads each file in the directory in parallel, using one thread per file. In this mode, multipart chunking is not applied to individual files.
Examples:
- Uploading a single file in parallel using multiple threads and chunking:
EXECUTE UploadFile FilePath = 'C:/Users/User/Desktop/SampleUploadtest.txt' - Uploading all files in a directory in parallel, one thread per file (no chunking):
EXECUTE UploadFile FilePath = 'C:/Users/User/Desktop/'
Input
| Name | Type | Description |
| Path | String | Mandatory. The full path in Azure Data Lake Storage where the file is uploaded. |
| FilePath | String | The local path of the file to upload. This parameter takes priority when both FilePath and file content inputs are provided. |
| FileContent | String | The Base64-encoded content of the file to upload when not using FilePath or Content. |
Result Set Columns
| Name | Type | Description |
| Success | Boolean | Indicates whether the file upload operation completes successfully. |