---
title: "Redshift | Skills We Assign For | Azendo"
description: "Redshift as a data warehouse — distribution keys, workload management, and the Azendo roles assigned for it."
url: "https://azendo.co/skills/redshift/"
---

[Skills](https://azendo.co/skills/) Data stores and query 

# Redshift.

Redshift is AWS's data warehouse: columnar, massively parallel, integrated with S3 and the rest of the AWS estate. Distribution and sort keys decide how data is spread across nodes and therefore how fast queries run.

## Where Redshift fits on a long engagement.

Redshift performance is a function of physical design far more than of query text. Distribution style decides whether a join happens locally or redistributes data across the network, and a table distributed on the wrong column turns a fast join into a cluster-wide data movement. That decision is the main lever and the one most often made by default.

Concurrency is the other recurring problem. A small number of heavy queries can occupy the cluster and leave dashboards timing out, and without workload management to separate the two, one analyst's exploratory query becomes everyone's outage.

## What an assigned team does with Redshift.

Warehouses degrade quietly. Tables grow, statistics go stale, vacuum is not run, and queries that were fast last year now take minutes with nothing in the change log to explain it.

Routine maintenance and a periodic review of the physical design is ongoing work rather than a migration task, and it is the kind of standing responsibility described in [how an assignment runs](https://azendo.co/how-it-works/).

## What we use Redshift for.

* Distribution designed for the joins Keys chosen so the common joins stay local rather than redistributing across nodes.
* Dashboards protected from ad-hoc queries Workload management separating interactive from exploratory, so one does not starve the other.
* Maintenance that keeps performance stable Vacuum and statistics on a schedule, so degradation is prevented rather than investigated.

## How Redshift capacity is assigned.

Warehouse capacity is assigned under [managed data services](https://azendo.co/services/data-engineering/), with physical design reviewed periodically rather than fixed at load.

## Roles we assign Redshift for

* [Data Engineer Data engineering](https://azendo.co/services/data-engineering/data-engineer/)

## Service lines it sits in

* [Data engineering](https://azendo.co/services/data-engineering/)

Capacity is agreed as a committed monthly capacity across a discipline, not per skill.

## Related in data stores and query

* [SQL — skill we assign for](https://azendo.co/skills/sql/)
* [PostgreSQL — skill we assign for](https://azendo.co/skills/postgresql/)
* [MySQL — skill we assign for](https://azendo.co/skills/mysql/)
* [MongoDB — skill we assign for](https://azendo.co/skills/mongodb/)
* [Snowflake — skill we assign for](https://azendo.co/skills/snowflake/)
* [BigQuery — skill we assign for](https://azendo.co/skills/bigquery/)
* [Redis — skill we assign for](https://azendo.co/skills/redis/)
* [Prisma — skill we assign for](https://azendo.co/skills/prisma/)

## Tell us what your roadmap needs Redshift for.

A service delivery manager replies with the disciplines we would assign, the monthly capacity and what the first month looks like.

[All skills we assign for](https://azendo.co/skills/)