Cloud Spanner Error: Cannot read properties of null (reading 'join')

In the cloud console, I created a new Cloud Spanner View called StudentView which left joined my Student table and a ClassEnrollment table. The update seemed to work as I could see the new View created.

I then looked at my Students table and I got the error:

Cannot read properties of null (reading 'join').

View screenshot of error

The Students table showed no data even though it is populated. I subsequently deleted the StudentView:

DROP VIEW StudentView;

The result is still the same and the Student table displays nothing but the error stated above - even though the StudentView has been dropped.

I have also tried replacing the StudentView View so it does not contain null values, but the error persists.

I am assuming the error refers to the View that I created. If that is not the case, please could you point me in the right direction.

Any idea how to go about this problem?

There was a short-lived bug in the Cloud Spanner UI that was active around the time you asked this question (2022-08-30). Assuming you can see Students now, and StudentView doesn't appear in the UI anymore, the bug probably affected you too. Nothing you're doing wrong, just unlucky timing.

If you ever suspect there's a problem with the Cloud Spanner UI, you can list and query DBs with gcloud spanner .... In this case gcloud should have continued to work while the UI was down.