Dynamic table refresh performance

Dynamic table refreshes determine the cost and data freshness of your dynamic tables. This topic covers how dynamic table refreshes affect performance and how you can influence refresh performance in the following order:

  1. Workload: Tune your workload by refining your queries and the characteristics of your data.

  2. Refresh mode: Adjust the refresh mode on your dynamic tables to match your workload.

  3. Refresh schedule cost: Control the schedule at which your pipeline refreshes.

  4. Warehouse considerations: Allocate the appropriate warehouse sizing to your refreshes.

Language: English