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

Support custom queries #1

Open
wvengen opened this issue Jan 19, 2022 · 2 comments
Open

Support custom queries #1

wvengen opened this issue Jan 19, 2022 · 2 comments
Labels
enhancement New feature or request

Comments

@wvengen
Copy link
Member

wvengen commented Jan 19, 2022

Currently, only SQL queries are supported. It would be great if native queries would also be supported.

@wvengen wvengen added the enhancement New feature or request label Jan 19, 2022
@wvengen
Copy link
Member Author

wvengen commented Jan 19, 2022

With the current approach of altering the current query, this would mean that the query type would need to be changed (since the materialized view can only be referenced using SQL - or can we reference it from a custom query? that may be a good alternative).

@wvengen
Copy link
Member Author

wvengen commented Jan 19, 2022

For SQL queries one can still edit the existing query, and press refresh.
For custom queries, if the query is modified to reference the materialized view, it cannot be edited in Metabase anymore (one would need to unmaterialize the question, edit it, and materialize it again).

It may be necessary for UX to change the approach, and keep the original query, creating a new question from the materialized view. Or, create a new question as a copy of the original, and modify the original question to reference the materalized view. The latter option makes it easier reference the query other queries, and not having to update these when switching between live and materialized.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant