Redshift Spectrum
Advantages
- Enables to run the exabytes of data directly from S3
- Directly can read the data from the S3 data lake& eliminates load and transfer of the data
- Redshift Spectrum scale the query process and uses the node as per the requirement
- Directly queries data in S3 with an open format including CSV, TSV, Parquet, Sequence, and RCFile.
- it enables to read the data from Redshift as well as where you kept your data
Advantages
- Pay per query no upfront cost based on the resources utilization
- Directly read from S3 no need to load and process data before query it
- Support multiple formats of the data
- Easily scalable and easy to manage
- You just need to register your Amazon Athena data catalog or Hive Metastore as an external schema.