Run SQL Queries from Postman😲

Yes, You have heard right 🙂we can run SQL Queries from Postman with the help of Apache Drill.

Apache DRILL with JDBC Client

Apache Drill is the first schema-free open-source SQL query engine for Big Data exploration. Let’s see how we can run SQL queries from the Postman

Setup on Windows machine

Step1: Download and Install java on the machine. And make sure to add the java path to the environment variable.

Resource link: https://www.oracle.com/java/technologies/downloads

Step2: Download and Install Apache drill Client Drivers (ODBC/JDBC). And make sure to add the Apache drill path to the environment variable.

Resource link: https://drill.apache.org/download

Step3: Start the Apache drill services. Open the cmd and type the command.

Command to start the Apache drill service: sqlline.bat -u “jdbc:drill:zk=local”

Command to quit Apache drill cmd: !quit

When the service gets started open the browser and type http://localhost:8047 UI for Apache drill gets opened up.

Step 4: There are few things to be kept in mind before creating a successful storage plugin.

1. MySQL service is up and running. Should have at least one database and one table.