Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Hidden gems in Redash

Hidden gems in Redash

Redash Meetup 3.0.0 の発表資料です #redashmeetup

Takuya Arita

July 10, 2018
Tweet

More Decks by Takuya Arita

Other Decks in Technology

Transcript

  1. Me • ariarijp (Takuya Arita / ༗ా ୓࠸) • Organizer

    of Redash Meetup • Contributor of getredash/redash • Working at Unitone inc. • Twitter: @ariarijp • Facebook: ariarijp • GitHub: ariarijp
  2. Agenda • Query Results Data Source • Python Results Data

    Source • Url Results Data Source • Script Results Data Source • Extending Redash • Demo • Consulusion
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. Demo • 1: Use Python script as Data Source •

    2: Use hand-crafted Query Runner
  9. 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