Faster Workbooks on Every Warehouse: Introducing Universal Result Cache

Sigma has introduced the Universal Result Cache, a new caching mechanism available in public beta, to enhance performance across all data warehouses it supports. This feature allows Sigma to store query results in a cloud storage bucket owned by the user, which significantly speeds up workbook loading times by serving cached results upon repeated requests, instead of rerunning queries in the warehouse. Universal Result Cache is particularly beneficial for frequently accessed workbooks, reducing redundant queries and associated costs, and providing users with control over data freshness by allowing them to set cache durations. It supports various warehouses, including those without native caching capabilities like Databricks and Redshift, and ensures data security by using temporary credentials to manage access within the user's cloud infrastructure. This innovation promises to streamline data operations by offering faster access while maintaining flexibility over data updates and security.

No tracked trend matches for this post yet.