The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
SQL Table Editor connecting to External Database not working
Hi, Can anyone explain why External connection is not working in SQL Table Editor ? The same connection is working for Data Adapter. Screenshot for Data Adapter and it’s working. Screensh...
Keep in mind that the editor and data adapter works differently. Also, is the user that you are using in the external connection does that user got write access to the tables?
Yes, that user has write access.
What is the error you are getting then? Prior releases won't let you write to a different schema. But I guess you are not on that version.
I am just trying a connection from Table editor and getting below error. I am on version 6.4.
Your data adapter does have aliasing on the SELECT statement. What if you remove the alias as do SELECT * from error_codes? Does that work?