{"id":3343,"date":"2019-11-15T11:13:33","date_gmt":"2019-11-15T11:13:33","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=3343"},"modified":"2024-03-29T10:33:37","modified_gmt":"2024-03-29T10:33:37","slug":"getting-started-with-amazon-redshift","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/","title":{"rendered":"Getting Started With Amazon Redshift"},"content":{"rendered":"<h1>Getting Started With Amazon Redshift<\/h1>\n<p>&nbsp;<\/p>\n<p>Getting Started With Amazon Redshift, Are you the one who is looking for the <a href=\"https:\/\/www.youtube.com\/channel\/UCwAaWqnH2MqikDMpb1jBspw\">best platform<\/a> which provides information about Getting Started With Amazon Redshift? Or the one who is looking forward to taking the advanced Certification Course from India\u2019s Leading <a href=\"https:\/\/prwatech.in\/aws-training-institute-in-pune\/\">AWS Training institute<\/a>? Then you\u2019ve landed on the Right Path.<\/p>\n<p>The Below mentioned Tutorial will help to Understand the detailed information about Getting Started With Amazon Redshift, so Just Follow All the Tutorials of India\u2019s Leading <a href=\"https:\/\/prwatech.in\/aws-training-institute-in-pune\/\">Best AWS Training institute<\/a> and Be a Pro AWS Developer.<\/p>\n<p><strong>Step 1: Set Up Prerequisites<\/strong><\/p>\n<p>Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites in this section:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/prwatech.in\/blog\/aws\/create-aws-account\/\">Sign Up for AWS\u00a0\u00a0<\/a>\u00a0 \u00a0And<\/strong><\/li>\n<li><strong>Determine Firewall Rules<\/strong><\/li>\n<\/ul>\n<h3><strong>Sign Up for AWS<\/strong><\/h3>\n<p>If you do not already have an AWS account, you must sign up for one. If you already have an account, you can skip this prerequisite and use your existing account.<\/p>\n<p><strong>Check Firewall Rules<\/strong><\/p>\n<p>If your client computer is behind a firewall, you need to configure an open port that you can use. This open port enables you to connect to the cluster from a SQL client tool and run queries during launching the redshift cluster, allow 5439 port in the firewall to access the cluster.<\/p>\n<p>In this step to make a proper connection, you have to add Amazon Redshift Port 5439 which is by default and add it in inbound rule in the security group.<\/p>\n<p><strong>Step 2: Create an IAM Role<\/strong><\/p>\n<p>For any operation that accesses data on another AWS resource, your cluster requires permission to access the resource and the data on the resource on your behalf. The COPY command is used to load data from Amazon S3. You have to provide those permissions by using AWS Identity and Access Management (IAM). You do so either through an IAM role that is attached to your cluster or by providing the AWS access key for an IAM user that has the necessary permissions.<\/p>\n<p>To best protect your sensitive data and to secure your AWS access credentials, we recommend creating an IAM role and attaching it to your cluster.<\/p>\n<p>In this step, you create a new IAM role that enables Amazon Redshift to load data from the path of an object in an Amazon S3 bucket. In the next step, you have to attach the role to your cluster.<\/p>\n<h3><strong>Steps to Create an IAM Role for\u00a0Amazon Redshift<\/strong><\/h3>\n<ol>\n<li>Sign in to the AWS Management Console and open the IAM console at\u00a0https:\/\/console.aws.amazon.com\/iam\/.<\/li>\n<li>In the navigation pane, choose\u00a0<strong>Roles<\/strong>.<\/li>\n<li>Choose to\u00a0<strong>Create role<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3344\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png\" alt=\"\" width=\"850\" height=\"366\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-300x129.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-768x331.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1200x517.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture.png 1303w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>4. In the\u00a0<strong>AWS Service<\/strong>group, select <strong>Redshift<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3345\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/4.png\" alt=\"\" width=\"850\" height=\"465\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/4.png 977w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/4-300x164.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/4-768x420.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>5. Under\u00a0<strong>Select your use case<\/strong>, choose\u00a0<strong>Redshift &#8211; Customizable<\/strong>then click on\u00a0<strong>Next: Permissions<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3346\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/6.png\" alt=\"\" width=\"850\" height=\"191\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/6.png 975w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/6-300x67.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/6-768x173.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>6. On the\u00a0<strong>Attach permissions policies\u00a0<\/strong>page, choose\u00a0<strong>AmazonS3ReadOnlyAccess<\/strong>. You can leave the default setting for\u00a0<strong>Set permissions boundary <\/strong>as it is. Then choose\u00a0<strong>Next: Tags.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3347\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/7.png\" alt=\"\" width=\"850\" height=\"601\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/7.png 783w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/7-300x212.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/7-768x543.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>7. The\u00a0<strong>Add tags\u00a0<\/strong>page appears. You can optionally add tags. Choose\u00a0<strong>Next: Review<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3348\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/8.png\" alt=\"\" width=\"850\" height=\"603\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/8.png 779w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/8-300x213.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/8-768x545.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>8. For\u00a0<strong>Role name<\/strong>, enter a name for your role. For this tutorial, enter\u00a0<strong>myRedshiftRole<\/strong>.<\/p>\n<p>9. Review the information, and then select \u00a0<strong>Create Role<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3349\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/9.png\" alt=\"\" width=\"850\" height=\"607\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/9.png 772w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/9-300x214.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/9-768x548.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>10.Choose the role name of the role you just created.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3350\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/10-1024x268.png\" alt=\"\" width=\"850\" height=\"222\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/10-1024x268.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/10-300x78.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/10-768x201.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/10.png 1101w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>11. Copy the\u00a0<strong>Role ARN<\/strong>and save in secure place\u2014this value is the Amazon Resource Name (ARN) for the role that you just created. You use that value when you use the COPY command to load data from Amazon S3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3351\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/11.png\" alt=\"\" width=\"850\" height=\"423\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/11.png 867w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/11-300x149.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/11-768x382.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>Once you create the new role, your next step is to attach it to your cluster. You can attach the role during launching a new cluster or you can attach it to an existing cluster. In the next step, you attach the role to a new cluster.<\/p>\n<p><strong>Step 3: Create a Sample Amazon Redshift Cluster<\/strong><\/p>\n<p>After completing prerequisites, you can launch your Amazon Redshift cluster.<\/p>\n<p><strong>Important<\/strong><\/p>\n<p>The cluster that you are about to launch is live. You incur the standard Amazon Redshift usage charges for the cluster until you delete it<em>.<\/em>\u00a0If you complete the tutorial described herein one sitting and delete the cluster when you are finished the work, the total charges are minimal.<\/p>\n<p><strong>To launch an Amazon Redshift cluster<\/strong><\/p>\n<ol>\n<li>Sign in to the AWS Management Console and open the Amazon Redshift console at\u00a0https:\/\/console.aws.amazon.com\/redshift\/.<\/li>\n<\/ol>\n<h3><strong>Important<\/strong><\/h3>\n<p>If you use IAM user credentials, ensure that the IAM user has the necessary permissions to perform the cluster operations. In the main menu, select the AWS Region in which you want to create the cluster. For the purposes of this tutorial, select\u00a0<strong>Asia Pacific (Mumbai Region)<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3352\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/re.png\" alt=\"\" width=\"850\" height=\"2137\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/re.png 171w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/re-119x300.png 119w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<ol start=\"2\">\n<li>On the Amazon Redshift Dashboard, click on the\u00a0<strong>Quick launch cluster<\/strong>.<\/li>\n<\/ol>\n<p>The Amazon Redshift Dashboard looks similar to the following screenshot taken.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3353\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1-1024x448.png\" alt=\"\" width=\"850\" height=\"372\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1-1024x448.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1-300x131.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1-768x336.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1-1200x525.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/1.png 1346w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<ol start=\"3\">\n<li>On the Cluster specifications page, enter the following values and then choose\u00a0<strong>Launch cluster<\/strong>:\n<ul>\n<li><strong>Node type<\/strong>: Choose\u00a0<strong>largely<\/strong>.<\/li>\n<li><strong>A number of compute nodes<\/strong>: Keep the default value of\u00a0<strong>1<\/strong>.<\/li>\n<li><strong>Cluster identifier<\/strong>: Enter the value\u00a0<strong>redshift-cluster-1<\/strong>.<\/li>\n<li><strong>Master user name<\/strong>: Keep the default value of\u00a0<strong>awsamol<\/strong>.<\/li>\n<li><strong>Master user password and<\/strong>\u00a0<strong>Confirm password<\/strong>: Enter a password for the master user account.<\/li>\n<li><strong>Database port<\/strong>: Set the default value of\u00a0<strong>5439<\/strong>.<\/li>\n<li><strong>Available IAM roles<\/strong>: Choose\u00a0<strong>myRedshiftRole<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>The quick launch cluster automatically creates a default database named\u00a0<strong>dev<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3354\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/28.png\" alt=\"\" width=\"850\" height=\"412\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/28.png 869w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/28-300x145.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/28-768x372.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3355\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/29.png\" alt=\"\" width=\"850\" height=\"401\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/29.png 864w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/29-300x142.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/29-768x363.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3><strong>Note<\/strong><\/h3>\n<p>Quick launch uses the default virtual private cloud (VPC) for your AWS Region. If a default VPC group doesn&#8217;t exist, the Quick launch returns an error. If you don&#8217;t have a default VPC group, you can use the standard Launch Cluster wizard to use a different VPC. A confirmation page appears and the cluster takes a few minutes to set up. \u00a0Click on the\u00a0<strong>Close <\/strong>button\u00a0to return to the list of clusters.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3356\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/30.png\" alt=\"\" width=\"850\" height=\"437\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/30.png 877w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/30-300x154.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/30-768x395.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<ol start=\"4\">\n<li>On the Clusters page, choose the cluster that you just launched and review the\u00a0<strong>Cluster Status<\/strong> Make sure that the\u00a0<strong>Cluster Status<\/strong>is\u00a0<strong>available<\/strong>\u00a0and the\u00a0<strong>Database Health<\/strong>\u00a0is\u00a0<strong>healthy<\/strong>\u00a0before you try to connect to the database later in this guide.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3357\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32-1024x255.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"212\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32-1024x255.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32-300x75.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32-768x191.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32-1200x299.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/32.png 1336w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>5. The Clusters page, choose the cluster that you just launched, choose the\u00a0<strong>Cluster<\/strong>button, then\u00a0<strong>Modify cluster<\/strong>. Choose the\u00a0<strong>VPC security groups<\/strong>\u00a0to attach with this cluster, then choose\u00a0<strong>Modify<\/strong>\u00a0to make the association. Make sure that the\u00a0<strong>Cluster Properties<\/strong>\u00a0displays the\u00a0<strong>VPC security groups<\/strong>\u00a0you choose before continuing to the next step.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3358\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33-1024x441.png\" alt=\"\" width=\"850\" height=\"366\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33-1024x441.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33-300x129.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33-768x331.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33-1200x517.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/33.png 1338w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Step 4: Authorize Access to the Cluster<\/strong><\/p>\n<h3><strong>Note<\/strong><\/h3>\n<p>A new console is available for Amazon Redshift. Choose either the\u00a0<strong>New <\/strong>or the\u00a0<strong>Original Console<\/strong>\u00a0instructions based guide on the console that you are using.<\/p>\n<p>In the earlier step, you launched your Amazon Redshift cluster. Before you can connect to the cluster, you need to configure a security group to authorize access to the cluster.<\/p>\n<p><strong>To configure the VPC security group (EC2-VPC platform)<\/strong><\/p>\n<ol>\n<li>In the Amazon Redshift dashboard, in the navigation pane, choose\u00a0<strong>Clusters<\/strong>.<\/li>\n<li>Choose\u00a0<strong>redshift-cluster-1<\/strong>to to open it, and make sure that you are on the\u00a0<strong>Configuration<\/strong><\/li>\n<li>Under\u00a0<strong>Cluster Properties<\/strong>, for\u00a0<strong>VPC Security Groups<\/strong>, choose your security group.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3359\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/34.png\" alt=\"\" width=\"850\" height=\"583\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/34.png 747w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/34-300x206.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>4. After your security group opens in the Amazon EC2 console, choose the\u00a0<strong>Inbound<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3360\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/inbound.png\" alt=\"\" width=\"850\" height=\"291\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/inbound.png 553w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/inbound-300x103.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>5. Choose\u00a0<strong>Edit<\/strong>,\u00a0<strong>Add Rule<\/strong>, and set the following, then choose\u00a0<strong>Save<\/strong>:<\/p>\n<ul>\n<li><strong>Select: Redshift<\/strong><\/li>\n<li><strong>Protocol<\/strong>:\u00a0<strong>TCP<\/strong>.<\/li>\n<li><strong>Port Range<\/strong>: Enter the same port number that you used when you launched the cluster. The default port number for Amazon Redshift is\u00a05439, but your port might be different.<\/li>\n<li><strong>Source<\/strong>: Select\u00a0<strong>Custom<\/strong>, then enter\u00a00.0.0.0\/0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3361\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/35.png\" alt=\"\" width=\"850\" height=\"523\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/35.png 862w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/35-300x184.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/35-768x472.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Important<\/strong><\/p>\n<p>Using source to anywhere 0.0.0.0\/0 means is not recommended for anything other than demonstration purposes because it allows access from any computer on the internet. In a real environment, you create inbound rules based on your own network settings.<\/p>\n<p><strong>Step 5: Connect to the Cluster and Run Queries<\/strong><\/p>\n<p>To query databases hosted by your Amazon Redshift cluster, you have two methods:<\/p>\n<ul>\n<li>Connect to your cluster and run queries to databases on the AWS Management Console with the query editor.<\/li>\n<\/ul>\n<p>If you use the query editor, you don&#8217;t have to download and set up an SQL client application.<\/p>\n<ul>\n<li>Connect to your cluster through an SQL client tool, such as SQL Workbench\/J.<\/li>\n<\/ul>\n<p><strong>Topics<\/strong><\/p>\n<ol>\n<li>Querying a Database by Using the Query Editor<\/li>\n<li>Querying a Database by Using a SQL Client<\/li>\n<\/ol>\n<h3><strong>Querying a Database Using the Query Editor<\/strong><\/h3>\n<p>Using the query editor is the easiest way to run queries on databases hosted by your Amazon Redshift cluster. After creating your cluster, you can immediately run queries using the console.<\/p>\n<p>The following cluster node types support the query editor:<\/p>\n<ul>\n<li>8xlarge<\/li>\n<li>large<\/li>\n<li>8xlarge<\/li>\n<li>8xlarge<\/li>\n<\/ul>\n<p>Using the Amazon Redshift console query editor, you can do the following:<\/p>\n<ul>\n<li>Run single SQL statement queries.<\/li>\n<li>Download result sets as large as 100 MB to a comma-separated value (CSV) file.<\/li>\n<li>Save the queries for reuse. You cannot save queries in the EU (Paris) Region or the Asia Pacific (Osaka-Local) Region.<\/li>\n<\/ul>\n<h3><strong>Enabling Access to the Query Editor<\/strong><\/h3>\n<p>To use the query editor, you need permission. To enable access, attach the\u00a0AmazonRedshiftQueryEditor\u00a0and\u00a0<strong>AmazonRedshiftReadOnlyAccess<\/strong><strong>\u00a0<\/strong>policies for AWS Identity and Access Management (IAM) to the IAM user that you use to access your cluster.<\/p>\n<p>If you have already created an IAM user to access the Amazon Redshift cluster, you can attach the\u00a0<strong>AmazonRedshiftQueryEditor<\/strong><strong>\u00a0<\/strong>&amp;\u00a0<strong>AmazonRedshiftReadOnlyAccess<\/strong>\u00a0policies to that user. If you haven&#8217;t created an IAM user yet, create one and attach the policies to the IAM user.<\/p>\n<h3><strong>To attach the required IAM policies for the Query Editor<\/strong><\/h3>\n<ol>\n<li>Sign in to the AWS Management Console and open the IAM console at\u00a0https:\/\/console.aws.amazon.com\/iam\/.<\/li>\n<li>Choose\u00a0<strong>Users<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3363\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/12.png\" alt=\"\" width=\"850\" height=\"538\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/12.png 787w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/12-300x190.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/12-768x486.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>3. Choose the IAM user that needs access to the <strong>Query Editor<\/strong>.<\/p>\n<p>4. Click on Add<strong> permissions<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3365\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/13-1.png\" alt=\"\" width=\"850\" height=\"540\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/13-1.png 778w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/13-1-300x190.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/13-1-768x488.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>5. Click on \u00a0<strong> Attach existing policies directly<\/strong>.<\/p>\n<p>6. For\u00a0<strong>Policy names<\/strong>, choose\u00a0<strong>AmazonRedshiftQueryEditor<\/strong>and\u00a0<strong>AmazonRedshiftReadOnlyAccess<\/strong>.7. Click on \u00a0<strong> Next: Review<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3366\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/14.png\" alt=\"\" width=\"850\" height=\"546\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/14.png 784w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/14-300x193.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/14-768x494.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>8. Click on \u00a0<strong> Add permissions<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3367\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/15.png\" alt=\"\" width=\"850\" height=\"553\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/15.png 786w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/15-300x195.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/15-768x499.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>9. Download the\u00a0<strong>csv<\/strong> file before closing the window contains Access key and Secret access key will use while accessing the resources via programmatic access.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3368\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16-1024x439.png\" alt=\"\" width=\"850\" height=\"364\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16-1024x439.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16-300x128.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16-768x329.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16-1200x514.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/16.png 1275w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3><strong>Using the Query Editor<\/strong><\/h3>\n<p>In the following demo, you use the query editor to perform the following tasks:<\/p>\n<ul>\n<li>To run SQL commands.<\/li>\n<li>View query execution details.<\/li>\n<li>To save a query.<\/li>\n<li>Download a query result set.<\/li>\n<\/ul>\n<h4><strong>To use the query editor:<\/strong><\/h4>\n<ol>\n<li>Sign in to the AWS Management Console &amp; open the Amazon Redshift console at\u00a0<u>https:\/\/console.aws.amazon.com\/redshift\/<\/u>.<\/li>\n<li>In the navigation pane, click on \u00a0 <strong>Query Editor<\/strong>.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3369\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37-1024x365.png\" alt=\"\" width=\"850\" height=\"303\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37-1024x365.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37-300x107.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37-768x274.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37-1200x428.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/37.png 1333w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>3. In the\u00a0<strong>Credentials<\/strong>dialog box, enter the following values and then click on \u00a0 <strong>Connect<\/strong>:<\/p>\n<ul>\n<li><strong>Cluster<\/strong>: Type your cluster name here <strong>redshift-cluster-1<\/strong>.<\/li>\n<li><strong>Database<\/strong>:\u00a0<strong>dev<\/strong>.<\/li>\n<li><strong>Database user<\/strong>:\u00a0<strong>awsamol<\/strong><\/li>\n<li><strong>Password<\/strong>: Enter the password that you specified when you launched the cluster.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3370\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/36-1.png\" alt=\"\" width=\"850\" height=\"650\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/36-1.png 379w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/36-1-300x230.png 300w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/>4. For\u00a0<strong>Schema<\/strong>, click on \u00a0 <strong>information_schema\u00a0<\/strong>to create a new table based on that schema.<\/p>\n<p>5. Enter the following in the Query Editor window &amp; choose\u00a0<strong>Run query\u00a0<\/strong>to create a new table.<\/p>\n<p>6. create table shoes(shoetype varchar (10), color varchar(10));<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3371\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38-1024x368.png\" alt=\"\" width=\"850\" height=\"305\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38-1024x368.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38-300x108.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38-768x276.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38-1200x431.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/38.png 1328w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>7. Choose\u00a0<strong>Clear<\/strong>.<\/p>\n<p>8. Enter the following command in the Query Editor window and choose\u00a0<strong>Run query\u00a0<\/strong>to add rows to the table.<\/p>\n<p>9. insert into shoes values(&#8216;loafers&#8217;, &#8216;brown&#8217;), (&#8216;sandals&#8217;, &#8216;black&#8217;);<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3372\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39-1024x373.png\" alt=\"\" width=\"850\" height=\"310\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39-1024x373.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39-300x109.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39-768x280.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39-1200x437.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/39.png 1310w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>10. Choose\u00a0<strong>Clear<\/strong><\/p>\n<p>11. Enter the following command in the Query Editor window &amp; choose\u00a0<strong>Run query to<\/strong>\u00a0query the new table.<\/p>\n<p>select * from shoes;<\/p>\n<p>You should see the following results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3373\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41-1024x435.png\" alt=\"\" width=\"850\" height=\"361\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41-1024x435.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41-300x127.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41-768x326.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41-1200x510.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/41.png 1337w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Step 6: Load Sample Data from Amazon S3 bucket<\/strong><\/p>\n<p>At this point, you have a database called\u00a0dev\u00a0&amp; you are connected to it. Next, you create some tables in the database dev, upload data to the tables, and try a query. For your convenience, ensure the sample data to load is available in an Amazon<a href=\"https:\/\/prwatech.in\/blog\/aws\/amazon-simple-storage-service-s3\/\"> S3<\/a> bucket.<\/p>\n<h4><strong>Note<\/strong><\/h4>\n<p>If you&#8217;re using a SQL client tool, check that your SQL client is connected to the cluster.<\/p>\n<p><strong>To load sample data into tables from s3 bucket:<\/strong><\/p>\n<ol>\n<li>Create tables.<\/li>\n<\/ol>\n<p>One-by-one copy and run the following create table command to create tables in the\u00a0dev\u00a0database.<\/p>\n<p>create table users(\u00a0\u00a0 userid integer not null distkey sortkey,\u00a0\u00a0 username char(8),\u00a0\u00a0 firstname varchar(30),\u00a0\u00a0 lastname varchar(30),\u00a0\u00a0 city varchar(30),\u00a0\u00a0 state char(2),\u00a0\u00a0 email varchar(100),\u00a0\u00a0 phone char(14),\u00a0\u00a0 likesports boolean,\u00a0\u00a0 liketheatre boolean,\u00a0\u00a0 likeconcerts boolean,\u00a0\u00a0 likejazz boolean,\u00a0\u00a0 likeclassical boolean,\u00a0\u00a0 likeopera boolean,\u00a0\u00a0 likerock boolean,\u00a0\u00a0 likevegas boolean,\u00a0\u00a0 likebroadway boolean,\u00a0\u00a0 likemusicals boolean);<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3374\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42-1024x319.png\" alt=\"\" width=\"850\" height=\"265\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42-1024x319.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42-300x94.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42-768x239.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42-1200x374.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/42.png 1328w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>create table venue(\u00a0\u00a0 venueid smallint not null distkey sortkey,\u00a0\u00a0 venuename varchar(100),\u00a0\u00a0 venuecity varchar(30),\u00a0\u00a0 venuestate char(2),\u00a0\u00a0 venueseats integer);<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3375\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46-1024x418.png\" alt=\"\" width=\"850\" height=\"347\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46-1024x418.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46-300x122.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46-768x314.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46-1200x490.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/46.png 1325w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>create table category(\u00a0\u00a0 catid smallint not null distkey sortkey,\u00a0\u00a0 catgroup varchar(10),\u00a0\u00a0 catname varchar(10),\u00a0\u00a0 catdesc varchar(50));\u00a0\u00a0create table date(\u00a0\u00a0 dateid smallint not null distkey sortkey,\u00a0\u00a0 caldate date not null,\u00a0\u00a0 day character(3) not null,\u00a0\u00a0 week smallint not null,\u00a0\u00a0 month character(5) not null,\u00a0\u00a0 qtr character(5) not null,\u00a0\u00a0 year smallint not null,\u00a0\u00a0 holiday boolean default(&#8216;N&#8217;));<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3376\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/48.png\" alt=\"\" width=\"850\" height=\"426\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/48.png 868w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/48-300x150.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/48-768x385.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>create table event(\u00a0\u00a0 eventid integer, not null dickey,\u00a0\u00a0 venueid smallint not null,\u00a0\u00a0 catid smallint not null,\u00a0\u00a0 dateid smallint not null sortkey,\u00a0\u00a0 eventname varchar(200),\u00a0\u00a0 starttime timestamp);<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3377\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50-1024x412.png\" alt=\"\" width=\"850\" height=\"342\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50-1024x412.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50-300x121.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50-768x309.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50-1200x483.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/50.png 1331w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>create table listing(\u00a0\u00a0 listid integer not null distkey,\u00a0\u00a0 sellerid integer not null,\u00a0\u00a0 eventid integer not null,\u00a0\u00a0 dateid smallint not null\u00a0 sortkey,\u00a0\u00a0 numtickets smallint not null,\u00a0\u00a0 priceperticket decimal(8,2),\u00a0\u00a0 totalprice decimal(8,2),\u00a0\u00a0 listtime timestamp);<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3379\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52-1024x411.png\" alt=\"\" width=\"850\" height=\"341\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52-1024x411.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52-300x120.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52-768x308.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52-1200x481.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/52.png 1329w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>create table sales(\u00a0\u00a0 salesid integer not null,\u00a0\u00a0 listid integer not null distkey,\u00a0\u00a0 sellerid integer not null,\u00a0\u00a0 buyerid integer not null,\u00a0\u00a0 eventid integer not null,\u00a0\u00a0 dateid smallint not null sortkey,\u00a0\u00a0 qtysold smallint not null,\u00a0\u00a0 pricepaid decimal(8,2),\u00a0\u00a0 commission decimal(8,2),\u00a0\u00a0 saletime timestamp);<\/p>\n<ol start=\"2\">\n<li>Load the sample data from Amazon S3 by using the <strong>COPY<\/strong><\/li>\n<\/ol>\n<h3><strong>Note<\/strong><\/h3>\n<p>If you have to load large datasets, then use COPY command into Amazon Redshift from Amazon S3 or DynamoDB<\/p>\n<p>Download file\u00a0<strong>tickitdb.zip<\/strong>\u00a0that includes individual sample data files. Unzip and load the individual files to a\u00a0ticket\u00a0folder in your Amazon S3 bucket in your AWS Region. Edit the COPY commands in this tutorial to point to the files in your Amazon S3 bucket.<\/p>\n<p><strong>To upload data in Amazon S3:<\/strong><\/p>\n<ol>\n<li><strong>Ready your sample data<\/strong><\/li>\n<li><strong>Browse it from the local machine<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3381\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18-1024x466.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"387\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18-1024x466.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18-300x136.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18-768x349.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18-1200x546.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/18.png 1251w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>3. Click on upload<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3382\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/19-1024x522.png\" alt=\"\" width=\"850\" height=\"433\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/19-1024x522.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/19-300x153.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/19-768x391.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/19.png 1101w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>4. First, select the bucket in which you want to store data. Create a folder under which you have to store files called objects.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3384\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20-1024x447.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"371\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20-1024x447.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20-300x131.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20-768x335.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20-1200x524.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/20.png 1263w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>5. Click on upload once you browse all\u00a0the data.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3385\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/22.png\" alt=\"\" width=\"850\" height=\"464\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/22.png 990w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/22-300x164.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/22-768x420.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>6. Click on a bucket in which your data stored and check it.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3386\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23-1024x452.png\" alt=\"\" width=\"850\" height=\"375\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23-1024x452.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23-300x132.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23-768x339.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23-1200x530.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/23.png 1266w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong><\/p>\n<p>To load sample data, you must provide authentication for your cluster to access Amazon S3 object on your behalf. You can provide either role-based authentication or a key-based authentication method. We recommend using a role-based authentication method.<\/p>\n<p>For this step, you provide authentication by referencing the IAM role that you created and then attached to your cluster in earlier steps.<\/p>\n<p><strong>Note<\/strong><\/p>\n<p>If you don&#8217;t have proper permissions to access Amazon S3, you receive the following error message when running the COPY command:\u00a0<strong>S3ServiceException: Access Denied<\/strong><strong>.<\/strong><\/p>\n<p>The COPY commands include a placeholder for the Amazon Resource Name (ARN) for the IAM role, your bucket name, and an AWS Region, as shown in the following example.<\/p>\n<p>copy users from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/allusers_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p>To authorize access using an IAM role, replace\u00a0<em>&lt;iam-role-arn&gt;<\/em>\u00a0in the CREDENTIALS parameter string with the role ARN for the IAM role that you created in\u00a0Step 2 while creating the IAM Role.<\/p>\n<h3>Your COPY command looks similar to the following example.<\/h3>\n<p>copy users from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/allusers_pipe.txt&#8217; credentials &#8216;aws_iam_role=arn:aws:iam::123456789012:role\/myRedshiftRole&#8217; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p>To load the sample data, replace\u00a0<em>&lt;myBucket&gt;<\/em>,\u00a0<em>&lt;iam-role-arn&gt;<\/em>, and\u00a0<em>&lt;aws-region&gt;<\/em>\u00a0in the following COPY commands with your values. Then run the commands one by one in your SQL client tool.<\/p>\n<p>copy users from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/allusers_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3393\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1-1024x411.png\" alt=\"\" width=\"850\" height=\"341\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1-1024x411.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1-300x120.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1-768x308.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1-1200x481.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/successful-data-load-to-user-from-s3-1.png 1332w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>copy venue from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/venue_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3394\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/venue-1.png\" alt=\"\" width=\"850\" height=\"381\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/venue-1.png 875w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/venue-1-300x134.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/venue-1-768x344.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>copy category from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/category_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p>copy date from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/date2008_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p>copy event from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/allevents_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; timeformat &#8216;YYYY-MM-DD HH:MI:SS&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3391\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/65.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"384\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/65.png 892w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/65-300x136.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/65-768x347.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>copy listing from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/listings_pipe.txt&#8217; credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216; delimiter &#8216;|&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p>copy sales from &#8216;s3:\/\/<em>&lt;myBucket&gt;<\/em>\/tickit\/sales_tab.txt&#8217;credentials &#8216;aws_iam_role=<em>&lt;iam-role-arn&gt;<\/em>&#8216;delimiter &#8216;\\t&#8217; timeformat &#8216;MM\/DD\/YYYY HH:MI:SS&#8217; region &#8216;<em>&lt;aws-region&gt;<\/em>&#8216;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3395\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/62-1.png\" alt=\"\" width=\"850\" height=\"382\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/62-1.png 891w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/62-1-300x135.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/62-1-768x345.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Now try the example queries<\/strong>.<\/p>\n<p><strong>\u00a0Get the definition for the sales table.<\/strong><\/p>\n<p>SELECT *\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 FROM pg_table_def\u00a0\u00a0\u00a0 7.\u00a0\u00a0\u00a0 WHERE tablename = &#8216;sales&#8217;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3397 size-full\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/66.png\" alt=\"\" width=\"850\" height=\"440\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/66.png 850w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/66-300x155.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/66-768x398.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>Now\u00a0\u00a0Find total sales on a given calendar date.<\/p>\n<p>SELECT sum(qtysold)\u00a0 FROM\u00a0\u00a0 sales, date\u00a0 WHERE sales.dateid = date.dateid AND\u00a0\u00a0\u00a0 caldate = &#8216;2008-01-05&#8217;;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3399\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/67.png\" alt=\"\" width=\"850\" height=\"423\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/67.png 894w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/67-300x149.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/67-768x382.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Find top 10 buyers by quantity.<\/strong><\/p>\n<p>SELECT firstname, lastname, total_quantity \u00a0\u00a0\u00a0\u00a0 FROM (SELECT buyerid, sum(qtysold) total_quantity\u00a0FROM sale\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 GROUP BY buyerid\u00a0 \u00a0 ORDER BY total_quantity desc limit 10) Q, users WHERE Q.buyerid = userid\u00a0\u00a0 \u00a0 ORDER BY Q.total_quantity desc;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3400\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/68.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"431\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/68.png 877w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/68-300x152.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/68-768x390.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Find events in the 99.9 percentile in terms of all time gross sales.<\/strong><\/p>\n<p>SELECT eventname, total_price \u00a0\u00a0\u00a0\u00a0 FROM\u00a0 (SELECT eventid, total_price, ntile(1000) over(order by total_price desc) as percentile \u00a0FROM (SELECT eventid, sum(pricepaid) total_price FROM\u00a0\u00a0 sales GROUP BY eventid)) Q, event E WHERE Q.eventid = E.eventid AND percentile = 1 ORDER BY total_price desc;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3401\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales-1024x426.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"354\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales-1024x426.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales-300x125.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales-768x320.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales-1200x500.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Find-events-in-the-99.9-percentile-in-terms-of-all-time-gross-sales.png 1302w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p><strong>Run the command given below for example:<\/strong><\/p>\n<p>Select * from venue;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3402\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/57.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"423\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/57.png 890w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/57-300x149.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/57-768x382.png 768w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<h3>Step 7: Find Additional Resources and Reset Your Cluster Environment<\/h3>\n<p>Once you have completed this tutorial, you can go to other Amazon Redshift resources to learn more about the concepts introduced in this guide. You can also reset your environment setup to the previous state. You might want to keep the sample cluster running if you want to try another tasks. However, remember that\u00a0you continue to be charged for your cluster as long as it is running in your account. To avoid charges, revoke access to the cluster and delete it when you no longer need it.<\/p>\n<p>To avoid charges, take snapshot of your cluster, and then delete it if no longer in use.<\/p>\n<p>You can relaunch cluster it later from snapshot that you have taken.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3403\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1024x256.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"213\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1024x256.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-300x75.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-768x192.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1200x300.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created.png 1343w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>You can see Snapshot created in an image given below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3404\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1-1024x256.png\" alt=\"Getting Started With Amazon Redshift\" width=\"850\" height=\"213\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1-1024x256.png 1024w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1-300x75.png 300w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1-768x192.png 768w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1-1200x300.png 1200w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/snapshot-created-1.png 1343w\" sizes=\"auto, (max-width: 850px) 100vw, 850px\" \/><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #0000ff;\">#Last but not least, always ask for help!<\/span><\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Getting Started With Amazon Redshift &nbsp; Getting Started With Amazon Redshift, Are you the one who is looking for the best platform which provides information about Getting Started With Amazon Redshift? Or the one who is looking forward to taking the advanced Certification Course from India\u2019s Leading AWS Training institute? Then you\u2019ve landed on the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1657,31],"tags":[388],"class_list":["post-3343","post","type-post","status-publish","format-standard","hentry","category-amazon-redshift","category-aws","tag-getting-started-with-amazon-redshift"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Getting Started With Amazon Redshift- Prwatech Bangalore<\/title>\n<meta name=\"description\" content=\"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Getting Started With Amazon Redshift- Prwatech Bangalore\" \/>\n<meta property=\"og:description\" content=\"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-15T11:13:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T10:33:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/\",\"url\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/\",\"name\":\"Getting Started With Amazon Redshift- Prwatech Bangalore\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png\",\"datePublished\":\"2019-11-15T11:13:33+00:00\",\"dateModified\":\"2024-03-29T10:33:37+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture.png\",\"width\":1303,\"height\":561},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Getting Started With Amazon Redshift\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Getting Started With Amazon Redshift- Prwatech Bangalore","description":"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Getting Started With Amazon Redshift- Prwatech Bangalore","og_description":"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.","og_url":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2019-11-15T11:13:33+00:00","article_modified_time":"2024-03-29T10:33:37+00:00","og_image":[{"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png","type":"","width":"","height":""}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"23 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/","url":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/","name":"Getting Started With Amazon Redshift- Prwatech Bangalore","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture-1024x441.png","datePublished":"2019-11-15T11:13:33+00:00","dateModified":"2024-03-29T10:33:37+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Getting Started With Amazon Redshift, Before you start to set up an Amazon Redshift cluster, make sure that you complete the following prerequisites.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2019\/11\/Capture.png","width":1303,"height":561},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/aws\/amazon-redshift\/getting-started-with-amazon-redshift\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Getting Started With Amazon Redshift"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=3343"}],"version-history":[{"count":19,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3343\/revisions"}],"predecessor-version":[{"id":11185,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/3343\/revisions\/11185"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=3343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=3343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=3343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}