Saving Tables; Materialized Tables, Logical Views, and Datasets Directly from Query

Arcadia Enterprise enables you to save tabular data as its own table, and writes it back to the database. It also enables you to produce a dataset based on data exposed in a visual, which may be used for self-referenced application stacking. Note that

Availability Notes:This feature is available only when:
  • Examining data in either table or query visuals.
  • Using Arcadia or Impala connections.
  • User has Data Import/Load privileges.

To follow these steps, you may choose to prepare by importing data from datafile SnP500.csv, and creating a dataset from it. We named our dataset S&P 500 Historical Data.

  1. Select the dataset, and click New Visual.
  2. For a Table visual: In the visual edit view, select the necessary fields from the Fields menu on the left, and place them onto the Dimensions, Measures, and Filter shelves.

    For a Query visual: make the necessary edits in the SQL statement at the top of the visual.

  3. Make all necessary changes to the shelves, such as filtering, ordering, calculation, and so on, so they can be saved in the new table.

    Tips:
    • Because the column names in the new table derive from the shelves, we recommend that you alias the aggregate fields.
    • Adjust the Limit to ensure that all rows are captured in the new table.
    • If you are comfortable working with SQL statements, many of these changes and adjustments are quicker to make by directly editing the SQL.
  4. On the top right menu, click (ellipsis) icon, and then select Save Table from the menu.

    Saving Table Data in Table Visual
  5. In the Create a materialized table or logical view modal window, chose one of the following options: