Data Cache in Serverless SQL Endpoints vs Non-Serverless SQL Endpoints

[Mike_Gardner]

Do Serverless SQL Endpoints benefit from Delta and Spark Cache? If so, does it differ from a non-serverless endpoints? How long does the cache last?

[Hubert-Dudek · Accepted solution]

All SQL endpoints have delta cache enabled out of the box (in fact 2X-Small etc. are E8/16 etc. instances which are delta cache enabled).

Delta cache is managed dynamically. So it stays till there is free RAM for that.