Redshift Spectrum is a querying engine service offered by AWS allowing customers to use only the computing capability of Redshift clusters on data available in S3 in different formats. This feature enables customers to add external tables to Redshift clusters and run complex read queries over them without actually loading or copying data to Redshift.
Since Redshift Spectrum is a built-in feature of Amazon Redshift, you need a redshift cluster.
To your question: Answer is yes. AWS charge for the created cluster. Yes even for redshift spectrum.
Here is the pricing calculator
dc2.8xlarge 32 244 GiB 2.56TB SSD 7.50 GB/s $4.80 per Hour dc2.large 2 15 GiB 0.16TB SSD 0.60 GB/s $0.25 per Hour
Answer from BigData-Guru on Stack Overflowamazon web services - How does AWS charge the Redshift Spectrum cluster? - Stack Overflow
Distinguish Redshift Spectrum from Redshift Costs
Is Redshift Serverless same as Redshift?
Redshift Spectrum with S3 Express One Zone?
What’s the difference between Amazon Redshift Serverless pricing and provisioned cluster pricing?
Amazon Redshift Serverless uses a pay-as-you-go model, where you're charged only for the compute capacity you actually use, measured down to the second. This means you only pay when queries are being processed, and there are no costs during idle periods.
On the other hand, provisioned clusters operate on an hourly billing model. Here, you're charged for the resources you allocate - like compute nodes and storage - whether or not they're being fully utilized. While this approach offers cost predictability, it can lead to higher expenses if resources sit idle.
How can I avoid unexpected charges with Amazon Redshift pricing?
When managing costs with Amazon Redshift, consider using Reserved Instances. These can offer big savings compared to on-demand pricing, making them a great choice for consistent workloads. On the other hand, if your workload varies a lot, the serverless option could be more cost-effective since you only pay for the resources you actually use.
It's also a good idea to keep an eye on your capacity settings, like maximum RPU hours, to ensure they match your budget. Regularly checking your usage and adjusting resources as needed can help you balance costs while maintaining strong performance.
How can Reserved Instances help save costs with Amazon Redshift?
Reserved Instances for Amazon Redshift offer a great way to save on costs by providing discounted rates when you commit to a one-year or three-year term. This pricing model works well for businesses with steady, predictable workloads, as it helps cut expenses compared to on-demand pricing.
By reserving instances, you can better control your cloud spending without sacrificing performance or scalability. It's an excellent choice for organizations aiming to handle long-term data analytics requirements more efficiently.