Skip to main content

Run a query on Databricks

Project description

dbq

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.

Usage

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.

Security

For sensitive security matters please contact security@getyourguide.com.

Legal

Copyright 2019 GetYourGuide GmbH.

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

Project details


Release history Release notifications

This version

0.9.0

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-py3-none-any.whl (7.9 kB) File type Wheel Python version py3 Upload date Hashes View hashes
Filename, size dbq-0.9.0.tar.gz (3.4 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page