101. Redshift Overview

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/5

encourage image

There's no tags or description

Looks like no tags are added yet.

6 Terms

1
New cards

Redshift

Fully managed petabyte-scale data warehouse based on PostgreSQl, but not used for Online Transaction Processing like RDS, but rather for OLAP – online analytical processing

2
New cards

Redshift loads data

Once every hour

3
New cards

Redshift stores data in

Columns

4
New cards

MPP

Massively Parallel Query Execution

5
New cards

Redshift price

Pay as you go based on the instances provisioned

6
New cards

Redshift Serverless

• Automatically provisions and scales data warehouse underlying capacity

• Run analytics workloads without managing data warehouse infrastructure

• Pay only for what you use (save costs)

• Use cases: Reporting, dashboarding applications, real-time analytics...