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/03/31 05:41:32 UTC
[GitHub] [superset] SimonTulettIdeaco opened a new issue #2574: mssql stored procedure execution support in SQL Lab?
SimonTulettIdeaco opened a new issue #2574:
URL: https://github.com/apache/superset/issues/2574
Make sure these boxes are checked before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if any
- [x] I have reproduced the issue with at least the latest released version of superset
- [x] I have checked the issue tracker for the same issue and I haven't found one similar
### Superset version
0.17.3
### Expected results
It would be good if it was possible to use SQLLab to create a slice generated from the execution of a stored procedure when working with MSSQL, via invocation with the exec keyword or with the call keyword in MySQL. Support for dynamically passing arguments would be required and perhaps cold be achieved using Jinja2 as Mode Analytics does with liquid.
https://help.modeanalytics.com/articles/add-parameters-to-reports/
### Actual results
N/A
### Steps to reproduce
N/A
--
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.
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] nealf commented on issue #2574: mssql stored procedure execution support in SQL Lab?
Posted by GitBox <gi...@apache.org>.
nealf commented on issue #2574:
URL: https://github.com/apache/superset/issues/2574#issuecomment-1023722493
Another use case (DB2 and MSSQL) we have for calling stored procedures uses the `{{ current_username() }}` jinja template to get a list of items the current user should have access to, which involves some sophisticated logic within the database. Some of our stored procedures could potentially be rewritten as table-valued functions, but I think a good chunk of them probably can't.
I realize there is probably a lot of work to make this a reality, but wanted to just add an additional use case.
--
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] MarkGStacey commented on issue #2574: mssql stored procedure execution support in SQL Lab?
Posted by GitBox <gi...@apache.org>.
MarkGStacey commented on issue #2574:
URL: https://github.com/apache/superset/issues/2574#issuecomment-878303700
Does this perhaps fit into some of the native filter enhancements?
--
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] MarkGStacey commented on issue #2574: mssql stored procedure execution support in SQL Lab?
Posted by GitBox <gi...@apache.org>.
MarkGStacey commented on issue #2574:
URL: https://github.com/apache/superset/issues/2574#issuecomment-788792661
Please reopen.
Ideally:
Proc is for instance, "GetReturn_Timeseries_ByFund", with parameter @FundID int (e.g. CREATE PROC dbo.GetReturn_Timeseries_ByFund (@FundID INT))
We would then like to be able to execute this proc and get back the data by query folding from the final dashboard.
So we'd pass a Fund Id of 253 or 11792 via the URL, and have the proc execute " EXEC dbo.GetReturn_Timeseries_ByFund @fundID = 253"
Hopefully this explains the use case
----------------------------------------------------------------
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.
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] junlincc commented on issue #2574: mssql stored procedure execution support in SQL Lab?
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #2574:
URL: https://github.com/apache/superset/issues/2574#issuecomment-810781854
closed #13577 and keep track of this issue in this thread
--
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.
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