How-To Guides – Page 18

How to search for files in S3 bucket folder using wildcard

aws s3 ls s3://bucketname/prefix1/prefix2/ | grep searchterm* | awk ‘{print $4}’

Command to Add or Modify a Sort key: ALTER TABLE schema.table_name ALTER SORTKEY (column_name); Command to Add or Modify a

Use the below command to delete folder named ‘prefix’ and all it’s contents from an S3 bucket aws s3 rm

Use the below command to delete all the contents of an S3 bucket folder and not the folder itself. aws

AWS does not support renaming an S3 bucket. If you’ve created a bucket with the incorrect name and would like

Copy file from one bucket to another within the same region where bucketname1 is the source bucket and bucketname2 is

Use the below command to identify the region of an S3 bucket where bucketname is the name of the bucket.

Download all the contents of an S3 bucket to your local current directory using below commands: aws s3 sync s3://bucketname

Identify the session that you would like to terminate from the below view and copy the process id. SELECT *

aws s3 ls s3://bucketName/ –recursive –summarize | grep “Total Size:” aws s3 ls s3://bucketName/prefix/ –recursive –summarize | grep “Total Size:”