Apache Drill Connection

The Apache Drill connection type configures a connection to Apache Drill via the sqlalchemy-drill Python package.

Default Connection IDs

Drill hooks and operators use drill_default by default.

Configuring the Connection

Host (required)

The host of the Drillbit to connect to (HTTP, JDBC) or the DSN of the Drill ODBC connection.

Port (optional)

The port of the Drillbit to connect to.

Extra (optional)

A JSON dictionary specifying the extra parameters that can be used in sqlalchemy-drill connection.

  • dialect_driver - The dialect and driver as understood by sqlalchemy-drill. Defaults to drill_sadrill (HTTP).

  • storage_plugin - The default Drill storage plugin for this connection. Defaults to dfs.

Was this entry helpful?