Amazon Web Services

Amazon Redshift and Redshift Spectrum

Query and Analyze your Redshift Data Warehouse and S3 Data Lake

Amazon Redshift is a strategic part of the cloud-computing platform Amazon Web Services (AWS) that includes a fully managed, fast, petabyte-scale data warehouse. It can also incorporate an S3-based data lake with unstructured and semistructured data through Redshift Spectrum.

The Benefits of Amazon Redshift and Redshift Spectrum

Amazon Redshift makes it simple and cost-effective to analyze data using standard SQL. Companies with standard data warehousing and SQL experience will find it easy to move their data into Amazon Redshift without significantly changing their query and analytics techniques or methods.

Amazon Redshift Spectrum is a service expands the scope of a given Redshift query to include unstructured Amazon Simple Storage Service (Amazon S3) data sources. When Redshift receives a SQL query that includes Amazon S3 data, it generates a plan to minimize the amount of Amazon S3 data that needs to be read and manages the shared resource pool to retrieve the data from Amazon S3.

Amazon Redshift and Redshift Spectrum in the Information Builders Data and Analytics Platform

Information Builders provides secure, easy access to Redshift data warehouses for data preparation, data quality, mastering, and ETL services.

Analytics and reporting users can do complex analysis, create joins, and develop interactive visualizations using Redshift that can be saved, shared, and published. An unlimited number of dashboards, reports, charts, and documents can also be created using Redshift.

In addition to data stored in Amazon Redshift data warehouses, any of the functionality of the Information Builders data and analytics platform can leverage Redshift Spectrum for analytics, reporting, and data management.

Learn More About Information Builders and AWS