Redshift Features

From Glitchdata
Revision as of 14:49, 11 July 2019 by Jasonchen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

  • Amazon Redshift is based on PostgreSQL 8.0.2
  • PostgreSQL 9.x includes some features that are not supported in Amazon Redshift. In addition, there are important differences between Amazon Redshift SQL and PostgreSQL 8.0.2".[2]
  • Sharding
  • Encryption at Rest using AWS keys
  • Multiple indexes
    • Global Secondary indexes available. (GSI)
  • Partitioning
    • GSI facilitates Partitioning
  • DynamoDB Streams
    • Attempting streaming...
  • JDBC and ODBC connections