Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector beyond simple SELECT operations with Amazon S3.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Amazon S3, along with an indication of whether the procedure succeeded or failed.
CData Power BI Connector for Amazon S3 Stored Procedures
| Name | Description |
| CopyObject | Copies an object from a source bucket to a destination bucket, preserving data and metadata unless otherwise specified. |
| DeleteObject | Removes an object from a specified bucket, permanently deleting its data and associated metadata. |
| DownloadObjects | Downloads objects from a specified bucket to a local environment or external application. |
| GeneratePresignedURL | Creates a presigned URL granting temporary, secure access to an object without requiring AWS credentials. |
| GetOAuthAccessToken | Retrieves an OAuth access token for authenticating API requests to Amazon S3. |
| GetOAuthAuthorizationURL | Generates an authorization URL for user consent, required when integrating S3 access into web applications via OAuth. |
| MoveObject | Transfers an object from one bucket to another by combining copy and delete operations. |
| PutBucketAcl | Applies or updates an ACL on a bucket, setting permissions for specific users, groups, or the public. |
| PutObjectAcl | Applies or updates an ACL on an object, customizing access rights at the object level. |
| RefreshOAuthAccessToken | Refreshes an expired or soon-to-expire OAuth access token to maintain API authentication. |
| UploadObject | Uploads a new object to a bucket in a single operation, including optional metadata and storage class settings. |