Object Storage Service (OSS) Select allows you to use simple SQL statements to select content from objects in OSS to obtain only required data. OSS Select helps you reduce the amount of data transmitted from OSS to improve the data retrieval efficiency and save time.

Note You can send requests to transmit SQL expressions to OSS. For more information about the SQL statements supported by OSS Select and the usage limits, see SelectObject.

Implementation methods

Usage notes

  • Object format: OSS Select supports CSV and JSON objects that are UTF-8 encoded and conform to RFC 4180. The CSV objects are CSV-like objects such as TSV objects. In the CSV objects, row and column delimiters and quote characters can be customized.
  • Encryption method: OSS Select supports objects encrypted by using server-side encryption fully managed by OSS (SSE-OSS) or server-side encryption that uses customer master keys (CMKs) managed by Key Management Service (KMS) for encryption (SSE-KMS).