-
Notifications
You must be signed in to change notification settings - Fork 1.7k
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
Metabase SQL API doesn't use pre-aggregation #8230
Comments
Hi @itestyoy 👋 I see that you have Also, is this issue a duplicate of this one #8256 you've also filed? |
@igorlukanin In this case, when we use the REST API and manually apply filters for analytics_analysis_view.date and analytics_analysis_view.user_first_touch_date, it works correctly, and the cube utilizes pre-aggregations. However, when we use the SQL API, the cube doesn't utilize pre-aggregations. |
OK, I see. Does this advice help?
|
Hi! We have pre-aggregations set up like this and we're using Metabase with the SQL API:
The query via the SQL API doesn't seem to recognize the pre-aggregation, possibly due to the time dimension.
However, if we create a query via the REST API, it correctly utilizes the pre-aggregation:
But the query generated via Metabase may not utilize the pre-aggregation properly. It might look like this with timeDimensions:
How can we ensure that the pre-aggregation is utilized via the SQL API?
The text was updated successfully, but these errors were encountered: