Run Databricks queries from your terminal or editor.
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]
Run dbq (without QUERY) to start an interactive REPL. Readline is supported, a history file is kept in ~/.dbq_history.
Specify - for QUERY. Useful for editor integrations; see next section.
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>
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 [email protected].
Copyright 2019 GetYourGuide GmbH.
dbq is licensed under the Apache License, Version 2.0. See LICENSE for the full text.