Hey everyone!
I want to use Google Data Studio (now Looker) to visualize my database from Xano.
I use Xano's data connector to have postgres credentials. However, when connecting on Google Data Studio the data source using the Postgres credentials given by Xano, all my Xano tables appear on Google Data Studio with the data within a single, unique column called "xdo", which contains an array (?) with all my table's data, but with as many rows as there are records in my table. It's only a record's data which fills a single "column", rather than as many columns as there a fields in the table.
I would like to have my tables' data to be formatted as email/first_name/last_name just like it is on Xano. Any idea how to make it work ?
Thanks a lot!
Nathan