Live Query

Hardik Chheda Updated by Hardik Chheda

In Tinace, Live Query is a mode in which there is no data movement from the data source to the data set.

Tinace does not copy data from the data source system. All queries directly connect to the source database, which helps you leverage your resources used in a data warehouse or data lakes.

Benefits of Live Query mode

  • No movement of raw data between data source and Tinace
  • Query results are always real-time (up-to-date)
  • No need to schedule data refresh

What you can not do in Live Query mode?

  • Limited data transforming capability as the source data can not be modified
  • Live Query works only across live data sources
  • Live Query performance is dependent on the performance of source database
  • Tinace Fast Query Engine (in-memory) cannot be leveraged to speed up queries
  • Live Query mode is available under the Advanced Settings option while creating a new data source and connecting to tables from the selected data source.

Did we help you?

Time Period Queries

Contact