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.
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
My mistake. Autocomplete works fine if I keep Catalog and Schema fields empty. But I can’t see all schemas.