Amazon today announced a massive update to its Redshift service. In short, developers have gained more options and more ways to organize and query their petabyte-scale data warehouse.

The new additions include distributed tables (control the distribution of a table’s rows across compute nodes), remote loading (load data from remote hosts across an SSH connection), approximate count distinct (use a variant of the COUNT function to approximate the number of matching rows), workload queue memory management (apportion available memory across work queues), key rotation (rotate keys for an encrypted cluster), HSM support (manage the encryption master and cluster encryption keys), database auditing and logging (log connections and user activity to Amazon S3), and SNS notification (issue notifications to an Amazon SNS topic when certain events occur).

Amazon Redshift – New Features Galore

See also – Amazon Web Services launches “petabyte-scale” Redshift data warehouse, with NASA, Netflix and others

Image Credit: Emmanuel Dunand/Getty Images