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.
user
21-08-2023 00:47:10 -0400
code

1 Answer

Hi, The list of delegable statements shown in Source Configuration (listed also in [Data Source Configuration Properties](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/data_source_configuration_properties/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](https://community.denodo.com/kb/en/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option). * 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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_custom_functions/creating_custom_functions_with_annotations#developing-custom-functions-that-can-be-delegated-to-a-database). Hope this helps.
Denodo Team
24-08-2023 03:52:31 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here