By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Does UNLOAD use result caching on Amazon Redshift

0

Hi,

when running an UNLOAD command on Amazon Redshift (or Redshift Serverless) with a SELECT statement attached to it.

Is the query benefiting the result caching mechanism available in Amazon Redshift ?

Result Caching

Thank you.

Topics
Analytics
Tags
AnalyticsAmazon Redshift
Language
English
profile pictureAWS
Semir
asked 2 months ago129 views
1 Answer
0

@semir I did a quick test on my serverless workgroup running the same UNLOAD multiple times but looks like in the SYS_QUERY_HISTORY result_cache_hit column was always "false". I assume this means UNLOAD will not use the result set cache.

AWS
EXPERT
Ranjan Burman - AWS
answered 2 months ago
  • Semir
    2 months ago

    thank you Ranjan for your time; what about Provisionned (I know the result caching is managed a bit differently)?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content