Apache Superset runs only SELECT
statements. When I try EXEC someSP
against SQL SERVER
then it throws me “Only SELECT statements are allowed against this database
.”. Because Superset is an open source software in Python Ι tried to find information how to change the code so to allow the execute of SP in Sql server (I imagine that the same problem exist with other rdbms as MySql that use Call SP and postgresql). Please I know that there are other posts in the Internet that suggest the use of OPENQUERY. I am not interested in the OPENQUERY solution that I have already test it and works. I need a solution related to python source code.
I found this text but didn’t understand. They refer to things that doesn’t exist or they use strange, unintelligible and unstructured speech.
Also I tried to find the source of this message to start from somewhere. I found it in the file sql_lab.py. I changed it to test if is this. And I didn’t see the change!
Is there a way to allow Superset to not limited to the SELECT
?