Distinguish Redshift Spectrum from Redshift Costs
Can Redshift Spectrum costs be distinguished from Redshift costs at billing time?
A customer has been a user of Redshift for the past year, and are now moving to use Redshift Spectrum more. They are trying to determine how to analyze how much of their monthly Redshift costs are attributed to Spectrum.
Thank you for any insight you can provide.
Redshift billing is independent of any cost that may incur due to querying S3 data using Redshift spectrum. When customer queries S3 data using Redshift Spectrum it involves- 1) spinning up compute environment which are part of the Spectrum managed fleet and is complete transparent to customers. These fleet of servers are taken from hot pool of servers managed and maintained by the Redshift service. Customers do not pay for these servers as they are baked into Redshift pricing- both on demand as well as RI pricing. 2) Scanning and retrieving the requested data from s3.
The only cost that customers need to pay for quering S3 data via Redshift SPectrum is the s3 scanning cost. And the cost is $5 per TB data data scanned. AWS Billing has added the feature to drill down API operations by Service. Yes customers can retrieve the Spectrum cost from the Cost Explorer by filtering out Service = Redshift and group by API Operations and look for the line item "DataScannedInTB ($)". This will provide the cost incurred by Redshift Spectrum. On the contrary if customers filter by S3 and hoping to find the DataScannedInTB there to extrapolate Spectrum cost, it will be incorrect. Hope this helps.
You can check the https://aws.amazon.com/redshift/pricing/ page for pricing associated with Redshift Spectrum.
Relevant questions
use Redshift Spectrum to query both Redshift table and s3 file
Accepted Answerasked 2 years agoAthena and Redshift Spectrum performance best practices
Accepted Answerasked 3 years agoRedshift Spectrum Access to Lake Formation
Accepted Answerasked 3 years agoCan you use a Redshift Spectrum Table in a CTE?
asked 4 months agoRedshift questions from AWS Customer
Accepted Answerasked 3 years agoHow is data returned from Spectrum to Redshift cluster?
Accepted Answerasked 2 years agoRedshift Managed Storage vs Spectrum
Accepted Answerasked 2 years agoDistinguish Redshift Spectrum from Redshift Costs
Accepted Answerasked 4 years agoIs it possible to have a Redshift Spectrum schema access multiple accounts data ?
asked 2 months agoRedshift Spectrum giving IERR_READ_ERROR (Access Denied) error
asked 2 years ago