Hey all, I've popped a feature request in here: https://github.com/lightdash/lightdash/issues/18729 It's to show multiple schemas in a clickhouse connection. I thought I'd raise it, just in case I'm missing some config or trick to make this work today. Thanks again! Ben

👋 Thanks for your message - someone from the Lightdash support team will get back to you asap. Feel free to add any additional context to the thread here in the meantime (screenshots, app version if you're self-hosting etc.).

Hey Ben 👋 Although I'm not too familiar with the new Clickhouse integration - the way this works with our other connectors is that the warehouse credentials provided will allow you to query any schema they have access too from within the SQL Runner, independent of the options give under the dbt connection - which is a just a default we need to provide dbt on compile. Can you check that if you add permissions for the Clickhouse account connected to Lightdash for more schema access, that it is then available to you in SQL Runner?

I can successfully select from the other schemas, but it would be really nice to be able to see the schemas/tables on the sidebar. you can see clickhouse only shows the entity_linkers schema, whereas iceberg/trino shows everything.

I've upvoted issue #18729 for you! This issue has been requested by 1 other user. I'll notify everyone here as soon as it's fixed.