I am just getting started with Great Expectations and I now know that Oracle is not currently supported. I am wondering if anyone on here has a work around for this issue that I posted on github and can get me started working with Oracle data. In summary from the link, any way I try to load an Oracle table I get the error DatabaseError: (cx_Oracle.DatabaseError) ORA-14459: missing GLOBAL keyword [SQL: CREATE TEMPORARY TABLE "ge_tmp_c45cd263" AS SELECT FROM DUAL WHERE ROWNUM <= 1000]
We would also be interested in having support for Oracle.
If the only problem was associated to the creation of the temporary table, this post in StackOverflow explains that the limitation comes from the current statement.
Using CREATE PRIVATE TEMPORARY TABLE ... should fix that part.
To get this to work for us, that probably means adding Oracle as a specific SqlAlchemy datasource to Great Expectations, but there might be another solution I don’t know yet 
1 Like
@patechoc @nafarmer Temporary table management is an area where database engines do not have standard behavior. We have been dealing with this by adding special logic based on the engine name. Your suggestion sounds right - adding another clause for Oracle. If you would like to contribute this as a PR, this would be super welcome and we will support you throughout the process.
1 Like
@eugene.mandel I am working on a PR for this.
2 Likes
@eugene.mandel @patechoc I have submitted PR #2609
2 Likes
Amazing - thank you! In review.