COS Select allows you to filter out desired data at the storage level, significantly reducing the amount of data transferred by COS, thereby lowering your usage costs, and improving data acquisition efficiency. In the COS console, you can extract data from individual files stored in buckets using the standard SQL templates we provide or by specifying statements that comply with syntax rules.
- COS Select currently supports objects in JSON or CSV format only in public cloud regions (Chinese mainland), and objects in Parquet format only in Beijing region.
- Please make sure the file to be extracted complies with COS Select specifications. For more information on COS Select specifications, please see SELECT Overview.
- COS Select in the console supports extraction of up to 40 MB data from a maximum of 128 MB files. To process larger files or extract more data, please use the API or SDKs.
Log in to the COS console.
Click Bucket List on the left sidebar.
Locate the bucket where the object resides and click the bucket name.
Click File List on the left sidebar.
Find the target object and click More > Extract on the right.
Currently, only objects in the STANDARD, STANDARD_IA, and INTELLIGENT TIERING storage classes can be extracted.
Configure the fields File Type, Header Field, Separator, Compression Format, and Export Format.
Click Select SQL Template.
In the pop-up window, select the template statement you want to use for extraction and click OK.
Edit the statement in the text box based on your actual file and then click Run SQL.
Now you can see the first 100 results in the text box at the bottom. To obtain the complete set of data, click Export Extraction Results.