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.

Files for dbq, version 0.9.0
Filename, size File type Python version Upload date Hashes
Filename, size dbq-0.9.0.tar.gz (3.4 kB) File type Source Python version None Upload date Hashes View
Filename, size dbq-0.9.0-py3-none-any.whl (7.9 kB) File type Wheel Python version py3 Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page