Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

MySQL Database Incomplete Results

nvalenzu
5 - Atom

Hi All, 

 

I am having an issue where after establishing a connection to a MySQL database, the results I pull are incomplete when compared to the same query run through MySQL Workbench. The issue arose when trying to dump a table (i.e., excluded the WHERE statement) and only received 800 records. For reference there should have been thousands. So I ran the same query in Workbench and got the expected result.  

 

Separately, for some of the tables the query will continue to run, but never produce any results. I wanted to see if anyone had encountered this issue, or had a solution. 

 

Thanks!

1 REPLY 1
JoeS
Alteryx Alumni (Retired)

What driver are you using?

I'd look to potentially try a different driver first to see if the issue persists there.

Labels
Top Solution Authors