These are chat archives for getredash/redash

9th
Nov 2015
Satyadeep
@satyadeepk
Nov 09 2015 08:36
I just came here to say a big thanks for this wonderful project!
I was always looking for a way to save us from the hassle of coding new dashboards for every query and datasource
and redash is perfect fit for us with Bigquery and Mongodb integrations :)
anthony
@Sigma-anthony
Nov 09 2015 09:45
Hi, are there any user quotas in redash?
anthony
@Sigma-anthony
Nov 09 2015 12:11
In terms of limiting no. of queries
Arik Fraimovich
@arikfr
Nov 09 2015 13:02
@satyadeepk happy to hear that :)
@Sigma-anthony you mean is it possible to limit a user to the number of queries he creates?
martin sarsale
@runa
Nov 09 2015 14:42
meh, my redash machine was owned because I had redis listening on the public interface
@arikfr any tips to backup my config and rebuild the machine?
Arik Fraimovich
@arikfr
Nov 09 2015 14:54
@runa oh crap. :( you only need a dump of your postgres db. then you can create a new instance, and load that dump and you're good to go
@runa did you use one of the AMIs I create?
martin sarsale
@runa
Nov 09 2015 14:56
@arikfr no, I think I used the shellscript
Arik Fraimovich
@arikfr
Nov 09 2015 15:01
@runa and it setup redis listening on the public interface, or it's something you changed later on?
martin sarsale
@runa
Nov 09 2015 15:02
@arikfr I don't remember changing it.
wow. the redash db is huge
I didn't expected this :)
martin sarsale
@runa
Nov 09 2015 15:10
-rw-rw-r-- 1 postgres postgres 17G Nov 9 09:09 redash.sql
maybe I need to do some kind of cleanup?
@arikfr ^
Arik Fraimovich
@arikfr
Nov 09 2015 15:32
@runa there is an automatic process that cleans up query results (that take most of the space). what version of redash do you run? (since one of the minor versions of 0.6, it's on by default)
@runa you can create a dump without query_results table, but then you will need: 1. to update reefrences in queries table (and might have issues with loading the data); 2. re-run all queries
martin sarsale
@runa
Nov 09 2015 15:38
@arikfr can I manually run this cleaning up process?
anthony
@Sigma-anthony
Nov 09 2015 16:42
@arikfr yes, I meant to limit number of queries a user can run?
martin sarsale
@runa
Nov 09 2015 17:43
@Sigma-anthony I'm running 6.1.b877 but my redash table is > 18gb
Arik Fraimovich
@arikfr
Nov 09 2015 18:58
@רומ
@runa yes:
  1. from /opt/redash/current run bin/run ./mange.py shell.
  2. execute: from redash import tasks
  3. execute: tasks.cleanup_query_results() - it deletes every time 100 query results. you might want to alter that to remove more.
@runa and I think it was enabled by default in 0.7 (and not 0.6+ as I thought before).