Last updated: 28 September 2026.
Quick answer:
Panoply was a managed cloud data warehouse with built-in ELT connectors, founded in Tel Aviv in 2015 and sold as “the smart data warehouse”. It was acquired by SQream in December 2021 and shut down in 2026 when SQream’s business entered insolvency. This site now runs under the same name as an independent directory of data tools and a home for the guides the original team wrote. Nothing here is for sale.
What the product did
The pitch was simple for its time: sync your SaaS tools and databases into a warehouse without writing pipelines, and query them with SQL from any BI tool. Under the hood, Panoply ran on Amazon Redshift (and later Google BigQuery), and the differentiator was the ingestion layer: 60-plus managed connectors, automatic schema handling, and what the company called “automatic data modeling”, meaning it flattened nested JSON from APIs into query-ready tables on your behalf.
In today’s vocabulary it was Fivetran plus Snowflake in one bill, aimed at teams too small to hire a data engineer. That combination is now the default shape of the modern data stack, sold as separate products. Panoply bundled it 5 years early.
Timeline
- 2015: founded in Tel Aviv by Yaniv Leven and Roi Avinoam. Managed warehouse on Redshift with automated ingestion.
- 2016: $7M Series A, San Francisco office opens. Total funding reaches about $13M by September 2017.
- 2018: named a Red Herring Top 100 winner. The data-warehouse guide on this site dates from this period and is still its most-linked content.
- December 2021: acquired by SQream, a GPU-accelerated analytics database company, and run as a separate business unit.
- 2022: Square partnership for seller analytics (April); listed on Google Cloud Marketplace (December).
- 2023: adds built-in visualizations and a “Flex Connector” for arbitrary APIs.
- 2026: the SQream business enters insolvency and the Panoply product is discontinued. The domain is acquired by the team behind this site.
What replaced it
If you were a Panoply customer, or you’re evaluating something like it, the modern equivalents split the job in two:
- Managed ingestion: Fivetran (the closest match for “connectors that just work”), Airbyte (open source, more connectors, more hands-on), Stitch or Hevo for the mid-market.
- The warehouse: Snowflake or BigQuery for most teams, Databricks if machine learning is the point, Redshift if you’re AWS-native.
- Transformation: dbt does what Panoply’s automatic modeling tried to do, with version control and tests.
- Dashboards: Metabase is the nearest thing to Panoply’s built-in visualizations.
For a small team the whole stack lands between $100 and $800 a month. The pricing playbook has the real numbers.
What lives on here
The original team published three long guides that a lot of the internet still links to: the Data Warehouse Guide, Building an Analytics Stack and the Shopify Analytics Guide. They’re preserved at their original URLs, and the Data Warehouse Guide was rewritten for 2026. Nearly 400 blog posts are also kept as an archive, with their original dates and authors.
The old product pages (comparisons, case studies, press releases) are kept for the record and marked as archived. Everything new on this site is editorial: the directory, the Panoply Score and the glossary.
A note on the name
panoply.kinsta.cloud is now published by an independent team with no connection to the former company, its investors or SQream. We don’t sell software, we don’t run a warehouse, and vendors can’t write their own pages here. If you’re looking for support for the discontinued product, there is none; the closest help is the migration paths above.