If you’re a developer engaged on an utility backed by Google Cloud Spanner and use an IDE from the JetBrains suite of developer instruments, we’ve received some excellent news for you! Now you can browse the database schema and question information saved in Cloud Spanner instantly out of your JetBrains IDE. On this submit, I’ll present you ways to hook up with a Cloud Spanner occasion utilizing IntelliJ IDEA.
To connect with Cloud Spanner inside IntelliJ, you will want:
Including the Cloud Spanner information supply
So as to add Cloud Spanner as an information supply, open the Database software window by navigating to View -> Software Home windows -> Database inside your IntelliJ undertaking. It will open a sidebar in IntelliJ that may present you an inventory of your present database connections for the undertaking. If in case you have by no means added a connection, this sidebar can be empty. Click on the ‘+’ icon to carry up the checklist of information sources you may add. The Cloud Spanner information supply could be discovered below the ‘Different’ part of this checklist. It is because the info supply is revealed below Fundamental Help.
In keeping with IntelliJ documentation, Fundamental Help offers, “code highlighting and shows objects that had been retrieved by the JDBC driver. IntelliJ IDEA makes use of JDBC metadata for database introspection and the SQL 2016 dialect for code highlighting. No errors are detected and highlighted. The introspection with JDBC metadata implies that some particular database objects is not going to seem within the database tree view. Code completion is not going to embrace objects that weren’t retrieved throughout introspection.”