Power BI Connector for IBM Cloud Object Storage

Build 20.0.7654

Objects

Returns information for objects inside a specific bucket.

Table Specific Information

Select

The {i 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 {i.

  • 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654