英文:
Why is BigQuery a PAAS and Snowflake a SAAS
问题
Snowflake和BigQuery都是云数据仓库，尽管底层架构略有不同，但它们解决了相同的目的。
然后我无法理解为什么Snowflake被称为SaaS，而BigQuery被谷歌称为PaaS。
英文:
Snowflake and Big Query both are cloud data warehouse and although the architecture under the hood is little different, they solve the same purpose.
Then I cannot wrap my head around for why Snowflake is called as Saas and BigQuery is term by google as Paas.
答案1
得分: 1
Snowflake 是专门为云提供商，如 Google Cloud Platform、Amazon Web Services 和 Azure 构建的，它几乎不需要管理或操作开销，就像 SaaS 的定义一样。它是一个云数据仓库，可以由提到的云平台托管，并作为分布式软件传递。Snowflake 也可以作为 PaaS，但 PaaS 需要更多对底层硬件或软件的管理（比 SaaS 多），而 Snowflake 不属于此类。
BigQuery 被归类为 PaaS，因为它是本地 Google Cloud Platform 数据仓库和云平台服务。它仅在 Google Cloud Platform 上运行，不能在任何云提供商上运行，与 Snowflake 不同。PaaS 提供并管理了应用程序开发所需的所有硬件和软件资源，这是在使用 BigQuery 时执行的操作。
基本上，它们仅基于管理范围以及每个数据仓库的管理方式有所不同。您可以查阅此文档，以帮助您更好地将 Snowflake 视为 SaaS，BigQuery 视为 PaaS。
英文:
As Snowflake was built purposely for cloud providers such as Google Cloud Platform, Amazon Web Services, and Azure, it requires almost no management or operational overhead same as how SaaS is being defined. It is a cloud data warehouse which can be hosted by the cloud platforms mentioned and passed as a distibuted software. Snowflake can also serve as PaaS, but PaaS requires more management (than SaaS) of the underlying hardware or software which Snowflake does not fall under.
BigQuery is categorized as PaaS since it is a native Google Cloud Platform data warehouse and a cloud-based platform service. It performs its function only on Google Cloud Platform and cannot run on any cloud provider, unlike Snowflake. PaaS delivers and manages all the hardware and software resources needed for application development which is being done when we are using BigQuery.
Basically, they just differ based on the scope of management and how each data warehouse is being managed. You can go through this documentation to help you better associate Snowflake as SaaS and BigQuery as PaaS.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论