Difference between revisions of "Redshift Features"

From Glitchdata
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
 
* DynamoDB Streams
 
* DynamoDB Streams
 
** Attempting streaming...
 
** Attempting streaming...
 +
* JDBC and ODBC connections
 +
 +
==Limitations==
 +
* https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html
 +
* https://www.flydata.com/blog/redshift-vs-postgres/
 +
  
  
 
[[Category: Redshift]]
 
[[Category: Redshift]]

Latest revision as of 14:49, 11 July 2019


  • 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

Limitations