Apache Drill

Interact with Apache Drill via sqlalchemy-drill.

View on GitHub

Last Updated: Mar. 22, 2023

Access Instructions

Install the Apache Drill provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.


schemaOptional DB schema that overrides the schema specified in the connection. Make sure that if you change the schema parameter value in the constructor of the derived Hook, such change should be done before calling the DBApiHook.__init__().
log_sqlWhether to log SQL query when it’s executed. Defaults to True.


Interact with Apache Drill via sqlalchemy-drill.

You can specify the SQLAlchemy dialect and driver that sqlalchemy-drill will employ to communicate with Drill in the extras field of your connection, e.g. {"dialect_driver": "drill+sadrill"} for communication over Drill’s REST API. See the sqlalchemy-drill documentation for descriptions of the supported dialects and drivers.

You can specify the default storage_plugin for the sqlalchemy-drill connection using the extras field e.g. {"storage_plugin": "dfs"}.

Was this page helpful?