Google Big Query Error - Response too large - Enable Large Result Sets

DF_DB — Sat, 20 Aug 2022 23:28:12 GMT

Trying to extract data from GBQ. Getting this error.

I looked this up. It said to enable large query sets. I go to the connection and that option is disabled.

So now I look that up. It says I have to change "Language Dialect" to Legacy SQL. So I make that change.

Now it wants a "Dataset Name for Large Result Sets". I have a dataset that is in the format. some-data-set. It works perfectly EVERYWHERE else I have queried data. But putting that hyphenated value into the field throws another error.

It doesn't like the hyphens.

Anyone know how to make this work?

topic Google Big Query Error - Response too large - Enable Large Result Sets in App Development

Google Big Query Error - Response too large - Enable Large Result Sets