You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/10/28 19:48:17 UTC
[GitHub] [superset] bvy007 opened a new issue #17273: Can I use filter Jinja Templating for schema selection in a database? if yes How?
bvy007 opened a new issue #17273:
URL: https://github.com/apache/superset/issues/17273
I have a scenario where we have 10,000 schemas in one database and I am trying to create a dynamic dashboard with plots that are common throughout all schemas. I am looking for an effective solution by selecting the schema name as a filter(I did creating a filter with all schema names in it) and configure charts using jinja templatÃng for schema selection in SQL query.
Also, is it possible to use plpgsql in sql editor when using postgresql as a datasource?
I am new to superset and looking for any suggestions?
Thanks in advance.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] mistercrunch commented on issue #17273: Can I use filter Jinja Templating for schema selection in a database?
Posted by GitBox <gi...@apache.org>.
mistercrunch commented on issue #17273:
URL: https://github.com/apache/superset/issues/17273#issuecomment-954156815
This seems worthy at a high level, so here's pointer to `get_template_processor` and how it's used to compile expressions in columns, filters and other places. Conceptually it seems like it could make sense to do this on the database schema too, but has security / data access policy implications, and it could be slightly complicated from an RBAC standpoint as I'm assuming the template (NOT rendered) will be shown as a single resource. IDK more research would be needed.
https://github.com/apache/superset/blob/5aaa3330a66c90047da3dcc557970cf9383d4933/superset/connectors/sqla/models.py#L84
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #17273: Can I use filter Jinja Templating for schema selection in a database?
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #17273:
URL: https://github.com/apache/superset/issues/17273#issuecomment-954453634
@bvy007 plsql should work in SQL Lab, but probably doesn't work properly in virtual tables (it's been a while since I've tested Superset on an Oracle database).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] bvy007 commented on issue #17273: Can I use filter Jinja Templating for schema selection in a database?
Posted by GitBox <gi...@apache.org>.
bvy007 commented on issue #17273:
URL: https://github.com/apache/superset/issues/17273#issuecomment-954204957
@mistercrunch Thank you for the quick reply.
Also, I am interested to know if pl/pgsql statements are supported in superset ?? I couldn't find anything related to that in superset documentation.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org