Skip to content

AWS bytes

  • Cheat Sheets
  • Concepts
    • Show All
    • S3 Concepts
  • How-To Guides
    • Show all
    • EC2
    • EBS
    • S3
    • Redshift
    • IAM
    • SQS
    • CloudWatch
    • Billing
  • CLI Guides
  • Contact Us
  • Tutorials
  • Interview Questions
  • Postgresql
How-To Guides / Redshift

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

Continue reading
How-To Guides / Redshift

How to query only the top 10 rows in Redshift

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

Continue reading
How-To Guides / IAM

How to deactivate the MFA device of an IAM user

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

Continue reading
How-To Guides / IAM

How to get information about an IAM role

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

Continue reading
How-To Guides / IAM

How to list all roles in your AWS account

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

Continue reading
How-To Guides / IAM

How to delete an IAM user

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

Continue reading
How-To Guides / IAM

How to delete an inline policy of an IAM user

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

Continue reading
How-To Guides / IAM

How to detach a policy from an IAM user

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

Continue reading
How-To Guides / IAM

How to remove an IAM user from a group

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

Continue reading
How-To Guides / IAM

How to rename an IAM user

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

Continue reading

Posts pagination

«Previous Posts 1 … 16 17 18 19 20 … 33 Next Posts»
  • PostgreSQL Tutorials
  • Redshift Tutorials
WordPress Theme: Maxwell by ThemeZee.