Snowflake’s underlying architecture layers are not disclosed in detail by Snowflake, but overall they also use an online scaling platform with a clear separation of storage and compute resources. Databases in this sense have separate storage areas but share the same query engine (i.e. (In fact, Panoply manages the position of your database under the hood and could potentially locate your database on a separate Redshift cluster.) With Panoply, you should be able to create multiple databases, which then are just Amazon Redshift databases. Different Panoply Clients share the same infrastructure so highly demanding query loads of one client could affect the query performance of another client. This architecture allows for online scaling by adding more nodes to a cluster. Amazon redshift is a scalable database with roots in the Postgres database architecture and added cluster abilities it runs solely as an Amazon Web Service. Panoply uses the Amazon Redshift Data Service together with the Elasticsearch Database and Amazon S3 Storage and Spark Compute Architecture under the hood. Regarding Panoply and Snowflake, the comparison is based only on the information they are sharing publicly on the Internet. The three platforms are not targeting the exact same audiences and feature sets, and as such, are not directly comparable in all aspects. To get a good overview of the overall data management tasks, we start with a rather complete list of criteria concerning the data engineering and analytics life cycle. For a data warehouse to serve as a long term manageable basis for analytics, more functionality is required. These are considered the defining features of what we call a Cloud Data Warehouse Platform and distinguishes them from other cloud data services that allow you to present or process data in the cloud, but do not allow you to store data in large amounts.Īlthough storing and processing data is at the heart of a data warehouse, it doesn’t stop there.

In particular, each service provides compute and storage resources for data. Panoply and its investors clearly believe that the company’s all-in-one platform gives it a competitive edge, though.Snowflake, Panoply, and Repods are cloud services that allow you to ingest, process, store, and access data in a managed cloud infrastructure. That market is now more competitive than ever, too, with incumbents like Snowflake, Databricks and others (including all of the hyper clouds) all aiming for their slice of the market. There’s nary a business left, after all, that isn’t looking to gain more insights from the copious amounts of data they gather every single day now. Today, though, there can be little doubt that we’re in a booming market for data warehousing and analytics services.

In some ways, Panoply was maybe just a bit early to the market.

“We aspire to make analysts’ lives simpler and more productive by making it easier for them to sync, store, and access their data, and this funding will go a long way toward that mission,” says CEO and co-founder Yaniv Leven in today’s announcement. The company says it will use the new funding to expand its sales and marketing efforts. Panoply.io Raises $1.3M Seed Round For Its Data Warehousing Platform

Panoply vs snowflake