ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Designer Discussions

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

Error when trying to extract a table from a SQL connection using the Connect In-DB tool

5 - Atom

I don't know if there is any existing solution post to this issue within the community. I experienced the same issue recently and could not find a viable solution online.


After carefully reviewing the error I changed the "Browse first x records" settings under the in_DB Browse tool to '0'. The default is 100 and this worked. 


Hopefully someone finds this useful

6 - Meteoroid

This helped me  - thanks for posting this. After removing all tabbed spaced that I created in SQL, my query connected and ran successfully!