Can I add entire Presto installation as Data Source?


#1

Hello. We use PrestoDB as a tool for cross-database PostgreSQL queries and Redash as a user-friendly querying interface. Unfortunately, I can’t see a way to add all (or several) PrestoDB catalogs as one Redash Data Source. It’s annoying and can’t allow using one of the main Redash features for us: schema visualization and autocompleting.
BTW, if I add one Presto catalog as the data source and construct the cross-catalog query manually - it will successfully work. But this behavior is non-intuitive and isn’t user-friendly.


#2

My mistake. Autocomplete works fine if I keep Catalog and Schema fields empty. But I can’t see all schemas.