This is an automated email from the ASF dual-hosted git repository.
billyliu pushed a commit to branch document
in repository https://gitbox.apache.org/repos/asf/kylin.git
The following commit(s) were added to refs/heads/document by this push:
new 050aa45 add redash-kylin plugin from strikingly
050aa45 is described below
commit 050aa454fefb5acf31e4977ea3408ee396b99fe1
Author: Billy Liu <billy...@apache.org>
AuthorDate: Tue May 8 18:34:04 2018 +0800
add redash-kylin plugin from strikingly
---
.../2018-05-08-redash-kylin-plugin-strikingly.md | 42 +++++++++++++++++++++
website/images/blog/redash/redash_1.jpeg | Bin 0 -> 371859 bytes
website/images/blog/redash/redash_2.jpeg | Bin 0 -> 420526 bytes
website/images/blog/redash/redash_3.jpeg | Bin 0 -> 300777 bytes
website/images/blog/redash/redash_4.jpeg | Bin 0 -> 400477 bytes
5 files changed, 42 insertions(+)
diff --git a/website/_posts/blog/2018-05-08-redash-kylin-plugin-strikingly.md
b/website/_posts/blog/2018-05-08-redash-kylin-plugin-strikingly.md
new file mode 100644
index 0000000..70f765d
--- /dev/null
+++ b/website/_posts/blog/2018-05-08-redash-kylin-plugin-strikingly.md
@@ -0,0 +1,42 @@
+---
+layout: post-blog
+title: Redash-Kylin plugin from Strikingly
+date: 2018-05-08 20:00:00
+author: Chase Zhang
+categories: blog
+---
+
+At strikingly, we are using Apache Kylin as our OLAP engine. Kylin is very
powerful and it supports our big data business well. We've chosen Apache Kylin
because it fits our demand: it handles a huge amount of data, undertakes
multiple concurrent queries and has sub-second response time.
+
+Although we are mainly using Kylin to provide service to our customers, we've
decided to reuse the built result for internal purposes too. Kylin supports
Business Intelligence tools like Apache Zeppelin and Tableau. With these BI
tools we can provide insight and visualization about our data which will help
making business decisions.
+
+Other than those BI tools mentioned above, we're using another similar
application named Redash because:
+
+1. We've already had a deployment of redash for data analyzing upon
traditional databases like PostgreSQL, etc
+
+2. Redash is open source and easy to deploy, rich in visualization functions
and has good integrations with other productivity tools we are using (like
Slack).
+
+Unfortunately, redash doesn't officially support Kylin as a data source for
now. Thus we wrote a simple one to include it. The plugin has already been open
sourced under BSD-2 license as a [GitHub
repository](https://github.com/strikingly/redash-kylin).
+
+The redash-kylin plugin is just a single piece of python file which implements
redash's data source protocol. To install, retrieve the `kylin.py` file inside
`redash/query_runner` folder of the plugin's repository and place it under
corresponding folder of redash.
+
+
+
+Before you can use the plugin, you need to enable it first. Please modify the
default enabled plugin list defined in `redash/settings.py`:
+
+
+
+At last you have to rebuild the docker image (if you are using docker
deployment) of redash and restart both server and worker of it. Currently, the
redash-kylin plugin only supports the current stable version of redash (3.0.0)
and 2.x version of Apache Kylin.
+
+Once installed successfully, you'll be able to find a KylinAPI data source
type at the New Data Source page. To use it, just select that source type and
fill in required fields. The redash-kylin plugin works by calling Kylin's HTTP
RESTful API, thus you should make sure your redash deployment has an access to
your Kylin cluster (either job mode or query mode).
+
+
+
+After a data source is setup and the connection is tested ok. You should be
able to view schemas, run queries and make visualizations from tables in Kylin.
Just type the SQL query in and get the result out. For more details about
redash's usage, please refer to [redash's
documentation](https://redash.io/help/).
+
+
+
+
+You can also add multiple data sources by setting different project names or
different API URLs. It's worth to mention that redash has an experiment
function which supports making a query from former cached query results. Thus,
once query results from different Kylin cluster has been imported, you'll be
able to join them together for richer data processing.
+
+Wish you have a good time with Redash-Kylin!
\ No newline at end of file
diff --git a/website/images/blog/redash/redash_1.jpeg
b/website/images/blog/redash/redash_1.jpeg
new file mode 100644
index 0000000..20b63eb
Binary files /dev/null and b/website/images/blog/redash/redash_1.jpeg differ
diff --git a/website/images/blog/redash/redash_2.jpeg
b/website/images/blog/redash/redash_2.jpeg
new file mode 100644
index 0000000..6a5e257
Binary files /dev/null and b/website/images/blog/redash/redash_2.jpeg differ
diff --git a/website/images/blog/redash/redash_3.jpeg
b/website/images/blog/redash/redash_3.jpeg
new file mode 100644
index 0000000..1988d32
Binary files /dev/null and b/website/images/blog/redash/redash_3.jpeg differ
diff --git a/website/images/blog/redash/redash_4.jpeg
b/website/images/blog/redash/redash_4.jpeg
new file mode 100644
index 0000000..80e46e5
Binary files /dev/null and b/website/images/blog/redash/redash_4.jpeg differ
--
To stop receiving notification emails like this one, please contact
billy...@apache.org.
