In case anyone else is struggling with something similar:
I have written a SQL query to return all user connections to a table an do a count per hour in order to determine the busiest time during the day for user connections. It returns 177 rows. Mondays were particularly busy with several thousand connection at 6am and 7am. I then copied and pasted the query into Metabase but to my surprise it showed a 100 or so connections instead of thousands.
It turned out that the count function was limited to the Metabase Row Count restriction. I did an override on that database and the data displayed as it should.