How To Filter Data Using S3 Select (2 Min) | AWS | Use SQL To Filter Contents Of S3 Object
In this tutorial, you'll learn how to filter and retrieve contents of an S3 Object using Amazon AWS S3 Select.
—
Facebook: / gokcedbsql
—
Video Transcript:
—
Hi guys, this is Abhi from Gokcedb. In this video, you're going to learn how to filter and retrieve data using Amazon S3 select. Let's start by navigating to the S3 service and then click on buckets.
Here, I'm going to go inside my test bucket and select the property.csv file. Click on the Actions drop-down and choose query with S3 select. Let's look at the property.csv file.
The first row is the header and I have six columns. Property number, APN size in acres, County, State, and Subdivision. For input settings, I'm going to select CSV for the format, comma for CSV delimiter, and check the exclude first line of CSV data because it contains a header row.
I'm going to leave the output settings to default then run the template query with selects star from the S3 object and limiting the output to 5 rows. As you can see the first five rows from the CSV file were returned. You can also add a where Clause to your select query.
Here, I'm restricting the results set to where the property underscore state is NY and further limiting the results to only five rows. In the next query, I'm using the and operator in the where clause and restricting the output to where the property underscore state is NY and the size in acres is greater than 3. In the next query, I'm using the like operator to return all the property states which start with the letter n.
You can also use the count function to just return the number of rows as well. There you have it. Make sure you like, subscribe, and turn on the notification bell.
Until next time.
e.g.
SELECT * FROM s3object WHERE property_state = 'NY' LIMIT 5
Смотрите видео How To Filter Data Using S3 Select (2 Min) | AWS | Use SQL To Filter Contents Of S3 Object онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Gokce DB 16 Январь 2023. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 673 раз и оно понравилось 3 посетителям.
