DB Explorer Table Comments in Tree View
Hi,
I would like to display table comments in DB Explorer Tree View. I'm working with a database that has very nondescript table names and the comments are essential.
As can be seen above, column comments are displayed correctly, but table comments are empty. I can verify that the table comments exist by running “DESCRIBE TABLE EXTENDED”:
The table comments are also visible in DBeaver and in the Catalog view in the Databricks Workspace.
I've enabled “Details in Tree View” under “View” → “Appearance”.
Now I'll reveal my inexperience, but I think the following might provide some hints. Previously, before using Unity Catalog and viewing the table definition in DataGrip, there is an “auto-generated definition”, at the end of which the table comment is explicitly set to “UNKNOWN”:
After implementing Unity Catalog, this ALTER TABLE expression has disappeared from the definition, but the comment shows up as empty instead of “UNKNOWN”. The original column comments are present, before and after implementing Unity Catalog.
The “UNKNOWN” comment does show up in the tree view, suggesting that it should be possible to display, but that it isn't being imported properly despite being present on the extended properties:
Additional info: Using the latest Databricks JDBC driver (version 2.6.36) with a cluster enabled for Unity Catalog. DataGrip version 2023.3.4.
Any suggestions on how to resolve this would be greatly appreciated. Thanks for taking the time.
Please sign in to leave a comment.
Hi Rickard,
Does it make a difference if you additionally enable the following option in the DB Explorer window settings?
Hi Arina,
Thanks for your response. That setting is already enabled; disabling it hides the column comments. There could be an obvious setting that I've missed, so here is my current configuration:
I submitted a new report about this to our bug tracker so that our developers can check it: https://youtrack.jetbrains.com/issue/DBE-20007
You are welcome to follow the progress there. I will monitor it too.
See this article if you are not familiar with our bug tracking system: https://intellij-support.jetbrains.com/hc/en-us/articles/207241135
Thank you, Arina. It could be something obvious I'm missing since I'm somewhat inexperienced, so please let me know if you need any additional information. I appreciate you looking into this.