Integration with Teradata Data Store

[justinleebehnke]

Is your feature request related to a problem? Please describe.
The lack of Teradata integration in CubeJS creates a bottleneck in our analytics workflow, limiting our ability to fully leverage the benefits of CubeJS's headless BI approach with our Teradata infrastructure.

Describe the solution you'd like
I would like CubeJS to add native integration with Teradata by developing a dedicated driver or connector.

Describe alternatives you've considered
It seems like the only other alternatives are to look for another headless BI tool or create our own.

Additional context
As far as I can tell, I am using version 17.20.3.08 of Teradata.

The only note about it I could find online was this one from 9 months ago.

[justinleebehnke]

Does anyone else have information to help me understand why CubeJS doesn't have a Teradata integration?

My theories for possible explanations so far are:

1. There is insufficient demand for Teradata to compete against the implementation of other features
2. The dialect of Teradata's SQL is in someway incompatible with CubeJS
3. There is another Headless BI solution that integrates well with Teradata, so CubeJS would not benefit from integrating with it and the ongoing maintenance of it and so forth.

If anyone can tell me whether it's 1, 2, 3, or some combination or something else and how they know that, I would be so grateful.

Thank you so much in advance.

[paveltiunov]

Hey @justinleebehnke ! Here's the PR for that #5537. We didn't have a chance to bring it over the finish line. We'd love to see someone gets a working version of the Teradata driver and publishes it. Then we can start endorsing it and consider making it part of the core repo. Please see https://github.com/cube-js/cube/blob/master/CONTRIBUTING.md#contributing-database-drivers for more details.

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[justinleebehnke]

@paveltiunov Thank you for the rapid reply, I am in the middle of a PoC and if it goes well I am sure I will be able to get approval to continue to carry the torch on this issue, if I am unsuccessful then I will not be able to so don't assign it to me just yet.

Thank you for pointing me to that other PR this is really a big help.