After executing a SQL Stream job, you can set up the Materialized Views to have a
snapshot of your queried data. You can use the URL Pattern from the Materialized View to
visualize the generated data.
Make sure that PostgreSQL is installed and configured
to SQL Stream Builder (SSB) to create Materialized Views.
Navigate to the Streaming SQL Console.
Go to your cluster in Cloudera Manager.
Select SQL Stream Builder from the list of
services.
Click SQLStreamBuilder Console.
The Streaming SQL Console opens in a new window.
Click Create Job or select a previous job on the
Getting Started page.
You are redirected to the Console page. The Materialized
View button will be available when you add a query to the SQL Editor.
Click Materialized View.
Switch Enable MV toggle.
Select a Primary Key.
If this list is empty, then no SQL is specified in the SQL
Editor or the SQL query is invalid. Select a key as a primary key
for the Materialized View. All data will be updated by this key.
Select a Retention Period.
Data not being mutated during this period is removed from the view.
Enable or disable Recreate on Job Start.
If enabled, the Materialized View is deleted when a job is started or
restarted.
Enable or disable Ignore NULLS.
If enabled, NULL values will NOT update values that are non null - they are
ignored.
Select an API Key.
In case there are no API Keys, click Add API key, or
click Materialized Views from the main menu. The add API
key window appears. Provide a name for the API key, and click Save Changes.
To check your created API keys:
Click Materialized Views from the main
menu.
The Materialized Views page appears.
Select API Keys tab.
Click Add New Query to create the Materialized View
query.
The Materialized View Query Configuration window appears.
Provide a name in the URL Pattern field.
Provide a description of the Materialized View Query, if needed.
Customize the Materialized View in the Query Editor.
Select the columns of the SQL job you want to use in the Materialized
View Query.
You can select every column in the table by clicking on the
Select All button.
Click Filters tab to apply computations and
further enrichment of your data.
Provide details of the filter by selecting the
Field, Operator and
Value.
You can add more rules or set a ruleset for the query.
Click Apply or Apply and Save
Job.
The URL for the Materialized View appears under the
Queries header.
You can click the created REST endpoint to review the data,
or copy it and visualize the queried data in a Business Intelligence tool, notebook,
code and so on. You can also review the list of Materialized View and API keys on the
Materialized View page.