The Open Distro for Elasticsearch Query Workbench enables you to query your Elasticsearch data using either SQL or PPL syntax from a dedicated Kibana UI. You can download your query results data in JSON, JDBC, CSV and raw text formats.

Please see our technical documentation to learn more about its features.

1. Download Elasticsearch for the version that matches the Kibana version specified in package.json.

2. Download and install the most recent version of Open Distro for Elasticsearch SQL plugin.

3. Download the Kibana source code for the version specified in package.json you want to set up.

   See the Kibana contributing guide for more instructions on setting up your development environment.

4. Change your node version to the version specified in .node-version inside the Kibana root directory.

5. cd into the Kibana source code directory.

6. Check out this package from version control into the plugins directory.

git clone git@github.com:opendistro-for-elasticsearch/sql.git plugins --no-checkout
cd plugins
echo 'workbench/*' >> .git/info/sparse-checkout
git config core.sparseCheckout true
git checkout master

6. Run yarn kbn bootstrap inside kibana/plugins/workbench.

Ultimately, your directory structure should look like this:

.
├── kibana
│   └── plugins
│       └── workbench

To build the plugin's distributable zip simply run yarn build.

Example output: ./build/opendistro-query-workbench-*.zip

• yarn start

  Starts Kibana and includes this plugin. Kibana will be available on localhost:5601.

• NODE_PATH=../../node_modules yarn test:jest

  Runs the plugin tests.

• Refer to CONTRIBUTING.md.
• Since this is a workbench, it can be useful to review the Kibana contributing guide alongside the documentation around workbenchs and plugin development.

Please file an issue to report any bugs you may find, enhancements you may need or questions you may have here.

This code is licensed under the Apache 2.0 License.

Copyright 2020 Amazon.com, Inc. or its affiliates. All Rights Reserved.