Slide 1
Slide 1 text
Hidden gems in Redash
@ariarijp
Slide 2
Slide 2 text
Me
• ariarijp (Takuya Arita / ༗ా ࠸)
• Organizer of Redash Meetup
• Contributor of getredash/redash
• Working at Unitone inc.
• Twitter: @ariarijp
• Facebook: ariarijp
• GitHub: ariarijp
Slide 3
Slide 3 text
I'm going to talk about five of
advanced features and usage in
Redash
Slide 4
Slide 4 text
Agenda
• Query Results Data Source
• Python Results Data Source
• Url Results Data Source
• Script Results Data Source
• Extending Redash
• Demo
• Consulusion
Slide 5
Slide 5 text
Query Results Data Source
Slide 6
Slide 6 text
Query Results Data Source
• You can use exiting Query as a Data Source
• I guess it's popular for you guys :)
• You can use SQLite's SQL Syntax
• Almost Standard SQL
• For now, you cannot use query parameters in Query Results Data Source
• It is still discussing at forum
• https://discuss.redash.io/t/thoughts-on-adding-support-for-queries-with-parameters-in-query-
results-data-source/1709?source_topic_id=1736
• https://discuss.redash.io/t/reql-query-language/1736/8
Slide 7
Slide 7 text
Python Data Source
Slide 8
Slide 8 text
Python Data Source
• You can use Python scripts as a Data Source
• You can write Python codes in the Query Editor on Redash
• If you want to use Python Data Source, you should know some Redash's
functions
• Eric Feng's article and Arik's example are good reference for developers
Slide 9
Slide 9 text
Url Data Source
Slide 10
Slide 10 text
Url Data Source
• You can use HTTP endpoints as a Data Source
• HTTP Endpoints should return Redash-styled JSON
• HTTP GET only supported
• You cannot send HTTP request body
Slide 11
Slide 11 text
Script Data Source
Slide 12
Slide 12 text
Script Data Source
• You can use any Scripts as a Data Source
• Scripts should output Redash-styled JSON
• This feature is insecure
• If you want to use it, you must care about your inventories
Slide 13
Slide 13 text
Extending Redash
Slide 14
Slide 14 text
Extending Redash
• You can create your own Query Runner
• Arik (The founder of Redash) introduces how to create a query runner for
Redash on forum
• If you want to create Query Runner, you should know about how Redash works
Slide 15
Slide 15 text
Demo
• 1: Use Python script as Data Source
• 2: Use hand-crafted Query Runner
Slide 16
Slide 16 text
Conclusion
• Redash has many varieties of Query Runners
• Redash can be extended by yourself in several ways
• Url, Script, or your own Query Runner
• However, I guess you can solve almost all of your issues without these
advanced features
• If you want to use advanced features, you have to remember below
• With great power comes great responsibility
Slide 17
Slide 17 text
Happy Redash-ing!