• Redshift SQL 꿀팁

• Redshfit Table 조작법

• Integrated Orders Query

• Redshift Sort Key

• Redshift UpperCase

• SQL View vs Materialized View

• FATAL: connection limit "2000" exceeded for non-bootstrap users

• STL (System Table Logging) - These system tables are generated from log files.

• STV (System Table Virtual) - These virtual system tables has snapshots of the current system data.

Amazon Redshift - Fundamentals (Jef Claes)

https://docs.aws.amazon.com/redshift/latest/dg/c_redshift_system_overview.html

https://s3-eu-west-1.amazonaws.com/cdn.jefclaes.be/amazon-redshift-fundamentals/aws-redshift-fundamentals.html

https://vutr.substack.com/p/i-spent-another-8-hours-understanding

<aside> 💡 Amazon Redshift achieves efficient storage and optimum query performance through a combination of massively parallel processing, columnar data storage, and very efficient, targeted data compression encoding schemes.

</aside>