Creating widgets

Widgets can be created on Streaming SQL Console when a SQL query is submitted and the job is successfully running.

  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
      The Streaming SQL Console opens in a new window.
  2. Open a project from the Projects page of Streaming SQL Console.
    1. Select an already existing project from the list by clicking the Open button or Switch button.
    2. Create a new project by clicking the New Project button.
    3. Import a project by clicking the Import button.
    You are redirected to the Explorer view of the project.
  3. Click Dashboard from the Project Manager.
  4. Click New Widgets.
    The Widget editor page appears.
    The Widget editor page consist of the following windows:
    • Data source, where you can select the job and its corresponding data sources for the widget.
    • Visualization Type where you can provide information and customize the visualization type.
    • Preview of the created widget, where you can check the configurations and customization of the widget that will be added to the Dashboard.
  5. Select a Data Source.
    The running jobs will be automatically displayed and categorized based on the Sampler or the Materialized View endpoint name of the corresponding job.For more information, see the Choosing data sources section.
  6. Select a Visualization type.
    A preview is available from the selected data source and visualization type.
  7. Customize the Visualization based on the available options.
    For more information, see the Customizing visualization types section.
  8. Click Create.
    The created widget is added to the Dashboard page.
    You can manage the created widget on the Dashboard by clicking , and selecting Edit to go back to the widget editor page and make changes to the visualization, or Remove to delete the widget.
You can create more widgets to the Dashboard page. You can resize and reorganize the widgets based on your requirements. For more information, see the Managing widgets on the Dashboard section.