Can I use filter Jinja Templating for schema selection in a database? #18339
Replies: 3 comments
-
This seems worthy at a high level, so here's pointer to |
Beta Was this translation helpful? Give feedback.
-
@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. |
Beta Was this translation helpful? Give feedback.
-
@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). |
Beta Was this translation helpful? Give feedback.
-
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.
Beta Was this translation helpful? Give feedback.
All reactions