Amazon Redshift is one of the many database solutions offered by Amazon Web Services which is most suited for business analytical workloads. Here in this blog on what is Amazon Redshift & Spectrum, we will learn what is Amazon Redshift and how it works. Further, we will also learn how to create a Redshift Database Cluster, then connecting to the database using the query editor.
The topics which we will in this tutorial section is given below:
Watch this End to End AWS Tutorial video:
What is Amazon Redshift in AWS?
Amazon Redshift is a data warehouse service which is fully managed by AWS. It is very simple and cost-effective because you can use your standard SQL and Business Intelligence tools to analyze huge amounts of data.
You can run complex queries against terabytes and petabytes of structured data and you will getting the results back is just a matter of seconds. The data is not needed to be converted to a particular file format, redshift accepts all types of data formats mentioned here – Avro, CSV, Grok, Ion, JSON, ORC, Parquet, RCFile, RegexSerDe, SequenceFile, TextFile, and TSV.
Are you interested in learning AWS? Intellipaat provides the best AWS training.
Redshift spectrum is a feature which lets you run queries against exabytes of unstructured data which is stored in Amazon S3. No loading or ETL (Extract, transform, load) is required for the data. First AWS Redshift identifies the data which is local and which is stored in the S3 bucket. After that, it creates a plan to reduce the content on Amazon S3 that needs to be read. Then AWS Redshift Spectrum workers are called to read and process the data from Amazon S3.
Interested in learning AWS? Go through this AWS Tutorial!
Queries can be run quickly regardless of data size because you scale out to thousands of instances if needed. You can use the same SQL queries as you used for Amazon S3 in Redshift. You can also separately scale compute and storage instances.
Benefits of Amazon Redshift
Now that we understand what is Amazon Redshift and what is Amazon Redshift Spectrum, let move on and discuss the benefits that Amazon Redshift provides.The benefits of Amazon Aurora remain the same for both MySQL compatible and PostgreSQL compatible.
- Faster Performance
- Provides 10x times faster performance than the other warehouses
- You can set caching to increase the data retrieval speed.
- Easy to create, deploy, and manage
- You can create and deploy a warehouse in minutes.
- Most of the commons tasks are automated. Tasks that are automated are monitoring and managing your warehouse.
- There are upfront costs or contract periods. It is 10 times cheaper than a traditional data warehouse which is set up on-premises.
- Scalability at it’s best
- This is the same as Redshift Spectrum. You can query any amount of data and AWS redshift will take care of scaling up or down. Also, the compute and storage instances are scaled separately.
- Query your data lake
- Redshift in AWS allows you to query your Amazon S3 data bucket or data lake. You can query petabytes of unstructured data using Redshift on Amazon S3.
- Highly secure
- Redshift in AWS lets you isolate your warehouse using VPC
- You can create Customer Management Keys (CMKs) using AWS Key Management Service to encrypt your data in the warehouse
If you have any doubts or queries related to AWS, do post on AWS Community.
Amazon Redshift Pricing
The prices of any Amazon service will vary according to its geographic region. Let us consider the region as North Virginia to check Reshift pricing.
First, let us look at its free trial.
Now let us see Amazon Redshift’s pricing for compute and storage.
|Instance Type||Price |
|dc2.large||$0.25 per Hour|
|dc2.8xlarge||$4.80 per Hour|
|Instance Type||Price |
|ds2.large||$0.85 per Hour|
|ds2.8xlarge||$6.80 per Hour|
For Backup and Recovery, Redshift pricing is the same as Amazon S3.
Now let us move on to the practical part of this tutorial. We are going to first create a Redshift Cluster. Then we will install and Configure Redshift ODBC driver.
Are you preparing for AWS interview? Then here are latest AWS interview questions
Hands-on Part 1: Creating Amazon Redshift Database & Cluster
Follow the steps given below to create your first Amazon Redshift Database Cluster.
Step 1: Logon to your AWS Management Console
Step 2: Click on Amazon Redshift under the Services dropdown
Step 3: Now click on the Quick Launch Cluster button
Step 4: In this step, Make sure your Redshift instance is dc2.large so that you can start your free trial. Then provide your database name, master username and an unique password. There is no need to change any other details. Now just provide launch cluster after this step.
Step 5: Wait for the Cluster to create and then you have successfully created a Redshift database cluster or Redshift data warehouse.
Get certified from top AWS course in Chicago Now!
Hands-on Part 2: Connecting the Redshift database Cluster using Query editor
Moving on with this what is amazon redshift tutorial, let’s now connect the redshift database cluster using query editor.
Step 6: Click on Query Editor and enter your database name, username, and the password. It will now automatically with the database and then the query editor will open a editor for you to write and execute queries.
Step 7: Now let us create a query and run it. First let us create a table called practice and run the query.
Step 8: Now let us check whether the table exists. Create a new query and click run query. After that download the CSV file or you can just see it in the web page and check whether the table attributes exists.
We have successfully created a Redshift cluster, connected it to the database, and have run queries in it.
Hope this tutorial on what is Amazon Redshift helps. Check out the related posts to learn about more Services offered by AWS.