Glad to be part of the community 🙂
I work as a Tableau developer and recently was requested to load data from Pinot into Tableau and while searching the net, I found that Pinot has JDBC connector t use with Tableau but was confused around how to actually do it. Landed on the community slack and was wondering if anyone has had any luck connecting Pinot with Tableau using the JDBC connector?
P.S: I also understand that this question might be too silly or "non-technical" for folks out here, but any kind of help will be appreciated!
Coffee is on me!
06/18/2021, 12:37 AM
Hello, welcome to the community. Pinot does have a JDBC driver, but since Pinot does not support full sql (eg complex joins, nested queries etc), it is not yet in a shape to be directly plugged into Tableau
Something we hope to add in near future cc @User
06/18/2021, 12:42 AM
@User Thanks mayank for the response.
What if I just have ONE table, not joining or nested queries. Do you think I can make Pinot work in Tableau?
06/18/2021, 12:47 AM
We should be able to make it work, will need to check on custom functions
06/18/2021, 12:48 AM
@User awesome, if possible, can you point me in the right direction or documentation links?