Solved: How to change the IAM role in Redshift cluster

In our last post we checked How to create a Redshift Cluster?

In this post we will see how to change the IAM role assigned to Redshift cluster.(Check earlier post to know how to create an IAM role.)

Udemy

Continue reading “Solved: How to change the IAM role in Redshift cluster”

Solved: How to reset the Master User Password of Redshift Cluster

In our last post we checked How to create a Redshift Cluster?

At times you may want to reset the password of the master user in DB of Redshift.

In this post we will see how to reset the password of  master user in Redshift cluster.

Udemy

Continue reading “Solved: How to reset the Master User Password of Redshift Cluster”

AWS Crash Course – Redshift

Redshift is a data warehouse from Amazon. It’s like a virtual place where you store a huge amount of data.

  • Redshift is fully managed petabyte-scale system
  • Amazon Redshift is based on PostgreSQL 8.0.2
  • It is optimized for data warehousing
  • Supports integrations and connections with various applications, including, Business Intelligence tools
  • Redshift provides custom JDBC and ODBC drivers.
  • Redshift can be integrated with CloudTrail for auditing purpose.
  • You can monitor Redshift performance from CloudWatch.

Features of Amazon Redshift

Udemy

Continue reading “AWS Crash Course – Redshift”

How to load data in Amazon Redshift Cluster and query it?

In the last post we checked How to build a Redshift Cluster? . In this post we will see how to load data in that cluster and query it.

Pre-requisite :-

Download SQL Workbench

Download Redshift Driver

Udemy

Once you have downloaded the above mentioned pre-requisites let’s move ahead.

Continue reading “How to load data in Amazon Redshift Cluster and query it?”

How to create a multi node redshift cluster?

In this tutorial we will see how to create a multi node Amazon Redshift  cluster. If you are new to Redshift refer to our AWS Crash Course – Redshift .

Pre-requisites :-

You will have to create an IAM role and Security Group for Redshift.

Refer How to create a Security Group and How to create an IAM role .

Udemy

Once you have created the role and security group follow below steps:-

Continue reading “How to create a multi node redshift cluster?”

AWS VS AZURE VS OPENSTACK

Most of the services provided by different cloud providers are same as what you do in on-premises setup, they just have a different name in cloud. Below is comparison of major services offered by different cloud providers and what they mean in simple laymen terms. Hope this is helpful to you.

Continue reading “AWS VS AZURE VS OPENSTACK”

Udemy