Cloudera Docs

Saving a table as a materialized table

Cloudera Data Visualization allows you to save a table as pre-computed (materialized) data. Use a materialized table if you want to permanently store your query results.

You have a table visual that you want to save as a materialized table.
  1. On the top right menu, click the (ellipsis) icon and select Save Table from the menu.
  2. In the Create a Table or Dataset modal window, fill out these fields:
    1. Choose Materialized table for Type to permanently save query results.
    2. Under Create in database, choose an existing database where you want to save the table.
    3. Enter the name of the new table.
    4. Choose Parquet or Text file as Storage format.
    5. Optional: When creating a dataset as part of this operation, select the Create a new dataset based on new table/view option and enter the Dataset name.
    6. Click CREATE.

    A success confirmation modal appears, with a link to the new default visual on the new dataset.

  3. Click the link to open a new default visual on the new dataset in Edit mode.