A Treasure Data query shell
Project description
tdq
Treasure Data Query shell
Install
pip install tdq
Features
A wrapper for td-client that focus on SQL query with following feature
- bash-like history-list editing (e.g. Control-P scrolls back to the last command, Control-N forward to the next one, Control-F moves the cursor to the right non-destructively, Control-B moves the cursor to the left non-destructively, etc.).
- directly execute SQL to the remote TD endpoint
- support multi-line queries
- support horizontal, vertical and CSV format ouput
Usage
Start the shell with default configuration
tdq
See all the command parameters:
tdq --help
Run the shell with predefined sql queries and write the result ot a CSV file
tdq -f input.sql -o output.csv --output-format CSV_HEADER
Besides valid commands, all user's inputs are consdered SQL queries. Currently, below commands are supported:
- help: display valid commands
- use : change current database. This could be set by -d option or read from default TD client config file
- display : change current display mode. Value is among
horizontal
,vertical
orNone
(auto) - quit: quit the shell (same with Ctrl-D)
Use -h to see all options
Configuration
tdq will utilize the file ~/.td/td.conf created by td-client for default configuration
Other
- see here for details about Treasure Data Python client
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
tdq-0.0.2-py3-none-any.whl
(9.2 kB
view hashes)