Currently a stored procedure needs to return a table with at least one column in order for Spotfire to create the stored procedure element in Information designer. In Databases like Snowflake, we can have stored procs that only return a scalar value. It would be nice to be able to handle these situations since the JDBC driver can handle them.
Yes this should handle the store proc hence voted. I found this article which says it does not support SP. Good to have this feature for snowflake database.
https://support.tibco.com/s/article/Cannot-create-a-procedure-element-using-TIBCO-Spotfire-Information-Services-for-a-Snowflake-stored-procedures