AWS Redshift 데이터베이스
| PostgreSQL을 커스터마이징하여 만들었음 DW 솔루션 서비스임 S3와 통합 Redshift Spectrum통해서 S3를 Redshift의 external table로 인식 computing의 slice에 나눠서 저장됨 computing에서 집계하여 결과 return |
https://aws.amazon.com/redshift/features/
Amazon Redshift 기능 - 클라우드 데이터 웨어하우스 - Amazon Web Services
aws.amazon.com
https://docs.aws.amazon.com/redshift/latest/dg/c_high_level_system_architecture.html
Data warehouse system architecture - Amazon Redshift
Thanks for letting us know this page needs work. We're sorry we let you down. If you've got a moment, please tell us how we can make the documentation better.
docs.aws.amazon.com
Amazon Redshift clusters - Amazon Redshift
Although the console displays this information in one field, it's two parameters in the Amazon Redshift API, ClusterVersion and ClusterRevisionNumber. For more information, see Cluster in the Amazon Redshift API Reference.
docs.aws.amazon.com
https://docs.aws.amazon.com/redshift/latest/dg/c-using-spectrum.html
Querying external data using Amazon Redshift Spectrum - Amazon Redshift
You can't view details for Redshift Spectrum tables using the same resources that you use for standard Amazon Redshift tables, such as PG_TABLE_DEF, STV_TBL_PERM, PG_CLASS, or information_schema. If your business intelligence or analytics tool doesn't reco
docs.aws.amazon.com
https://aws.amazon.com/blogs/big-data/10-best-practices-for-amazon-redshift-spectrum/
Best Practices for Amazon Redshift Spectrum | Amazon Web Services
Amazon Redshift Spectrum enables you to run Amazon Redshift SQL queries on data that is stored in Amazon Simple Storage Service (Amazon S3). With Amazon Redshift Spectrum, you can extend the analytic power of Amazon Redshift beyond the data that is stored
aws.amazon.com
https://docs.aws.amazon.com/redshift/latest/dg/wlm-short-query-acceleration.html
Working with short query acceleration - Amazon Redshift
Working with short query acceleration Short query acceleration (SQA) prioritizes selected short-running queries ahead of longer-running queries. SQA runs short-running queries in a dedicated space, so that SQA queries aren't forced to wait in queues behind
docs.aws.amazon.com