How do you run queries and work with transformation views?

faq

#1

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).

#2

How do you materialize the view that you mention?


#3

Hi, Markus. Great question.

Before I give a direct answer, I’ll back up and give a bit of context about materialized views for others who may not be familiar. Materialized views cache the results of a query as a table rather than a non-cached, virtual table. A materialized view could be especially useful for data that is frequently accessed. This is because materialized views increase query performance since queries go to the materialized views rather than to the underlying detail tables.

To answer your “how to” question: By default, Redshift doesn’t support view materialization. However, Panoply Support can create materialized views on your behalf. We do this automatically using our automated query materialization (AQM). If you want to transform a simple view into a materialized view, we would be glad to help you.