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

Muhreng
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

Liezl
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!

Labels