Creating Acceleration Instructions

From the Varada Control Center, you can manage acceleration instructions. These define the materialization type Varada will perform on a column to warm up the data in the column. The actual warmup takes place when a query hits the column.

📘

You can also manage acceleration instructions using REST commands.

On the Table page, the Instructions column shows which acceleration instruction types, if any, are defined for each column.

👍

You can view these instructions with higher granularity on the Rules page.

You can define or override an acceleration instruction for a single column, or define the same instruction for multiple columns at the same time.

  1. On the Table page, select the checkbox(es) next to the column(s) for which you want to define the acceleration instruction, then select Accelerate.
    The New Acceleration Instruction dialog box appears.
  1. From the Materialization Type options, select one or more materialization types to perform on the column data (Index, Data, Lucene‍, Bloom High, Bloom Medium, or Bloom Low.

  2. From the Priority dropdown list, select the instruction priority. The priority determines the order in which the materialized column data is removed from memory when the system is constrained.

  3. In the Time to live (mins) field, enter the TTL threshold for the instruction. When the threshold is met without the data associated with the instruction being accessed, the column materialization will be reverted if the system has reached its upper storage limit.

  4. From the Apply to options, select the partitions to be materialized.

    • Specific partitions: A list of the relevant partitions appears, along with the number of queries hitting each partition. Select the checkbox(es) for the required partitions.
    • Time range partitions: Either select a moving window or a specific date range. If you select a moving window, the system will calculate the partition date range each time it materializes the data.
    • All
  5. When you are ready, select Create to create the new instruction.