Amazon Redshift, a fully-managed cloud data warehouse, now adds support for Recursive Common Table Expression (CTE). Starting today, you can use a Recursive CTE on your Redshift cluster to query hierarchical data such as organizational charts where employees reports to other employees (managers), or multi-level product orders where a product consists of many components, which in turn consist of other components.

Starting today, AWS Transit Gateway Network Manager is now available in the AWS Asia Pacific (Osaka) Region.

You now can use the AWS SDK for Java 2.x with DynamoDB local, the downloadable version of Amazon DynamoDB. With DynamoDB local, you can develop and test applications by using a version of DynamoDB running in your local development environment without incurring any additional costs. DynamoDB local does not require an internet connection, and it works with your existing DynamoDB API calls. 

To learn more about the AWS SDK for Java 2.x, see the official AWS SDK for Java – Version 2  on GitHub. For more information about DynamoDB local, see Setting Up DynamoDB Local (Downloadable Version) .

Amazon FinSpace is a new fully managed data management and analytics service that makes it easy to store, catalog, and prepare financial industry data at scale, reducing the time it takes for financial services industry (FSI) customers to find and access all types of financial data for analysis from months to minutes.  

Starting today Amazon Relational Database Service (RDS) for Oracle and Amazon RDS for PostgreSQL now support Amazon RDS Encrypted Cross-Region Automated Backups. This feature extends the existing RDS backup functionality, giving you the ability to set up automatic replication of system snapshots and transaction logs from a primary AWS Region to a secondary AWS Region. These backups are encrypted using an AWS KMS customer master key in the destination Region.

Amazon Redshift data sharing allows you to share live, transactionally consistent data across different Redshift clusters without the complexity and delays associated with data copies and data movement. Ability to share data across clusters that are in the same AWS account is already generally available. Now you can preview cross-account data sharing to share data across Redshift clusters in different AWS accounts, both within and outside your organization. Cross-account data sharing is available on all Redshift RA3 node types. There is no additional cost to use cross-account sharing on your Amazon Redshift clusters. 

The Amazon Chime SDK for JavaScript now provides a way for builders to prioritize video streams according to their online meeting user case. If there is insufficient bandwidth to download all available video streams, the Amazon Chime SDK uses the video prioritization policy to maximize the fidelity and quality of high-priority video streams.

The AWS Cloud Development Kit (AWS CDK) v2 is now available for Developer Preview, and offers two new capabilities for CDK users. The first is all CDK versions now support Go , expanding the number of programming languages developers can use to define infrastructure-as-code, and provision through AWS CloudFormation. The second is that all stable constructs from the AWS Construct Library are now available in a single, separate package, making it easier for you to use the CDK and stay up-to-date with new versions as we evolve it going forwards.

Now on EC2 Image Builder, you can create a new version of your EC2 Auto Scaling launch template that references your latest Amazon Machine Images (AMIs). Using Image Builder pipeline, you can easily create these new launch template versions with the latest AMI to be used across all your AWS regions.

AWS Systems Manager Fleet Manager, a new capability in AWS Systems Manager that helps you streamline and scale your remote server management process is now available in AWS GovCloud (US) Regions. AWS GovCloud (US) is designed to host sensitive data and regulated workloads in the cloud for customers with stringent U.S. federal, state, or local government compliance requirements.