JDBC Driver for IBM Cloud Object Storage

Build 22.0.8462

Objects

Returns information for objects inside a specific bucket.

Table Specific Information

Select

The driver will use the IBM Cloud Object Storage API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.

  • Bucket supports the '=, IN' comparisons.
  • Key supports the '=, LIKE' comparisons.

For example, the following queries are processed server side:

SELECT * FROM Objects WHERE Bucket = 'testBucket' 

SELECT * FROM Objects WHERE Bucket IN ('testBucket', 'testBucket2') 

SELECT * FROM Objects WHERE Key LIKE 'ad%'

Columns

Name Type Description
Key [KEY] String Name of the object.
Size String Size of the object.
Etag String Etag of the object.
StorageClass String Storage class of the object.
LastModified Datetime Date the object was last modified.
Bucket [KEY] String Bucket in which the object is located.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462