Visualizing data in a Zeppelin notebook

Db2 Big SQL data can be visualized for examination or presentation through an Apache Zeppelin notebook.

Before you begin

Make sure that you have Apache Zeppelin installed and a Db2 Big SQL interpreter configured. For details see Configuring the Db2 Big SQL interpreter for Apache Zeppelin.

Visualizing your data

To visualize Db2 Big SQL data in a Zeppelin notebook:
  1. Access Zeppelin in a web browser at address: http://<Zeppelin host>:9995/.
  2. In the navigation bar, click on the Notebook drop-down menu and select Create new note.
    screen capture of Ambari user interface
  3. Provide a note name. For the interpreter select bigsql and then click OK.
  4. If you want to change the interpreter binding, click on the notebook gear icon and select interpreter binding settings.
    screen capture of Ambari user interface

    Once the interpreter is chosen, you will see %bigsql (in this scenario) already populated in the first cell of the notebook.

  5. Do some simple testing to check that the connection works, as shown below:
    screen capture of Ambari user interface
  6. You can also query against the data that is already accessible via Db2 Big SQL.

You are now able to visualize data in Db2 Big SQL using an Apache Zeppelin notebook.