{"id":29768,"date":"2022-11-25T18:26:17","date_gmt":"2022-11-25T12:56:17","guid":{"rendered":"https:\/\/blazeclan.com\/reinventing-data-warehouse-with-amazon-redshift\/"},"modified":"2023-03-20T11:02:52","modified_gmt":"2023-03-20T05:32:52","slug":"reinventing-data-warehouse-with-amazon-redshift","status":"publish","type":"post","link":"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/","title":{"rendered":"ReInventing Data Warehouse with Amazon Redshift"},"content":{"rendered":"<p>Transactional systems and other relational databases typically feed data into data warehouses, and structured, semi-structured, and unstructured data often go into a data warehouse as well. A regular cadence is followed for processing, transforming, and ingesting this data. The data can be accessed by BI tools, SQL clients, and other tools by business analysts, data scientists, and decision-makers.<\/p>\n<h2>Data Warehouse as a Service<\/h2>\n<p>When we think about Data warehouses, it&#8217;s always about expensive dedicated hardware along with huge software licensing fees. You have to pay upfront for both the hardware and software along with the costs associated with setting up and installing them. This would require you to have DBA and networking teams in place to ensure smooth deployment and continuous maintenance.<\/p>\n<p>Small enterprises cannot afford data warehouses, and lose the competitive edge vis a vis larger organizations.<\/p>\n<p>For Larger Organizations, the challenges are different, while the average growth in enterprise data is at 50% year on year, data warehousing is not growing at the same pace. This results in a lot of data being left out of the Data Warehousing and Business Intelligence process.<\/p>\n<h2>Enter Amazon Redshift<\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-19534 size-full\" src=\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/08\/Amazon-Redshift-\u2013-11-Key-Points-to-Remember.png\" alt=\"data warehouse\" width=\"1650\" height=\"680\"><\/p>\n<p><a href=\"https:\/\/blazeclan.com\/en-eu\/blog\/amazon-redshift-vs-traditional-data-warehouses\/\">Amazon Redshift<\/a> is Data Warehousing on Cloud by Amazon Web Services. It is a fully managed, petabyte-scale data warehouse.<\/p>\n<p>Amazon Redshift turns the Data Warehousing economics upside down. The best thing about Amazon Redshift is that you can provide it within minutes, doing away with the routine heavy lifting of setting up hardware and installing software to start using a data warehouse.<\/p>\n<p>With Redshift, you do away with all the upfront investments required for hardware or software. It is a pay as you go service and is priced to analyze all your data. It is extremely fast and it is cheaper than most options available in the market today.<\/p>\n<h3>Redshift reduces I\/O Operations<\/h3>\n<p><a href=\"https:\/\/aws.amazon.com\/redshift\/\">Redshift provides<\/a> columnar data storage. With Columnar data storage, all values for a particular column are stored contiguously on the disk in sequential blocks.<\/p>\n<div>Columnar data storage helps reduce the I\/O requests made to the disk compared to traditional row-based data storage. It also reduces the amount of data loaded from the disk improving the processing speed, as more memory is available for query executions.<\/div>\n<p>As similar data is stored sequentially, Redshift compresses the data rather efficiently. Compression of data further reduces the amount of I\/O required for queries.<\/p>\n<h3>Redshift is implemented using a Massively parallel processing architecture<\/h3>\n<p><a href=\"https:\/\/blazeclan.com\/en-eu\/blog\/what-is-amazon-redshift-11-key-points-remember\/\">Amazon Redshift<\/a> has a Massively Parallel Processing Architecture. MPP enables Redshift to distribute and parallelize queries across multiple nodes. Apart from queries, the MPP architecture also enables parallel operations for data loads, backups and restores.<\/p>\n<p>Redshift architecture is inherently parallel; there is no additional tuning or overheads for the distribution of loads for the end-users.<\/p>\n<h3>Redshift has security built-in<\/h3>\n<p>Amazon provides various security features for Redshift just like all other AWS services. Access Control can be maintained at the account level using IAM roles. For database level access control, you can define Redshift database groups and users and restrict access to specific databases and tables.<\/p>\n<p>Redshift can be launched in Amazon VPC. You can define VPC security groups to restrict inbound access to your clusters.<\/p>\n<p>Redshift allows Data Encryption for all data which is stored in the cluster as well as SSL encryption for data in transit.<\/p>\n<h2>Redshift Node Types<\/h2>\n<p>We offer different node types in Amazon Redshift to meet the diverse workload patterns of our clients, making it one of the fastest, fully managed, and most popular cloud data warehouses. AQUA (Advanced Query Accelerator), cross-cluster data sharing, and cross-Availability Zone cluster relocation are some of the advanced features of Amazon Redshift RA3 with managed storage. At the same time, you can scale and pay for computing and storage independently.<\/p>\n<p>Many customers start with the RA3 instances, which are available in three-node sizes, as their default choice when using Amazon Redshift.<\/p>\n<table class=\"table table-hover\">\n<tbody>\n<tr>\n<td><strong>Node size<\/strong><\/td>\n<td><strong>vCPU<\/strong><\/td>\n<td><strong>RAM (GiB)<\/strong><\/td>\n<td><strong>Managed storage quota per node<\/strong><\/td>\n<\/tr>\n<tr>\n<td>ra3.xlplus<\/td>\n<td>4<\/td>\n<td>32<\/td>\n<td>32 TB<\/td>\n<\/tr>\n<tr>\n<td>ra3.4xlarge<\/td>\n<td>12<\/td>\n<td>96<\/td>\n<td>128 TB<\/td>\n<\/tr>\n<tr>\n<td>ra3.16xlarge<\/td>\n<td>48<\/td>\n<td>384<\/td>\n<td>128 TB<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Which warehouse is a good fit for your business?<\/h2>\n<p>Comparing these two data warehouse solutions further demonstrates how they are each suitable for different needs:<\/p>\n<h3>What features are bundled and what aren&#8217;t?<\/h3>\n<p>Using Redshift as a data warehouse, enterprise-level scalability is immediately possible. However, Snowflake&#8217;s split computation and storage and tiered editions ensure businesses can obtain just the features they require while preserving scalability.<\/p>\n<h3>Do you think JSON is a dealbreaker or not?<\/h3>\n<p>Snowflake&#8217;s support for JSON storage is better than Redshift&#8217;s. Snowflake provides native functions for storing and querying JSON with native support. JSON is split into strings when loaded into Redshift, making it harder to query and work with.<\/p>\n<h3>How many levels of security are enough, or is it just what you need?<\/h3>\n<p>Redshift&#8217;s encryption capabilities are deep, but Snowflake&#8217;s security and compliance features are tailored to each edition so your data is protected to the highest degree possible.<\/p>\n<h3>What methods should you use to manage your data?<\/h3>\n<p>For tasks that cannot be automated, such as data vacuuming and compression, Redshift requires more hands-on maintenance. The advantage of Snowflake in this regard is that it automates more of these issues, making it easier to diagnose and resolve issues.<\/p>\n<p>Think about how optimized you would like your data warehouse to be. You can gauge the pros and cons of these features by comparing them with your data strategy.<\/p>\n<div>Blazeclan is an AWS and Snowflake partner, <span><em><a href=\"https:\/\/blazeclan.com\/en-eu\/contact\/\">get in touch with us here<\/a><\/em><\/span> to determine what&#8217;s best for you.<\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Transactional systems and other relational databases typically feed data into data warehouses, and structured, semi-structured, and unstructured data often go into a data warehouse as well. A regular cadence is followed for processing, transforming, and ingesting this data. The data can be accessed by BI tools, SQL clients, and other tools by business analysts, data [&hellip;]<\/p>\n","protected":false},"author":192,"featured_media":16886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1549],"tags":[1939,2207,2694,1415,1604,2982],"class_list":["post-29768","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-warehouse-on-aws-en-eu","tag-amazon-redshift-en-eu","tag-amazon-web-services-en-eu","tag-aws-redshift-en-eu","tag-data-warehouse-en-eu","tag-data-warehousing-en-eu","tag-redshift-en-eu"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ReInventing Data Warehouse with Amazon Redshift - Blazeclan<\/title>\n<meta name=\"description\" content=\"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ReInventing Data Warehouse with Amazon Redshift - Blazeclan\" \/>\n<meta property=\"og:description\" content=\"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\" \/>\n<meta property=\"og:site_name\" content=\"Blazeclan\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/blazeclan.hq\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T12:56:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-20T05:32:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1650\" \/>\n\t<meta property=\"og:image:height\" content=\"680\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Team Blazeclan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@blazeclan_hq\" \/>\n<meta name=\"twitter:site\" content=\"@blazeclan_hq\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Team Blazeclan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\"},\"author\":{\"name\":\"Team Blazeclan\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/779910eccddff4a1ea6663b6bfb271e8\"},\"headline\":\"ReInventing Data Warehouse with Amazon Redshift\",\"datePublished\":\"2022-11-25T12:56:17+00:00\",\"dateModified\":\"2023-03-20T05:32:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\"},\"wordCount\":923,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#organization\"},\"image\":{\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png\",\"keywords\":[\"Amazon Redshift\",\"Amazon Web Services\",\"AWS Redshift\",\"Data warehouse\",\"Data Warehousing\",\"Redshift\"],\"articleSection\":[\"Data Warehouse On AWS\"],\"inLanguage\":\"en-EU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\",\"url\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\",\"name\":\"ReInventing Data Warehouse with Amazon Redshift - Blazeclan\",\"isPartOf\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png\",\"datePublished\":\"2022-11-25T12:56:17+00:00\",\"dateModified\":\"2023-03-20T05:32:52+00:00\",\"description\":\"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.\",\"breadcrumb\":{\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#breadcrumb\"},\"inLanguage\":\"en-EU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-EU\",\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage\",\"url\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png\",\"contentUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png\",\"width\":1650,\"height\":680},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blazeclan.com\/en-eu\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ReInventing Data Warehouse with Amazon Redshift\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#website\",\"url\":\"https:\/\/blazeclan.com\/en-eu\/\",\"name\":\"Blazeclan\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blazeclan.com\/en-eu\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-EU\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#organization\",\"name\":\"Blazeclan\",\"url\":\"https:\/\/blazeclan.com\/en-eu\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-EU\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg\",\"contentUrl\":\"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg\",\"caption\":\"Blazeclan\"},\"image\":{\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/blazeclan.hq\/\",\"https:\/\/x.com\/blazeclan_hq\",\"https:\/\/www.instagram.com\/blazeclantechnologies\/\",\"https:\/\/www.linkedin.com\/company\/blazeclan-technologies\/\",\"https:\/\/www.youtube.com\/channel\/UCCKF4Lcbtus-pUoZr7Lxrow\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/779910eccddff4a1ea6663b6bfb271e8\",\"name\":\"Team Blazeclan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-EU\",\"@id\":\"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a43c1fa01bb3c7e839254c9084bf11ed422d7e633231f9e935096045af416ba2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a43c1fa01bb3c7e839254c9084bf11ed422d7e633231f9e935096045af416ba2?s=96&d=mm&r=g\",\"caption\":\"Team Blazeclan\"},\"sameAs\":[\"http:\/\/localhost\/ps-local-wp\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ReInventing Data Warehouse with Amazon Redshift - Blazeclan","description":"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.","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:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/","og_locale":"en_US","og_type":"article","og_title":"ReInventing Data Warehouse with Amazon Redshift - Blazeclan","og_description":"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.","og_url":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/","og_site_name":"Blazeclan","article_publisher":"https:\/\/www.facebook.com\/blazeclan.hq\/","article_published_time":"2022-11-25T12:56:17+00:00","article_modified_time":"2023-03-20T05:32:52+00:00","og_image":[{"width":1650,"height":680,"url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png","type":"image\/png"}],"author":"Team Blazeclan","twitter_card":"summary_large_image","twitter_creator":"@blazeclan_hq","twitter_site":"@blazeclan_hq","twitter_misc":{"Written by":"Team Blazeclan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#article","isPartOf":{"@id":"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/"},"author":{"name":"Team Blazeclan","@id":"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/779910eccddff4a1ea6663b6bfb271e8"},"headline":"ReInventing Data Warehouse with Amazon Redshift","datePublished":"2022-11-25T12:56:17+00:00","dateModified":"2023-03-20T05:32:52+00:00","mainEntityOfPage":{"@id":"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/"},"wordCount":923,"commentCount":0,"publisher":{"@id":"https:\/\/blazeclan.com\/en-eu\/#organization"},"image":{"@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage"},"thumbnailUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png","keywords":["Amazon Redshift","Amazon Web Services","AWS Redshift","Data warehouse","Data Warehousing","Redshift"],"articleSection":["Data Warehouse On AWS"],"inLanguage":"en-EU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blazeclan.com\/en-eu\/blog\/reinventing-data-warehouse-with-amazon-redshift\/","url":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/","name":"ReInventing Data Warehouse with Amazon Redshift - Blazeclan","isPartOf":{"@id":"https:\/\/blazeclan.com\/en-eu\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage"},"image":{"@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage"},"thumbnailUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png","datePublished":"2022-11-25T12:56:17+00:00","dateModified":"2023-03-20T05:32:52+00:00","description":"Think about how optimized you would like your data warehouse to be. Amazon Redshift turns the Data Warehousing economics upside down.","breadcrumb":{"@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#breadcrumb"},"inLanguage":"en-EU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/"]}]},{"@type":"ImageObject","inLanguage":"en-EU","@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#primaryimage","url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png","contentUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2013\/11\/ReInventing-Data-WareHouse-with-Amazon-Redshift-1.png","width":1650,"height":680},{"@type":"BreadcrumbList","@id":"https:\/\/blazeclan.com\/blog\/reinventing-data-warehouse-with-amazon-redshift\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blazeclan.com\/en-eu\/"},{"@type":"ListItem","position":2,"name":"ReInventing Data Warehouse with Amazon Redshift"}]},{"@type":"WebSite","@id":"https:\/\/blazeclan.com\/en-eu\/#website","url":"https:\/\/blazeclan.com\/en-eu\/","name":"Blazeclan","description":"","publisher":{"@id":"https:\/\/blazeclan.com\/en-eu\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blazeclan.com\/en-eu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-EU"},{"@type":"Organization","@id":"https:\/\/blazeclan.com\/en-eu\/#organization","name":"Blazeclan","url":"https:\/\/blazeclan.com\/en-eu\/","logo":{"@type":"ImageObject","inLanguage":"en-EU","@id":"https:\/\/blazeclan.com\/en-eu\/#\/schema\/logo\/image\/","url":"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg","contentUrl":"https:\/\/blazeclan.com\/wp-content\/uploads\/2024\/10\/ITCI-Blazeclan_logo.svg","caption":"Blazeclan"},"image":{"@id":"https:\/\/blazeclan.com\/en-eu\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/blazeclan.hq\/","https:\/\/x.com\/blazeclan_hq","https:\/\/www.instagram.com\/blazeclantechnologies\/","https:\/\/www.linkedin.com\/company\/blazeclan-technologies\/","https:\/\/www.youtube.com\/channel\/UCCKF4Lcbtus-pUoZr7Lxrow"]},{"@type":"Person","@id":"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/779910eccddff4a1ea6663b6bfb271e8","name":"Team Blazeclan","image":{"@type":"ImageObject","inLanguage":"en-EU","@id":"https:\/\/blazeclan.com\/en-eu\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a43c1fa01bb3c7e839254c9084bf11ed422d7e633231f9e935096045af416ba2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a43c1fa01bb3c7e839254c9084bf11ed422d7e633231f9e935096045af416ba2?s=96&d=mm&r=g","caption":"Team Blazeclan"},"sameAs":["http:\/\/localhost\/ps-local-wp"]}]}},"_links":{"self":[{"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/posts\/29768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/users\/192"}],"replies":[{"embeddable":true,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/comments?post=29768"}],"version-history":[{"count":0,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/posts\/29768\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/media\/16886"}],"wp:attachment":[{"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/media?parent=29768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/categories?post=29768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blazeclan.com\/en-eu\/wp-json\/wp\/v2\/tags?post=29768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}