I think you can get the "data scanned per query" from Redshift by querying the STL_QUERY_METRICS table. http://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUE

I think you can get the "data scanned per query" from Redshift by querying the STL_QUERY_METRICS table. http://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_METRICS.html http://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_ME... I would be interested in seeing the settings for the table in Redshift. I don't know much about how BigQuery works, but Redshift relies heavily on distribution and sort keys to efficiently query data.