{"id":2082,"date":"2020-09-22T08:46:59","date_gmt":"2020-09-22T13:46:59","guid":{"rendered":"https:\/\/lg-staging.lougcloud.com\/?p=2082"},"modified":"2021-04-07T10:35:04","modified_gmt":"2021-04-07T15:35:04","slug":"what-is-snowflake-technology","status":"publish","type":"post","link":"https:\/\/lg-staging.lougcloud.com\/?p=2082","title":{"rendered":"What is Snowflake Technology?"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-85bp3-f856194ef33e7bc72ec0d3bf98278fce\">\n.flex_column.av-85bp3-f856194ef33e7bc72ec0d3bf98278fce{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-85bp3-f856194ef33e7bc72ec0d3bf98278fce av_one_full  avia-builder-el-0  el_before_av_section  avia-builder-el-no-sibling  first flex_column_div av-zero-column-padding  '     ><p><br \/>\n<section  class='av_textblock_section av-k0pon615-83a3f74a3a12ae3df6b12e1982bff3e8 '  ><div class='avia_textblock' ><h1>What is Snowflake Technology?<\/h1>\n<\/div><\/section><br \/>\n<section  class='av_textblock_section av-k0pop9td-34c3529061cd7bb9ffd7b4d3c815c3f0 '  ><div class='avia_textblock' ><p><a href=\"https:\/\/www.snowflake.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Snowflake<\/a>, Silicon Valley\u2019s hottest new public company, opened up trading last week (9\/16) and quickly became the biggest tech IPO of the year. Warren Buffett\u2019s <a href=\"https:\/\/www.berkshirehathaway.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Berkshire Hathaway<\/a> and <a href=\"https:\/\/www.salesforce.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Salesforce<\/a> both invested $250 million in Snowflake, which shows us how impressive the technology must be. But from a tech perspective, what does Snowflake actually do?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2083 aligncenter\" src=\"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/snowflake-logo.jpg\" alt=\"\" width=\"820\" height=\"231\" \/><\/p>\n<h2>What does Snowflake do?<\/h2>\n<p>We live in a world currently being overrun with data. It\u2019s the new gold mine for many companies, but considering how much data is available, how do you make sense of it all?<\/p>\n<p>That\u2019s where Snowflake comes into play.<\/p>\n<p>Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible. Available as a service on leading cloud providers such as <a href=\"https:\/\/azure.microsoft.com\/en-us\/\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft Azure<\/a>, <a href=\"https:\/\/aws.amazon.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">AWS<\/a> and <a href=\"https:\/\/cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a>, Snowflake eliminates architectural complexity that, historically speaking, would\u2019ve required a team of in-house data engineers running open-source software and racking up large costs because data engineers are limited in supply and high in demand.<\/p>\n<h2>How much does Snowflake cost?<\/h2>\n<p>The process of understanding Snowflake pricing is not straightforward, and we aren\u2019t ashamed to admit it. To put it simply, Snowflake pricing depends on how the following three services are being utilized by the user: Virtual warehouses, data storage and cloud services. Snowflake services are provided on-demand, allowing users to select the amount of compute and storage they need before paying for it (based on usage or on a monthly fixed-rate model).<\/p>\n<h2>Where is Snowflake\u2019s data stored?<\/h2>\n<p>The Snowflake data warehouse is built entirely on the cloud and employs a subscription-based model with storage and compute operating independently. It\u2019s a fully managed, cloud data warehouse available in the form of Software-as-a-Service (SaaS) or Database-as-a-Service (DaaS).<\/p>\n<h2>What makes Snowflake unique?<\/h2>\n<p>In one word: Architecture.<\/p>\n<p>Providing companies with the tools to navigate their data and multi-cluster computer, even when it is housed on servers run by different vendors is the true advantage of Snowflake. Not having to be concerned about any back-end work like installations and maintenance is another true advantage of Snowflake.<\/p>\n<\/div><\/section><\/p><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='newsletter-cta'  class='avia-section av-k94bv4z5-3db5045821716543f466fd2ed6fe087e main_color avia-section-default avia-no-border-styling  avia-builder-el-4  el_after_av_one_full  avia-builder-el-last  avia-bg-style-scroll container_wrap fullsize'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-full alpha units'><div class='post-entry post-entry-type-page post-entry-2082'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-51vv-890cb9339298166528b66afbca7f3287\">\n.flex_column.av-51vv-890cb9339298166528b66afbca7f3287{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-51vv-890cb9339298166528b66afbca7f3287 av_one_half  avia-builder-el-5  el_before_av_one_half  avia-builder-el-first  first flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-k91ny805-e4fa07328a97eaf5a443b98b19009ade '  ><div class='avia_textblock' ><p>Louisville Geek provides comprehensive managed IT services for a diverse range of businesses and non-profit organizations. We are passionate about IT and love what we do!<\/p>\n<\/div><\/section><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-2sej-3ae0b85a4ea0cf26f8956379e2e0883d\">\n.flex_column.av-2sej-3ae0b85a4ea0cf26f8956379e2e0883d{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n<\/style>\n<div  class='flex_column av-2sej-3ae0b85a4ea0cf26f8956379e2e0883d av_one_half  avia-builder-el-7  el_after_av_one_half  avia-builder-el-last  flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-k94busar-1ebe35827b8056452803c9570dc5b3a4 '  ><div class='avia_textblock' ><h3>Stay updated by signing up for our newsletter<\/h3>\n<\/div><\/section><br \/>\n<\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Snowflake provides companies with the tools to navigate their data and multi-cluster computer, even when it is housed on servers run by different vendors.<\/p>\n","protected":false},"author":1,"featured_media":2086,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,5],"tags":[],"class_list":["post-2082","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-geek-news","category-tech-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is Snowflake Technology? - Louisville Geek<\/title>\n<meta name=\"description\" content=\"Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible.\" \/>\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=\"What is Snowflake Technology? - Louisville Geek\" \/>\n<meta property=\"og:description\" content=\"Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lg-staging.lougcloud.com\/?p=2082\" \/>\n<meta property=\"og:site_name\" content=\"Louisville Geek\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-22T13:46:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-07T15:35:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-1030x687.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1030\" \/>\n\t<meta property=\"og:image:height\" content=\"687\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"lg_admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"lg_admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Snowflake Technology? - Louisville Geek","description":"Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible.","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":"What is Snowflake Technology? - Louisville Geek","og_description":"Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible.","og_url":"https:\/\/lg-staging.lougcloud.com\/?p=2082","og_site_name":"Louisville Geek","article_published_time":"2020-09-22T13:46:59+00:00","article_modified_time":"2021-04-07T15:35:04+00:00","og_image":[{"width":1030,"height":687,"url":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-1030x687.jpg","type":"image\/jpeg"}],"author":"lg_admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"lg_admin","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#article","isPartOf":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082"},"author":{"name":"lg_admin","@id":"https:\/\/lg-staging.lougcloud.com\/#\/schema\/person\/3be0d57bc8c8a3746bb75ce4d733211c"},"headline":"What is Snowflake Technology?","datePublished":"2020-09-22T13:46:59+00:00","dateModified":"2021-04-07T15:35:04+00:00","mainEntityOfPage":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082"},"wordCount":860,"publisher":{"@id":"https:\/\/lg-staging.lougcloud.com\/#organization"},"image":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#primaryimage"},"thumbnailUrl":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-scaled.jpg","articleSection":["Geek News","Tech Tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082","url":"https:\/\/lg-staging.lougcloud.com\/?p=2082","name":"What is Snowflake Technology? - Louisville Geek","isPartOf":{"@id":"https:\/\/lg-staging.lougcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#primaryimage"},"image":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#primaryimage"},"thumbnailUrl":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-scaled.jpg","datePublished":"2020-09-22T13:46:59+00:00","dateModified":"2021-04-07T15:35:04+00:00","description":"Snowflake stores both structured and semi-structured data, converting it into a usable format that is SQL-compatible.","breadcrumb":{"@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lg-staging.lougcloud.com\/?p=2082"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#primaryimage","url":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-scaled.jpg","contentUrl":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2020\/09\/GettyImages-1228547619-scaled.jpg","width":2560,"height":1707,"caption":"Snowflake"},{"@type":"BreadcrumbList","@id":"https:\/\/lg-staging.lougcloud.com\/?p=2082#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/lg-staging.lougcloud.com\/"},{"@type":"ListItem","position":2,"name":"What is Snowflake Technology?"}]},{"@type":"WebSite","@id":"https:\/\/lg-staging.lougcloud.com\/#website","url":"https:\/\/lg-staging.lougcloud.com\/","name":"Louisville Geek","description":"Empowering Local Businesses and National Enterprises with Comprehensive IT Services","publisher":{"@id":"https:\/\/lg-staging.lougcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lg-staging.lougcloud.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/lg-staging.lougcloud.com\/#organization","name":"Louisville Geek","url":"https:\/\/lg-staging.lougcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lg-staging.lougcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2019\/10\/lougeek_full_logo-black-1.png","contentUrl":"https:\/\/lg-staging.lougcloud.com\/wp-content\/uploads\/2019\/10\/lougeek_full_logo-black-1.png","width":1671,"height":506,"caption":"Louisville Geek"},"image":{"@id":"https:\/\/lg-staging.lougcloud.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/lg-staging.lougcloud.com\/#\/schema\/person\/3be0d57bc8c8a3746bb75ce4d733211c","name":"lg_admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6e9e6411eb9b94c27ad6dcf6eeea2a67959e86f4aa3ee1cc1b61e042286e2d35?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6e9e6411eb9b94c27ad6dcf6eeea2a67959e86f4aa3ee1cc1b61e042286e2d35?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6e9e6411eb9b94c27ad6dcf6eeea2a67959e86f4aa3ee1cc1b61e042286e2d35?s=96&d=mm&r=g","caption":"lg_admin"},"url":"https:\/\/lg-staging.lougcloud.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2082","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2082"}],"version-history":[{"count":4,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2082\/revisions"}],"predecessor-version":[{"id":2088,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/posts\/2082\/revisions\/2088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=\/wp\/v2\/media\/2086"}],"wp:attachment":[{"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2082"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2082"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lg-staging.lougcloud.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}