Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for Nessie catalog #3673

Open
grifenx opened this issue Jan 21, 2025 · 1 comment
Open

Add support for Nessie catalog #3673

grifenx opened this issue Jan 21, 2025 · 1 comment
Labels
Engine: Trino Feature Adds new functionality

Comments

@grifenx
Copy link

grifenx commented Jan 21, 2025

Issue / Problem Statement:
As of now SQLmesh Trino doesn't support Nessie catalog due to absence of views in functionality (as stated in https://sqlmesh.readthedocs.io/en/stable/integrations/engines/trino/#aws-glue).
Currently THERE IS support of Iceberg views in Nessie, which allows for Trino - Nessie setups, which is being widely adopted at the moment.

Proposed solution:
Add support for Nessie catalog for Trino setups.

@georgesittas georgesittas added the Feature Adds new functionality label Jan 21, 2025
@erindru
Copy link
Collaborator

erindru commented Jan 24, 2025

There are two modes to configure Nessie within Trino:

According to the Trino docs, iceberg.catalog.type=nessie still does not support views?

The Nessie catalog does not support view management or materialized view management

Which mode were you trying to run it under?

It works today if its running in rest mode. From our docs:

The Trino Iceberg Connector must be configured with an iceberg.catalog.type that supports views. At the time of this writing, this is hive_metastore, glue, and rest

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Engine: Trino Feature Adds new functionality
Projects
None yet
Development

No branches or pull requests

4 participants