In this repo, there are three views you can reference on how to attribute the cost of a query in Amazon Redshift.
- redshift_spectrum_scan_summary_vw - Contains information about the Amazon Redshift Spectrum query
- redshift_query_summary_vw - Contains information about a query execution at the query level
- redshift_query_attribution_vw - Contains information about the estimated compute cost (in USD) of each query execution
When you download the views, as a pre-requisite before using is to modify the redshift_query_attribution_vw script. Update the values as per the following based on your Amazon Redshift cluster configuration:
- price_per_node_per_hour
- daily_operation_hour
- spectrum_price_per_tb
- concurrency_price_per_second
- cpu_rated_score
- disk_io_rated_score
- execution_rated_score
- daily_redshift_compute_cost
See CONTRIBUTING for more information.
This library is licensed under the MIT-0 License. See the LICENSE file.