I have not been able to figure out how to actually run queries on the redash database.

From another post on backing up your redash database, I found this query.
select t1.datname AS db_name
from pg_database t1
where t1.datname = ‘redash’

If I run this on my docker installed local instance (v.3.0.0), there are no results.

I also see references on querying the metadata in the documentation, but I have never seen the actual sql to run.

If I run the above query without the where clause, I only get a list of database names for my data source