HIi @flamber, we have the same issue with Snowflake.
For example query on this screenshot returns only one row instead of 8.
This issue seems to be reproduced only with grouping by dates(day, month etc.).
We didn't change our Metabase version recently.
The same “select * from table_name” returns a much smaller number of rows when queried from Metabase in comparison to when queried from Snowflake directly. This happens for both “Ask a question”, and “Native query”
Tried to update to the latest version of the application - didn’t help
Tried increasing the resources on the machine (AWS) - didn’t help
Tried re-syncing the schemas and disabling the cache - didn’t help
Tried dropping the table and rebuilding it again - didn’t help
Made sure warehouse is not limited from Snowflake side - it is not limited
Hey, we’ve figured out that’s a Snowflake issue.
There are no issues if we are using Snowflake web UI, but if it’s the connection through JDBC driver -
every time the same query returns a different result. Snowflake know about that issue and working on it. Hope that’s help
UPD: looks like they’ve fixed it