Jump to content

Recommended Posts

Posted

Hello everyone,

I'm trying to get a Snowflake stored procedure running in Spotfire. The instructions online tell me to create an Information Link with the stored procedure as an element, but I can't find any stored procedure that I created in Snowflake in the accoring Datasource. There are only the Tables and Views in the element tree for me to select, even after several refreshes. The Snowflake role that is used for the Datasource has access to the stored procedure and I can see and use it inside of Snowflake using this role.

I created all kinds of stored procedures (returning tables, performing sql operations, written in sql, written in Javascrip, written in Python) to see if any would be visible in Spotfire, but none are. Do any of you know why I can't see it, and therefore also not use in an Information Link? Any help/ideas are highly appreciated.

 

Cheers

Posted

Hello Kirsten,

thank you for your quick reply! Is there also a feature request to support Snowflake stored procedures in general or at least with a tabular return? Because this request focuses on returing scalar values, but also Snowflake stored procedures that return tables seem to be unsupported, even though apparently it's supported for other database technologies (according to the description in the feature request).

If not I can also add that as a comment of the ticket, but it seems to have a somewhat different focus than what I'm aiming for.

Best regards

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...