Re: [I] SuperSet Database connection is successfully established but not able to get the tables under a specific schema [superset]

["rodrigomsrocha (via GitHub)" <gi...@apache.org>]

rodrigomsrocha commented on issue #30208:
URL: https://github.com/apache/superset/issues/30208#issuecomment-3089633073

   Hi! I’d like to share some additional context regarding this issue.
   
   I’m connecting Apache Superset to a Kyuubi server, which exposes a Spark SQL environment via the Spark Thrift Server protocol. I’m using the following connection string (with LDAP authentication):
   ```bash
   hive://user:password@host:port/spark_catalog?auth=LDAP
   ```
   While I can successfully run SQL queries against my tables (both in SQL Lab and by manually creating datasets), Superset is not able to automatically list tables and columns in the database/schema browser. This means I cannot see or select tables/columns from the UI to easily create datasets—I’m only able to create them by writing SQL queries manually.
   
   Additional context:
   - The same user/connection works perfectly in other BI tools (like Power BI), which are able to list tables and columns without issue, so it doesn’t appear to be a permissions problem.
   - The Spark/Kyuubi backend supports SHOW TABLES, SHOW DATABASES, and column metadata queries via the Thrift interface.
   - This seems to be a limitation or incompatibility between Superset’s database engine/driver and Kyuubi/Spark Thrift Server.
   - The problem occurs both with and without the spark_catalog parameter in the URI.
   
   If you need any specific logs or connection details, I’m happy to provide them!
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org