Trino Connector for Google Looker Studio

Trino
1

Has anyone developed a Google Looker Studio connector for Trino since A Trino Connector for Google Data Studio which was developed for Studio when it was named Data Studio ?

I believe there is one for full blown Google Looker, but I am failing to find a useable one for Looker Studio.

TIA

2

I looked around for a little bit and didnā€™t see one for Looker Studio, just the ā€œfull blownā€ Looker over at Starburst | Looker. Sounds like you think about forking @victorc 's GitHub - victorcouste/trino-datastudio-connector: Trino Community Connector for Google Data Studio repo to see if you can make it work.

I mentioned Victor above, but Iā€™ll ping him on Slack to take a peek at this forum question JUST IN CASE he might be able to help in any way.

3

Thanks @lester for your notification !
Hi @chippyash , so yes I did that few years ago when It was still ā€œData Studioā€, I didnā€™t test it recently but it should still work. But be aware that this connector is a bit ā€œbasicā€, just user/password auth, no SQL pushdown to Trino from Data Studio, I just get all data in memory to draw the dashboard.
Anyway, test it, have a look on source code and ping me if you have any questions on features, on code or on how it works.
Victor

1 Like
4

Hi Victor

I did indeed clone your repo :wink: Iā€™ve managed to get it working and have extended it to call a proxy server to Trino that takes care of grabbing the data in one call from Studio, uses JWT for authorisation and adds an additional API key for security. Iā€™ve also figured out how to send a user constructed SQL from Studio, so itā€™s no longer limited to a single table as in the original version. As it requires the Proxy server, itā€™s not much use for others, but Iā€™d be happy to share the JS code with you if you wanted to think about updating your more generic version at some point.

Regards

1 Like
5

Great and congrats @chippyash for this work ! :muscle: And yes, I think for the Trino community it could be nice if you can share part of your code / connector. Then we can also put you in contact with the Trino community manager so your plugin appears here Trino | Ecosystem: Client applications :grinning:

1 Like
6

Hi.
I will do that in time. Currently facing an issue where Studio is not sending the correct request details to the plugin getData() function. Despite having a Date filter dimension, it is not sending the ā€˜forFilterOnlyā€™ flag in the request.fields entry for the datetime field and thus not adding the filterDimensions element either.

Grr. Studio is not easy to work with and you canā€™t run the app script code locally. Very frustrating.