{"id":456,"date":"2015-12-09T09:19:18","date_gmt":"2015-12-09T09:19:18","guid":{"rendered":"http:\/\/cloudkul.com\/blog\/?p=456"},"modified":"2017-06-14T11:34:25","modified_gmt":"2017-06-14T11:34:25","slug":"amazon-redshift-your-own-data-warehouse-on-cloud","status":"publish","type":"post","link":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/","title":{"rendered":"Amazon Redshift : Your own Data Warehouse on cloud"},"content":{"rendered":"<p>An organization keeps its data in different systems, which support various business processes. In order to create an overall picture of business operations, customers and suppliers, the data must come together in one place and made compatible. Both external (from the environment) and internal data (from ERP, CRM and financial systems) should merge into a central location and permanent storage space for reporting and data analysis, such system is known as Data Warehouse.<\/p>\n<p>Data analytics are important for business but building a traditional data warehouse may have the following drawbacks :<\/p>\n<ul>\n<li>Data warehouses are complex, can take months to setup and cost you millions of dollors in software and hardware expenses.<\/li>\n<li>Once you have made the investment and final setup, you have to hire bunch of DBAs to make sure that your queries run fast and data is never lost.<\/li>\n<li>These data warehouses don&#8217;t scale up and down easily so when data volume grows, you have to choose between slow query performance or timing effort on an extensive upgrade process.<\/li>\n<\/ul>\n<p>What if you could replace all those software and hardware with a data warehouse service which is easy to use, scale and cost effective ?<\/p>\n<p>Yes, Amazon Redshift is\u00a0a fast, fully managed, petabyte-scale data warehouse that makes it easy for you to setup, manage and scale your data warehouse.It also provides you cost-effective way to analyze all your data using your existing business intelligence tools.<\/p>\n<p>The entire process of creating our data warehouse can be summerized in the following steps :-<\/p>\n<p>First, we need to create an amazon redshift cluster :-<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-504\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_3.png\" alt=\"Screenshot_3\" width=\"1143\" height=\"603\" \/><\/a>Choose the default settings for rest of the configuration and click on launch cluster.<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-505\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_5.png\" alt=\"Screenshot_5\" width=\"1136\" height=\"531\" \/><\/a><\/p>\n<p>Connect any query tool of your choice.Here we are taking the example of\u00a0\u00a0jackdb, which is a browser based interface for writing queries.Login to jackdb and add\u00a0a datasource for amazon redshift.<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-507\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_6.png\" alt=\"Screenshot_6\" width=\"1132\" height=\"571\" \/><\/a><\/p>\n<div class=\"panel panel-info\">\n<div class=\"panel-heading\">Note<\/div>\n<div class=\"panel-body\">\n<ul>\n<li>In the server hostname or ip section, enter the end point name as displayed on aws redshift console without &#8220;:5439&#8221; port number.<\/li>\n<li>Don&#8217;t click on the create data source button before adding an inbound security group rule for jackdb.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p>Depending on your network and security settings, you may need to enter an inbound rule for the specified query tool in order to connect it to your redshift cluster.<\/p>\n<p>Switch on aws console, click on default security group :-<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-511\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_4.png\" alt=\"Screenshot_4\" width=\"991\" height=\"545\" \/><\/a><\/p>\n<p>Add a inbound TCP rule for Jackdb&#8217;s ip (here it is 107.23.138.60\/32) on port 5439 :-<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-522\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_9.png\" alt=\"Screenshot_9\" width=\"1149\" height=\"563\" \/><\/a><\/p>\n<p>Now, you can switch to jackdb console and click on create datasource. After successfully establishing a connection with aws redshift cluster, you must get a console as shown below. Now you can execute any query on your &#8216;test&#8217; database :-<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-513\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_7.png\" alt=\"Screenshot_7\" width=\"1141\" height=\"557\" \/><\/a><\/p>\n<p>You can verify whether the queries have been executed on your database or not by clicking on queries section of redshift cluster :-<\/p>\n<p><a href=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-514\" src=\"http:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Screenshot_8.png\" alt=\"Screenshot_8\" width=\"1036\" height=\"413\" \/><\/a><\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/cloudkul.com\/contact\/\" target=\"_blank\">FOR ANY QUERY OR SUPPORT, PLEASE CONTACT US\u00a0<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An organization keeps its data in different systems, which support various business processes. In order <a class=\"text-primary\" title=\"read more\" href=\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":5,"featured_media":533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2],"tags":[3,30,29],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul\" \/>\n<meta property=\"og:description\" content=\"An organization keeps its data in different systems, which support various business processes. In order [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"Cloudkul\" \/>\n<meta property=\"article:published_time\" content=\"2015-12-09T09:19:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-06-14T11:34:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Amazon-Redshift-Your-own-Data-Warehouse-on-cloud-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"848\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Naina Johari\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\",\"url\":\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\",\"name\":\"Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul\",\"isPartOf\":{\"@id\":\"https:\/\/cloudkul.com\/blog\/#website\"},\"datePublished\":\"2015-12-09T09:19:18+00:00\",\"dateModified\":\"2017-06-14T11:34:25+00:00\",\"author\":{\"@id\":\"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/38f7cddff574c7fe989d6ca2df61fc57\"},\"breadcrumb\":{\"@id\":\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cloudkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Amazon Redshift : Your own Data Warehouse on cloud\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cloudkul.com\/blog\/#website\",\"url\":\"https:\/\/cloudkul.com\/blog\/\",\"name\":\"Cloudkul\",\"description\":\"Host your eCommerce Store on AWS with Optimized Performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cloudkul.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/38f7cddff574c7fe989d6ca2df61fc57\",\"name\":\"Naina Johari\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c7a0be3afff58963975900f809e57046?s=96&d=https%3A%2F%2Fs.gravatar.com%2Favatar%2F6148c37469011bc2f8e491ca8f5de495%3Fs%3D80&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c7a0be3afff58963975900f809e57046?s=96&d=https%3A%2F%2Fs.gravatar.com%2Favatar%2F6148c37469011bc2f8e491ca8f5de495%3Fs%3D80&r=g\",\"caption\":\"Naina Johari\"},\"url\":\"https:\/\/cloudkul.com\/blog\/author\/naina-johari379\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/","og_locale":"en_US","og_type":"article","og_title":"Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul","og_description":"An organization keeps its data in different systems, which support various business processes. In order [...]","og_url":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/","og_site_name":"Cloudkul","article_published_time":"2015-12-09T09:19:18+00:00","article_modified_time":"2017-06-14T11:34:25+00:00","og_image":[{"width":848,"height":422,"url":"https:\/\/cloudkul.com\/blog\/wp-content\/uploads\/2015\/12\/Amazon-Redshift-Your-own-Data-Warehouse-on-cloud-1.png","type":"image\/png"}],"author":"Naina Johari","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/","url":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/","name":"Amazon Redshift : Your own Data Warehouse on cloud - Cloudkul","isPartOf":{"@id":"https:\/\/cloudkul.com\/blog\/#website"},"datePublished":"2015-12-09T09:19:18+00:00","dateModified":"2017-06-14T11:34:25+00:00","author":{"@id":"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/38f7cddff574c7fe989d6ca2df61fc57"},"breadcrumb":{"@id":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cloudkul.com\/blog\/amazon-redshift-your-own-data-warehouse-on-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Amazon Redshift : Your own Data Warehouse on cloud"}]},{"@type":"WebSite","@id":"https:\/\/cloudkul.com\/blog\/#website","url":"https:\/\/cloudkul.com\/blog\/","name":"Cloudkul","description":"Host your eCommerce Store on AWS with Optimized Performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudkul.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/38f7cddff574c7fe989d6ca2df61fc57","name":"Naina Johari","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cloudkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c7a0be3afff58963975900f809e57046?s=96&d=https%3A%2F%2Fs.gravatar.com%2Favatar%2F6148c37469011bc2f8e491ca8f5de495%3Fs%3D80&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c7a0be3afff58963975900f809e57046?s=96&d=https%3A%2F%2Fs.gravatar.com%2Favatar%2F6148c37469011bc2f8e491ca8f5de495%3Fs%3D80&r=g","caption":"Naina Johari"},"url":"https:\/\/cloudkul.com\/blog\/author\/naina-johari379\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/posts\/456"}],"collection":[{"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":21,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":535,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/posts\/456\/revisions\/535"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/media\/533"}],"wp:attachment":[{"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudkul.com\/blog\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}