Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Oracle Synonyms in Alteryx


Is there anything special we have to do to get Oracle Synonyms to show up in Alteryx Visual Query Builder as oracle tables?  I have access to the real tables, but they are _X and _Y, meaning I never know which one is current without digging in.  The company solved this by setting up Synonyms, which works great for SQL Developer and Business Objects.  But for the life of me, I can't figure out how to get them to show up in Alteryx Visual Query Builder.  I've verified I have access because I can run simple queries in SQL Developer.  One person was able to do it and the synonym.table icons show up, but they are green.  What does green mean?




Tables named with Oracle Synonyms generally do not show up in the list of Tables, but do show up in the Visual Query Builder if they are a part of the schema the user has access to.  In cases where they are part of a different schema or are "owned" by a different user, they may not appear.  Sometimes it is possible to access them from the SQL Editor via an appropriately constructed SQL query, even when they don't appear in the main window of the Visual Query Builder.


In general Visual Query Builder color codes tables and similar constructs:  Tables are blue, Synonyms are green, and Views are orange.


Visual Query Builder with Synonyms.png

Lisa LePome
Customer Support Engineer -- Knowledge Management Coach
Alteryx, Inc.

Hi LisaL,


The Synonyms from my Oracle database isn't showing up in the Tables or Visual Query Builder. I tried to write a simple SQL query too but that didn't work either. 


Please let me know what alternatives/ work around option would be. Thanks in advance.