Hasn't finished introspecting BigQuery over a week

Answered

Hi, 

I'm connecting to BigQuery using IntelliJ IDEA's inbuilt database features, and the 'Introspecting server object' feature is extremely slow. We have over 4000 projects in BQ but I have selected around 24 projects and each of them might have around 50 datasets each. Each dataset will have around 10-20 tables. It has been over a week since I set this up and IntelliJ has not finished introspecting even a single table level schema. It has managed to scan around 3 BQ projects but for each of those it has only managed to get a list of datasets and not table schema has been introspected. Clearly this is not good for productivity, and I find myself having not using the database features. How can I optimize this?

I'm using:

IntelliJ IDEA 2021.1.3 (Ultimate Edition)
Build #IU-211.7628.21, built on June 30, 2021
Runtime version: 11.0.11+9-b1341.60 x86_64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
macOS 11.4
GC: ParNew, ConcurrentMarkSweep
Memory: 1979M
Cores: 16
Non-Bundled Plugins: IdeaVIM (0.68), net.seesharpsoft.intellij.plugins.csv (2.17.1), com.godwin.json.parser (1.4.2), org.jetbrains.kotlin (211-1.5.10-release-909-IJ7142.45), Pythonid (211.7628.24), com.leinardi.pycharm.pylint (0.12.2), python-smart-execute (0.1.6), R4Intellij (211.6693.5)
Kotlin: 211-1.5.10-release-909-IJ7142.45

 

0

Please sign in to leave a comment.