Google Data Studio: Write user input back into a Google Big Query table

0
votes

I want users to be able to respond to questions in a Google Data Studio report and feed the answers back into a Google Big Query table. It doesn't need to be Google Big Query it could be Google Cloud Storage instead. Is that possible at all with Google Data Studio?

2
google-bigquerygoogle-data-studio
It is not possible. - Diego Queiroz

2 Answers

0
votes

It is not possible. Data Studio is for data visualization, not for input.

You can probably hack this behavior with Community Connector to some extent, but it will be a terrible user experience and you surely don't want to go through this path.

0
votes

It is possible to use Data Studio as an input mask and write the inputs to a Big Query table. I have written a Community Connector for that, but I can only give you the source code and you have to host it yourself.

https://script.google.com/d/16uE5pE2BiJFPt1h989hB_-heUCGPmI5cBDZaW4DKvn5aU9WYIFDPKnsI/edit?usp=sharing

https://github.com/sagr81/community-connectors/tree/master/DDL-BigQuery-write-data-into-tables