{"id":11490,"date":"2021-07-23T16:14:11","date_gmt":"2021-07-23T16:14:11","guid":{"rendered":"http:\/\/ismiletechnologies.com\/?p=11490"},"modified":"2021-10-11T21:06:12","modified_gmt":"2021-10-11T15:36:12","slug":"snowflake-data-warehouse","status":"publish","type":"post","link":"https:\/\/ismiletechnologies.com\/en_us\/cloud-services\/snowflake-data-warehouse\/","title":{"rendered":"Snowflake Data Warehouse"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n

As per snowflake \u201cSnowflake\u00a0is an analytic data warehouse provided as Software-as-a-Service (SaaS).\u00a0Snowflake provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouse offerings<\/em><\/strong>.\u201d\u00a0<\/p>\n\n

Snowflake is a cloud-based data warehouse or data storage service that enables adoption of\u00a0multi-cloud strategy. It doesn\u2019t consume IT resources for setting up, configuring or maintenance. It\u00a0couples\u00a0a\u00a0unique\u00a0SQL\u00a0query\u00a0engine with architecture suited,\u00a0specifically for cloud.\u00a0It allows separate storage and computing to scale capabilities. So,\u00a0users can separately pay for storage and computation. Snowflake comes with inbuilt usage simplicity. You need not\u00a0invest in installing, managing and configuring any software or hardware. Maintenance, upgrades or fine tuning of the snowflake data platform are all handled by snowflake.\u00a0<\/p>\n\n

The architecture of snowflake cloud data warehouse is unique..<\/p>\n


Snowflake data architecture has a central data repository from which persisted data can be accessed across all the compute nodes in the data platform but query processing is done using MPP compute clusters (Massively Parallel Processing), where individual nodes of the cluster locally store a part of the entire data set. So, the database architecture can be called hybrid with a combo of shared disk and shared nothing database.\u00a0<\/p>\n\n

The entire snowflake architecture can be divided into three independently scalable layers\u00a0<\/p>\n\n

Storage, compute and cloud services<\/strong>\u00a0<\/p>\n\n

    \n
  • The storage layer<\/strong>\u00a0carries all structured, semi structured and unstructured data. The data is stored and maintained, structured, compressed, organized,\u00a0and the\u00a0file size\u00a0is\u00a0determined by Snowflake. It runs independent of the compute layer.\u00a0<\/li>\n<\/ul>\n\n
      \n
    • The compute layer<\/strong>\u00a0is composed of virtual warehouses and performs the data processing tasks for queries. The separation of compute and storage layers ensures that compute resources can automatically scale when the queries are running without the need for redistribution or rebalancing of the data in storage.\u00a0<\/li>\n
    • The cloud services layer<\/strong>\u00a0is a layer that coordinates all activities across Snowflake which includes Authentication, Infrastructure management, Metadata management, Query parsing and, access control\u00a0<\/li>\n<\/ul>\n\n

      The separation of the storage and compute layers and their ability to individually scale can be attributed to Snowflake being famous. Companies can pay for storage and computation separately. So, if an organization has high storage needs but minimum need for CPU cycles, the organization need not pay for an integrated bundle of storage and compute and can pay only for the resources it is using in both. It helps save your cost without sacrificing the goals of your solutions.\u00a0<\/p>\n\n

      SQL that Snowflake uses<\/strong>\u00a0<\/p>\n\n

      Snowflake supports SQL standard set which is a subset of ANSI standards\u00a0( 1999-2003). This implies that most SQL\u00a0statements which execute against Netezza, Teradata or Oracle will execute on Snowflake,\u00a0without requirement of any changes. Snowflake has multiple extensions which ensures quick migration of SQL.\u00a0<\/p>\n\n

      \"snowflake<\/figure>\n\n

      Security on Snowflake<\/strong>\u00a0<\/p>\n\n

      Snowflake security features include\u00a0<\/p>\n\n

        \n
      • IP whitelisting\u00a0<\/li>\n
      • Multifactor\u00a0Authentication\u00a0<\/li>\n<\/ul>\n\n
          \n
        • System for Cross Domain Identity management (SCIM) for managing user and group identities\u00a0<\/li>\n
        • Key pair authentication\u00a0<\/li>\n
        • Ingested data in snowflake is protected through AES256 encryption\u00a0<\/li>\n<\/ul>\n\n

          Snowflake is PCI-DSS compliant, High trust CSF compliant, HIPAA compliant, SOC I Type II and SOC 2 Type II complaint.\u00a0<\/p>\n\n

          Snow flake\u2019s\u00a0Cloud First Approach<\/strong>\u00a0<\/p>\n\n

          Snowflake was built specifically for cloud. Due to its cloud first approach, it can be easily used for multi-cloud and cross-cloud applications and systems.\u00a0<\/p>\n\n

          If you want to implement Snowflake for your organization data, connect with\u00a0Ismile\u00a0Technologies. We have experts who can help optimize costs and provide consultation on every aspect of Snowflake migration.\u00a0<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

          As per snowflake \u201cSnowflake\u00a0is an analytic data warehouse provided as Software-as-a-Service (SaaS).\u00a0Snowflake provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouse offerings.\u201d\u00a0 Snowflake is a cloud-based data warehouse or data storage service that enables adoption of\u00a0multi-cloud strategy. It doesn\u2019t consume IT resources for setting up, configuring […]<\/p>\n","protected":false},"author":3,"featured_media":11493,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[81],"tags":[95,147],"class_list":["post-11490","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-services","tag-cloud","tag-snowflake"],"_links":{"self":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/11490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/comments?post=11490"}],"version-history":[{"count":3,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/11490\/revisions"}],"predecessor-version":[{"id":18847,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/posts\/11490\/revisions\/18847"}],"wp:attachment":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media?parent=11490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/categories?post=11490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/tags?post=11490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}