Skip to main content

Run a query on Databricks

Project description


Run Databricks queries from your terminal or editor.

Basic demo

Installation and configuration

pip3 install dbq

Note: libsasl2 is required on your system. On Ubuntu, get it through sudo apt-get install libsasl2-dev.

Configuration instructions will be displayed when you run dbq.


dbq [QUERY]

Interactive session

Run dbq (without QUERY) to start an interactive REPL. Readline is supported, a history file is kept in ~/.dbq_history.

Read query from stdin

Specify - for QUERY. Useful for editor integrations; see next section.

Integrating with vim

This example binds ctrl+s to running the selected text as a query (visual mode) or the subquery that is under the cursor (normal mode).

nnoremap <C-s> vi(:w !dbq -<cr>
vnoremap <C-s> :w !dbq -<cr>

Vim demo

Development and contributing

For development pipenv is required on your system. Set up the development environment with make develop, run with pipenv run dbq ... as needed. When submitting pull requests, ensure that make lint comes back clean; you can auto format the code with make format.

We welcome pull requests; if you are planning to perform bigger changes then it makes sense to file an issue first.


For sensitive security matters please contact


Copyright 2019 GetYourGuide GmbH.

dbq is licensed under the Apache License, Version 2.0. See LICENSE for the full text.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbq-0.9.0.tar.gz (3.4 kB view hashes)

Uploaded source

Built Distribution

dbq-0.9.0-py3-none-any.whl (7.9 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page