Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    How are you using Redash?

    Redash
    6
    10
    493
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • robi
      robi last edited by

      Anyone using it?
      How so?
      Have you successfully pointed it at the local Cloudron DBs?

      Life of Advanced Technology

      rmdes jimcavoli 2 Replies Last reply Reply Quote 1
      • rmdes
        rmdes @robi last edited by

        @robi I tried to point it to cloudron db's but never managed to make this work, if you manage to do this I'm interested to learn !

        1 Reply Last reply Reply Quote 0
        • martinkbs
          martinkbs last edited by

          You just have to use the command in the server terminal to identify the host IP.

          docker inspect mysql | grep IPAddress
          

          With this and with the credentials of the application database, you can connect Redash.

          redash-test.png

          1 Reply Last reply Reply Quote 3
          • jimcavoli
            jimcavoli App Dev @robi last edited by

            @robi Yeah, I set it up as you suggested, but confusion/difficulty around permissions and the requirement of SQL to build queries brought be back to Metabase. I've played with Apache Superset before, the other of the "big 3" in this space (if we keep Grafana separate; imo not in the same category) though I don't remember a ton about it by comparison. Either way, pointing it at the databases was the easy part.

            robi 1 Reply Last reply Reply Quote 1
            • robi
              robi @jimcavoli last edited by

              @jimcavoli so you're saying Metabase is better to point at the local DB and get some automatic insights than with Redash where you have to build out the queries for the graphs?

              Life of Advanced Technology

              jimcavoli 1 Reply Last reply Reply Quote 0
              • marcusquinn
                marcusquinn last edited by marcusquinn

                Most useful thing for me with any of these apps is building pivot-tables, which sadly is an enterprise feature in Metabase. Not played with Redash yet but if anyone knows if it does pivot-tables, that would be a huge win for creating self-service reporting tools.

                We're not here for a long time - but we are here for a good time :)
                Jersey/UK
                Work & Ecommerce Advice: https://brandlight.org
                Personal & Software Tips: https://marcusquinn.com

                robi 1 Reply Last reply Reply Quote 0
                • jimcavoli
                  jimcavoli App Dev @robi last edited by jimcavoli

                  @robi Yeah, if it's automatic or nearly automatic "here's some interesting things" you want, it's worth getting the data model set up with some added detail in the Metabase Admin, which is easy enough (it does a pretty good job of inferring common conventions), and then browsing through the data and doing different visualizations is dead easy, plus it'll try to do some automatic "X-Rays" as it calls the auto-generated dashboards. Here's an example of a table that I haven't customized the data model on at all, but it did a good job with, as an example:

                  Edit: Ugh, no GIFs allowed. Here's a sequence of static shots:

                  CleanShot 2020-11-20 at 09.41.57.png
                  CleanShot 2020-11-20 at 09.42.55.png
                  CleanShot 2020-11-20 at 09.43.24.png

                  I'd suggest playing with both - there's necessarily going to be a fair bit of preference at play here.

                  nebulon 1 Reply Last reply Reply Quote 4
                  • nebulon
                    nebulon Staff @jimcavoli last edited by

                    @jimcavoli fixed the gif uploading

                    jimcavoli 1 Reply Last reply Reply Quote 5
                    • jimcavoli
                      jimcavoli App Dev @nebulon last edited by

                      @nebulon You rock

                      1 Reply Last reply Reply Quote 0
                      • robi
                        robi @marcusquinn last edited by

                        @marcusquinn https://redash.io/help/user-guide/visualizations/pivot-table-visualizations

                        Accessible from the in app help under Visualizations

                        Life of Advanced Technology

                        1 Reply Last reply Reply Quote 1
                        • Referenced by  robi robi 
                        • First post
                          Last post
                        Powered by NodeBB