These are chat archives for getredash/redash

11th
Dec 2016
NadavN-NI
@NadavN-NI
Dec 11 2016 10:55
Hi, I am using redash to run some MySQL queries on RDS. To prevent my queries being too intrusive on the DB, I would like to set isolation level read uncommitted. (SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;).
In a query console (like workbench) I would have add a statement ahead of the query.
How should I do that in redash?
Arik Fraimovich
@arikfr
Dec 11 2016 10:55
did you try to do the same in Redash?
NadavN-NI
@NadavN-NI
Dec 11 2016 12:05

@arikfr I Tried this:
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Select 1;

I got this:
Error running query: No data was returned.

Arik Fraimovich
@arikfr
Dec 11 2016 12:05
there was nothign else after "select 1"?
NadavN-NI
@NadavN-NI
Dec 11 2016 12:05
@arikfr Nope
Arik Fraimovich
@arikfr
Dec 11 2016 12:10
strange. this message appears when we got no results from the query, which not supposed to happen in your case