AWS bytes

How to determine the distribution style of a table in Redshift database

You can query the SVV_TABLE_INFO view to determine the distribution style of a table. select “database”, “schema”, “table”, “diststyle” from

Use the Top function to query only the top 10 rows. Syntax is as below: Select top 10 * from

Run the below command to deactivate the MFA device defined for an IAM user where username is the name of

Use the below command to view all the information of an IAM role where ROLENAME is the name of the

Run the below command to view all the roles defined in an AWS account. aws iam list-roles

Below is the command to delete an IAM user using AWS command line where username is the name of the

Below is the command to delete an inline policy from an IAM user where username is the name of the

Use the below command to detach an attached policy from an IAM user where username is the name of the

To remove an IAM user from an IAM group, use the below command where username is the name of the

Use the below command to rename an IAM user from AWS CLI where oldusername is the current user name and