Cannot find SQL window when trying to create a dataset from a query

Hi,
I tried to create a dataset from the query following this instruction.

http://documentation.arcadiadata.com/latest/#pages/topics/create-dataset.html#create-dataset-from-query
But there is no window “Enter SQL Below” only table selection.
I am not sure it might possible for this connection (postgres). Please advise.

@Stima_Livingpresent what version of Arcadia are you currently running?

It is Arcadia Enterprise 5.0.1.2.1553479820
Thanks

@Stima_Livingpresent thanks for clarifying. There’s a bug in Arcadia 5.0.x that is causing the behavior you’re seeing (This bug has since been fixed in 5.1.x). To workaround this you can go to the “Direct Access” tab, construct your SQL, and then save your Dataset like this:

1 Like

Thank you very much. Will try.:smile:

Our connection is to postgres database, there is no direct access tab.
Will keep finding method unless gotta go for creating table for this purpose .
Thank you very much