How do you run queries and work with transformation views?



After the data has been stored in table format, you can query the sample table. After running a query, you can save the query as a transformation or export the resulting table into your own system.

Panoply offers two types of transformation views: simple views and materialized views. A transformation typically start as a simple view. When needed, based on performance, simple views can be transformed into materialized views, which are always accessible and up to date.

  1. Select Data Sources from the navigation pane, then select the table from the list of open tables.
  2. Run a query against the selected table.
  3. To view the history of all previously run queries, select Query Log from the navigation pane.
  4. Select Jobs from the navigation pane to track your job progress. You can filter the jobs list according to status (All Statuses, Running, Booting, Pending, Error, Success) and job types (All Types, Collect, Collect-Direct, Materialize, Alter, and Export).


How do you materialize the view that you mention?