Introduction

Yellowbrick is an elastic Data Warehouse designed for the most demanding batch, real-time, ad hoc, and mixed workloads. It provides an ACID-compliant, Massively Parallel Processing (MPP) SQL relational database that enables thousands of concurrent users to run complex SQL queries against highly normalized schemas and petabytes of data.

Yellowbrick deploys as an appliance in a data center or as software running in a public cloud account. It presents a PostgreSQL interface to the ecosystem and supports the standard ODBC and JDBC PostgreSQL open source drivers, enabling compatibility with a wide range of PostgreSQL-compatible tools and services.

Architecture

While the database software is the same version in all deployments, the architecture of Yellowbrick on an appliance differs from the architecture in the public cloud.

Kubernetes in Public Cloud

Yellowbrick Enterprise deploys on AWS, Azure, and GCP as a Kubernetes app. In the public cloud, the architecture separates compute from storage and supports multiple elastic compute clusters, each containing one or more compute nodes.

Appliance in a Data Center

The appliance combines the storage and compute into a single multi-node compute cluster. For high availability, all hardware components are redundant — this includes the power, cooling, network, storage, and compute elements. If you purchase an appliance, the Yellowbrick team takes care of the data center installation for you.

Document Types

Tutorials

If you're looking to build something specific or are more of a hands-on learner, check out the tutorials section. This is the best place to get started.

These are the best ones to get started with:

• Walkthrough Tour
• Loading Data
• Connecting with DBeaver

Explore the full list of Yellowbrick tutorials here.

How-to Guides

Here you’ll find short answers to “How do I….?” types of questions. These how-to guides don’t cover topics in-depth — you’ll find that material in the Tutorials and the Reference. However, these guides help you quickly accomplish common tasks using Yellowbrick.

Concepts Guide

Introductions to all the key parts of Yellowbrick you need to know. Here you'll find details of the Yellowbrick architecture and concepts.

Reference

Head to the reference section for full documentation on all SQL data types, functions, and commands in Yellowbrick.

Ecosystem Integration

Yellowbrick supports a rich ecosystem of tools via native and PostgreSQL-compatible connectors. If you're looking to build solutions involving other components, check out the growing list of Yellowbrick integrations.