Option to show raw output instead of html table

1

I often just want to select some data from an SQL result and copy it, but I can't because (aside from the annoying popup about drill through getting in the way) the data is formatted as an HTML table.

The only other option is to download a file opening in some other application and then copy it and then delete the file. Way too many steps to copy some text to clipboard.

It would be extremely handy to just see raw MySQL output instead of jumping through hoops just to select and copy a some text.

Many values are also formatted and don't show what's actually in the database, which is a massive pain for devs trying to debug/replicate issues caused by data.

Seeing the raw output would also help with this major pain point.

Or just the option to display the CSV/JSON version that the download option gives without downloading it would be fine too.

2

But the UI will limit the output to 2000 rows for raw and 10000 for unaggregated data ... So you still have to download the whole dataset to troubleshoot issues right?

You seem to be after a Querying tool like Data Grip or DBeaver rather than an analytics tool

3

I just want the ability to use what I can already see on the page. Obviously id still need to download a file if I wanted a massive set but thats not the issue

PS - The company doesnt hand out the keys to the production databases so I have to go through Metabase. I agree this tool is bad for developers and Id use something else if I could.