Will data cached in a warehouse be lost when the warehouse is resized?

Question

Jermaine Wells · Accepted Answer

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Jermaine Wells · Answer

Yes. because the compute resource is replaced in its entirety with a new compute resource.

Jermaine Wells · Answer

No. because the size of the cache is independent from the warehouse size

Jermaine Wells · Answer

Yes. became the new compute resource will no longer have access to the cache encryption key

List of questions