Unable to query the newly created table in oracle using Alteryx

Question

I have a question here, regarding creating a new table in oracle using Alteryx. I am able to create a table in oracle through Alteryx. I tried to query the table in oracle, I got an error "table or view doesn't exist". But  I'm able to see the table and data in connection tree. Anyone have encountered any issue like this??? or if you know the step/solutions please let me know.

TheOC · Accepted Answer

Hi @Sarav_93 
I may not be the best help on this one, my apologies, i have not faced the exact issue you are describing. I was, however, able to give the Community a search for you, and found the following resource which may be useful:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Receive-error-quot-ORA-00942-table-or-view-does-not-exist-quot/ta-p/891162

It appears that a quote identifier may be the issue here, can you ensure that the connection is configured to "both read and write 'Quoted'."?

Hope this helps,

Owen