Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Error opening SHOW VARIABLES LIKE aurora-version when connecting to MariaDB via ODBC

Alteryx
Alteryx
Created

Environment Details


When selecting the input data tool to connect to MariaDB via an ODBC DSN, the following error occurs in the workflow.
 

Error opening "SHOW VARIABLES LIKE 'aurora_version'"


The Visual Query Builder does show a table, so a connection is made, but any query placed into the Editor and clicking on the Test Query button produces the error. Or simply running the workflow will produce the error.

  • Alteryx Designer ≤ 2020.1.2
  • MariaDB ODBC Driver


Cause


MariaDB is not supported.



Resolution


WORKAROUND

None.

STATUS

An enhancement request has been created to support MariaDB in a future release of Alteryx Designer. There are no guarantees that an enhancement will be implemented.