Connecting to a MariaDB as a datasorce

Options
tgb417
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,595 Neuron

@ys91
, @casper
, @KimmyC
,

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
    importthepandas Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 115 Neuron
    Options

    bumping this as we're experiencing issues with MariaDB

  • tgb417
    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,595 Neuron
    Options

    What kind of issues are you seeing?

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,708 Neuron
    Options

    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
    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,595 Neuron
    Options

    @Turribeach

    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
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,708 Neuron
    Options

    Thanks Tom. Yeah I have raised it with support to see what they say.

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,708 Neuron
    Options
Setup Info
    Tags
      Help me…