Data Extraction

Last updated: 2020-03-17 17:29:13

    Overview

    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 COS Console, you can extract the content of individual files stored in buckets using standard SQL templates we provide or by entering statements that meet syntax rules.

    • COS Select currently only supports objects in json and csv file formats, and public cloud regions in mainland China.
    • Please make sure the file to be extracted complies with the specification of COS Select. For more information on the specification of COS Select, see SELECT Overview.
    • COS Select in the console supports data extraction of up to 40M for 128MB files. If you need to process larger files or extract more data, please use API or SDK.

    Steps

    1. Log into the COS Console.
    2. In the left sidebar, click Bucket List.
    3. Click the bucket name to enter the bucket where the object is stored.
    4. In the "File List" module of the bucket, locate the object to be extracted and click Extract in the right-side "Operation" column.
    5. Enter the extract object content page in the console, select the type, header field, separator, and compression format of the file to be extracted.
    6. Click Select an SQL Template, select the desired template statement, and click OK.
    7. Edit the statement in the text box based on the actual file and click Run SQL.
    8. After the process is finished, you can view the first 100 results in the text box at the bottom. To obtain complete data, click Export.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help