ODBC Driver for Google Cloud Storage

Build 20.0.7746

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')

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'

Input

Name Type Required Description
Bucket String True Bucket name where the object will be uploaded.
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.
ObjectInformationAggregate String False An aggregate representing the object information. Can be in the form of XML, JSON or a #TEMP table.

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7746