Snowflake was born from the vision of harnessing the power of the cloud for data analytics. Snowflake’s founders designed a new kind of database that has high scalability & performance when processing large amounts of data.
They have also introduced the concept of the ‘Data Cloud; where thousands of organizations can seamlessly access each other’s data and collaborate to extract more value from their data. It provides a marketplace where users can discover, acquire and monetize live data, services and apps.
In addition, it uses “Snowpark,” a new way to develop pipelines, models and apps using different programming languages.
Microsoft vs. Snowflake
If you are an organization using the Microsoft cloud, in addition to using Snowflake or Databricks, there is also the option of using a Microsoft-based data platform. This data platform will be based on Microsoft Fabric (and before that Microsoft Synapse Analytics). With this, Microsoft offers an alternative for those organizations that have chosen a “Microsoft-aside” architecture, also known as best-of-suite.
Microsoft Fabric is a holistic platform for data integration, engineering, real-time analytics, data science and business intelligence. It leverages the concepts of OneLake and Lakehouse to create an integrated environment for data and analytics. It also leverages AI and machine learning capabilities, and supports open data formats.
Microsoft Fabric makes greater use of open standards and thus provides less onerous lock-in. It also has a simpler and mostly more affordable pricing model and offers better integration with data governance tooling.