Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Snowflake datastore functions

former_member817565
Member

on ‎2022 Oct 05 10:28 AM

0 Likes
638

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

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
jmuiruri
Product and Topic Expert
Product and Topic Expert
‎2022 Oct 05 10:28 PM
0 Likes

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

Accepted Solutions (0)

Answers (0)

Ask a Question