- Newest
- Most votes
- Most comments
Hi Yasmeen,
Creating an external schema in Redshift does not always mean that Redshift Spectrum will be used. It depends on the FROM parameter; Redshift Spectrum is used to query data directly from files on an Amazon S3.
In your case, when you execute the create external schema ... from redshift ... command, you are just mapping a data share schema to a local schema. This means both ways, with or without an external schema, will have the same cost which is, the producer cluster is charged for the data they shared and consumer clusters get charged for the compute they use in accessing the shared data.
Thanks,
Hello,
In this context I would like to inform you that with respect to Redshift spectrum pricing the main parameters that can incur costs are:
- Volume of data scanned.
- S3 storage.
- S3 access requests made.
In case of data sharing, no additional cost is incurred to use the feature because no data is being scanned from S3 and no S3 storage is involved. You can securely share live data with Amazon Redshift clusters in the same or different AWS accounts, and across regions.
There will also be no additional cost for creating EXTERNAL SCHEMA, cost is incurred only when you scan data from AWS Glue data catalog, S3, KMS or any such resources.
Refer https://aws.amazon.com/redshift/pricing/ for more details on pricing.
Relevant content
- asked 8 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago