Bigquery input delay when typing when query length is past 300 lines

user_13000865 0
Viewed 525

Google BigQuery recently deprecated their legacy UI in favor of their new UI. While the new UI is cleaner looking, has a linter, and has better autocomplete, I had avoided using it because the performance when typing crashes when queries are longer than around 300 lines. For example, if I paste in a query it will take ~30 seconds for the linter to run during which time I cannot do anything. Then if I try to type anything new in, there will be an input delay of a few seconds. This issue did not occur in the old UI so I believe it stems from the linter.

Has anyone else run into this issue. Currently developing within Bigquery is a miserable developer experience and I cannot do my work.

Thank you

google-bigquery
2 Answers
user_54768480

While this issue will be addressed / resolved - you can try yet another UI tool for BigQuery

This is Goliath – the IDE for BigQuery – part of Potens.io Suite available at Marketplace.

I tried your query and have not experienced any delays you described. At least you can try and see if this will work for you and enjoy many perks coming with Goliath

Note: Another tool in this suite is Magnus - Workflow Automator. supports all BigQuery, Cloud Storage and most of Google APIs as well as multiple simple utility type Tasks like BigQuery Task, Export to Storage Task, Loop Task and many many more along with advanced scheduling, triggering, etc.

Disclosure: I am creator of those tools and leader on Potens team. Also, I am author and creator of well-known BigQuery Mate chrome extension that helped thousands and thousands of users since 2015 to overcome limitations and limits of Native BigQuery UI known as Classic BigQuery UI

user_52219440
Related