AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.7K members online now
1.7K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

DS internal error connecting Postgres table that contains json or jsonb field

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

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.

Steps to reproduce:
  1. connect datasource, choose Postgresql,
  2. provide with database credentials in the "Database Authentication" form,
  3. choose a table that contains at least one field of type "json" or "jsonb" in the "Tables" list,
  4. DataStudio shows the error instead of the list of fields for selected table.

Tables without the "json" or "jsonb" type fields can be connected.datastudio_json_jsonb_the_error.png