The Private Data Warehouse (PDW) is a clone of your Magento BI data warehouse exported to an Amazon Redshift instance. PDW allows you to interact with and explore your data any way you like, whether it's running queries or layering on statistical analysis tools.
Note that PDW is an additional feature we provide for Magento BI, not a requirement. You can still interact with your data via the Data Warehouse Manager. PDW is intended for users who want to directly query their data, build custom applications, or layer third-party tools on top of their warehouse.
Amazon Redshift is fully managed, cloud-based data warehouse. Redshift exhibits far better performance for large-scale analytical queries than do traditional, row-based relational databases like MySQL and PostgreSQL. You can learn more about transactional vs. analytic databases in our Data Strategy Guide.
Spinning up a Redshift instance of your own is required to use the Private Data Warehouse. In this tutorial, we’ll walk you through:
In the next section, we'll walk you through setting up the prerequisites.