DS internal error connecting Postgres table that contains json or jsonb field
DataStudio shows "The server encountered an internal error and was unable to complete your request" when trying to connect Postgresql table that contains json or jsonb fields.
- connect datasource, choose Postgresql,
- provide with database credentials in the "Database Authentication" form,
- choose a table that contains at least one field of type "json" or "jsonb" in the "Tables" list,
- DataStudio shows the error instead of the list of fields for selected table.
Tables without the "json" or "jsonb" type fields can be connected.