_ _______ _______ _ ______ ( \ ( ____ \|\ /|( ____ \( \ / ____ \ | ( | ( \/| ) ( || ( \/| ( ( ( \/ | | | (__ | | | || (__ | | | (____ | | | __) ( ( ) )| __) | | | ___ \ | | | ( \ \_/ / | ( | | | ( ) ) | (____/\| (____/\ \ / | (____/\| (____/\ ( (___) ) (_______/(_______/ \_/ (_______/(_______/ \_____/
Progress: |======.....| 6/11
SELECT the right way to solve it :)
S3 Select is designed to pull out only the data you need from an object, which can improve the performance and reduce the cost.
S3 Select filters the content of an Amazon S3 object based on SQL statement. In the request, you must specify a data format (JSON, CSV, or Apache Parquet). Amazon S3 uses this format to parse object data into records and returns only records that match the specified SQL expression. You must also specify the data serialization format for the response.
Hint 1 Find the gzipped CSV (semicolon delimiter) treasure file. Try requesting it with following SQL query: SELECT Answer FROM <THE FILE> WHERE Category = 'TREASURE' Here are the parameters for select-object-content command.Note: Definitely, there are other ways to find a secret code in the file. :) But try using S3 Select instead. It worth studying...