GitHub user imedlee added a comment to the discussion: Querying Superset
dataset using jinja
The {{dataset()}} macro in Superset always uses the AS keyword to generate SQL
with aliases, such as (SELECT...) AS dataset_1, independent of the database.
Oracle does not allow AS to use table aliases in subqueries. Therefore, using
the {{dataset()}} macro in oracle will result in the ORA-00907 error.
https://github.com/apache/superset/pull/34613
GitHub link:
https://github.com/apache/superset/discussions/32788#discussioncomment-14066737
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
