- Query and analyze data across databases, data warehouses, and data lakes
- Federate your Redshift cluster with other Redshift clusters
- Access data stored in external data sources like S3
- Perform complex joins across multiple tables in Redshift