Overview

COS S3 Select feature enables applications to retrieve only a subset of data from an object by using simple Structured Query Language (SQL) like expressions. COS S3 Select feature lets users run SQL-like queries on objects stored in IBM COS and filter the contents of the objects on the server-side, thus reducing the amount of data retrieved by the applications, in turn reducing the cost to the customers.

COS S3 Select feature can only be used on objects with structured data. The Select feature works on objects which are stored in CSV, JSON, and Apache Parquet formats. Select feature also works on objects which are compressed in either GZIP or BZIP2 formats.