Cloudera Docs

Saving a table as a materialized table

CDP Data Visualization enables you to save a a table as pre-computed/materialized data.

You have a Table visual that you want to save as a materialized table.
  1. In the Create a materialized table or logical view modal window, fill out these fields:
    1. Enter the Name of the new table. In this example snp500_price_and_earnings is used.
    2. Choose Materialized table for Type to permanently save query results.
    3. Choose Parquet or Text file as Storage format.
    4. Under Create in database, choose an existing database where you want to save the table.
    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.

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