Skip to main content

Others

Column level access controls​

https://aws.amazon.com/about-aws/whats-new/2020/03/announcing-column-level-access-control-for-amazon-redshift image

https://aws.amazon.com/blogs/aws/new-aqua-advanced-query-accelerator-for-amazon-redshift image

image

image

image

Amazon Redshift spatial provides location-based analytics for rich insights into your data. It seamlessly integrates spatial and business data to provide analytics for decision making.Amazon Redshift launched native spatial data processing support in November 2019, with a polymorphic data type GEOMETRY and several key SQL spatial functions. We now support GEOGRAPHY data type, and our library of SQL spatial functions has grown to 80. We support all the common spatial datatypes and standards, including Shapefiles, GeoJSON, WKT, WKB, eWKT, and eWKB.

Vacuum and Analyze commands​

https://hevodata.com/blog/redshift-vacuum-and-analyze

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

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

Auto WLM with queue priority​

https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html

Others​

STL Load Errors - https://docs.aws.amazon.com/redshift/latest/dg/r_STL_LOAD_ERRORS.html

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