AWS Redshift / SageMaker Lakehouse

Natural language SQL query generation feature that enables data users to write SQL queries using natural language prompts through Amazon Q in Redshift Query Editor.

First-party excerpt: Boost productivity by enabling data users to more quickly and easily write SQL queries using natural language with Amazon Q generative SQL in Redshift Query Editor.

Natural language SQL query generation feature in Redshift Query Editor that enables users to write SQL queries using natural language, improving productivity for data analysis.

First-party excerpt: Boost productivity by enabling data users to more quickly and easily write SQL queries using natural language with Amazon Q generative SQL in Redshift Query Editor.

Graviton-based instances that run data warehouse and data lake workloads up to 2.4x faster than RA3 instances at 30% lower cost per vCPU, with integrated data lake query engine for open formats like Apache Iceberg and Parquet.

First-party excerpt: Amazon Redshift RG instances, powered by AWS Graviton processors, deliver better performance - running data warehouse and data lake workloads up to 2.4x as fast as previous generation RA3 - at 30% lower per-vCPU cost.

Serverless data warehouse that automatically scales compute to handle evolving analytic needs without infrastructure provisioning or management, enabling analysis of data in seconds.

First-party excerpt: Redshift Serverless learns from your workloads and automatically scales compute to handle your evolving analytic needs, so you can focus on uncovering insights without managing infrastructure.

Unified, open, secure data lakehouse that integrates Amazon Redshift data warehouses, Amazon S3 data lakes, and third-party federated data sources, enabling SQL analytics across unified data with high-performance query capabilities.

First-party excerpt: Unify access across Amazon Redshift data warehouses, Amazon S3 data lakes, and third-party and federated data sources with the lakehouse in Amazon SageMaker

Accelerates low-latency SQL query response times by up to 7x from the first run using enhanced code generation and query-specific compilation for analytics applications, BI dashboards, and agentic AI workloads.

First-party excerpt: Amazon Redshift accelerates query response times of low-latency SQL queries from the very first run, such as those used in near real-time analytics applications, BI dashboards, ETL pipelines, and autonomous, goal-seeking AI agents.

Query optimization capability using enhanced code generation to produce highly optimized, query-specific compiled code for low-latency SQL queries, achieving up to 7x faster response times on first execution.

First-party excerpt: Amazon Redshift accelerates query response times of low-latency SQL queries from the very first run, such as those used in near real-time analytics applications, BI dashboards, ETL pipelines, and autonomous, goal-seeking AI agents. Enhanced code generation produces highly optimized, query-specific compiled code that ensures queries start fast and stay fast.

Capability to build, train, and deploy machine learning models directly in Redshift using SQL for use cases including predictive analytics, classification, and regression on large datasets.

First-party excerpt: Use SQL to build, train, and deploy ML models for many use cases including predictive analytics, classification, regression and more to support advanced analytics on large amount of data.

Capability to use Redshift as a structured knowledge base for Amazon Bedrock to provide more accurate generative AI output and enable advanced natural language processing tasks like text summarization, entity extraction, and sentiment analysis.

First-party excerpt: Use Redshift as your structured knowledge base in Amazon Bedrock for more accurate generative AI output.

Seamless integration enabling SQL analytics on unified data across a lakehouse architecture in Amazon SageMaker, allowing queries on open formats stored in S3 without moving data between data lakes and data warehouse.

First-party excerpt: Leverage Redshift's powerful SQL analytic capabilities across all of your unified data through its seamless integration in Amazon SageMaker. Query your data in open formats stored on Amazon S3 with high performance, eliminating the need to move or duplicate data between your data lakes and data warehouse.

Enhanced code generation feature that accelerates query response times of low-latency SQL queries by up to 7x from the first run, optimized for real-time analytics, BI dashboards, and autonomous AI agents.

First-party excerpt: Amazon Redshift accelerates query response times of low-latency SQL queries from the very first run, such as those used in near real-time analytics applications, BI dashboards, ETL pipelines, and autonomous, goal-seeking AI agents.

Enhanced code generation feature that accelerates query response times of low-latency SQL queries from the first run by producing highly optimized, query-specific compiled code for near real-time analytics, BI dashboards, ETL pipelines, and autonomous AI agents.

First-party excerpt: Amazon Redshift accelerates query response times of low-latency SQL queries from the very first run, such as those used in near real-time analytics applications, BI dashboards, ETL pipelines, and autonomous, goal-seeking AI agents.

AWS Graviton-powered data warehouse instances delivering up to 2.4x faster performance than RA3 instances at 30% lower per-vCPU cost, with built-in data lake query engine for Apache Iceberg and Parquet formats.

First-party excerpt: Amazon Redshift RG instances, powered by AWS Graviton processors, deliver better performance - running data warehouse and data lake workloads up to 2.4x as fast as previous generation RA3 - at 30% lower per-vCPU cost.

AWS Graviton-powered compute instances for Redshift that deliver up to 2.4x faster performance on data warehouse and data lake workloads compared to RA3, with 30% lower per-vCPU cost and built-in data lake query engine supporting Apache Iceberg and Parquet.

First-party excerpt: Amazon Redshift RG instances, powered by AWS Graviton processors, deliver better performance - running data warehouse and data lake workloads up to 2.4x as fast as previous generation RA3 - at 30% lower per-vCPU cost. With a built-in data lake query engine, Redshift RG instances natively process open formats — including Apache Iceberg and Apache Parquet.

Serverless analytics capability that automatically scales compute resources based on workload patterns, eliminating infrastructure management and enabling data analysis within seconds.

First-party excerpt: Start analyzing your data in a few seconds with Amazon Redshift Serverless. Redshift Serverless learns from your workloads and automatically scales compute to handle your evolving analytic needs, so you can focus on uncovering insights without managing infrastructure.

Native integrations that seamlessly move transactional data from databases like Amazon Aurora, RDS, DynamoDB into Redshift, and ingest high-volume real-time data from Kinesis and MSK without complex data pipelines.

First-party excerpt: Leverage zero-ETL integrations to seamlessly move transactional data from databases like Amazon Aurora, RDS, and DynamoDB into Redshift without performance impact. Ingest high volume real-time data from Amazon Kinesis and Amazon MSK

Unified, open, and secure data lakehouse that unifies access across Amazon Redshift data warehouses, Amazon S3 data lakes, and third-party federated data sources, integrated with Amazon SageMaker.

First-party excerpt: Unify access across Amazon Redshift data warehouses, Amazon S3 data lakes, and third-party and federated data sources with the lakehouse in Amazon SageMaker

Unified data lakehouse in Amazon SageMaker that enables seamless SQL analytics across Redshift data warehouses, S3 data lakes, and federated data sources without moving or duplicating data.

First-party excerpt: Unify access across Amazon Redshift data warehouses, Amazon S3 data lakes, and third-party and federated data sources with the lakehouse in Amazon SageMaker

Native streaming and real-time data integration capabilities connecting Redshift with Amazon Aurora, RDS, DynamoDB, Kinesis, and MSK without requiring complex data pipelines, enabling near real-time analytics.

First-party excerpt: Leverage zero-ETL integrations to seamlessly move transactional data from databases like Amazon Aurora, RDS, and DynamoDB into Redshift without performance impact. Ingest high volume real-time data from Amazon Kinesis and Amazon MSK with native streaming services integrations.

Integration enabling Redshift data to serve as a structured knowledge base in Amazon Bedrock for more accurate generative AI output and advanced NLP tasks like text summarization, entity extraction, and sentiment analysis via SQL.

Integration enabling Redshift to serve as a structured knowledge base for Amazon Bedrock, allowing invocation of large language models for NLP tasks like text summarization, entity extraction, and sentiment analysis on warehouse data.

Integration enabling organizations to build personalized applications using their organizational data in Redshift with LLMs from Amazon Bedrock for advanced NLP tasks and generative AI capabilities.

Integrated development environment for building and scaling generative AI applications with pre-built models and APIs.

Generative AI assistant for software development that helps discover data, build and train ML models, generate SQL queries, and create data pipeline jobs through natural language.

Generative AI assistant for software development that helps discover data, build and train ML models, generate SQL queries, and create data pipeline jobs through natural language.

Enterprise data warehouse providing SQL analytics capabilities for gaining insights from structured data with price-optimized query performance.

Unified, open, secure data lakehouse that provides SQL analytics across Redshift data warehouses, S3 data lakes, and third-party federated data sources, enabling high-performance queries on open formats without data movement.

Integration of Redshift as a structured knowledge base for Amazon Bedrock generative AI models, enabling more accurate and contextual AI output using organizational data.

Integration enabling Redshift data to serve as a contextualized knowledge base for Amazon Bedrock LLMs, improving accuracy of generative AI outputs for enterprise applications.

Capability to build, train, and deploy machine learning models directly in Redshift using SQL for predictive analytics, classification, and regression tasks.

Enhanced code generation for Amazon Redshift that accelerates low-latency SQL query response times by up to 7x on first run, optimized for near real-time analytics, BI dashboards, ETL pipelines, and autonomous AI agents.

Unified lakehouse platform integrating Redshift with SageMaker, enabling SQL analytics across structured warehouse data and open data lake formats for analytics and ML workloads.

Comprehensive AI development platform for building, training, and deploying ML and foundation models with fully managed infrastructure, tools, and workflows across the entire AI lifecycle.

Data and AI governance platform for securely discovering, governing, and collaborating on data and AI artifacts, built on Amazon DataZone.

Data preparation and integration capabilities for analyzing, preparing, and processing data for analytics and AI using open source frameworks on Athena, EMR, and Glue.

High-performance distributed training infrastructure for accelerating large-scale ML model training.

Pre-built ML solutions and pre-trained models to accelerate model development and deployment.

Unified, open, and secure data lakehouse that provides seamless SQL analytics access across Redshift data warehouses, S3 data lakes, and third-party federated data sources.

Unified, open data lakehouse in Amazon SageMaker that integrates Redshift data warehouses with S3 data lakes and third-party data sources, enabling SQL analytics across consolidated data without moving or duplicating data.

Operational tools and workflows for managing, monitoring, and scaling ML models in production.

Integrated development environment providing unified access to data, analytics, and AI tools in a single serverless notebook with built-in AI agent.