Live Queries in Qlik Sense
Live Queries with no QVDs: A Streamlined Approach
Firstly, LiveQuery for Qlik Sense is a service that enables live queries directly from the Qlik Sense front-end to a specified data warehouse. Importantly, there’s no need to move data to QVDs with LiveQuery. Essentially, the product is a service residing on a server. Specifically, the LiveQuery service acts as an intermediary between Qlik and the data warehouse. With LiveQuery, you do not need to move data to QVDs in order to use Qlik Sense. The service makes it possible to create queries from Qlik Sense without moving all the data in memory, thereby simplifying your architecture.
Seamless integration between live queries and in-memory: Enhancing Data Accessibility
Moreover, the LiveQuery service enables near-seamless integration between live queries and in-memory data. To achieve this, the LiveQuery service dynamically transforms the queries and links the query results to the Qlik data model, based on a series of factors. This is done in real time as the user is using the application.
In-memory cache: Efficient Data Management
Additionally, the LiveQuery service has an in-memory result cache. This means that repeated queries can return results without accessing the warehouse. This reduces the load on the data warehouse and increases the responsiveness of the Qlik front-end. The cache has a configurable time-to-live; when a query result in the cache surpasses this time, the result is evicted from the cache and the query is parsed on the data warehouse. This enables the administrators to balance the requirement between real-time data and load/cost on the data warehouse.
User-specific queries: Personalized Data Experience
Furthermore, the LiveQuery service enables queries to be parsed based on the information about which user is performing the query in the front end. This enables support for user-specific queries, reusing existing table and row-level access implemented to best practice standards for the data warehouse.
Frontend-driven development: Simplified Application Building
Lastly, the LiveQuery service integrates into the Qlik Sense development GUI, which makes the development of applications utilizing LiveQuery simple and fast. No scripting or template applications are required, only SQL and some knowledge of the structure of the data warehouse.
