🔴Live Query mode

Understand the Live Query mode: Benefits, Limitations, and Activation process

In the Live Query mode, data remains static at its source, eliminating the need for data movement. This mode ensures that all queries are executed directly on the source database. It is particularly beneficial for those utilizing resources in data warehouses or data lakes.

What is the use of live querying?

• No data movement: Live query mode eliminates the transfer of raw data between the data source and Tellius, ensuring data integrity and security.

• Real-time results: Queries reflect the most current data, providing up-to-date insights without the need for scheduled data refreshes.

Limitations

• In Live query mode, the capability to transform data is limited since the source data remains unmodified.

• This mode is exclusively applicable only to live data sources.

• The efficiency of Live query is contingent on the performance of the source database.

• Tellius's Fast Query Engine, designed for accelerating queries, cannot be utilized in this mode.

Business Views that support live querying are easily identifiable by a small green circle displayed next to their name.

How to enable live query mode?

Live Query mode can be activated by selecting the 'Advanced Settings' option during the process of creating a new data source or when connecting to tables from a chosen data source.