You can use CTRL+l to edit the full path in the file picker dialog.
But I agree with your point, it could be improved. My personal gripe with the file picker is that backspace does not go to the parent directory anymore.
For me, the killer dataset would be the Google Scholar data. That would just blow the whole scientometric space wide open. It would also be a nice introduction for researchers into BigQuery (calculate your own H-factor)
Yes, this is so horrible.
As a workaround I sometimes put "sep=," on the first line of the spreadsheet. This forces Excel to use the comma as a separator, regardless of the locale.
The downside of course is that every other tool on the planet shows the extra row, so it's not very useful.
We're also affected, our app runs in EU datacenters. We had auth errors on both Cloud Storage and BigQuery.
BigQuery seems to work now, but not Cloud Storage.
Our last outage was 2013, but this has been going on for over 12 hours..