退屈なことは RedashAPI にやらせよう/utilize-redash

RedashAPIの紹介 @Redash Meetup 6.0.0

Transcript

1. ๼౹ƍŶƋƒ
   RedashAPI ƎƧƬžƫũ 3FEBTI
   .FFUVQ
   
   !BSJNBOY
2. ࣗݾ঺հ w ໊લ
   ߥҪ྄ຏ
   w ৬छ
   σʔλΤϯδχΞ!גࣜձࣾΤϒϦʔ
   w झຯ
   ໺ٿ؍ઓ υϥΰϯζ
   
   ϚϦʔϯζ
   w 5XJUUFS
   !BSBJNBOY
3. ΞδΣϯμ w "1*ʹΑΓ࡞ۀ޻਺Λେ෯ʹ࡟ͬͨࣄྫ
   w "1*ػೳ֓ཁ
   w "1*ར༻ͷྲྀΕ
   d
   άϥϑͷՄࢹԽΛྫʹ
   d
4. ΞδΣϯμ w "1*ʹΑΓ࡞ۀ޻਺Λେ෯ʹ࡟ͬͨࣄྫ
   w "1*ػೳ֓ཁ
   w "1*ར༻ͷྲྀΕ
   d
   άϥϑͷՄࢹԽΛྫʹ
   d
5. ࣌ؒ
   
   ὎
   
   ෼
6. ࡞ۀ಺༰ ҎԼͷΑ͏ͳνϟʔτΛ໿ݸ࡞Δඞཁ͕͋ͬͨ
7. ࡞ۀ޻ఔ "1*׆༻લ ΫΤϦ࡞੒
   ΫΤϦ࣮ߦ άϥϑඳը ɾ42-ͷهड़
   ɾม਺ͷઃఆ ɾ࣮ߦ ɾ9:࣠ͷઃఆ
   ɾม਺ͷઃఆ
   ɾ:࣠ͷεέʔϧ
   ɹมߋ
8. ࡞ۀ޻ఔ "1*׆༻ޙ ΫΤϦ࡞੒
   ΫΤϦ࣮ߦ άϥϑඳը ɾ42-ͷهड़
   ɾม਺ͷઃఆ શͯࣗಈԽ͠·ͨ͠ ɾ࣮ߦ ɾ9:࣠ͷઃఆ
   ɾม਺ͷઃఆ
   ɾ:࣠ͷεέʔϧ
   ɹมߋ
9. ࢖༻ٕज़ w ݴޠ
   w 1ZUIPO
   w ϥΠϒϥϦ
   w KTPO
   w SFRVFTUT
10. ΞδΣϯμ w "1*ʹΑΓ࡞ۀ޻਺Λେ෯ʹ࡟ͬͨࣄྫ
    w "1*ػೳ֓ཁ
    w "1*ར༻ͷྲྀΕ
    d
    άϥϑͷՄࢹԽΛྫʹ
    d
11. άϥϑͷඳը·Ͱ"1*Ͱ׬݁Ͱ͖Δ͜ͱ
    ஌͍ͬͯ·͔ͨ͠ʁ
12. ެࣜυΩϡϝϯτͷهड़ ΫΤϦͷग़ྗ΍ɺΫΤϦͷߋ৽ʹؔͯ͠ͷྫࣔ
13. ιʔείʔυ ͨ͘͞Μʂ(6*ʹଘࡏ͢Δػೳ͸ԿͰ΋Ͱ͖ͦ͏
14. "1*ͷػೳ֓ཁ Queries Resouce ΫΤϦͷ$36%ɾ42-ϑΥʔϚοτɾΫΤϦݕࡧ QueryResults Resouce ΫΤϦͷ࣮ߦɾΫΤϦ݁Ռͷऔಘ Job Resource ࣮ߦதδϣϒͷऔಘΩϟϯηϧ Visualization Resource άϥϑͷ$36% Dashboard Resource μογϡϘʔυͷ$36%
15. ΞδΣϯμ w "1*ʹΑΓ࡞ۀ޻਺Λେ෯ʹ࡟ͬͨࣄྫ
    w "1*ػೳ֓ཁ
    w "1*ར༻ͷྲྀΕ
    d
    άϥϑͷՄࢹԽΛྫʹ
    d
16. "1*ར༻ͷྲྀΕ
    d
    άϥϑͷՄࢹԽΛྫʹ
    d w 6TFS
    "1*
    ,FZͷऔಘ
    w +40/ܗࣜͷϦΫΤετσʔλ࡞੒
    w "1*΁ͷϦΫΤετ
17. 6TFS
    "1*
    ,FZͷऔಘ ΞΧ΢ϯτϖʔδ͔ΒऔಘՄೳ
18. +40/ܗࣜͷϦΫΤετσʔλ࡞੒ body = { "id": None, "type": "CHART", "name": "άϥϑ໊", "description": "", "options": { "globalSeriesType": "bubble", "columnMapping": { “column_for_x”: "x", “column_for_y”: "y", “column_for_series”: "series", “column_for_bubble_size”: "size" }, ... }, "query_id": 1234 } νϟʔτͷछྨ ΧϥϜࢦఆ
19. "1*΁ͷϦΫΤετ body = { "id": None, ... "query_id": 1234 } header = { "content-type": "application/json", "Authorization": "Key your_api_key" } requests.post( "http://localhost/api/visualizations/1234", data=json.dumps(body), headers=header )
20. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠