We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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



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.

Environment Details

  • Alteryx Designer
    • 2020.1.2 or lower
  • MariaDB ODBC Driver
  • MariaDB Database


MariaDB is only supported on Alteryx Designer 2021.3 and higher. MariaDB is not supported on earlier versions of Designer, should the error occur. Validation details are on the MariaDB Data Source page.


Upgrade to Alteryx version 2021.3 or higher and obtain the support Simba drivers for MariaDB from the Downloads page and it's recommended to adhere to the Alteryx Version Support Policy.

Additional Resources