The recommended way to connect to Apache Drill is through SQLAlchemy. You can use the sqlalchemy-drill package.
Once that is done, you can connect to Drill in two ways, either via the REST interface or by JDBC. If you are connecting via JDBC, you must have the Drill JDBC Driver installed.
The basic connection string for Drill looks like this:
To connect to Drill running on a local machine running in embedded mode you can use the following connection string:
Connecting to Drill through JDBC is more complicated and we recommend following this tutorial.
The connection string looks like: