analytics-dictionary / tool overview / data infrastructure

Amazon Redshift

Amazon Redshift is AWS data warehouse service for large-scale analytics.

Written by Reflective Data experts · updated Oct 5, 2026

It uses columnar storage and parallel processing, with provisioned clusters or a serverless option. It integrates closely with other AWS services such as S3.

It is a natural fit for teams that are already invested in AWS.

Amazon S3 Data warehouse Snowflake

// how we can help

We design, build and optimise data warehouses and the cloud infrastructure around them. Data infrastructure services → · Managed data pipelines

Fivetran

Fivetran is a managed ELT service with connectors for many SaaS tools and databases.

analytics-data-pipeline.md

Data pipeline

A data pipeline is an automated process that moves data from one or more sources to…

row-level-security.md

Row-level security

Row-level security restricts which rows of a table a user can see, based on who they…

role-based-access-control.md

Role-based access control (RBAC)

RBAC gives people access to data and tools based on their role, rather than granting permissions…

single-sign-on.md

Single sign-on (SSO)

Single sign-on lets users access many tools with one login managed by a company identity provider.

data-masking.md

Data masking

Data masking hides or obscures sensitive values, so people can work with data without seeing personal…

← full analytics dictionary