Building Google Cloud Platform Solutions

Performing a simple query

With the data in place, we can execute queries against our Spanner instance using familiar ANSI 2011 SQL. Navigate to your Cloud Spanner instance in the Cloud Console, select the library database, and click Query. We can again retrieve the top 10 most prolific authors in our library with the following query:

SELECT Author.author_name, count(AuthorBook.isbn) as num_booksFROM AuthorJOIN AuthorBookON Author.author_id = AuthorBook.author_idGROUP BY Author.author_nameORDER BY num_books DESCLIMIT 10;

While Cloud Spanner offers a number of similarities to traditional SQL databases, its design and implementation is a significant departure from these traditional databases. In order to get the most out of Cloud Spanner, it's ...