1#@!#!123s

22527 1#@!#!123s

: / usr / local / aws-cli / v2 / 2.22.17 / dist / awscli / examples / s3api /

Filename : select-object-content.rst

back

**To filter the contents of an Amazon S3 object based on an SQL statement**

The following ``select-object-content`` example filters the object ``my-data-file.csv`` with the specified SQL statement and sends output to a file. ::

    aws s3api select-object-content \
        --bucket my-bucket \
        --key my-data-file.csv \
        --expression "select * from s3object limit 100" \
        --expression-type 'SQL' \
        --input-serialization '{"CSV": {}, "CompressionType": "NONE"}' \
        --output-serialization '{"CSV": {}}' "output.csv"

This command produces no output.