View inheritance of table and column comments

[Malthe]

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.

[lingareddy_Alva · Accepted solution]

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

[lingareddy_Alva]

Thanks for the accepted solution, useful for others @Malthe