How to run SQL query on a S3 file in AWS

Post author:Abhishek Singh
Post published:June 8, 2024
Post category:AWS

In this blog, we’ll guide you to run SQL query on a S3 file in AWS simplifies data analysis by eliminating the need for database management.

Table of Contents

Steps to follow in order to run SQL query on a S3 file

First of all you have to create a bucket and upload a file in it. We have discussed this step in the previous blog. Next you have to select the file where you want to query and click on Actions and select the option as “Query with S3 Select“.

Now you have to leave everything as default and scroll to the last section.

On the SQL Query section you can write your query and click on “Run SQL query”.

SELECT * from s3object s LIMIT 5

Conclusion

In conclusion, running queries on an S3 file in AWS using “Query with S3 Select” simplifies data analysis by eliminating the need for database management. This approach enhances efficiency, reduces costs, and provides seamless access to valuable insights stored in your S3 buckets.

If you like this blog, you can share it with your friends or colleague. You can connect with me on social media profiles like LinkedIn, Twitter, and Instagram.

If you like the article and would like to support me, make sure to: