Amazon Redshift Architecture

Popular models used in Redshift

  • Star
  • Highly denormalised
  • Snowflake

Data types available in Redshift

These adhere to standard SQL data types but alwas handy to have them printed out for ref:

  • Numeric: smallint, integer, bigint, decimal, real, double precision
  • Text: char, varchar
  • Datetime: date, timestamp, timestamptz
  • Other: geometry (brief but insightful example here), boolean

Data loading via COPY command

Impressive versatility here with the ability to cross-account reference specific buckets… and it adheres to the command syntax already familiar to users of DynamoDB, EMR, SSH, etc:

  • specific formats incl CSV, TXT, JSON, ORC, Parquet, Avro
  • compression details
  • encryption details

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oli Steadman

Oli Steadman

Bass/BV @StornowayBand. DataCat @AstraZeneca. Consulting via StoneStreetProductions.