This section describes how the component models the IBM Cloud Object Storage API as relational Views and Stored Procedures.
- The component models IBM Cloud Object Storage buckets, bucket information, and objects as relational views, allowing you to write SQL to query IBM Cloud Object Storage data.
- Stored procedures allow you to execute operations to IBM Cloud Object Storage, including downloading and uploading objects.
- Live connectivity to these objects means any changes to your IBM Cloud Object Storage account are immediately reflected when using the component.
Pre-defined Views are available for read only access to data from IBM Cloud Object Storage, including Buckets, Services, and Objects.
Stored procedures allow you to execute operations to IBM Cloud Object Storage, including downloading and uploading objects.
System Tables contains information about the objects and resources belonging to your database.
Collaborative Query Processing
The component offloads as much of the SELECT statement processing as possible to IBM Cloud Object Storage and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.
See SupportEnhancedSQL for more information on how the component circumvents API limitations with in-memory client-side processing.