Redshift Features

From Glitchdata
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