Stay Up to Date: Subscribe via RSS »
-
Amazon Redshift now supports fine-grained access control on COPY and UNLOAD commands
Posted On: Jan 12, 2021You can now grant the privilege to run COPY and UNLOAD commands to specific users and groups in your Amazon Redshift cluster to create more fine-grained access control policy.
-
AWS Database Migration Service now supports parallel apply when using Redshift as a target during on-going replications
Posted On: Dec 22, 2020AWS Database Migration Service (AWS DMS) has expanded its functionality by supporting parallel apply when using Redshift as a target during on-going replications. Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. You can start with just a few hundred gigabytes of data and scale to a petabyte or more. By taking advantage of the multithreaded CDC task settings, you can improve the performance of your on-going replications from any DMS supported sources to Amazon Redshift.
-
Amazon Redshift launches RA3.xlplus nodes with managed storage
Posted On: Dec 9, 2020Amazon Redshift RA3 with managed storage is the the latest generation node type and allows you to scale compute and storage independently. Today, we're announcing RA3.xlplus - the third and smallest member of the RA3 node-family. RA3 allows you to size your cluster based primarily on your compute needs. With the introduction of RA3.xlplus, you now have even more compute sizing options to choose from to address a broader set of workload requirements.
-
Amazon Redshift launches the ability to easily move clusters between AWS Availability Zones (AZs)
Posted On: Dec 9, 2020Amazon Redshift, the most widely used data warehouse, now offers the ability to move an Amazon Redshift cluster to another AWS Availability Zone (AZ). The cluster relocation feature moves a cluster to another AZ in one step without requiring application changes. You can invoke the relocation function in cases where resource constraints in a given AZ are disrupting cluster operations such as the ability to resume or resize a cluster. This feature is available for use on clusters leveraging the RA3 instance family and is offered at no additional cost.
-
Amazon Redshift announces Automatic Table Optimization
Posted On: Dec 9, 2020Amazon Redshift, the most widely used cloud data warehouse, announces general availability of Automatic Table Optimization, a new self-tuning capability that optimizes the physical design of tables by automatically setting sort and distribution keys to improve query speed. You can use Automatic Table Optimization to get started with Amazon Redshift easily or optimize production workloads by decreasing the administrative effort required to get the best possible performance.
-
Amazon Redshift introduces data sharing (preview)
Posted On: Dec 9, 2020Amazon Redshift, the most widely used cloud data warehouse, now enables a secure and easy way to share live data across Amazon Redshift clusters. Data sharing enables instant, granular, and high-performance data access across Amazon Redshift clusters without the need to copy or move data. Data Sharing provides live access to the data so that your users always see most up-to-date and consistent information as it is updated in the data warehouse.
-
Amazon Redshift announces support for native JSON and semi-structured data processing (preview)
Posted On: Dec 9, 2020Amazon Redshift, a fully-managed cloud data warehouse, announces preview of native support for JSON and semi-structured data. It is based on the new data type ‘SUPER’ that allows you to store the semi-structured data in Redshift tables. Redshift also adds support for the PartiQL query language to seamlessly query and process the semi-structured data. This functionality enables you to achieve advanced analytics that combine the classic structured SQL data (such as strings, numerics, and timestamps) with the semi-structured SUPER data with superior performance, flexibility, and ease-of-use.
-
Amazon Redshift now includes Amazon RDS for MySQL and Amazon Aurora MySQL databases as new data sources for federated querying (Preview)
Posted On: Dec 9, 2020We announced general availability of Amazon Redshift federated query with support for Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL earlier this year. With this feature, many customers have been able to combine live data from operational databases with the data in Amazon Redshift data warehouse and the data in Amazon S3 data lake environment in order to get unified analytics view across all the data in the enterprise. We now extend the federated query capability to Amazon RDS for MySQL and Amazon Aurora MySQL.
-
Amazon Redshift announces native console integration with partners (Preview)
Posted On: Dec 9, 2020Amazon Redshift, a fully-managed cloud data warehouse, now supports native integration with select AWS partners from within the Amazon Redshift Console. With the new console partner integration, you can accelerate data onboarding and create valuable business insights in minutes by integrating with select partner solutions. With these solutions, you can bring data from applications like SalesForce, Google Analytics, Facebook Ads, Slack, Jira, Splunk, and Marketo into your Amazon Redshift data warehouse in an efficient and streamlined way. It also enables you to join these disparate datasets and analyze them together to produce actionable insights.
-
AWS announces Amazon Redshift ML (preview)
Posted On: Dec 8, 2020Amazon Redshift ML makes it possible for data warehouse users such as data analysts, database developers, and data scientists to create, train, and deploy machine learning (ML) models using familiar SQL commands. Amazon Redshift is the most widely used cloud data warehouse and, with Amazon Redshift ML, you can now leverage Amazon SageMaker, a fully managed machine learning service, using SQL and without moving your data or learning new skills.
-
AWS announces AQUA for Amazon Redshift (preview)
Posted On: Dec 1, 2020AQUA (Advanced Query Accelerator) for Amazon Redshift is available in preview. AQUA provides a new distributed and hardware accelerated cache that brings compute to the storage layer for Amazon Redshift and delivers up to 10x faster query performance than other cloud data warehouses.
-
Amazon Redshift announces support for TIME and TIMETZ data types
Posted On: Nov 11, 2020Amazon Redshift, a fully-managed cloud data warehouse, now adds native support for TIME and TIMETZ data types. TIME data type stores the time of day without timezone information, and TIMETZ stores the time of day including timezone information. This new data type builds on the existing support in Amazon Redshift for DATE, TIMESTAMP and TIMESTAMPTZ data types that can store date and date-and-time values.
-
Amazon Redshift announces automatic refresh and query rewrite for materialized views
Posted On: Nov 11, 2020Amazon Redshift, a fully-managed cloud data warehouse, now supports automatic refresh and query rewrite capabilities to simplify and automate the usage of materialized views. The automatic refresh feature helps administrators to keep materialized views up-to-date, while the automatic query rewrite feature enables end-users to easily benefit from improved query performance.
-
Amazon Redshift announces Open Source JDBC and Python drivers
Posted On: Nov 5, 2020Amazon Redshift JDBC and Python drivers are now open source and available for the user community under the Apache-2.0 license. With this release, customers will gain enhanced visibility to the driver implementation and can contribute to its development. Users can now browse the code for both drivers on the relevant AWS GitHub repositories, submit driver functionality enhancements through Git Pull Requests, and report issues for review.
-
Amazon Redshift announces support for Lambda UDFs and enables tokenization
Posted On: Oct 26, 2020Amazon Redshift, a fully-managed cloud data warehouse, now supports Lambda user-defined functions (UDFs) enabling you to use an AWS Lambda function as a UDF in Amazon Redshift. This functionality enables you to write custom extensions for your SQL query to achieve tighter integration with other services or third-party products. For example, you can write Lambda UDFs to enable external tokenization of data by integrating with vendors like Protegrity, or access other services such as Amazon DynamoDB or Amazon SageMaker in your Redshift query.
-
Amazon Redshift now supports the scheduling of SQL queries by integrating with Amazon EventBridge
Posted On: Oct 22, 2020Amazon Redshift now allows you to schedule your SQL queries for executions in recurring schedules and enables you to build event-driven applications by integrating with Amazon EventBridge. You can now schedule time sensitive or long running queries, loading or unloading your data, or refreshing your materialized views on a regular schedule.
-
Amazon Redshift now supports modifying column compression encodings to optimize storage utilization and query performance
Posted On: Oct 20, 2020Amazon Redshift now allows users to modify the compression encoding of existing columns with a single statement. This new capability makes it easier to maintain the optimal compression encodings in Amazon Redshift to achieve high performance and reduce the storage utilization.
-
Announcing cross-database queries for Amazon Redshift (preview)
Posted On: Oct 15, 2020Amazon Redshift Amazon Redshift now supports the ability to query across databases in a Redshift cluster. With cross-database queries, you can seamlessly query data from any database in the cluster, regardless of which database you are connected to. Cross-database queries can eliminate data copies and simplify your data organization to support multiple business groups on the same cluster. Support for cross-database queries is available on Amazon Redshift RA3 instance types.
-
Amazon Redshift announces support for HyperLogLog Sketches
Posted On: Oct 2, 2020Amazon Redshift introduces support for natively storing and processing HyperLogLog (HLL) sketches. HyperLogLog is a novel algorithm that efficiently estimates the approximate number of distinct values in a data set. HLL sketch is a construct that encapsulates the information about the distinct values in the data set. You can use HLL sketches to achieve significant performance benefits for queries that compute approximate cardinality over large data sets, with an average relative error between 0.01–0.6%.
-
Now it's even easier to connect JetBrains IDEs to Amazon RDS or Redshift Databases
Posted On: Sep 25, 2020With the recent most release of the AWS Toolkit for JetBrains, customers can connect to Amazon RDS or Redshift with only a few clicks. Using the AWS Toolkits for JetBrains, you can use both IAM or credentials in Secrets Manager to connect to Amazon Redshift or RDS databases. You no longer need to have long-lived database credentials, or copy-paste auth tokens from the AWS CLI; credentials are generated by the Toolkit as they are needed instead of being saved to disk.
-
Amazon Redshift Spectrum adds support for querying open source Apache Hudi and Delta Lake
Posted On: Sep 24, 2020You can now use Amazon Redshift to run read queries against tables in your Amazon S3 data lake with open source Apache Hudi or Delta Lake. Amazon Redshift Spectrum, a feature of Amazon Redshift, enables you to query your S3 data lake directly from your Redshift cluster without first loading the data into it, minimizing time to insight.
-
Amazon Redshift announces spatial functionality enhancements
Posted On: Sep 15, 2020Amazon Redshift launched native spatial data processing support in November 2019, with a polymorphic data type GEOMETRY, and more than 40 SQL spatial functions. This capability enables you to store, retrieve, and process spatial data so you can enhance your business insights by integrating spatial data into your analytical queries. Now, Amazon Redshift supports over 30 new spatial functions such as validation, simplification of geometries, new spatial relationships like "Crosses" and "ContainsProperly". Furthermore, Amazon Redshift enhanced the spatial functionality with multiple capabilities such as ODBC/JDBC support for GEOMETRY data, support for importing spatial data in Shapefile format, and spatial join performance improvements.
-
Announcing Data API for Amazon Redshift
Posted On: Sep 10, 2020Amazon Redshift can now be accessed using the built-in Data API, making it easy to build web-services based applications and integrating with services, including AWS Lambda, AWS AppSync, and AWS Cloud9. Redshift Data API simplifies data access, ingest, and egress from languages supported with AWS SDK such as Python, Go, Java, Node.js, PHP, Ruby, and C++ so you can focus on building applications versus managing infrastructure.
-
Amazon Redshift now supports 100K tables in a single cluster
Posted On: Sep 10, 2020Amazon Redshift now supports up to 100K tables in a single cluster for clusters with DC2.8XL, DS2.8XL, RA3.4XL, and RA3.16XL node types. This feature is intended for customers with workloads that require a large number of tables to run with Amazon Redshift without having to split the tables across clusters or storing them in Amazon S3.
-
The new Amazon Redshift console is now available in AWS GovCloud (US) Regions
Posted On: Jul 9, 2020You can now use the new Amazon Redshift console Amazon Redshift in the AWS GovCloud (US) Regions. The new user interface and new features simplify management and improve insights into the health and performance of your Amazon Redshift clusters and workloads.
-
Amazon Redshift RA3 nodes are now available in the Asia Pacific (Mumbai) Region
Posted On: Jun 24, 2020Amazon Redshift RA3 nodes are now available in the Asia Pacific (Mumbai) Region. RA3 nodes enable you to scale and pay for compute and storage independently allowing you to size your cluster based only on your compute needs.
-
Amazon Redshift materialized views support external tables
Posted On: Jun 19, 2020Amazon Redshift adds materialized view support for external tables. With this enhancement, you can create materialized views in Amazon Redshift that reference external data sources such as Amazon S3 via Spectrum, or data in Aurora or RDS PostgreSQL via federated queries.
-
Amazon Redshift now supports writing to external tables in Amazon S3
Posted On: Jun 8, 2020You can now write the results of an Amazon Redshift query to an external table in Amazon S3 either in text or Apache Parquet formats. The external table metadata will be automatically updated and can be stored in AWS Glue, AWS Lake Formation, or your Hive Metastore data catalog. This enables you to easily share your data in the data lake and have it immediately available for analysis with Amazon Redshift Spectrum and other AWS services such as Amazon Athena, Amazon EMR, and Amazon SageMaker. Amazon Redshift Spectrum enables you to power a lake house architecture to directly query and join data across your data warehouse and data lake.
-
Amazon Redshift now delivers better cold query performance by significantly improving compilation times
Posted On: Jun 2, 2020Amazon Redshift now processes queries 2x faster when they need to be compiled. This improvement gives you better query performance when you create a new Redshift cluster, onboard a new workload on an existing cluster, or after a software update of an existing cluster. These query performance improvements are available at no extra charge to you, and no action is needed to enable it on your clusters.
-
Announcing storage controls for schemas in Amazon Redshift
Posted On: Jun 2, 2020You can now restrict the amount of disk space used by a schema in Amazon Redshift. With the CREATE and ALTER SCHEMA statement, administrators can set quotas on the maximum amount of storage consumed by schemas.
-
Amazon Redshift now leverages Bloom filters to improve data lake query performance by up to 2x
Posted On: May 15, 2020Amazon Redshift now leverages Bloom filters to enable early and effective data filtering for up to 2x faster query performance on external tables in Amazon S3. A Bloom filter is a probabilistic, memory-efficient data structure that accelerates join queries at scale by filtering rows that do not match the join relation, significantly reducing the amount of data transferred over the network. Amazon Redshift automatically determines what queries are suitable for leveraging Bloom filters at query runtime. You can power a lake house architecture with Amazon Redshift Spectrum to directly query and join data across your data warehouse and data lake, enabling you to gain unique insights not possible otherwise.
-
Announcing new query monitoring capabilities in the Amazon Redshift console
Posted On: May 7, 2020The Amazon Redshift console simplifies isolating and fixing expensive queries with the redesigned query monitoring page. You can use the redesigned query monitoring page by navigating to cluster details for a cluster and then selecting the Query monitoring tab.
-
Announcing cost controls for Amazon Redshift Spectrum and Concurrency Scaling
Posted On: Apr 23, 2020You can now monitor and control your usage and associated cost for Amazon Redshift Spectrum and Concurrency Scaling features. You can create daily, weekly, and monthly usage limits, and define actions that Amazon Redshift automatically takes if those limits are reached to maintain your budget with predictability. Actions include: logging an event to a system table, alerting with a CloudWatch alarm, notifying an administrator with SNS, and disabling further usage. Amazon Redshift Spectrum enables you to power a lake house architecture to directly query and join data across your data warehouse and data lake, and Concurrency Scaling enables you to support thousands of concurrent users and queries with consistently fast query performance.
-
Amazon Redshift introduces support for multi-factor authentication
Posted On: Apr 20, 2020Amazon Redshift now supports multi-factor authentication (MFA). Customers can use MFA to provide additional security when authenticating to their Amazon Redshift cluster.
-
Amazon Redshift announces general availability for federated querying
Posted On: Apr 16, 2020Amazon Redshift enables you to query data across your operational databases, your data warehouse, and your data lake. With Amazon Redshift Federated Query, you can query live data in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL and integrate it with the data in your Amazon Redshift and Amazon S3 environments.
-
Amazon Redshift now supports changing node types within minutes with elastic resize
Posted On: Apr 6, 2020Amazon Redshift now supports elastic resize across node types. Customers can change node types within minutes and with one simple operation using elastic resize.
-
Amazon Redshift launches RA3.4xlarge nodes with managed storage
Posted On: Apr 2, 2020Starting today, Amazon Redshift RA3.4xlarge nodes are generally available. These new node types support up to 64 TB of Redshift managed storage per node. They enable you to scale and pay for compute and storage independently, allowing you to size your cluster based only on your compute needs.
-
Amazon Redshift RA3 nodes are now available in the Canada, Brazil (São Paulo), and Europe (Paris) regions
Posted On: Mar 30, 2020Amazon Redshift RA3 nodes are now available in the Europe (Paris), Canada (Central), and Brazil (São Paulo) regions. RA3 nodes enable you to scale and pay for compute and storage independently allowing you to size your cluster based only on your compute needs.
-
Amazon Redshift now recommends sort keys for improved query performance
Posted On: Mar 26, 2020Amazon Redshift Advisor now recommends sort keys for frequently queried tables. With the ALTER TABLE command, you can add and change sort keys of existing Redshift tables without having to re-create the tables and without impacting concurrent read or write queries.
-
Amazon Redshift introduces support for materialized views (Generally Available)
Posted On: Mar 12, 2020Starting today, Amazon Redshift supports materialized views functionality. Materialized views provide significantly faster query performance for repeated and predictable analytical workloads such as dashboarding, queries from business intelligence (BI) tools, and ELT (Extract, Load, Transform) data processing.
-
Amazon Redshift launches pause and resume
Posted On: Mar 11, 2020Amazon Redshift now supports the ability to pause and resume a cluster, allowing customers to easily suspend on-demand billing while the cluster is not being used. For example, a cluster used for development can now have compute billing suspended when not in use. While the cluster is paused, you are only charged for the cluster’s storage. This adds significant flexibility in managing operating costs for your Amazon Redshift clusters.
-
Announcing column-level access control for Amazon Redshift
Posted On: Mar 5, 2020Amazon Redshift now supports access control at a column-level for data in Redshift. Customers can use column-level grant and revoke statements to help them meet their security and compliance needs.
-
Announcing Microsoft Azure Active Directory support for Amazon Redshift
Posted On: Feb 19, 2020Customers can now sign-on to Amazon Redshift cluster with Microsoft Azure Active Directory(AD) identities. This allows customers who use Azure AD to be able to sign-on to Redshift without duplicating these identities in Redshift.
-
Amazon Redshift now supports per-second billing
Posted On: Feb 4, 2020Starting today, Redshift will be billed in one-second increments for on-demand clusters. Pricing is still listed on a per-hour basis, but bills are now calculated down to the second and show usage in decimal form.
-
Amazon Redshift Spectrum launches in AWS China (Ningxia) Region, operated by NWCD
Posted On: Jan 9, 2020Amazon Redshift Spectrum is now available in AWS China (Ningxia) region, operated by NWCD.
-
Announcing Amazon Redshift data lake export: share data in Apache Parquet format
Posted On: Dec 3, 2019You can now unload the result of an Amazon Redshift query to your Amazon S3 data lake as Apache Parquet, an efficient open columnar storage format for analytics. The Parquet format is up to 2x faster to unload and consumes up to 6x less storage in Amazon S3, compared to text formats. This enables you to save data transformation and enrichment you have done in Amazon Redshift into your Amazon S3 data lake in an open format. You can then analyze your data with Redshift Spectrum and other AWS services such as Amazon Athena, Amazon EMR, and Amazon SageMaker.
-
Amazon Redshift introduces support for federated querying (preview)
Posted On: Dec 3, 2019The in-preview Amazon Redshift Federated Query feature allows you to query and analyze data across operational databases, data warehouses, and data lakes. With Federated Query, you can now integrate queries on live data in Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL with queries across your Amazon Redshift and Amazon S3 environments.
-
Amazon Redshift introduces RA3 nodes with managed storage enabling independent compute and storage scaling
Posted On: Dec 3, 2019Starting today, Amazon Redshift RA3 nodes with managed storage are generally available. RA3 nodes enable you to scale and pay for compute and storage independently allowing you to size your cluster based only on your compute needs. Now you can analyze even more data cost-effectively.
-
Amazon Redshift introduces support for materialized views (preview)
Posted On: Nov 27, 2019Starting today, Amazon Redshift adds support for materialized views in preview. Materialized views provide significantly faster query performance for repeated and predictable analytical workloads such as dashboarding, queries from business intelligence (BI) tools, and ELT (Extract, Load, Transform) data processing.
-
Amazon Redshift now supports elastic resize scheduling
Posted On: Nov 26, 2019The Amazon Redshift cluster elastic resize operation can now be automated using a scheduler that allows you to automatically resize clusters to accommodate changes in workloads that occur on a regular basis. For example, you can now automatically expand a cluster to accommodate heavier workloads as well as shrink a cluster to accommodate lighter workloads at specific times of day. This will allow you to automate cluster resizing to balance price and performance when using Redshift.
-
Amazon Redshift introduces Automatic Table Sort, an automated alternative to Vacuum Sort
Posted On: Nov 25, 2019Amazon Redshift now provides an efficient and automated way to maintain sort order of the data in Redshift tables to continuously optimize query performance. The new automatic table sort capability offers simplified maintenance and ease of use without compromising performance and access to Redshift tables. Automatic table sort complements Automatic Vacuum Delete and Automatic Analyze and together these capabilities fully automate table maintenance. Automatic table sort is now enabled by default on Redshift tables where a sort key is specified.
-
Amazon Redshift Spectrum launches in five additional AWS regions
Posted On: Nov 22, 2019Amazon Redshift Spectrum is now available in five additional AWS regions: EU (Paris, Stockholm), Middle East (Bahrain), Asia Pacific (Hong Kong), and the AWS GovCloud (US-West) Region.
-
Amazon Redshift announces support for spatial data
Posted On: Nov 21, 2019With the addition of a new polymorphic data type, GEOMETRY, Amazon Redshift now provides the ability to natively process spatial data. This capability enables customers to store, retrieve, and process spatial data so you can enhance your business insights by integrating spatial data into your analytical queries.
-
Amazon Redshift announces a console refresh to improve management and monitoring of your data warehouse
Posted On: Nov 15, 2019Amazon Redshift now offers a new console for Redshift users. The new user interface and new features simplify management and improve insights into the health and performance of your Redshift clusters and workloads .
-
Amazon Redshift launches cross-instance restore
Posted On: Nov 15, 2019Amazon Redshift now supports cross-instance restore to allow you to restore Redshift snapshots to clusters that are different sizes or running different node types. This simplifies snapshot restore workflows to support your evolving use cases. You can change instance type and count based on compute resources, storage capacity and cost requirements of your specific workloads. For example, you can cross-instance restore a snapshot of your production dense-compute cluster with small instances into a cluster with powerful large instances to serve more demanding workloads, or to a lower-cost development cluster. Once a cluster is restored, you can resize it as your performance and capacity needs change over time.
-
Amazon Redshift now supports changing table sort keys dynamically
Posted On: Nov 7, 2019Amazon Redshift now enables users to add and change sort keys of existing Redshift tables without having to re-create the table. The new capability simplifies user experience in maintaining the optimal sort order in Redshift to achieve high performance as their query patterns evolve and do it without interrupting the access to the tables.
-
Amazon Redshift Improves Performance of Inter-Region Snapshot Transfers
Posted On: Oct 14, 2019Performance enhancements have been made that allow Amazon Redshift to copy snapshots across regions much faster, allowing customers to support much more aggressive Recovery Time Objective (RTO) and Recovery Point Objective (RPO) Disaster Recovery (DR) policies. The performance of copying a snapshot across regions is now orders of magnitude faster than what was achievable earlier this year, with up to 40,000 MB/s transfer rates observed.
-
Amazon Redshift introduces AZ64, a new compression encoding for optimized storage and high query performance
Posted On: Oct 8, 2019AZ64, a proprietary compression encoding that is designed to achieve a high compression ratio and improved query performance, is now available. Innovations in the AZ64 algorithm efficiently compress small groups of data values and leverage SIMD instructions for data parallel processing. This encoding results in significant storage savings in most cases relative to LZO and ZSTD encodings and optimal de-compression performance for numeric and date/time data stored in Amazon Redshift.
-
Amazon Redshift announces automatic workload management and query priorities
Posted On: Sep 20, 2019Amazon Redshift now makes it easy to maximize query throughput and get consistent performance for your most demanding analytics workloads. Automatic workload management (WLM) uses machine learning to dynamically manage memory and concurrency helping maximize query throughput. In addition, you can now easily set the priority of your most important queries, even when hundreds of queries are being submitted.
-
Amazon Redshift now recommends distribution keys for improved query performance
Posted On: Aug 20, 2019Amazon Redshift Advisor now recommends the most appropriate distribution key for frequently queried tables to improve query performance. The Advisor generates tailored recommendations by analyzing the cluster's performance and query patterns. You can then use the ALTER TABLE ALTER DISTKEY command to add or modify the distribution key of a table, without impacting concurrent read or write queries.
-
Amazon Redshift now supports column level access control with AWS Lake Formation
Posted On: Aug 9, 2019Amazon Redshift Spectrum now supports column level access control for data stored in Amazon S3 and managed by AWS Lake Formation. Column level access control can be used to limit access to only the specific columns of a table rather than allowing access to all columns of a table.
-
Amazon Redshift Launches Concurrency Scaling in Five additional AWS Regions, and Enhances Console Performance Graphs in all supported AWS Regions
Posted On: Aug 6, 2019Amazon Redshift Concurrency Scaling is now available in five additional AWS Regions: Canada (Central), EU (Frankfurt), Asia Pacific (Sydney), Asia Pacific (Singapore), and Asia Pacific (Seoul). The Amazon Redshift Management Console presents performance graphs for monitoring Concurrency Scaling activity and associated performance gains related to query concurrency, throughput, latency, and queueing on your Amazon Redshift cluster.
-
New Digital Training Course Now Available: Data Analytics Fundamentals
Posted On: Jun 27, 2019Data Analytics Fundamentals, which replaces the digital training course Big Data Technology Fundamentals, will teach you the latest on how to seamlessly plan a data analysis solution using the suite of AWS services. In this 3.5-hour, self-paced digital course, you will understand the big picture of data analysis, how to plan data analysis solutions, as well as the data analytic processes involved in those solutions.
-
New Quick Start deploys a data lake with SnapLogic on AWS
Posted On: May 28, 2019This Quick Start builds a data lake environment on the Amazon Web Services (AWS) Cloud in about 15 minutes by deploying SnapLogic components and AWS services such as Amazon Simple Storage Service (Amazon S3) and Amazon Redshift.
-
Amazon Redshift now supports stored procedures
Posted On: May 17, 2019Amazon Redshift now supports SQL stored procedures to make migration to Amazon Redshift easier. Stored procedures are used to encapsulate logic for data transformation, data validation, and business-specific logic. By combining multiple SQL steps into a stored procedure, you can reduce round trips between your applications and the database.
-
Amazon Redshift now provides more control over snapshots
Posted On: Apr 4, 2019Amazon Redshift automatically takes incremental snapshots (backups) of your data every 8 hours or 5 GB per node of data change. You now get more information and control over a snapshot including the ability to control the automatic snapshot's schedule.
-
Amazon Redshift now automatically picks the best distribution style
Posted On: Mar 28, 2019Amazon Redshift can now automatically assign an optimal distribution style based on the size of the table data. With the automatic selection of the right distribution style, you get better query performance and storage space utilization across nodes.
-
Amazon Redshift announces Concurrency Scaling: Consistently fast performance during bursts of user activity
Posted On: Mar 27, 2019Amazon Redshift now automatically and elastically scales query processing power to provide consistently fast performance for hundreds of concurrent queries. Concurrency Scaling resources are added to your Redshift cluster transparently in seconds, as concurrency increases, to process queries without wait time. Once workload demand subsides, Amazon Redshift automatically shuts down Concurrency Scaling resources to save you cost. You can continue to use your existing applications and Business Intelligence tools without any changes.
-
Use AWS Secrets Manager to Rotate Credentials for Amazon DocumentDB and Amazon Redshift
Posted On: Mar 15, 2019Starting today, you can use AWS Secrets Manager to rotate credentials for Amazon DocumentDB and Amazon Redshift automatically, in addition to rotating credentials for all database types hosted on Amazon Relational Database Service (Amazon RDS). Rotating credentials is an AWS Identity and Access Management (IAM) best practice that helps you meet your security and compliance requirements.
-
Amazon Redshift now updates table statistics by running ANALYZE automatically
Posted On: Jan 18, 2019Analyze operations now run automatically on your Amazon Redshift tables in the background to deliver improved query performance and optimal use of system resources.
-
Amazon Redshift now runs VACUUM DELETE automatically
Posted On: Dec 19, 2018Amazon Redshift now automatically runs the VACUUM DELETE operation to reclaim disk space occupied by rows that were marked for deletion by previous UPDATE and DELETE operations. It also defragments the tables to free up consumed space and improves performance for your workloads.
-
Amazon Redshift now available in the EU (Stockholm) AWS Region
Posted On: Dec 12, 2018Amazon Redshift is now available in the EU (Stockholm) AWS Region.
-
Amazon Redshift announces Deferred Maintenance and Advance Event Notifications
Posted On: Nov 20, 2018You can now defer maintenance of your Amazon Redshift cluster to keep your data warehouse running without interruption during critical business periods. You will now also receive advance notifications from Amazon Redshift prior to any upcoming maintenance on your cluster.
-
Amazon Redshift announces Elastic resize: Add and remove nodes in minutes
Posted On: Nov 15, 2018You can now quickly resize your Amazon Redshift cluster in minutes by adding nodes to get better performance and more storage for demanding workloads or by removing nodes to save cost.
-
Amazon Redshift now available in AWS GovCloud (US-East) Region
Posted On: Nov 12, 2018We are excited to announce that Amazon Redshift is now available in the AWS GovCloud (US-East) Region.
-
Amazon Redshift announces Query Editor to run queries directly from the AWS Management Console
Posted On: Oct 4, 2018You can now query data in your Amazon Redshift cluster directly from your AWS Management console, using the new Query Editor. This provides an easier way for admins and end users to run SQL queries without having to install and setup an external JDBC/ODBC client. Query results are instantly visible within the console.
-
Amazon Redshift announces support for nested data with Redshift Spectrum
Posted On: Aug 8, 2018You can now use Amazon Redshift to directly query nested data in Apache Parquet, Apache ORC, JSON and Amazon Ion file formats stored in external tables in Amazon S3. Redshift Spectrum, a feature of Amazon Redshift, enables you to use your existing Business Intelligence tools and intuitive and powerful SQL extensions to analyze both scalar and nested data stored in your Amazon S3 data lake.
-
Amazon Redshift automatically enables short query acceleration
Posted On: Aug 8, 2018Amazon Redshift now enables short query acceleration by default to speed up execution of short-running queries such as reports, dashboards, and interactive analysis. Short query acceleration uses machine learning to provide higher performance, faster results, and better predictability of query execution times.
-
Amazon Redshift announces support for lateral column alias reference
Posted On: Aug 7, 2018Amazon Redshift now enables you to write queries that refer to a column alias within the same query immediately after it is declared, improving the readability of complex SQL queries.
-
Amazon Redshift announces new metrics to help optimize cluster performance
Posted On: Jul 30, 2018You can now get a detailed view of your Amazon Redshift cluster performance with the Workload Execution Breakdown graph on the console Database Performance page or the QueryRuntimeBreakdown metric via Cloudwatch. You can use these new metrics to optimize cluster performance to provide higher throughput and faster results.
-
Amazon Redshift now supports current and trailing tracks for release updates
Posted On: Jul 26, 2018Amazon Redshift is now available on two different release cycles - Current Maintenance Track and Trailing Maintenance Track. With the Current Maintenance Track you will get the most up-to-date certified release version with the latest features, security updates, and performance enhancements. With the Trailing Maintenance Track you will be on the previous certified release.
-
Amazon Redshift now provides customized best practice recommendations with Advisor
Posted On: Jul 26, 2018Amazon Redshift announces Advisor, a new feature that provides automated recommendations to help you optimize database performance and decrease operating costs. Advisor is available via the Amazon Redshift console at no charge.
-
Amazon Redshift announces free upgrade for DC1 Reserved Instances to DC2
Posted On: Jul 19, 2018You can now upgrade your Amazon Redshift DC1 Reserved Instances to DC2 Reserved Instances for the remainder of your DC1 reserved term, and get up to twice the performance of DC1 at the same price. DC2 nodes are designed for demanding data warehousing workloads that require low latency and high throughput.
-
Amazon Redshift Can Now COPY from Parquet and ORC File Formats
Posted On: Jun 5, 2018You can now COPY Apache Parquet and Apache ORC file formats from Amazon S3 to your Amazon Redshift cluster. Apache Parquet and ORC are columnar data formats that allow users to store their data more efficiently and cost-effectively. With this update, Redshift now supports COPY from six file formats: AVRO, CSV, JSON, Parquet, ORC and TXT.
-
Amazon Redshift Makes Short Query Acceleration Self-Optimizing
Posted On: May 31, 2018Amazon Redshift improved Short Query Acceleration (SQA) by automating the maximum time-out setting for short queries. On Nov 20th, 2017, we announced SQA which uses machine learning algorithms to predict the execution time of a query, and move short-running queries to an express queue for immediate processing. In the past, SQA needed user defined 'maximum run time' (between 1-20 seconds) to identify short queries. With this update, by setting the maximum short query run time to 'dynamic,' you can let Redshift automate this setting. In addition, SQA’s improved machine learning algorithm adapts the maximum run time to the changing workload, making it easier to use to minimize short query queuing time and increase throughput.
-
Amazon Redshift Adds New CloudWatch Metrics for Easy Visualization of Cluster Performance
Posted On: May 23, 2018You can now monitor the performance and health of your Amazon Redshift cluster with two new Amazon CloudWatch metrics, Query Throughput and Query Duration. These metrics monitor Redshift cluster performance and provide insights to adjust workload management settings to improve query performance. We have also improved the user interface to view the Query Performance Data on the console.
-
Stream Real-Time Data in Apache Parquet or ORC Format Using Amazon Kinesis Data Firehose
Posted On: May 10, 2018We have added support for Apache Parquet and Apache ORC formats in Amazon Kinesis Data Firehose, so you can stream real-time data into Amazon S3 for cost-effective storage and analytics.
-
Amazon Redshift announces Dense Compute (DC2) nodes in the AWS GovCloud (US) Region with twice the performance as DC1 at the same price
Posted On: Apr 25, 2018You can now launch Amazon Redshift clusters on our second-generation Dense Compute (DC2) nodes in the AWS GovCloud (US) Region. DC2 nodes deliver up to twice the performance as the previous generation DC1 nodes, at the same price.
-
Amazon Redshift Spectrum Launches in Two Additional AWS Regions
Posted On: Mar 15, 2018Amazon Redshift Spectrum is now available in two additional AWS regions: Asia Pacific (Mumbai) and South America (Sao Paulo).
-
Amazon Redshift Doubles the Number of Tables You Can Create in a Cluster
Posted On: Mar 15, 2018Amazon Redshift increases the number of tables you can create to 20,000 for 8xlarge cluster node types. Doubling the number of tables gives you more control and granularity for organizing data in your cluster.
-
Amazon Redshift Spectrum Now Supports Scalar JSON and Ion Data Types
Posted On: Mar 8, 2018You can now use Amazon Redshift Spectrum to directly query scalar JSON and Ion data types stored in external tables in Amazon S3 - without loading or transforming the data.
-
Amazon Redshift Introduces Late Materialization for Faster Query Processing
Posted On: Dec 21, 2017Amazon Redshift now uses late materialization to reduce the amount of data scanned and improve performance for queries with predicate filters.
-
Amazon Redshift Spectrum Launches in Three Additional AWS Regions
Posted On: Dec 19, 2017Amazon Spectrum is now available in three additional AWS regions: US West (Northern California), EU (London), and Canada (Central).
-
Announcing the AWS EU (Paris) Region
Posted On: Dec 18, 2017AWS is excited to announce immediate availability of the new AWS EU (Paris) Region. Paris joins Ireland, Frankfurt, and London as the fourth AWS Region in Europe and as the 18th region worldwide, bringing the global total of AWS Availability Zones to 49.
-
Amazon Redshift Spectrum Now Supports DATE Data Type
Posted On: Dec 21, 2017You can now leverage Amazon Redshift Spectrum to query DATE data type stored in Optimized Row Columnar (ORC) and text files in Amazon S3. For example, you can use the DATE data type to query clickstream data within specific time windows to gain insights into business trends. To learn more, visit our documentation.
-
Amazon Redshift Introduces Result Caching for Sub-Second Response for Repeat Queries
Posted On: Nov 21, 2017Amazon Redshift improves performance for repeat queries by caching the result and returning the cached result when queries are re-run.
-
Amazon Redshift Spectrum is Now Available in Four Additional AWS Regions, and Enhances Query Performance in All Available AWS Regions
Posted On: Nov 20, 2017Amazon Redshift Spectrum is now available in four additional AWS Regions: EU (Frankfurt), Asia Pacific (Sydney), Asia Pacific (Singapore), and Asia Pacific (Seoul). Additionally, large bzip2-compressed files and ORC files are automatically split to enhance query performance in all available AWS Regions.
-
Amazon Redshift Uses Machine Learning to Accelerate Dashboards and Interactive Analysis
Posted On: Nov 20, 2017Amazon Redshift introduces Short Query Acceleration to speed up execution of short running queries. Short Query Acceleration provides higher performance, faster results, and better predictability of query execution times.
-
Amazon Redshift Allows Regular Users to be Granted Access to All Rows in Selected System Tables
Posted On: Nov 17, 2017Starting today, Amazon Redshift allows Superusers to grant regular users access to all rows in selected system tables and views.
-
Amazon Redshift Improves Performance by Automatically Hopping Queries Without Restarts
Posted On: Nov 17, 2017Starting today, Amazon Redshift improves query performance by automatically moving read and write queries to the next matching queue without restarting the moved queries. This enhancement to Workload Management enables more efficient use of resources to improve query performance.