These are chat archives for getredash/redash

7th
Jul 2015
j0t3x
@j0t3x
Jul 07 2015 17:53
hey guys, i have problems with BigQuery integration in redash
i have an instance created with the image provided by redash wiki, the one prepared to use bigquery
i already created a service account - client ID(p12 key) and inputed the values from the console(service account and project ID)
but the only message i get when i do a query using this dataaource is : "New query failed to run"
Arik Fraimovich
@arikfr
Jul 07 2015 17:59
@j0t3x did you place the p12 file in path accessible to the redash user?
j0t3x
@j0t3x
Jul 07 2015 18:03
this should be /opt/redash/ ?
Arik Fraimovich
@arikfr
Jul 07 2015 18:03
@j0t3x yes, and change owner of the file to redash
j0t3x
@j0t3x
Jul 07 2015 18:05
great help man! ill try. Ill get back to you after i try
Arik Fraimovich
@arikfr
Jul 07 2015 18:05
and then set the path to this file as the value of privateKey
let me know if it still doesn't work
j0t3x
@j0t3x
Jul 07 2015 18:14
its working now man!
one last question, how do i delete datasources?
Arik Fraimovich
@arikfr
Jul 07 2015 18:16
@j0t3x you can delete it from the web admin (/admin/datasource), BUT if you already created queries with it, it might break some things if you open these queries
j0t3x
@j0t3x
Jul 07 2015 22:05
thanks arik, got it working now. I have a little problem with mongodb queries
im getting the whole collection with any query(even aggregation)