Remote cache #databricks #shorts

Even if you terminate your SQL warehouse after one minute, you can still benefit from caching.
Additionally, even if you run multiple serverless SQL warehouses in your workspace, they can exchange caches between themselves.
This is all thanks to the remote cache.
Let’s look at an example:
We run a query on the warehouse, which reads the files and data.
Then, we terminate the warehouse.
After some time, we start it again and run the same query again.
This time, it doesn’t read any files so it means that even after termination it benefits from caching.

свернуть