Hi all, I'm a new user here, hence I am only allowed to post only 1 picture in my post, so I've combined all my 4 screenshots into 1, apologies. Also, I've been a daily Metabase user for my company for more than 6 months already, so I can say I am fairly experienced in it. However, this new problem that I am currently facing completely stumps me (and my fellow data colleague).
Just wanna say first that my data warehouse is Snowflake, and querying anything there seems fine. So the raw data should not be having any issue.
So, for example, SELECT * FROM TABLE1
yields me 18k entries on Snowflake, which is correct. However running this same query on MB (Native Query) yields me just 300 entries (top left of screenshot).
But it only gets worse/more mind-boggling from here. Querying different fields from the same table gives me DIFFERENT number of entries returned (without any WHERE filter being applied) (top right and bottom left of screenshot).
That is so weird! And this is just for TABLE1; all my other tables are having the same problem. The last weird issue is, doing a COUNT(*) query returns the CORRECT number of entries on Metabase (same as on Snowflake) (bottom right of screenshot)
My colleague and I have never seen such an error before.
Lastly, upon checking the Troubleshooting Logs, there is this error:
{:error-code "invalid_auth", :errors {:slack-token "Invalid token"}}
Not sure whether this error is causing this issue, though I wouldn't think so because an invalid Slack integration shouldn't be affecting the querying right?
Also, I am currently using the latest version of Metabase 0.37.3 (just updated it).
Would anyone care to help? Thanks a lot!