You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@superset.apache.org by "imedlee (via GitHub)" <gi...@apache.org> on 2025/08/10 23:16:57 UTC

Re: [D] Querying Superset dataset using jinja [superset]

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 notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org