Sooner or later, we will be depending on external libraries than that don't come bundled with Zeppelin. For instance, we might need, a library for CSV or import or RDBMS data import. Let's see how to load a MySQL database driver and visualize data from a table.
In order to load a mysql connector Java driver, we just need to specify the group ID, artifact ID, and version number, and the JAR gets downloaded from the Maven repository. %dep indicates that the paragraph adds a dependency, and the z implicit variable represents the Zeppelin context:
The only thing that we need to watch out for while using %dep is that the dependency paragraph should be used before using the libraries that are being loaded. So it is generally advised to load the dependencies at the top of the Notebook.
Once we have loaded the dependencies, we need to construct the options required to connect to the MySQL database:
We use the connection to create a DataFrame:
