AWS Data Engineering- Module Lab 2 - Accessing and Analyzing Data by Using Amazon S3 - Anand K

Accessing and Analyzing Data by Using Amazon S3 Lab overview and objectives In this lab, you will learn how to upload, encrypt, compress, and secure data as a .csv file in Amazon Simple Storage Service (Amazon S3). Then, by using the S3 Select feature, you will use SQL statements to query data in Amazon S3 without needing to set up a database. After completing this lab, you should be able to do the following: Create an AWS CloudFormation template and deploy it as a stack to create an S3 bucket. Load data into an S3 bucket. Use S3 Select to query a .csv file that is stored in an S3 bucket. Modify the encryption properties and storage type for an S3 object. Upload a compressed version of a dataset to Amazon S3. Review an AWS Identity and Access Management (IAM) policy that is used by team members to access the data. Test a team member's restricted access to the data by using the AWS Command Line Interface (AWS CLI).