I am trying to access a postgres database on a local network. If I use psql or even oracle sql developer the query "select * from states" gives me the correct returned data. But if I try it from redash I get an error
Error running query: relation "states" does not exist LINE 1:
I cannot figure out what I am doing wrong. If it was an access permissions issue once assumes psql or oracle sql developer would give me the same problem. There is obviously something about redash queries that I don't understand.
Any help would be appreciated.