Redash supports several types of data sources, and if you set it up using the provided images, it should already have the needed dependencies to use them all. Starting from version 0.7 and newer, you can manage data sources from the UI by browsing to
/data_sources on your instance.
If one of the listed data source types isn’t available when trying to create a new data source, make sure that:
REDASH_ENABLED_QUERY_RUNNERSsetting, it’s included in the list.
pyopensslpython packages (on Ubuntu it might require installing
For information on how to write MongoDB queries, see documentation.
For information on how to write Elasticsearch queries, see documentation.
- String of format
- Address to a Presto coordinator.
- Port to a Presto coordinator. 8080 is the default port.
- Default schema name of Presto. You can read other schemas by qualified name like FROM myschema.table1.
- Catalog (connector) name of Presto such as hive-cdh4, hive-hadoop1, etc.
- User name to connect to a Presto.
A URL based data source which requests URLs that return the results JSON format
Very useful in situations where you want to expose the data without connecting directly to the database.
The query itself inside Redash will simply contain the URL to be executed (i.e. http://myserver/path/myquery)
Valid types of columns returned in results:
To manipulate the data you get from the URL you can save the query that resulted with all the data and then query that data set. Read more about querying query results here.
Read about querying Google Spreadsheets here.
Execute other queries, manipulate and compute with Python code
This is a special query runner, that will execute provided Python code as the query. Useful for various scenarios such as merging data from different data sources, doing data transformation/manipulation that isn’t trivial with SQL, merging with remote data or using data analysis libraries such as Pandas (see example query).
While the Python query runner uses a sandbox (RestrictedPython), it’s not 100% secure and the security depends on the modules you allow to import. We recommend enabling the Python query runner only in a trusted environment (meaning: behind VPN and with users you trust).
REDASH_ADDITIONAL_QUERY_RUNNERSenvironmental variable. If you used the bootstrap script, or one of the provided images, add to
/opt/redash/.envfile the line:
- DSN Service name
cx_Oraclepython package. This requires the installation of the Oracle instant client.
- Type (TreasureData)
- API Key
- Database Name
- Type (Presto/Hive[default])
Data type support is currently quite limited.
Complex and new types are converted to strings in
Known conversion issues for:
pymssqlpython package, requires FreeTDS to be installed first
- URL (your JIRA instance url)
For information on how to write JIRA/JQL queries, click here.