UploadObject
Uploads objects in a single operation. Use the SimpleUploadLimit connection property to adjust the threshold in bytes in order to perform a multipart upload.
Execute
The Driver Uses #TEMP tables as fields for aggregate information entered
You must include in your query:
INSERT INTO ObjectInformationAggregate#TEMP (LocalFilePath) VALUES ('C:/amazons3/test/testfile.txt')
If specifying a list of files, you can additionally set the value of ContentType:
INSERT INTO ObjectInformationAggregate#TEMP (LocalFilePath, ContentType) VALUES ('C:/amazons3/test/testfile.txt', 'text/plain')
Then you execute the procedure by specifying the value of ObjectInformationAggregate with the name of #TEMP table used ObjectInformationAggregate#TEMP.
EXEC UploadObject ObjectInformationAggregate = 'ObjectInformationAggregate#TEMP'
Note: When setting the GetSignedUrl input to true, you need to authenticate with a service account which has the storage.objects.get IAM role.
Input
Name | Type | Required | Description |
Bucket | String | True | Bucket name where the object will be uploaded. |
ObjectName | String | False | The name of the uploaded object. It should be specified only when uploading the content as InputStream. |
FolderPath | String | False | The path to the folder that will receive the data of the object. |
LocalFilePath | String | False | The path to the file that will be uploaded in the bucket. If this is a path to a folder, then all the files in the folder will be uploaded in the bucket. |
ContentType | String | False | Content-Type of the object data. |
ObjectInformationAggregate | String | False | An aggregate representing the object information. Can be in the form of XML, JSON or a #TEMP table. |
GetSignedUrl | Boolean | False | Whether to return a signedURL. Only available when OAuthJWTCert is set.
デフォルト値はfalseです。 |
ExpiresIn | String | False | The expiration time for the SignedURL it should be in the format: 1d2h3m4s, the maximum value is 7d0h0m0s |
Result Set Columns
Name | Type | Description |
Object | String | Object name for the object that is uploaded. |
Success | String | Indicator if the stored procedure was successful or not. |
SignedURL | String | Returns a signedUrl which can be used to download the resource. |