These are chat archives for getredash/redash

29th
Apr 2016
Joseph Francis
@josephfrancis
Apr 29 2016 10:54
Hi, any chance I could use the docker image in the public repository to run redash rather than using docker-compose?
Cory
@clevinson
Apr 29 2016 11:04
hallo! having some issues doing a deploy...
would appreciate a hand walking through the fab-file stuff if someone can give some advice
Arik Fraimovich
@arikfr
Apr 29 2016 11:06
@clevinson I can help in about an hour, when I'll be near a computer. Can help now but in limited capacity from my mobile.
@josephfrancis you can. Compose is only for convenience to run the other dependencies (postgres, redis).
Cory
@clevinson
Apr 29 2016 11:13
cheers, 1 hr is fine
Joseph Francis
@josephfrancis
Apr 29 2016 11:17
@arikfr it would be very helpful if you can direct me to a documentation on how to run the image? A simple docker run -d --name redash redash/redash doesn't look to be enough. I suppose the postgres and redis images needs to be run separately?
Arik Fraimovich
@arikfr
Apr 29 2016 11:17
Yes. But why not use docker compose to orchestrate them all?
Joseph Francis
@josephfrancis
Apr 29 2016 11:21
From the setup using docker-compose in the documentation required me to have a docker-machine running and setting it up on an amazon linux ami was a bit too much hassle for me :)
actually sorry! just saw the docker-compose-example.yml and that does indeed serve the purpose! thanks for your help :)
Arik Fraimovich
@arikfr
Apr 29 2016 11:51
@josephfrancis docker-machine isn't required, the documentation should clarify this.
@clevinson I'm around if you still need help.
@josephfrancis and you don't need the whole repo, just the compose file.
Cory
@clevinson
Apr 29 2016 11:53
all good now
just updated to 0.10.0
having a few strangenesses wehn I try to create a new visualization though...
Arik Fraimovich
@arikfr
Apr 29 2016 11:59
try clearing browser cache and refresh the page
Cory
@clevinson
Apr 29 2016 12:02
@arikfr danke
Arik Fraimovich
@arikfr
Apr 29 2016 12:03
@clevinson are you still using Redash along side Tableau?
Cory
@clevinson
Apr 29 2016 12:03
yep
Arik Fraimovich
@arikfr
Apr 29 2016 12:04
and what version did you upgrade from?
Cory
@clevinson
Apr 29 2016 13:52
0.8.0
(sorry was out to lunch)
Arik Fraimovich
@arikfr
Apr 29 2016 13:53
np. quite a jump :) you will find many things changed.
Cory
@clevinson
Apr 29 2016 13:53
loving the new plot.ly graphics :)
in general, it looks like the UI got a big upgrade
:clap: :clap: :clap: :clap:
Arik Fraimovich
@arikfr
Apr 29 2016 13:54
yes, that a recent change in 0.10. but there are bug fixes and new features as well.
Florian Pieront
@fpieront
Apr 29 2016 15:33
is upgrading using the fabfile likely to overwrite my own nginx & supervisor conf files? is there anything i should pay attention to when running it on a not redash-exclusive server?
vgeorgo
@vgeorgo
Apr 29 2016 17:07
Hi there!
Can I aks questions here? About doubts I have using Redash?
Arik Fraimovich
@arikfr
Apr 29 2016 17:19
@fpieront no, it won't touch supervisor or nginx. but I recommend reviewing the script and understanding what it does.
@vgeorgo sure.
vgeorgo
@vgeorgo
Apr 29 2016 17:21
My query on Redash brings a huge amount of rows...
I needed to use it in my application with params, is that possible? I have already set the query with the param and when I open the URL with the 'p_param' the query executes, but I don't know how to execute that from my application.
Is it possible?
Arik Fraimovich
@arikfr
Apr 29 2016 18:07
From your application, you mean via the api?
vgeorgo
@vgeorgo
Apr 29 2016 18:08
yes, via API
Arik Fraimovich
@arikfr
Apr 29 2016 18:16
not at the moment, but it's something I'm planning to add soon. if you need a new result on every call, you can use the refresh API instead, which already supports parameters
vgeorgo
@vgeorgo
Apr 29 2016 18:23
no, we would need all result working at the same time...
do you know when maybe the parameter via API will be working?
Arik Fraimovich
@arikfr
Apr 29 2016 18:24
what do you mean by "all result working at the same time"?
vgeorgo
@vgeorgo
Apr 29 2016 18:25
i guess i'm supposing how it would work with a query with parameters..
a new result would be saved for every different parameter?
Arik Fraimovich
@arikfr
Apr 29 2016 18:26
yes
vgeorgo
@vgeorgo
Apr 29 2016 18:26
so, thats what i meant
Arik Fraimovich
@arikfr
Apr 29 2016 18:26
so that's what it does :)
it just that the refresh API will always execute the query, while the other API might return cached result if available
vgeorgo
@vgeorgo
Apr 29 2016 18:28
yeah, thats what im looking for, cause the query we are executing takes about 40 seconds to execute.. and we need to use it with parameters
we cant really wait 40 seconds every time we need to open a new page
thats why i was looking for cached queries with params
but if this is not working yet I guess we'll jsut have to wait
Arik Fraimovich
@arikfr
Apr 29 2016 18:30

you can implement caching on your side as a temporary solution. the way the refresh API works is:

  1. you call refresh asking to refresh query X with parameter Y
  2. it creates a task to refresh the query, and returns it ID
  3. you poll on this ID until you get a result

just store the result ID , and query for it directly until you want a new result

vgeorgo
@vgeorgo
Apr 29 2016 18:34
yea, that should work, we were just wondering if the redash would already have this working
but maybe we will try this solution
vgeorgo
@vgeorgo
Apr 29 2016 18:47
thank you for your help
Arik Fraimovich
@arikfr
Apr 29 2016 18:47
happy to help
what are you doing with Redash? I mean, where are you using the API?
vgeorgo
@vgeorgo
Apr 29 2016 18:50
we are generating data based on periods
until now we were working with the query bringing all the periods at once, but we realized that this is causing some side effects, cause the result thats generated is really big
thats why we needed tthe parameters, to bring less data based on the period
its still a great amount of data, but not as big as brings all the periods
don't know if thats what you asked
Arik Fraimovich
@arikfr
Apr 29 2016 18:53
but what do you do with the result?
vgeorgo
@vgeorgo
Apr 29 2016 18:55
for now the app filters the data as we need and present on the screen
Arik Fraimovich
@arikfr
Apr 29 2016 19:04
got it. thanks