Cloudera Docs

Saving a table as a logical view

CDP Data Visualization enables you to save a table as a logical view.

When creating a logical table, follow these steps:

  1. In the Create a materialized table or logical view modal window, fill out these fields:
    1. Enter the Name of the new logical view. We are using snp5_p_e.
    2. Choose the Type: Logical view to generate updated query results every time the visualization is loaded or refreshed.
    3. [If creating a Materialized Table] Choose Storage format, either Parquet or Text file.
    4. Under Create in database, choose an existing database where to save the table.
    5. [Optional] When creating a dataset as part of this operation, select the Create a new dataset... option, and enter the Dataset name.
    Figure 1. Creating a Logical Table
  2. 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.