HEX
Server: LiteSpeed
System: Linux s1049.use1.mysecurecloudhost.com 4.18.0-477.27.2.lve.el8.x86_64 #1 SMP Wed Oct 11 12:32:56 UTC 2023 x86_64
User: xedaptot (3356)
PHP: 8.3.31
Disabled: NONE
Upload Files
File: //usr/lib/python3.6/site-packages/awscli/examples/s3api/select-object-content.rst
**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.