Materialize a view

Learn how to materialize a View to improve its performance.

To improve the performance of a View, you can materialize it. This operation computes the data for the View and stores it in memory, just like a table. You can expect a 3-6 times performance improvement on a Materialized View over a View that is not materialized. However, materialized Views take up space in memory, so weigh the tradeoffs and benefits of materializing a View ahead of time.

Row Level Security does not apply to Materialized Views. All users will see the same data when using the Materialized View as a data source.

To materialize a view:

  1. To find your View, click Data in the top menu, and choose Views.

  2. Click the name of your View.

  3. Click Schema.

  4. If needed, add joins.

  5. Under Materialization, click Materialize.

    materialization dialog off
  6. Fill in the details for primary key, sharding key, and number of shards.

    materialize details
    If you do not fill in the sharding details, the View will be replicated on every node of your cluster. If you’re not sure what to fill in, ask your ThoughtSpot administrator, or follow the links in this step to learn more about sharding.
  7. Click Materialize.

  8. In the Schedule data updates dialog, select an option for Repeats (Monthly, Weekly, or Daily).

    materialized view sched weekly

    If you don’t want to set a schedule now, choose Setup later and skip to Step 11.

  9. Fill in the schedule details:

    schedule data updates weekly
  10. Click Update.

  11. You can see the status of the materialization as it progresses. Click Update Status to refresh it.

    materialization update status
  12. When it says Materialized your Materialized View is ready for search.

    materialization dialog on

    If after some time, the status has not changed to Materialized, check the list of statuses and corresponding actions to take.