This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I had this error when I was trying to connect to the wrong DB.
Check that too.
Right... if it works in a sql console but not in Alteryx, it is probably because the sql concole is connected to a specific schema or DB, but Alteryx is not. In Alteryx, you will need to use the fully qualified name. I got stuck on this b/c I had a large query, all was fully qualified except for one table. It worked in my sql console, but not in Alteryx. Took a few minutes to figure out!