Snowflake datastore functions

[jmuiruri]

Good morning,

We are migrating from Oracle (on-Prem) to Snowflake on cloud (AWS) but are facing an unexpected issue. Snowflake Datastores do not have Functions available in BODS.

I have searched high and low to see if anyone else has had the same issue but haven't found anything relating to this.

The snowflake team have converted the functions but there just is no functions option available in BODS.

The screenshot below shows the issue more clearly.

Any help with this would be much appreciated.

Thanks

Dan

[jmuiruri]

Hi Dan,

Unfortunately for Snowflake data stores we only support tables and views. You can see the supported objects by right clicking on the data store and select Import By Name and in the popup window under the Type drop down you can see the supported objects.

*stored procedures

When it comes to stored procedures you can call them using the sql() function.

Best regards,

Joseph