topic View inheritance of table and column comments in Generative AI

View inheritance of table and column comments

Malthe — Thu, 26 Jun 2025 11:48:49 GMT

Reading through the documentation and searching in the community forum, I'm getting conflicting information on how views might inherit table and column comments from the underlying tables in a Genie context.

My question is, to what extent does Genie pick up comments from underlying tables (which are not exposed directly to the Genie Space).

This is especially relevant since COMMENT ON does not work on views.

Re: View inheritance of table and column comments

lingareddy_Alva — Fri, 27 Jun 2025 04:23:40 GMT

Hi @Malthe

Based on the current understanding of Genie's behavior:
Comment Inheritance in Genie Views
What Genie typically inherits:
- Column descriptions from underlying tables are often picked up automatically
- Basic column metadata (data types, nullability) is inherited
- Some semantic information may be preserved depending on the view definition
What Genie typically doesn't inherit:
- Table-level comments are usually not inherited by views
- Custom column comments may not always be preserved, especially through complex transformations
- Extended properties or custom metadata attributes

Re: View inheritance of table and column comments

lingareddy_Alva — Fri, 27 Jun 2025 15:35:57 GMT

Thanks for the accepted solution, useful for others @Malthe