How to Connect Apache Zeppelin with PostgreSQL

Step 1) Click on Interpreter

Step 2) Click on Create

Step 3) Give name for Interpreter psql

Step 4) Choose interpreter type JDBC

Step 5) scroll down to enter JDBC parameter

Step 6) default driver appears for PostgreSQL, Enter password for PostgreSQL

Step 7) Default JDBC URL will appear else change the URL as per user connection requirement and enter default user for postgreSQL

Step 8) Enter JDBC Jar path in artifact space

Step 9) Click on save and scroll up

Step 10) Click on create new note

Step 11) Enter note name as per your choice

Step 12) Click on default Interpreter psql

Step 13) Now Apache Zeppelin is connected with PostgreSQL

Video Available as part of below Training Course on Udemy or skillshare

APACHE ZEPPELIN TRAINING COURSE ON UDEMY OR SKILLSHARE

Skillshare Course link

https://skl.sh/2DTSLEh

Udemy Course Link

https://www.udemy.com/share/103ttw/

Learn to Install Apache Zeppelin, Connect with Databases, Load , Query & Visualize Data

In this Course participants will get overview of Apache Zeppelin, and will be able to perform following tasks.

  • Install Apache Zeppelin by downloading binary 
  • Install Apache Zeppelin with Docker
  • Install Apache Web Server (Command Line)
  • Install MariaDB
  • Install phpmyadmin
  • Create database and load SQL file in MariaDB table with phpmyadmin
  • Create database and load CSV file in MariaDB table with phpmyadmin
  • Configure interpreter for MariaDB to connect with Apache Zeppelin
  • Install MySQL
  • Install MySQL Workbench
  • Create database and load CSV file in MySQL table with MySQL Workbench
  •   Configure interpreter for MySQL to connect with Apache Zeppelin
  • Create interactive note and use databases in Apache Zeppelin
  • Install PostgreSQL with PGAdmin4
  • Configure interpreter for PostgreSQL to connect with Apache Zeppelin
  • Create interactive note and use databases in Apache Zeppelin
  • Create table Visualization in Interactive note with simple SQL Command
  • Create Bar Chart Visualization in Interactive note with simple SQL Command
  • Create Pie Chart Visualization in Interactive note with simple SQL Command
  • Create Area Chart Visualization in Interactive note with simple SQL Command
  • Create Line Chart Visualization in Interactive note with simple SQL Command
  • Create Scatter Chart Visualization in Interactive note with simple SQL Command