community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

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

gtorres8
Alteryx Alumni (Retired)
Created

‎04-06-2020 04:36 AM - edited ‎10-06-2021 11:41 AM

Issue


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


Cause


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.



Resolution


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

 
Labels