I Love AWS

Data Warehousing

How to design a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS.

Data types in Amazon Redshift https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html
Choosing Sort Keys https://docs.aws.amazon.com/redshift/latest/dg/t_Sorting_data.html Sorting enables efficient handling of range-restricted predicates.
Distribution Styles https://docs.aws.amazon.com/redshift/latest/dg/c_choosing_dist_sort.html
Tutorial: Tuning Table Design https://docs.aws.amazon.com/redshift/latest/dg/tutorial-tuning-tables.html n this tutorial, you will learn how to optimize the design of your tables. You will start by creating tables based on the Star Schema Benchmark (SSB) schema without sort keys, distribution styles, and compression encodings.
Amazon Redshift Best Practices for Designing Tables https://docs.aws.amazon.com/redshift/latest/dg/c_designing-tables-best-practices.html These design choices also have a significant effect on storage requirements, which in turn affects query performance by reducing the number of I/O operations and minimizing the memory required to process queries.

Data Format Parameters for the COPY command https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-format.html
Zero Administration Amazon Redshift Database Loader https://github.com/awslabs/aws-lambda-redshift-loader drop files into pre-configured locations on Amazon S3, and this function automatically loads into your Amazon Redshift clusters.

Amazon Redshift Utils contains utilities, scripts and view which are useful in a Redshift environment https://github.com/awslabs/amazon-redshift-utils .
Amazon RedShift Parameter Groups can be used to configure database settings such as query timeout and datestyle. https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-parameter-groups.html.
Analyzing Tables https://docs.aws.amazon.com/redshift/latest/dg/t_Analyzing_tables.html - Automatic analyze is enabled by default.
Run Mixed Workloads with Amazon Redshift Workload Management https://aws.amazon.com/blogs/big-data/run-mixed-workloads-with-amazon-redshift-workload-management/
Working with Concurrency Scaling https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html - automatically adds additional cluster capacity when you need it to process an increase in concurrent read queries.
Implementing Automatic WLM https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html
Amazon Redshift launches the ability to easily move clusters between AWS Availability Zones (AZs) https://aws.amazon.com/about-aws/whats-new/2020/12/amazon-redshift-launches-ability-easily-move-clusters-between-aws-availability-zones/
Quotas and limits in Amazon Redshift https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html

Using Amazon Redshift for Fast Analytical Reports https://aws.amazon.com/blogs/database/using-amazon-redshift-for-fast-analytical-reports/ How AWS Premier Partner Wipro helped their customer (a leading US business services company) move their workload from on-premise data warehouse to Amazon Redshift. This move enabled the company to reap the benefits of scalability and performance without affecting how their end users consume reports.
Nasdaq Uses AWS to Pioneer Stock Exchange Data Storage in the Cloud https://aws.amazon.com/solutions/case-studies/nasdaq-case-study/
Magellan Rx Reduces ETL Time by Over 70% Using Amazon Redshift https://aws.amazon.com/solutions/case-studies/magellan-rx-redshift/