Missing Data from MYSQL query (Input Data tool)

Question

Hello,

I have the weirdest problem. I'm pulling in a 2 column table of exactly 50 rows (US state codes and names). When I query the MYSQL Database table the data is all present and intact. When I connect to the table using the Input Data tool there are loads of nulls where there should state codes, state names or both. What on earth is causing this?

I tried searching for the problem but found nothing useful. Any ideas good people of the Alteryx Community?

Regards

David

DaveJ · Accepted Answer

Update: I have recreated the ODBC connection using this driver (MySQL ODBC 5.3) and it now works. I had been using this driver (Maria DB ODBC 2.0) - It is a Maria Database technically hence the driver I had been using.