Influx DB to Dataiku
Hi all! Do anyone have solution to connect Influx DB to Dataiku?
Operating system used: Linux
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,128 Neuron
InfluxDB does not have a native JDBC driver which is what Dataiku normally uses to connect to databases. However they have recently published this blog post:
https://www.influxdata.com/blog/querying-influxdb-3-0-using-jdbc-driver-tableau/
where they claim it's possible to connect Tableau to InfluxDB 3.0 to query data for visualization using the Apache Arrow Flight SQL JDBC driver (Flight SQL driver). So it might possible to use this driver in Dataiku as well, you will have to test. You can create a generic JDBC connection using the New Connection => Other SQL databases.
-
Influx db has a rest API. You might be able to leverage it with the api-connect plugin, or with your own plugin, using this one as an implementation example...
-
ANH Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 2 Partner
Thank you alex! Now we get it and might test it soon!