Configuration error/query error when connecting to Cloud SQL
I succeeded in setting up a Cloud SQL Postgresql instance. I can connect to this instance from within the company network with standard SQL tools.
For access by Data Studio I've also added all Google networks as listed in this Google Support Article.
In Data Studio I can connect to the Cloud SQL Postgresql instance. I can do this both as a Cloud SQL
data source or as a Postgresql data source
(both require the exact same connection data: ip address, port, username, password, database).
In Data Studio I can select a table from my database and define the fields as measures or dimensions,
and define the aggregation strategy for the measures (see image below).
Yet when I then add a simple table to the page and add a dimension and a measure
I get "Configuration error". When I open the error I get the message "there is a query error".
When I select a predefined example data source in data studio I can indeed create a simple table.
Am I trying something that is not (yet) supported?
What do the id's in the (cryptic) error messages mean? Thx for your feed-back.
Details of Configuration error: