Skip to main content
Join the official 2020 Python Developers SurveyStart the survey!

Redash Dynamic Query

Project description

## Redash Dynamic Query

A tool for executing dynamic query of redash.

## Install

```
pip install redash-dynamic-query
```

## SYNOPSIS

```python
from redash_dynamic_query import RedashDynamicQuery

redash = RedashDynamicQuery(
endpoint='http://myredash-host',
apikey='secret_apikey',
data_source_id=2, # Optional, default auto fill
max_age=0, # Optional, default value is 0
max_wait=60, # Optional, default value is 60
)

query_id = 111
bind = {
'start_date': '2017-01-01T00:00:00',
'end_date': '2017-01-01T23:59:59',
}
result = redash.query(query_id, bind)
print(result['query_result']['data'])
# {
# 'rows': [
# {'mydata': 'xxx'}
# ],
# 'columns': [
# {
# 'type': 'string',
# 'friendly_name': 'mydata',
# 'name': 'mydata'
# }
# ]
# }
```

## CLI

```
% rdq
```

```
% rdq --help

usage: rdq [-h] [-d N] [-a N] [-w N] [-k APIKEY] [-e ENDPOINT] -q QUERY_ID
[-p QUERY_PARAMETERS] [-f {csv,tsv,json,redash_csv}]

Process some integers.

optional arguments:
-h, --help show this help message and exit
-d N, --data-source-id N
an integer for the data_source_id
-a N, --max-age N an integer for the max_age
-w N, --max-wait N an integer for the max_wait(timeout)
-k APIKEY, --apikey APIKEY
required: redash apikey (can also be specified using
REDASH_APIKEY environment variable)
-e ENDPOINT, --endpoint ENDPOINT
required: redash endpoint (can also be specified using
REDASH_ENDPOINT environment variable)
-q QUERY_ID, --query-id QUERY_ID
required: redash query id
-p QUERY_PARAMETERS, --query-parameters QUERY_PARAMETERS
redash query parameters(eg. key1=val1,key2=val2)
-f {csv,tsv,json,redash_csv}, --output-format {csv,tsv,json,redash_csv}
redash output format
```

```
# example
% rdq -e http://myredash-host -k secret_apikey -q 111 -p start_date=2017-01-01T00:00:00,end_date=2017-01-01T23:59:59 -f csv
```

## LICENSE

MIT

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 redash-dynamic-query, version 1.0.4
Filename, size File type Python version Upload date Hashes
Filename, size redash-dynamic-query-1.0.4.tar.gz (5.2 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page