April 29, 2019

Persistence Settings

Every time you explore or query a SQL model, the whole query is run again. These operations can have low performance, put unnecessary strains on your resources, or become very costly (in case of pay-per-use data warehouses like BigQuery) if the query is unoptimized.

To avoid this situation, Persistence helps you periodically run the model's query and write the result to a physical table in your database.

With Persistence enabled, when users explore or query from a SQL model, they will interact with the persisted data table instead. This will give you more power to optimize query performance and cost.

Noting.io BETA