Connecting to a MariaDB as a datasorce
![tgb417](https://us.v-cdn.net/6038231/uploads/lithium_attachments/n1980i7BE7BDB445EC1955.jpg)
I'm curious how you have set up MariaDB in Dataiku. I understand that it is a variant of MySQL, maybe primarily a version 5.x with some extensions. I'm trying to connect to a MariaDB V10.0.... as a data source. Not as an analytic database per se. I'm hoping to grab the data and use it locally on a design node.
Are you using the MySQL database connection in the earlier than V8.0 mode? Or the more generic JDBC drivers and selecting a SQL dialect MySQL <= 8.0? Possibly using the JDBC diver from this source?
How are you finding the setup and use of this database with Dataiku V8.x. Has it been fairly straightforward or are you running into lots of challenges? If so can you provide any clues about avoiding such problems.
Thanks in advance for any help you can provide.
Answers
-
importthepandas Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 115 Neuron
bumping this as we're experiencing issues with MariaDB
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
What kind of issues are you seeing?
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,876 Neuron
Hi all, any relevant issue that you can share about MariaDB? Got a query that runs in dbvisualizer (a popular SQL client tool) but hangs in Dataiku. Anyone else seeing similar issues?
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron
I've only connect to MariaDB once or twice from Dataiku 2-3 years ago.
I notice that MariaDB is not explicitly listed on the Supported List of Database. However, I believe that MariaDB is similar to MYSQL. But there may be some important differences as well. https://mariadb.com/database-topics/mariadb-vs-mysql/If I were you I'd open a support ticket. See what the support team says.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,876 Neuron
Thanks Tom. Yeah I have raised it with support to see what they say.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,876 Neuron
Also raised Product Idea to add official support for it: https://community.dataiku.com/t5/Product-Ideas/Add-support-for-MariaDB/idi-p/38725