Skip to content

SNOW-2135807: Support for "semantic views" at the dialect level? #590

@mistercrunch

Description

@mistercrunch

context: https://docs.snowflake.com/en/user-guide/views-semantic/overview

We're looking to add semantic view support to Apache Superset, and wondering what is the best place to do so.

Now I'm thinking the best place for it might be in this driver. It would probably require:

  • exposing semantic views as normal views (assuming they behave consistently-enough with views), presumably through get_view_names, and returning extra metadata as to whether the view in the list is a pure or semantic view
  • extending get_column_names to handle semantic views - again, assuming they generally behave like views

Is it in the plan to support this? Would contributions be welcomed to add this feature to the dialect?

Any fundamental reasons why semantic views are too different from traditional views to be handled in such a way?

Metadata

Metadata

Assignees

No one assigned

    Labels

    featuremaintenance_modeIssue was raised during maintenance mode thus could not be addressed.status-triage_doneInitial triage done, will be further handled by the driver team

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions