You can translate the question and the replies:

Delegate geospatial function

Hi Experts, How can I delegate the ST_INTERSECTS geospatial function to my snowflake datasource? In the Source configuration, I see analytic, scalar and other types of functions. How do I delegate a geospatial fumction to Snowflake? Thanks much in advance.
21-08-2023 00:47:10 -0400

1 Answer

Hi, The list of delegable statements shown in Source Configuration (listed also in [Data Source Configuration Properties]( defines what is delegable by Denodo to the Data Source. If your function is not in that list the only two options are: * Create a base with the "Create Base View from View". This KB article could be useful: [USING THE CREATE BASE VIEW FROM QUERY OPTION]( * Create a Delegable Custom Function in Java, that you can import in Denodo as a .Jar file. You don't have to rewrite Snowflake function's logic (even if it is possible and usually ), you just have to declare a *DelegationPattern* that tells Denodo how to call the corresponding function in Snowflake. This section will be useful: [Developing Custom Functions that Can Be Delegated to a Database]( Hope this helps.
Denodo Team
24-08-2023 03:52:31 -0400
You must sign in to add an answer. If you do not have an account, you can register here