Hey πŸ‘‹πŸ»

My name is Christian, an Agile Developer, living in Trento (IT)

I write good code at Wonderflow

You can follow me on and Github


More about me πŸ€–




Trying out Redash

Today I installed redash with AWS EC2 and AWS SES, with the help of the official guide.

Take a look at the public dashboard that visualizes the current user count on my Redash instance!

redash.users.count.png

The server runs on a t2.micro instance, backed by the Redash Ubuntu AMI.

I am using Amazon SES as the mail service.

Redash

Visualize Queries

To visualize something in Redash, you need a query.

And you execute a query on some data.

Fortunately, Redash has a default dataset (itself!) to play with, instead of hooking up an external data source.

Visualize Events

Create a new Query (/queries/new):

redash.create.new.query.png

Let’s aggregate events by action and type of a Redash instance:

SELECT count(*) as times
              , action
              , object_type
          FROM events
          group by action, object_type
          order by times desc

redash.query.new.png

Use the following configuration to create a visualization:

redash.visualization.new.png

Final result

You should end up with something like this:

redash.visualization.events.png


Conclusion

It seems like a nice piece of software, my idea is to integrate Redash with mnesia to visualize things you saved in mnesia!