Greenplum + Aginity

Analyze data from the leading massively parallel processing analytic database based on open-source Postgres with Aginity’s unique SQL tools.

Parallel Postgres at Enterprise Scale

Greenplum is a massively parallel processing (MPP) database server with an architecture specially designed to manage large-scale analytic data warehouses and business intelligence workloads.

  • Store, manage, and analyze petabytes of data
  • Analyze a broad set of data times in a single environment—structured, text, geospatial, and graphs
  • Infrastructure-agnostic and available for bare metal, private cloud, and public cloud deployments

Greenplum Features
We Love

Based on open-source projects

  • Execute point queries, fast data ingestion, data science exploration, and long-running reporting queries
  • Flexibility and new capabilities developed with the open-source PostgreSQL and Greenplum Database communities
  • Greenplum’s wide array of advanced analytic features and database objects

Aginity Extends Greenplum

Reuse Your SQL

Save your work in an active analytics catalog so you can easily reuse your SQL rather than re-write it

Find Your Work

Easily find your previous SQL assets from your query history and analytics catalog

Feature Engineering

Develop features once for re-use across your machine learning models

Collaborate with Your Team

Share your SQL work with your teammates securely

What is an active analytics catalog?

Built with your role in mind

Use your SQL in a whole new way

– Save queries, relationships, and snippets once for reuse in SQL statements

– Find previous work in query history or your catalog

– Describe code with rich titles and descriptions help you remember why you wrote it in the first place

Easily design and maintain your data warehouse 

– Create data models and schemas 

– Analyze data across database platforms

– Reuse—don’t recode—your common SQL logic

Produce consistent reports quickly for your team

– Spend less time rewriting SQL and more time reusing it

– Define, document, and save common analytics in your personal catalog

– Efficiently re-run analysis and reports with consistent results

Spend more time training models and less time data wrangling

– Develop reusable features to train machine learning models

– Create flexible commonly used data cleansing SQL

– Use your SQL as objects to make complicated queries more simple

Reuse Your Code. Empower Your Team.

Aginity Pro

Reuse your SQL. Don't recode it.

Aginity Team

Share your team's SQL.

Aginity Greenplum Catalogs

Import our Greenplum toolkits and getting started catalogs from Github into Aginity Pro/Team, giving instant access to hundreds of useful SQL utilities, queries and snippets. 

Active Analytic Catalog

Businesses Using Aginity with Greenplum