Using the Streaming SQL Console
The Streaming SQL Console is the user interface for the SQL Stream Builder. You can manage your queries, tables, functions and monitor the history of the SQL jobs using the SQL Stream Console.
You can access the Streaming SQL Console through Cloudera Manager:
- Go to your cluster in Cloudera Manager.
- Click on SQL Stream Builder from the list of Services.
- Click on SQLStreamBuilder Console.
The following illustration details the main menu and the tabs of the user interface.
- The main menu consist of the following:
- Console - The homepage of the Console where you can find the SQL window, other tabs and the Log window.
- Data Sources - Setting up data sources and sinks for the Virtual Tables.
- Materialized Views - Setting up and managing Materialized Views and API keys.
- The main tabs consist of the following:
- Compose - At default, the Compose tab is selected on the Console. You can create your SQL queries on the Compose tab.
- Virtual Tables - You can select your Virtual Tables on this tab.
- History - You can review the history of submitted SQL queries.
- SQL Jobs - You can review the history of submitted SQL jobs.
- The alternate windows consist of the following:
- SQL - At default, the SQL Window is displayed on the Console. You can add your SQL Queries to the window to compose queries.
- Materialized View - Displays settings to create Materialized Views.
- The audit tabs consist of the following:
- Logs - Displays the status of the SQL Console.
- Results - Displays the results of the executed SQL queries.
- SQL Window - SQL statement editor of the Console.