Tag: HAQM Redshift

This post discusses 10 best practices to help you maximize the benefits of Federated Query when you have large federated data sets, when your federated queries retrieve large volumes of data, or when you have many Redshift users accessing federated data sets. These techniques are not necessary for general usage of Federated Query. They are intended for advanced users who want to make the most of this exciting feature.

Many organizations are moving toward self-service analytics, where different personas create their own insights on the evolved volume, variety, and velocity of data to keep up with the acceleration of business. This data democratization creates the need to enforce data governance, control cost, and prevent data mismanagement. Controlling the storage quota of different personas is a significant challenge for data governance and data storage operation. This post shows you how to set up HAQM Redshift storage quotas by different personas.

With IBM announcing Netezza reaching end-of-life, you’re faced with the prospect of having to migrate your data and workloads off your analytics appliance. For some, this presents an opportunity to transition to the cloud.

Enter HAQM Redshift.

Building a modern data platform on AWS enables you to collect data of all types, store it in a central, secure repository, and analyze it with purpose-built tools. Yet you may be unsure of how to get started and the impact of certain design decisions. To address the need to provide advice tailored to specific technology and application domains, AWS added the concept of well-architected lenses 2017. AWS now is happy to announce the Analytics Lens for the AWS Well-Architected Framework. This post provides an introduction of its purpose, topics covered, common scenarios, and services included.

Tens of thousands of customers use HAQM Redshift to power their workloads to enable modern analytics use cases, such as Business Intelligence, predictive analytics, and real-time streaming analytics. As an administrator or data engineer, it’s important that your users, such as data analysts and BI professionals, get optimal performance. You can use the HAQM Redshift […]

April 2024: This post was reviewed for accuracy. December 2022: This post was reviewed and updated for accuracy. February 2nd, 2022: This blog was updated by Kay Lerch. Recently, we helped a large enterprise customer who was building their data warehouse on HAQM Redshift, using Microsoft Azure Active Directory (Azure AD) as a corporate directory. […]

September 2023: This post was reviewed for accuracy. HAQM Redshift is the most popular cloud data warehouse because it provides fast insights at a low cost. Customers can confidently run mission critical workloads, even in highly regulated industries, because HAQM Redshift comes with out of the box security and compliance. The security features, combined with […]

The HAQM Redshift materialized views function helps you achieve significantly faster query performance on repeated or predictable workloads such as dashboard queries from Business Intelligence (BI) tools, such as HAQM QuickSight. It also speeds up and simplifies extract, load, and transform (ELT) data processing. You can use materialized views to store frequently used precomputations and […]

HAQM Redshift Federated Query allows you to combine the data from one or more HAQM RDS for PostgreSQL and HAQM Aurora PostgreSQL databases with data already in HAQM Redshift. You can also combine such data with data in an HAQM S3 data lake.

You may have heard the saying that the best ETL is no ETL. HAQM Redshift now makes this possible with Federated Query. In its initial release, this feature lets you query data in HAQM Aurora PostgreSQL or HAQM RDS for PostgreSQL using HAQM Redshift external schemas. Federated Query also exposes the metadata from these source databases through system views and driver APIs, which allows business intelligence tools like Tableau and HAQM Quicksight to connect to HAQM Redshift and query data in PostgreSQL without having to make local copies.